My shopping cart items stored in session but I want store all items in database.
<?php
if (isset($_POST['order'])) {
$member_id = $_POST['member_id'];
$item_id = $_POST['item_id'];
$item_name = $_POST['item_name'];
$item_price = $_POST['item_price'];
$item_qty = $_POST['item_qty'];
$total = $_POST['total'];
mysql_select_db('shoppingcartdemo', mysql_connect('localhost','root',''))or die(mysql_error());
mysql_query("insert into ordernew (id,item_id,item_name,item_price,item_qty,total,status,member_id) values('','$item_id','$item_name','$item_price','$item_qty','$total','Delivered','$member_id')") or die(mysql_query);
header('location:payment.php');
}
?>