SHOW:
|
|
- or go back to the newest paste.
1 | // fungsi untuk mendapatkan isi keranjang belanja | |
2 | function isi_keranjang(){ | |
3 | $isikeranjang = array(); | |
4 | $sid = $_SESSION[email]; | |
5 | $sql = mysqli_query($con,"SELECT * FROM orders_temp WHERE id_session='$sid'"); | |
6 | //hentikan memakai *.. ketik aja nama field yg akan di panggil | |
7 | ||
8 | while ($r=mysqli_fetch_array($sql)) { | |
9 | $isikeranjang[] = $r; | |
10 | } | |
11 | return $isikeranjang; | |
12 | } | |
13 | ||
14 | function query_insert($table, $data){ | |
15 | $sql="insert into `{$table}` "; | |
16 | $sql="(`".implode("`, `",array_keys($data))."`)"; | |
17 | $sql=" values "; | |
18 | ||
19 | $data_convert=array(); | |
20 | foreach($data as $values){ | |
21 | $data_convert[]=addslashes($values); | |
22 | } | |
23 | ||
24 | $sql="('".implode("', '",array_keys($data_convert))."')"; | |
25 | ||
26 | //===semoga bener.. sy belum tes | |
27 | return $sql; | |
28 | } | |
29 | date_default_timezone_set('Asia/Jakarta'); | |
30 | $tgl_skrg = date("Ymd"); | |
31 | $jam_skrg = date("H:i:s"); | |
32 | ||
33 | $id = mysqli_fetch_array(mysqli_query($con,"SELECT id_kustomer FROM kustomer WHERE email='$email' AND password='$password'")); | |
34 | ||
35 | // mendapatkan nomor kustomer | |
36 | $id_kustomer=$id[id_kustomer]; | |
37 | ||
38 | // simpan data pemesanan | |
39 | mysqli_query($con,"INSERT INTO orders(tgl_order,jam_order,id_kustomer) VALUES('$tgl_skrg','$jam_skrg','$id_kustomer')"); | |
40 | ||
41 | ||
42 | // mendapatkan nomor orders | |
43 | $id_orders=mysqli_insert_id($con); | |
44 | ||
45 | // panggil fungsi isi_keranjang dan hitung jumlah produk yang dipesan | |
46 | $isikeranjang = isi_keranjang(); | |
47 | $jml = count($isikeranjang); | |
48 | ||
49 | // simpan data detail pemesanan | |
50 | /* | |
51 | for ($i = 0; $i < $jml; $i++){ | |
52 | mysqli_query($con,"INSERT INTO orders_detail(id_orders, id_produk, jumlah) | |
53 | VALUES('$id_orders','{$isikeranjang[$i]['id_produk']}', '{$isikeranjang[$i]['jumlah']}')"); | |
54 | } | |
55 | */ | |
56 | foreach($isikeranjang as $row){ | |
57 | $input_data=array( | |
58 | 'id_orders' =>$id_orders, | |
59 | 'id_produk'=>$row['produk'], | |
60 | 'jumlah'=>$row['jumlah'] | |
61 | ); | |
62 | $sql= query_insert('orders_detail',$input_data); | |
63 | /* | |
64 | "INSERT INTO orders_detail(id_orders, id_produk, jumlah) | |
65 | VALUES('$id_orders','{$isikeranjang[$i]['id_produk']}', '{$isikeranjang[$i]['jumlah']}')" | |
66 | */ | |
67 | $que = mysqli_query($con,$sql) or die($sql."<hr/>".mysqli_error()); | |
68 | } | |
69 | // setelah data pemesanan tersimpan, hapus data pemesanan di tabel pemesanan sementara (orders_temp) | |
70 | for ($i = 0; $i < $jml; $i++) { | |
71 | mysqli_query($con,"DELETE FROM orders_temp | |
72 | WHERE id_orders_temp = {$isikeranjang[$i]['id_orders_temp']}"); | |
73 | } |