Shopping cart problem

PHP
1

hi all,
i am working on a simple shopping cart program.I have created one database and stored images too in database.
i am not getting executed the shopping cart.tell me what went wrong.
below is my database i have created…
it is saved as “shopping.sql”



-- Table structure for table `customers`

CREATE TABLE IF NOT EXISTS `customers`(
  `serial` int(11) NOT NULL auto_increment,
  `name` varchar(20) collate latin1_general_ci NOT NULL,
  `email` varchar(80) collate latin1_general_ci NOT NULL,
  `address` varchar(80) collate latin1_general_ci NOT NULL,
  `phone` varchar(20) collate latin1_general_ci NOT NULL,
  PRIMARY KEY(`serial`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

-- Table structure for table `orders`

CREATE TABLE IF NOT EXISTS `orders` (
  `serial` int(11) NOT NULL auto_increment,
  `date` date NOT NULL,
  `customerid` int(11) NOT NULL,
  PRIMARY KEY(`serial`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
-- Dumping data for table `orders`

-- Table structure for table `order_detail`
CREATE TABLE IF NOT EXISTS `order_detail` (
  `orderid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- Dumping data for table `order_detail`

-- Table structure for table `products`
CREATE TABLE IF NOT EXISTS `products`(
  `serial` int(11) NOT NULL auto_increment,
  `name` varchar(20) collate latin1_general_ci NOT NULL,
  `description` varchar(255) collate latin1_general_ci NOT NULL,
  `price` float NOT NULL,
  `picture` varchar(80) collate latin1_general_ci NOT NULL,
  PRIMARY KEY(`serial`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7;

INSERT INTO `products` (`serial`, `name`, `description`, `price`, `picture`) VALUES
(1, 'View Sonic LCD', '19" View Sonic Black LCD, with 10 months warranty', 250, 'images/lcd.jpg'),
(2, 'IBM CDROM Drive', 'IBM CDROM Drive', 80, 'images/cdrom-drive.jpg'),
(3, 'Laptop Charger', 'Dell Laptop Charger with 6 months warranty', 50, 'images/charger.jpg'),
(4, 'Seagate Hard Drive', '80 GB Seagate Hard Drive in 10 months warranty', 40, 'images/hard-drive.jpg'),
(5, 'Atech Mouse', 'Black colored laser mouse. No warranty', 5, 'images/mouse.jpg'),
(6, 'Nokia 5800', 'Nokia 5800 XpressMusic is a mobile device with 3.2" widescreen display brings photos, video clips and web content to life', 299, 'images/mobile.jpg');

below is my database connection saved ad “db.php”


<?php
mysql_connect("localhost","root","") or die("mysql_error()");
mysql_select_db("shopping") or die("mysql_error()");
session_start();
?>

below is my “functions.php” program


<?php
function get_product_name($pid)
 {
  $result=mysql_query("select name from products where serial=$pid");
  $row=mysql_fetch_array($result);
  return $row['name'];
 }

function get_price($pid)
 {
  $result=mysql_query("select price from products where serial=$pid");
  $row=mysql_fetch_array($result);
  return $row['price'];
 }

function remove_product($pid)
 {
  $pid=intval($pid);
  $max=count($_SESSION['cart']);
  for($i=0;$i<$max;$i++)
   {
    if($pid==$_SESSION['cart'][$i]['productid'])
     {
	unset($_SESSION['cart'][$i]);
	break;
     }
   }
    $_SESSION['cart']=array_values($_SESSION['cart']);
 }

function get_order_total()
{
 $max=count($_SESSION['cart']);
 $sum=0;
 for($i=0;$i<$max;$i++)
 {
  $pid=$_SESSION['cart'][$i]['productid'];
  $q=$_SESSION['cart'][$i]['qty'];
  $price=get_price($pid);
  $sum+=$price*$q;
 }
return $sum;
}

function addtocart($pid,$q)
 {
  if($pid<1 or $q<1) return;
  if(is_array($_SESSION['cart']))
   {
    if(product_exists($pid)) return;
    $max=count($_SESSION['cart']);
    $_SESSION['cart'][$max]['productid']=$pid;
    $_SESSION['cart'][$max]['qty']=$q;
   }
    else
     {
      $_SESSION['cart']=array();
      $_SESSION['cart'][0]['productid']=$pid;
      $_SESSION['cart'][0]['qty']=$q;
     }
 }
	
function product_exists($pid)
 {
  $pid=intval($pid);
  $max=count($_SESSION['cart']);
  $flag=0;
  for($i=0;$i<$max;$i++)
  {
   if($pid==$_SESSION['cart'][$i]['productid'])
    {
     $flag=1;
     break;
    }
  }
return $flag;
 }
?>

below is the “products.php”.this is the program from where my shopping cart begins.here i am not getting displayed the product image,price.and “addtocart” button is also not executing.


<?php
include("db.php");
include("functions.php");
if($_REQUEST['command']=='add' && $_REQUEST['productid']>0)
 {
  $pid=$_REQUEST['productid'];
  addtocart($pid,1);
  header("location:shoppingcart.php");
  exit();
 }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Products</title>
<script type="text/javascript">
function addtocart(pid)
 {
  document.form1.productid.value=pid;
  document.form1.command.value='add';
  document.form1.submit();
 }
</script>
</head>
<body>
<form name="form1">
<input type="hidden" name="productid" />
<input type="hidden" name="command" />
</form>
<div align="center">
<h1 align="center">Products</h1>
<table border="0" cellpadding="2px" width="600px">
<?php
 $result=mysql_query("select * from products");
 while($row=mysql_fetch_array($result))
  {
?>
   <tr>
    <td><img src="<?php=$row['picture']?>" /></td>
    <td><b>       <?php=$row['name']?></b><br />
                  <?php=$row['description']?><br />
				  Price:<big style="color:green">
                 $<?php=$row['price']?></big><br /><br />
       <input type="button" value="Add to Cart" onclick="addtocart(<?php=$row['serial']?>)" />
	</td>
	</tr>
      <tr><td colspan="2"><hr size="1" /></td></tr>
       <?php
 } 
       ?>
</table>
</div>
</body>
</html>

below is my “shoppingcart.php” program after selecting no of items for shopping the below program id displayed.


<?php
include("db.php");
include("functions.php");
if($_REQUEST['command']=='delete' && $_REQUEST['pid']>0)
 {
  remove_product($_REQUEST['pid']);
 }
else if($_REQUEST['command']=='clear')
 {
  unset($_SESSION['cart']);
 }
else if($_REQUEST['command']=='update')
 {
  $max=count($_SESSION['cart']);
  for($i=0;$i<$max;$i++)
   {
    $pid=$_SESSION['cart'][$i]['productid'];
    $q=intval($_REQUEST['product'.$pid]);
    if($q>0 && $q<=999)
     {
	$_SESSION['cart'][$i]['qty']=$q;
     }
	else
     {
	  $msg='Some products not updated!,quantity must be a number between 1 and 999';
	 }
   }
 }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Shopping Cart</title>
<script type="text/javascript">
function del(pid)
{
 if(confirm('Do you really mean to delete this item?'))
   {
    document.form1.pid.value=pid;
    document.form1.command.value='delete';
    document.form1.submit();
   }
}

function clear_cart()
{
 if(confirm('This will empty your shopping cart, continue?'))
  {
    document.form1.command.value='clear';
    document.form1.submit();
  }
}

function update_cart()
 {
  document.form1.command.value='update';
  document.form1.submit();
 }

</script>
</head>
<body>
<form name="form1" method="post">
<input type="hidden" name="pid" />
<input type="hidden" name="command" />
<div style="margin:0px auto; width:600px;" >
  <div style="padding-bottom:10px">
   <h1 align="center">Your Shopping Cart</h1>
   <input type="button" value="Continue Shopping" onclick="window.location='products.php'" />
  </div>
    <div style="color:#F00"><?php=$msg?></div>
    <table border="0" cellpadding="5px" cellspacing="1px" style="font-family:Verdana, Geneva, sans-serif; font-size:11px; background-color:#E1E1E1" width="100%">
    <?php
    if(is_array($_SESSION['cart']))
      {
        echo '<tr bgcolor="#FFFFFF" style="font-weight:bold">
	    <td>Serial</td>
	    <td>Name</td>
		<td>Price</td>
		<td>Qty</td>
	    <td>Amount</td>
		<td>Options</td></tr>';
	    $max=count($_SESSION['cart']);
	     for($i=0;$i<$max;$i++)
          {
		 $pid=$_SESSION['cart'][$i]['productid'];
		 $q=$_SESSION['cart'][$i]['qty'];
		 $pname=get_product_name($pid);
		 if($q==0) continue;
	?>
  <tr bgcolor="#FFFFFF"><td><?php=$i+1?></td><td><?php=$pname?></td>
     <td>$ <?php=get_price($pid)?></td>
     <td><input type="text" name="product<?php=$pid?>" value="<?php=$q?>" maxlength="3" size="2" /></td>
     <td>$ <?php=get_price($pid)*$q?></td>
     <td><a href="javascript:del(<?php=$pid?>)">Remove</a></td>
  </tr>
 <?php
 }
 ?>
	<tr>
	<td><b>Order Total: $<?php=get_order_total()?></b></td>
	<td colspan="5" align="right">
	<input type="button" value="Clear Cart" onclick="clear_cart()">
    <input type="button" value="Update Cart" onclick="update_cart()">
    <input type="button" value="Place Order" onclick="window.location='billing.php'">
	</td>
	</tr>
  <?php
      }
	else
     {
	echo "<tr bgColor='#FFFFFF'><td>There are no items in your shopping cart!</td>";
	}
	?>
     </table>
   </div>
</form>
</body>
</html>

this is the final “billing.php”.if only user name is given it will execute.
but i want all things to be mandatory.


<?php
include("db.php");
include("functions.php");
if($_REQUEST['command']=='update')
{
  $name=$_REQUEST['name'];
  $email=$_REQUEST['email'];
  $address=$_REQUEST['address'];
  $phone=$_REQUEST['phone'];
  $result=mysql_query("insert into customers values('','$name','$email','$address','$phone')");
  $customerid=mysql_insert_id();
  $date=date('Y-m-d');
  $result=mysql_query("insert into orders values('','$date','$customerid')");
  $orderid=mysql_insert_id();	
  $max=count($_SESSION['cart']);
  for($i=0;$i<$max;$i++)
   {
    $pid=$_SESSION['cart'][$i]['productid'];
    $q=$_SESSION['cart'][$i]['qty'];
    $price=get_price($pid);
    mysql_query("insert into order_detail values($orderid,$pid,$q,$price)");
   }
	die('Thank You! your order has been placed!');
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Billing Info</title>
<script type="text/javascript">
 function validate()
  {
	var f=document.form1;
	 if(f.name.value=='')
      {
		alert('Your name is required');
		f.name.focus();
		return false;
	  }
		f.command.value='update';
		f.submit();
 }
</script>
</head>
<body>
<form name="form1" onsubmit="return validate()">
    <input type="hidden" name="command" />
	<div align="center">
        <h1 align="center">Billing Info</h1>
        <table border="0" cellpadding="2px">
         <tr><td>Order Total:</td><td><?=get_order_total()?></td></tr>
         <tr><td>Your Name:</td><td><input type="text" name="name" /></td></tr>
         <tr><td>Address:</td><td><input type="text" name="address" /></td></tr>
         <tr><td>Email:</td><td><input type="text" name="email" /></td></tr>
         <tr><td>Phone:</td><td><input type="text" name="phone" /></td></tr>
         <tr><td> </td><td><input type="submit" value="Place Order" /></td></tr>
        </table>
	</div>
</form>
</body>
</html>

tell me what went wrong why it is not executing…

2

hi ,
for the above shopping cart written in php and html whether it is possible to do in JQUERY and CSS and and by javascript…
kindly tell me how to do with JQUERY and CSS for looking still good…

3

in my “billing.php” i want all fields to be mandatory presently i have only name field is mandatory. i want email,phone no also should be mandatory…
tell me how to do it…

4

validate the fields, preferably with a regex, and if they do not contain valid input display an appropriate message to enter valid inputs.

5

Have you walked through the code yourself, to see where it might have gone wrong?

Always the first step a programmer would take. Make a note of your variables, and keep an eye out for spelling mistakes - they’re the most common problem.

6

i think there are no spelling mistakes and i have declared the variables correctly

7

As StarLion says, you need to walk through your code and check the actual values of variables as they are created.

Stepping through your code also tells you if your code logic is corrrect.

8

can u tell me where i went wrong.i am not getting executed the “addtocart” function is it the problem.

9

not without spending time stepping through your code to debug it and I don’t see why you can’t step through the code yourself.

You can use echo and alert statements to check if your code is doing what it’s supposed to.

10

in my database i have stored picture as “image/lcd.jpg” in products table whether it is correct. i am not getting displaying the image and the price of the item.
tell me what to do to display the image

11

I haven’t got time now to step through your code to debug it.

Post the line that is supposed to display the image that is not appearing.

12

firstly i have created the table “products” with 5 fields.tell me whether it is correct or not.


CREATE TABLE IF NOT EXISTS `products` (
  `serial` int(11) NOT NULL auto_increment,
  `name` varchar(20) collate latin1_general_ci NOT NULL,
  `description` varchar(255) collate latin1_general_ci NOT NULL,
  `price` float NOT NULL,
  `picture` varchar(80) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`serial`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`serial`, `name`, `description`, `price`, `picture`) VALUES
(1, 'View Sonic LCD', '19" View Sonic Black LCD, with 10 months warranty', 250, 'images/lcd.jpg'),
(2, 'IBM CDROM Drive', 'IBM CDROM Drive', 80, 'images/cdrom-drive.jpg'),
(3, 'Laptop Charger', 'Dell Laptop Charger with 6 months warranty', 50, 'images/charger.jpg'),
(4, 'Seagate Hard Drive', '80 GB Seagate Hard Drive in 10 months warranty', 40, 'images/hard-drive.jpg'),
(5, 'Atech Mouse', 'Black colored laser mouse. No warranty', 5, 'images/mouse.jpg'),
(6, 'Nokia 5800', 'Nokia 5800 XpressMusic is a mobile device with 3.2" widescreen display brings photos, video clips and web content to life', 299, 'images/mobile.jpg');

this is the line where i want to display the image but it is not getting displayed in “products.php” page

<td><img src=“<?php=$row[‘picture’]?>” /></td>

13 
<td><img src="<?php=$row['picture']?>" /></td>

ok, to help you get started with your debugging, if the image is not being displayed then there is a problem with the src value.

First,

<?php=$row['picture']?>

should be

<?php echo $row['picture']; ?>

If that doesn’t display the image then do the following to check if the src is correct:


<?php
echo $row['picture'];

die();
?>
<td><img src="<?php echo $row['picture']; ?>" /></td>

The relative path for the src needs to be relative to the directory the php file is in.

14

thank you i have done like u said now it is displaying images and price and description and working fine.
just i have replaced = with echo in all things
below
<td><img src=“<?php = $row[‘picture’]?>” /></td>
<td><b><?php = $row[‘name’]?></b><br />
as
<td><img src=“<?php echo $row[‘picture’]?>” /></td>
<td><b><?php echo $row[‘name’]?></b><br />
tell me what much difference it makes replacing = with echo inside <?php and ?>

15

You need to actually output the value of $row[‘picture’] to the html. Echo and print commands are the only 2 ways I can think of to do that. I’m just used to using echo.

16

in my “db.php” i have used session_start() .in my database for customers table it is displaying two the value each two times i have given in “billing.php”.why it is showing that…

17

the difference is you were trying to use short tags instead of the command.

<?= is (unfortunately) the same as saying <?php echo