Hi All,
I’m a newbie programmer that just started learning PHP. I would really appreciate if you can help me out with this issue that I have for about 2 days and couldn’t solve it.
Here is the code that I am using to retrieve data from the database and show it as a nice clean table with a check box beside each item:
<?php
$con = mysql_connect("database", "usename", "password");
if (!$con) {
die('Connection Failed: ' . mysql_error());
}
if (mysql_select_db("database",$con)){
if ($qry= mysql_query("select * from INVENTORY")){
$num=mysql_numrows($qry);
mysql_close();
}
}
?>
<html>
<body>
<form method="POST">
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th>Item</th>
<th>Description</th>
<th>Price</th>
<th>Picture</th>
<th>Selection</th>
</tr>
<?php
while ($row=mysql_fetch_array($qry)) {
$f1=$row['Item_Image'];
$f2=$row['Inventory_ID'];
echo "<tr><td>";
echo $row['Item_Name'];
echo "</td><td>";
echo $row['Item_Details'];
echo "</td><td>";
echo $row['Item_Price'];
echo "</td><td>";
?>
<img src="http://zenit.senecac.on.ca/~php701_121sa03/assign2/<?php echo $f1; ?>" alt= "<?php echo $f1; ?>" width="100" height="100" />
<td> <input type="checkbox" name= <?php echo $f2; ?> /></td>
<?php
echo "</td></tr>";
}
echo "</table>";
?>
</form>
<form action="cart.php" method="POST">
<input type="submit" name="submit" value="Add to the Cart">
</form>
</body>
</html>
So What I wanna do is that when I press submit button, it takes the items that is checked and put them in a temporary cart
this is the page that is called if I press submit buttom, i make a temporary cart and I am trying to input the values that is set to the checkboxes into the temp cart but I have no idea how to do it …
I tried to use cookie to save the values that selected but couldn’t sort that out , I need help …
<?php
$con = mysql_connect("database", "username", "password");
if (!$con) {
die('Connection Failed: ' . mysql_error());
}
$userid = $_COOKIE['loguser'];
$myquery= ("CREATE TABLE " . $userid . "_CART (Cart_Item_ID int auto_increment, PRIMARY KEY(Cart_Item_ID), Item_ID int not null, FOREIGN KEY(Item_ID) REFERENCES INVENTORY(Inventory_ID), Added_On Timestamp default CURRENT_TIMESTAMP)");
$userid = $_COOKIE['loguser'];
if (isset($_POST['submit'])){
if (mysql_select_db("database",$con)) {
if ($qry = mysql_query($myquery,$con)) {
$myquery1= ("insert into ". $userid . "_CART(Item_ID) select Inventory_ID from INVENTORY where INVENTORY.Inventory_ID = ". $_POST;
} else {
die('Database Query Error: ' . mysql_error());
}
}
}
?>
here is my database tables one is inventory, and the other one is temporary cart , Im trying to input the value of inventory_ID into the Item_ID where the check boxes is selected …
Inventory_id is foreign key of temp cart and primary key of Inventory table
±-------------±----------±-----±----±------------------±---------------+
| Field | Type | Null | Key | Default | Extra |
±-------------±----------±-----±----±------------------±---------------+
| Cart_Item_ID | int(11) | NO | PRI | NULL | auto_increment |
| Item_ID | int(11) | NO | MUL | | |
| Added_On | timestamp | YES | | CURRENT_TIMESTAMP | |
±-------------±----------±-----±----±------------------±---------------+
3 rows in set (0.00 sec)
mysql> desc INVENTORY;
±-------------±---------------±-----±----±------------------±---------------+
| Field | Type | Null | Key | Default | Extra |
±-------------±---------------±-----±----±------------------±---------------+
| Inventory_ID | int(11) | NO | PRI | NULL | auto_increment |
| Item_Name | varchar(40) | NO | | | |
| Item_Details | varchar(250) | YES | | NULL | |
| Item_Image | varchar(25) | YES | | noIMG.jpg | |
| Item_Price | float unsigned | YES | | 0 | |
| Added_On | timestamp | YES | | CURRENT_TIMESTAMP | |
±-------------±---------------±-----±----±------------------±---------------+
6 rows in set (0.00 sec)
Please advise me what to do ?
If only you can tell me how to get the checkbox values and show it in the cart page as an echo it will solve lots of my issues as well…