Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function isi_keranjang(){
- $isikeranjang = array($con);
- $sid = $_SESSION[email];
- $sql1 ="SELECT * FROM orders_temp WHERE id_session='$sid'";
- $hasil1 = mysqli_query($con,$sql1);
- while ($r3=mysqli_fetch_array($hasil1)) {
- $isikeranjang[] = $r3;
- }
- return $isikeranjang;
- }
- date_default_timezone_set('Asia/Jakarta');
- $tgl_skrg = date("Ymd");
- $jam_skrg = date("H:i:s");
- $id = mysqli_fetch_array(mysqli_query($con,"SELECT id_kustomer FROM kustomer WHERE email='$email' AND password='$password'"));
- // mendapatkan nomor kustomer
- $id_kustomer=$id[id_kustomer];
- // simpan data pemesanan
- mysqli_query($con,"INSERT INTO orders(tgl_order,jam_order,id_kustomer) VALUES('$tgl_skrg','$jam_skrg','$id_kustomer')");
- // mendapatkan nomor orders
- $id_orders=mysqli_insert_id($con);
- // panggil fungsi isi_keranjang dan hitung jumlah produk yang dipesan
- $isikeranjang = isi_keranjang();
- $jml = count($isikeranjang);
- // simpan data detail pemesanan
- for ($i = 0; $i < $jml; $i++){
- mysqli_query($con,"INSERT INTO orders_detail(id_orders, id_produk, jumlah)
- VALUES('$id_orders','{$isikeranjang[$i]['id_produk']}', '{$isikeranjang[$i]['jumlah']}')");
- }
- // setelah data pemesanan tersimpan, hapus data pemesanan di tabel pemesanan sementara (orders_temp)
- for ($i = 0; $i < $jml; $i++) {
- mysqli_query($con,"DELETE FROM orders_temp
- WHERE id_orders_temp = {$isikeranjang[$i]['id_orders_temp']}");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement