cart problem

mclordgt

hey guys i am a newbie on php programming and right i am trying to setup a cart but the problem is i don't know how to pass the value of the quantity upon clicking the add to cart button.. basically here's the situation:

i have a DB that contains products.
i have a table that shows the contents of the DB.
i have a text input where the customer can put in the quantity of the product.
i am having trouble passing the value of the input text to the cart.php
here is the code:

<?php session_start();?>
<?php
$con = mysql_connect("localhost", "root");
if(!$con){
die('Could not connect;'. mysql_error());
}
mysql_select_db("products", $con);

$query=mysql_query("SELECT * from books");
?>
<form action="cart.php" method="post">
<?php
echo "<table>
<tr align='center'>
<td></td>
<td>Title</td>
<td>Author</td>
<td>Price</td>
<td></td>
</tr>";

while($row= mysql_fetch_array($query)){
echo "<tr align='center'>";
echo "<td><input type=\"text\" name=\"qty\" size=\"3\" maxlength=\"3\"></td>";
echo "<td width='250'>".$row['title']."</td>";
echo "<td width='150'>".$row['author']."</td>";
echo "<td width='150'>".$row['price']."</td>";
echo "<td><input type=\"submit\" name=\"add\" value=\"ADD to cart\"></td>";
}
echo "</table>";
?>
</form>

thanks in advance....

dalecosp

cart.php will have access to the field data from the "text" field via $_POST['text'].

djjjozsi

your cart.php doesn't know which item has selected.
Use a primary key in your books table:

echo "<td><input type=\"text\" name=\"qty["  . $row["bookID"] ."]\" size=\"3\" maxlength=\"3\"></td>";
/*
here you can echo the details...
*/
echo "<td><input type=\"submit\" name=\"add\" value=\"ADD to cart\"></td>";

in your cart.php you can get the quantity with this array: $_POST["qty"]

<?php
if (isset($_POST["qty"])) {
    foreach($_POST["qty"] AS $itemID => $q) {
        echo "Selected item: $itemID  with a quantity: $q <br />";
    } 
} 

?>

mclordgt

thanks to those who replied,

i guess that is really my problem,, i don't know to reference the id of the clicked row to the text...

djjjozsi thanks for that input... another question if i may... do i have to put <input type="hidden"> on the code as well or upon clicking the button the id will be referenced to the text already?

thanks again...

bradgrafelman

The id is passed as part of the name of the field; look at djjjozsi's foreach() loop - he showed you exactly how to pair the quantity with the id.

halojoy

This is how I would change the form page.
I have let everything run in php.

<?php

session_start();//Actually No need for SESSION

$con = mysql_connect("localhost", "root");
if(!$con){
die('Could not connect;'. mysql_error());
}
mysql_select_db("products", $con);

$result=mysql_query("SELECT * from books");

echo '<form action="cart.php" method="post">';
echo "<table>
<tr align='center'>
<td></td>
<td>Title</td>
<td>Author</td>
<td>Price</td>
<td></td>
</tr>";
// Loop fetch the $result
while($row= mysql_fetch_array( $result )){
echo "<tr align='center'>";
echo "<td><input type=\"text\" name=\"qty\" size=\"3\" maxlength=\"3\"></td>";
echo "<td width='250'>".$row['title']."</td>";
echo "<td width='150'>".$row['author']."</td>";
echo "<td width='150'>".$row['price']."</td>";
echo "<td><input type=\"submit\" name=\"add\" value=\"ADD to cart\"></td>";
}
echo "</table>";
echo '</form>';

?>

mclordgt

Thanks guys, am trying the code now...

mclordgt

hi am back with another prob...

i have used the code posted by djjjozsi and it worked ok. the problem i have is i can't echo the title of the book and can't multiply the quantity of the product by the price of the individual product can anyone help me with that...

thanks in advance

djjjozsi

In the form you just inserted the primary keys for the books table.

On the next page where you post the form you can save the book_ID and quantity in a session variable or cookie.

On a 'Show ma Cart' page you can pull down the books details based on the session, and count the grand total prise.