Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    New Coder
    Join Date
    Jul 2011
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    shopping cart problem

    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"
    [HIGHLIGHT="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');
    [/HIGHLIGHT]

    below is my database connection saved ad "db.php"
    Code:
    <?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
    Code:
    <?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.
    Code:
    <?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.
    Code:
    <?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.
    Code:
    <?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>&nbsp;</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
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,979
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    This is way too much code to go through.
    What debugging have you done on your part to determine the problem?

  • #3
    New Coder
    Join Date
    Jul 2011
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    reply

    in my "products.php" page "addtocart" function is not executing.when i click on "addtocart" button i am not getting the products to select.

  • #4
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,979
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    Quote Originally Posted by ravi9510 View Post
    in my "products.php" page "addtocart" function is not executing.when i click on "addtocart" button i am not getting the products to select.
    Post the HTML source of the products.php page.

  • #5
    New Coder
    Join Date
    Jul 2011
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    reply

    in my "billing.php" only my name field is mandatory but i want other fields like email to be of correct format and phone no should be of exactly 10 digits
    unless they are filled it should not accept ......
    tell me how to do it.....

  • #6
    New to the CF scene
    Join Date
    Feb 2010
    Location
    3 Locust Street, Suite A Assonet, MA 02702
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Way too long code!! Would take time to go through it!!

  • #7
    New Coder
    Join Date
    Jul 2011
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    reply

    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 much better.....


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •