Going Nuts!!

itworks

i'm implementing a shopping cart in a site i had already done and so far i've made it possible to add a certain qty of items to the table cart and keep shopping.

but now i want to have a little box where i can show the user the quantity of items he has in his shopping cart.

i've played arround with codes but nothing seems to work.

i'm using include in the script that calls the function in another script.

i know that i still have a long journey ahead in the various functions of the shopping cart, but i would like to have this one done so i can move ahead.

please help me, how would you do this?

thanks in advance.

jpmoriarty

it's really going to depend on how you're storing your shopping cart items i guess. When i designed one a few months back, I had a table which contained all the shopping carts and all their items (it wasnt a particularly large online shop - just a school shop. If yours is bigger it might be wiser for each customer to have their own table, and their shopping lists go into there...).

If i wanted to know how many items there were in the "cart" all i would do was a query on the table where the "cart id" matched the one i was interested in. Then you can use mssql_num_results (or mysql, depending on what your database is) to return the number of records found - which in turn is the number of items in the cart. (of course, that works if 1 item = 1 product in cart. If you have a quantity field too, then you'd want to do a sum on that in your query that you send to mssql).

That hopefully makes sense, and i think that it should do if you're at the level of designing a shopping cart system. If it doesnt however, then let me know which bit and I (or probably someone more experienced than me!) will try to clear things up.

itworks

i'm having lot's of problems with this shopping cart thing, but since i started to talk about this particular function i'll ask for help only with this one now.

in the index.php page i have include("cart.php"); which is a little script like this:

<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="#999999">
  <tr> 
    <td bgcolor="#b6b7cb"><b><a href="index.php?page=cart"><font color="#FFFFFF">Cart</font></a></b>
	</td>
  </tr>
  <tr>
      <td bgcolor="#F8F8F9">
<?php
include("IEUser.class.php");

$cart = new IEUser();
$cart->seeItems($login_user);
$cart->endIEUser();
?>
      </td>
  </tr>
</table>

the piece of code in IEUser.class.php that is refered in cart.php is:

function seeItems($login_user) {
            $sql = "SELECT * FROM cart WHERE email='$login_user'";
            $rs=$this->bd->executeSQL($sql);

		$n=0;
		while(mysql_fetch_row($rs)) {
				echo "".mysql_result($rs, $n, "qte")." - ";
				echo "".mysql_result($rs, $n, "cod")."";
				echo "<br>";
				$n++;
		}	
    }

this works good, but only if you have items in the cart.
if you don't have any items in the cart, the index.php script will break in include("cart.php"); and won't show the rest of the page.

this also happens when you are seeing the product and choosing the quantity you want and click add item, then it goes back to normal.

hope you can help me 'cause i can't move on 'till i figure out this part.

thanks in advance.

itworks

i solved the problem, i had the seeItems function inside the same class script as login and showCart, once i removed it to another script it solved that particulary problem.

i still have a long way to go and most likely will need all the help you can spare, and i'm sure you will assist me the best you can as you always do.

thanks a lot to you all?! 😉