shopping cart calculate the amount

[JamesB]

Okay, check my previous post though I posted another update.

 

And dont forget to update this one from 'cart' to 'paniers'

 

 

<td><?php print $_SESSION['cart'][$produit['name']]*$produit['quantity'];?>€</td>

[Louffeman]

thers' no output:if(isset($_SESSION['cart'])){$sql="SELECT * FROM trybase WHERE name IN (";$sql.=$id.",";foreach($_SESSION['cart'] as $name=>$value) {$sql.="'".$name."',";}the output is http://www.hostingpics.net/viewer.php?id=617578php3.jpgif(isset($_SESSION['paniers'])){$sql="SELECT * FROM trybase WHERE name IN (";$sql.=$id.",";foreach($_SESSION['paniers'] as $name=>$value) {$sql.="'".$name."',";

[JamesB]

Remove this line: $sql.=$id.",";

 

Then add: echo $sql; after your foreach loop.

 

You will need to reset your cookies and run the page again which stores data into the session.

[Louffeman]

now the output is:SELECT * FROM trybase WHERE name IN ('',SELECT * FROM trybase WHERE name IN ('','produits',error the same:Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:wampserver32wwwsalevotre_panier.php on line 31

[JamesB]

What's the latest code you have?

[Louffeman]

it is the output,http://www.hostingpics.net/viewer.php?id=491451php4.jpg

[Louffeman]

can you tell me what do it do this line ?$sql=substr($sql, 0, -1).") ORDER BY name ASC";

[JamesB]

That line looks fine.

 

What is your latest code?

 

And did you delete your cookies?

[Louffeman]

how can I delete the cookies ?I have never done it

[Louffeman]

ok, I removed all the cookies

[JamesB]

https://www.google.co.uk/?gws_rd=ssl#q=how+to+delete+cookies

[Louffeman]

it is the same after having removed the cookies

[JamesB]

Okay, but can you please post your latest code?

[Louffeman]

for the script:

<?phpif(isset($_SESSION['cart'])){$sql="SELECT * FROM trybase WHERE name IN (";foreach($_SESSION['cart'] as $name=>$value) {$sql.="'".$name."',";}$sql=substr($sql, 0, -1).") ORDER BY name ASC";$query=mysql_query($sql);while ($produit=mysql_fetch_array($query)){?>

the output is:http://www.hostingpics.net/viewer.php?id=203614php5.jpg

[Louffeman]

for the script

<?phpif(isset($_SESSION['paniers'])){$sql="SELECT * FROM trybase WHERE name IN (";foreach($_SESSION['paniers'] as $name=>$value) {$sql.="'".$name."',";}$sql=substr($sql, 0, -1).") ORDER BY name ASC";$query=mysql_query($sql);while ($produit=mysql_fetch_array($query)){?>

the output is:http://www.hostingpics.net/viewer.php?id=678861php6.jpgso, I think $_SESSION['paniers']is no good

[Louffeman]

I will return tomorrow, it is very night here,thank you very much !

[Louffeman]

I found out the solution, in fact, it's very simple, like this:<td><?php print($produit['quantity']*$produit['price'])?></td>thank you so much!