...

View Full Version : insert data from cart to mysql



garevn
05-23-2011, 03:05 PM
Hello I have a cart and i want to insert some users data into mysql in 2 different tables.

My basic cart code is this



<?php
$cartOutput="";
$cartTotal="";
if(!isset($_SESSION["cart_array"])||count($_SESSION["cart_array"])<1){
$cartOutput="<h2 align='center'>your shopping cart is empty</h2>";
}else{
$i=0;
foreach($_SESSION["cart_array"]as $each_item){
$item_id=$each_item['item_id'];
$sql=mysql_query("SELECT productid,productname,price,image FROM products WHERE productid='$item_id' LIMIT 1");
while($row= mysql_fetch_array($sql)){
$productname=$row['productname'];
$price=$row['price'];
$image=$row['image'];
$productid=$row['productid'];
}
$pricetotal=number_format($price*$each_item['quantity'],2,".","");
$cartTotal=number_format($pricetotal+$cartTotal,2,".","");

$cartOutput.="<tr>";
$cartOutput.='<td><img src="images/site pic 2/mysql/'.$image.'" width="45" height="45" /></td>';
$cartOutput.='<td>'. $productid.'</td>';
$cartOutput.='<td>'. $productname.'</td>';
$cartOutput.='<td>$'. $price.'</td>';
$cartOutput.='<td><form action="mycart.php" method="post">
<input name="quantity" type="text" value="'. $each_item['quantity'].'" size="1" maxlength="2" />
<input name="adjustBtn'.$item_id.'" type="submit" value="change" />
<input name="item_to_adjust" type="hidden" value="'.$item_id.'" />
</form></td>';
//$cartOutput.='<td>'. $each_item['quantity'].'</td>';
$cartOutput.='<td>$'. $pricetotal.'</td>';
$cartOutput.='<td><form action="mycart.php" method="post">
<input name="deleteBtn'.$item_id.'" type="submit" value="X" />
<input name="index_to_remove" type="hidden" value="'.$i.'" />
</form>
</td>';
$cartOutput.='</tr>';
$i++;

}

$cartTotal="<div align='center'>Cart Total: $".$cartTotal."</div>";
}
?>



When the user wish to buy the products i display him a form to complete some data like address/credit card/payment method/and card type.
i have method post and action orderdata.php.


I Tried to pass some values with sessions but i am not really experienced.

My current orderdata.php looks like this





<?php
session_start();

$productid=$_SESSION['productid'] ;
$pricetotal=$_SESSION['pricetotal'] ;
$price=$_SESSION['price'] ;
$cartTotal=$_SESSION['cartTotal'] ;
$each_item=$_SESSION['quantity'] ;


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

mysql_select_db("mypc", $con);

$sql="INSERT INTO sales (address, paymethod, creditcard,credittype,totalprice)
VALUES
('$_POST[address]','$_POST[RadioGroup1]','$_POST[pass]', '$_POST[type]','$cartTotal')";

$sql="INSERT INTO orders (productid, quantity, unitprice, pricetotal)
VALUES
('$productid','$each_item','$price','$pricetotal')";


if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con)
?>

garevn
05-23-2011, 03:27 PM
Ok i almosd done everything tnx anyway



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum