View Full Version : how to insert multiple rows into mysql

05-24-2011, 12:31 AM
Atm i have almost complete the insert page just 2 things left and need some help.

my insert page looks like

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

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

mysql_select_db("mypc", $con);

$sql1="INSERT INTO sales(address, paymethod, creditcard,cardtype,username,cartTotal,phone) VALUES
if (!mysql_query($sql1,$con))
die('Error: ' . mysql_error());
$sql2="INSERT INTO orders(unitprice,pricetotal,quantity,productid ) VALUES
if (!mysql_query($sql2,$con))
die('Error: ' . mysql_error());


1--> Atm sql2 insert only the last product's id at the table.
I need to insert all products chosen by the user.
If for example made 10 selections then i insert all 10 rows into mysql

2--> I want to display a message to him like "the processing was successfull" but in the same page. Atm when i insert the products i see a blank page or a message which i removed.

05-24-2011, 06:33 AM
Use a loop.

05-24-2011, 11:51 AM
I tried this but i get an error on forech... any suggestions?

foreach ($_SESSION['productid'] as $value)
echo $sql2="INSERT INTO orders(unitprice,pricetotal,quantity,productid ) VALUES
if (!mysql_query($sql2,$con))
die('Error: ' . mysql_error());

05-24-2011, 01:56 PM
Ok i have managed to insert into the table equal products like products the user chose, but though my data is not all correct i working on it know if u have any suggestions tnx!!

foreach ($_SESSION['cart_array'] as $value) {
$sql2="INSERT INTO orders(unitprice,pricetotal,quantity,productid,username ) VALUES
if (!mysql_query($sql2,$con))
die('Error: ' . mysql_error());

And my cart

$cartOutput="<h2 align='center'>your shopping cart is empty</h2>";
foreach($_SESSION["cart_array"]as $each_item){
$sql=mysql_query("SELECT productid,productname,price,image FROM products WHERE productid='$item_id' LIMIT 1");
while($row= mysql_fetch_array($sql)){

$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.'" />
//$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.'" />