shopping cart

Lylian

Dear all experts,

I am very new to PHP and MySql, I am trying to make my question clear... I am starting to do my shopping cart and I get stuck on the first step. let's say I have a page display a table and this table pulled out from mySql Database, my table has 10 rows (calls R1, R2.. to R10), each row has 3 fields and this table. Now, user want to buy item R3. How can I grab this R3 from my database to throw in the shopping cart? What step am I missing? Do I need a line number or something? so when I click on any line (Row) I can link back to where the "Row" came from to pull out that record to throw in a new table (shopping cart)? Please help. My question might be very dump, I will try to make it clear as much as I can. Thanks

lucasrd

When you display your items in the table, include the item_id in the query string:

Depending on how you set up your cart, you might want to keep track of (at a minimum) session_id, item_id, and quantity.

Lylian

Dear Lucasrd

Thanks, I got the idea but what is the number"4"? Can it be 1 and increment 1+ when I print out my table? but then how can I pull the record out from my database by that ID number to get product "brand or model, price, qty"?. Please see my code below

lucasrd

4 is arbitrary...replace it with code that echos out the item_id...asuming you set up your database with primary, autoincremented keys...

Originally posted by Lylian
Dear Lucasrd

Thanks, I got the idea but what is the number"4"? Can it be 1 and increment 1+ when I print out my table? but then how can I pull the record out from my database by that ID number to get product "brand or model, price, qty"?. Please see my code below

<-- this is a working PHP file called "search.php" How do I do the shopping cart, thank you--->

<html>
<-- my Search button------------------>
<form method="post" action="search.php">
<input type="text" name="search" size="20">
<input type="submit" name = "submit" value="Search!">
</form>

<?php

I have cut un-needed lines to make it easier for you to help.

mylogon.php contains Host name, user and password

include('mylogon.php');
Print ("Searching For:<b>$search</b><br><br>");
$link = mysql_connect(Host,user,Password);
mysql_select_db(myd😎;

#------- my table Inventory for DVD, VCR etc. Will print more than 1 row, could be 10.. matching brand but different model how do I IDs?

$query= "SELECT * FROM INVENTORY WHERE Model LIKE '%$search%' OR Brand LIKE '%$search%'";
$result = mysql_query($query);

#------Print out all the matching Brand, model found on mysql database from inventory table..

while ($row = mysql_fetch_object ($result)) {
Print ("<td align=center>  $row->Brand</td>");
Print ("<td align=center>  $row->Model</td>");
Print ("<td align=center>  $row->Stock</td>");
 	Print ("<td align=center>$ $row->Price</td>");
}

mysql_close($link);
?>
</html> [/B]

Lylian

got it, thanks all