DaniWeb Forum Index > Web Development > PHP

Php Mysql Shopping Cart

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2006

Posts: 25

Reputation: wandie is an unknown quantity at this point

Solved Threads: 0

wandie

Offline

Light Poster

Php Mysql Shopping Cart

Mar 13th, 2008

Could some please help me. I am following a tutorial from "http://www.devarticles.com/c/a/MySQL/Building-A-Persistent-Shopping-Cart-With-PHP-and-MySQL/2/"

I keep getting a "
Parse error: syntax error, unexpected $end in C:\xampp\htdocs\cart1\products.php on line 59"

My db connection is fine but I am trying bring a result from the diagram shown in the url. Please help. This is what I have put in my code from the site the products page.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
 
// This page will list all of the items
// from the items table. Each item will have
// a link to add it to the cart
 
include("db.php");
 
// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
$result = mysql_query("select * from items order by itemName asc");
 
?>
<?php
while($row = mysql_fetch_array($result))
{
?>
<html>
<head>
<title>Products</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
 
<body>
<table>
<tr>
<td width="30%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemName"]; ?>
</font>
</td>
    <td width="10%" height="25"> <font face="verdana" size="1" color="black"> <?php echo $row["itemPrice"]; ?> 
      </font> </td>
<td width="50%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemDesc"]; ?>
</font>
</td>
<td width="10%" height="25">
<font face="verdana" size="1" color="black">
<a href="cart.php?action=add_item&id=<?php echo $row["itemId"]; ?>&qty=1">Add Item</a>
</font>
</td>
</tr>
<tr>
<td width="100%" colspan="4">
<hr size="1" color="red" NOSHADE>
</td>
</tr>
<tr>
<td width="100%" colspan="4">
<font face="verdana" size="1" color="black">
<a href="cart.php">Your Shopping Cart &gt;&gt;</a>
</font>
</td>
</tr>
</table>
</body>
</html>
<?php

// This page will list all of the items
// from the items table. Each item will have
// a link to add it to the cart

include("db.php");

// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
$result = mysql_query("select * from items order by itemName asc");

?>
<?php
while($row = mysql_fetch_array($result))
{
?>
<html>
<head>
<title>Products</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table>
<tr>
<td width="30%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemName"]; ?>
</font>
</td>
    <td width="10%" height="25"> <font face="verdana" size="1" color="black"> <?php echo $row["itemPrice"]; ?> 
      </font> </td>
<td width="50%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemDesc"]; ?>
</font>
</td>
<td width="10%" height="25">
<font face="verdana" size="1" color="black">
<a href="cart.php?action=add_item&id=<?php echo $row["itemId"]; ?>&qty=1">Add Item</a>
</font>
</td>
</tr>
<tr>
<td width="100%" colspan="4">
<hr size="1" color="red" NOSHADE>
</td>
</tr>
<tr>
<td width="100%" colspan="4">
<font face="verdana" size="1" color="black">
<a href="cart.php">Your Shopping Cart &gt;&gt;</a>
</font>
</td>
</tr>
</table>
</body>
</html>

•

Join Date: Nov 2007

Posts: 121

Reputation: Auzzie is an unknown quantity at this point

Solved Threads: 16

Auzzie

Offline

Junior Poster

Re: Php Mysql Shopping Cart

Mar 13th, 2008

If that is all the code from the page it is because you forgot the closing curley brace } for the while loop

•

Join Date: Dec 2006

Posts: 25

Reputation: wandie is an unknown quantity at this point

Solved Threads: 0

wandie

Offline

Light Poster

Re: Php Mysql Shopping Cart

Mar 13th, 2008

•

Originally Posted by Auzzie

If that is all the code from the page it is because you forgot the closing curley brace } for the while loop

Thanks would anyone know where i can get info on how to display information from a database or retrieve info for my items and display them on the page

•

Join Date: Nov 2007

Posts: 121

Reputation: Auzzie is an unknown quantity at this point

Solved Threads: 16

Auzzie

Offline

Junior Poster

Re: Php Mysql Shopping Cart

Mar 13th, 2008

It depends on which database your using (mysql, mssql etc) www.php.net and search mysql

•

Join Date: Dec 2006

Posts: 25

Reputation: wandie is an unknown quantity at this point

Solved Threads: 0

wandie

Offline

Light Poster

Re: Php Mysql Shopping Cart

Mar 14th, 2008

Mysql I am trying to display the info just like the one on the url i sent "http://www.devarticles.com/c/a/MySQL/Building-A-Persistent-Shopping-Cart-With-PHP-and-MySQL/2/"

the results should be at the bottom