Insert query using Session values

[Icewolf]

Hi

I am trying to create a insert query that stores some session values. However I am getting an error and can't figure out what is causing it. I have tried to search for the error but can't find the answer.

 

Here is the error.

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/pdogclan/public_html/community/addtobasket.php on line 6

 

Here is the code

<?php
include 'connect.php';
include 'timeout.php';
include 'header_signin.php';

$sql = ("INSERT INTO `shp_order_items`(`product_id`, `user_id`) VALUES ('.$_SESSION['prod_id'].' , '.$_SESSION['user_id'].')");

?>

Edited November 10, 2013 by Icewolf

[Ch0cu3r]

If you're using $_SESSION variables within "..." (double quoted string) then you need to wrap the session variable within curly braces

$sql = "INSERT INTO `shp_order_items`(`product_id`, `user_id`) VALUES ('{$_SESSION['prod_id']}' , '{$_SESSION['user_id']}')";

Or use concatenation

$sql = "INSERT INTO `shp_order_items`(`product_id`, `user_id`) VALUES ('".$_SESSION['prod_id']."' , '".$_SESSION['user_id']."')";

Edited November 10, 2013 by Ch0cu3r

[Icewolf]

Thank you Ch0cu3r. That was it.Now I just need to figure out why it is pulling the wrong product id.

 

I need to figure out how to pull the product id of the line they are on now. Here is what I have.

include 'connect.php';
include 'timeout.php';
include 'header_signin.php';

echo '<a class="item" href="redeemer.php">Redeemer</a>';

    $sql = "SELECT * FROM shp_products";
	 
	$result = mysql_query($sql);
 
	if(!$result)
	 
{	 
	
	echo "There are no products.";
	 
}
	 
	else{
	 
	echo '<table border="1">
			  <tr>
			    <th>Image</th>
				<th>Product</th>
				<th>Description</th>
				<th># of Bank Points</th>
				
			  </tr>';	
			

while($row = mysql_fetch_assoc($result))
{
        echo '<tr>';
			echo "<td><img src='images/".$row['prod_image']."'></td>";
			echo '<td>'. $row['prod_name']. '</td>';
			echo '<td>' . $row['prod_desc']. '</td>';
			echo '<td>' . $row['prod_price']. '</td>';
			echo '<td><a href="addtobasket.php?acion&id=1">Select Item</a></td>';
			
		 echo '</tr>'; 
	
						$_SESSION['prod_id'] 	= $row['prod_id'];

Edited November 10, 2013 by Icewolf

[AaronClifford]

By the looks of it your setting the $_SESSION['prod_id'] in the while loop out putting your data.

 

I'm guessing based on the limited code but this line:

echo '<td><a href="addtobasket.php?acion&id=1">Select Item</a></td>';

Should be:

echo '<td><a href="addtobasket.php?acion&id={$row['product_id']}">Select Item</a></td>';

However I'm not sure what "acion" is?

 

Then in addtobasket.php it should be:

$sql = "INSERT INTO `shp_order_items`(`product_id`, `user_id`) VALUES ('{$_GET['id']}' , '{$_SESSION['user_id']}')";

I'm sort of guessing based on the above code, but in theory it should work.

Edited November 10, 2013 by AaronClifford

[Icewolf]

Thank you for looking but when I add echo

echo '<td><a href="addtobasket.php?acion&id={$row['product_id']}">Select Item</a></td>';

I get this error now

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/pdogclan/public_html/community/shop.php on line 40

[AaronClifford]

Try:

echo '<td><a href="addtobasket.php?acion&id='.$row['product_id'].'">Select Item</a></td>';

[Icewolf]

Thanks Aaron that worked but the product id is still not being captured from that row. Now it is just pulling 0.

[AaronClifford]

Ah sorry what is the id field name for `shp_products`, replace the product_id with the id field from `shp_products`

[Icewolf]

that works it was prod_id thanks for your help

Edited November 10, 2013 by Icewolf

[AaronClifford]

No worries glad I could help!