help on online-shopping cart..

**shotokan99** · 04-13-2007, 11:30 PM

hi pipz,

im working on a simple cart, whenever the user click on "add to cart" link i store the data to mysql. then i display these records using a table and each row i place "remove" link.

my problem is if the user click "remove" how will i tell mysql what record to delete?

can someone pls help me on this?

**Mattmaul1992** · 04-13-2007, 11:42 PM

You could use the get method. So the link would be to
www.yoursite.com/yourpage.php?act=remove&id=32

Remember $_GET is usually your friend. Or you could use a JavaScript onclick but the problem there is if someone had JavaScript disabled. using the get method is the way to go for an affective, simplistic manner.

**shotokan99** · 04-15-2007, 09:49 PM

this is how i display the contents of the basket of the user...
--------------------------------
<?php
$x=0;
$total=0;
while($x<$num){
echo '<tr>';
$type=mysql_result($result,$x,'citemtype');
$item=mysql_result($result,$x,'cref');
$price=mysql_result($result,$x,'cprice');
$total=$total+$price;

echo '<td width="45" align="center" height="12">';
echo ''.$type.'</td>';
echo '<td width="131" align="center" height="12">';
echo ''.$item.'</td>';
echo '<td width="54" align="center" height="12">';
echo ''.$price.'</td>';
echo '<td width="98" align="center" height="12">';
echo '<a href="rem.php" style="text-decoration: none">remove</a></td>';

$x++;
}//end while
?>
---------------

this part is where the user would like to remove a certain item:
echo '<a href="rem.php" style="text-decoration: none">remove</a>

now where should i place the $_GET here?

currently the contents of rem.php is these:
-------
<html>
<head>
</head>
<body>
<?php
session_start();
$user = $_SESSION['myuser'];
$conn=mysql_connect(.....) or die('server not found');
$db='mydb';
mysql_select_db($db) or die('.: database done exist :.');
$sel="delete from cart where cuser = '$user'";
$result=mysql_query($sel) or die('.: can\'t perform the query :.');
mysql_close();
?>
<script type="text/javascript">
window.location="basket.php";
</script>
</body>
</html>

since i dont know yet how to remove an item individually..i erase them all.