function addToCart() { // make sure the product id exist if (isset($_GET['p']) && (int) $_GET['p'] > 0) { $productId = (int) $_GET['p']; } else { header('Location: index.php'); } // does the product exist ? $sql = "SELECT pd_id, pd_qty\n\t FROM tbl_product\n\t\t\tWHERE pd_id = {$productId}"; $result = dbQuery($sql); if (dbNumRows($result) != 1) { // the product doesn't exist header('Location: cart.php'); } else { // how many of this product we // have in stock $row = dbFetchAssoc($result); $currentStock = $row['pd_qty']; if ($currentStock == 0) { // we no longer have this product in stock // show the error message setError('The product you requested is no longer in stock'); header('Location: cart.php'); exit; } } // current session id $sid = session_id(); // check if the product is already // in cart table for this session $sql = "SELECT pd_id\n\t FROM tbl_cart\n\t\t\tWHERE pd_id = {$productId} AND ct_session_id = '{$sid}'"; $result = dbQuery($sql); if (dbNumRows($result) == 0) { // put the product in cart table $sql = "INSERT INTO tbl_cart (pd_id, ct_qty, ct_session_id, ct_date)\n\t\t\t\tVALUES ({$productId}, 1, '{$sid}', NOW())"; $result = dbQuery($sql); } else { // update product quantity in cart table $sql = "UPDATE tbl_cart \n\t\t SET ct_qty = ct_qty + 1\n\t\t\t\tWHERE ct_session_id = '{$sid}' AND pd_id = {$productId}"; $result = dbQuery($sql); } // an extra job for us here is to remove abandoned carts. // right now the best option is to call this function here deleteAbandonedCart(); header('Location: ' . $_SESSION['shop_return_url']); }
$stok = $r[stok]; if ($stok == 0) { echo "stok habis"; } else { // check if the product is already // in cart table for this session $sql = mysql_query("SELECT id_produk FROM orders_temp\n\t\t\t\tWHERE id_produk='{$_GET['id']}' AND id_session='{$sid}'"); $ketemu = mysql_num_rows($sql); if ($ketemu == 0) { // put the product in cart table mysql_query("INSERT INTO orders_temp (id_produk, jumlah, id_session, tgl_order_temp, jam_order_temp, stok_temp)\n\t\t\t\t\tVALUES ('{$_GET['id']}', 1, '{$sid}', '{$tgl_sekarang}', '{$jam_sekarang}', '{$stok}')"); } else { // update product quantity in cart table mysql_query("UPDATE orders_temp \n\t\t\t\t\tSET jumlah = jumlah + 1\n\t\t\t\t\tWHERE id_session ='{$sid}' AND id_produk='{$_GET['id']}'"); } deleteAbandonedCart(); header('Location:media.php?module=keranjangbelanja'); } } elseif ($module == 'keranjang' and $act == 'hapus') { mysql_query("DELETE FROM orders_temp WHERE id_orders_temp='{$_GET['id']}'"); header('Location:media.php?module=keranjangbelanja'); } elseif ($module == 'keranjang' and $act == 'update') { $id = $_POST[id]; $jml_data = count($id); $jumlah = $_POST[jml]; // quantity for ($i = 1; $i <= $jml_data; $i++) { $sql2 = mysql_query("SELECT stok_temp FROM orders_temp\tWHERE id_orders_temp='" . $id[$i] . "'"); while ($r = mysql_fetch_array($sql2)) { if ($jumlah[$i] > $r[stok_temp]) { echo "<script>window.alert('Jumlah yang dibeli melebihi stok yang ada');\n window.location=('media.php?module=keranjangbelanja')</script>";