html到php到mysql_我需要使用PHP将数据从HTML表存储到MySQL数据库

我正在做一个HTML，CSS，PHP和MySQL的项目。该项目是一个网上蔬菜店，几乎是一个电子商务网站。我需要使用PHP将数据从HTML表格(我的购物车)存储到MySQL数据库。该表看起来像这样：

http://i.imgur.com/OngFBuP.png

“购物车”的代码是：

'<?php

include("session.php");

include_once("config.php");

?>

View shopping cart

View Cart

if(isset($_SESSION["cart_products"]))

{

$total = 0;

$fl=1;

$b = 0;

foreach ($_SESSION["cart_products"] as $cart_itm)

{

$product_name = $cart_itm["product_name"];

$product_qty = $cart_itm["product_qty"];

$product_price = $cart_itm["product_price"];

$product_code = $cart_itm["product_code"];

$subtotal = ($product_price * $product_qty);

$bg_color = ($b++%2==1) ? 'odd' : 'even';

echo '

';

echo '

'.$fl.'';

echo '

'.$user.'';

echo '

name="product_qty['.$product_code.']" value="'.$product_qty.'" />

';

echo '

'.$product_name.'';

echo '

'.$product_price.'';

echo '

'.$subtotal.'';

echo '

value="'.$product_code.'" />

';

echo '

';

$fl++;

$total = ($total + $subtotal);

}

echo$fl;

$grand_total = $total;

}

?>

buy

echo $current_url; ?>" />

'我正在使用PHP页面(buy.php)来存储数据库中的所有数据。 buy.php的代码是：

'<?php

include('session.php');

$con=new mysqli("localhost","root","","test");

$total=0;

foreach ($_SESSION["cart_products"] as $cart_itm)

{

$product_name = $cart_itm["product_name"];

$product_qty = $cart_itm["product_qty"];

$product_price = $cart_itm["product_price"];

$product_code = $cart_itm["product_code"];

$subtotal = ($product_price * $product_qty);

$total = ($total + $subtotal);

}

$sql="INSERT INTO cart (Uname,TotalCost,veg_id,quantity)

VALUES('$user','$total','$product_code','$product_qty')";

if($con->query($sql)==true){

echo"data inserted successfully";

}

echo" Return to Your Dashboard

Buy More Items";

?>'问题是这个buy.php页实际上是将最后一条记录存储到数据库中。图片链接：

http://i.imgur.com/ZaCnvjI.png

我想将所有的购物车物品存储到数据库中。我需要做些什么来解决这个问题？