Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // fungsi untuk mendapatkan isi keranjang belanja
- function isi_keranjang(){
- $isikeranjang = array();
- $sid = $_SESSION[email];
- $sql = mysqli_query($con,"SELECT * FROM orders_temp WHERE id_session='$sid'");
- //hentikan memakai *.. ketik aja nama field yg akan di panggil
- while ($r=mysqli_fetch_array($sql)) {
- $isikeranjang[] = $r;
- }
- return $isikeranjang;
- }
- function query_insert($table, $data){
- $sql="insert into `{$table}` ";
- $sql="(`".implode("`, `",array_keys($data))."`)";
- $sql=" values ";
- $data_convert=array();
- foreach($data as $values){
- $data_convert[]=addslashes($values);
- }
- $sql="('".implode("', '",array_keys($data_convert))."')";
- //===semoga bener.. sy belum tes
- return $sql;
- }
- 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']}')");
- }
- */
- foreach($isikeranjang as $row){
- $input_data=array(
- 'id_orders' =>$id_orders,
- 'id_produk'=>$row['produk'],
- 'jumlah'=>$row['jumlah']
- );
- $sql= query_insert('orders_detail',$input_data);
- /*
- "INSERT INTO orders_detail(id_orders, id_produk, jumlah)
- VALUES('$id_orders','{$isikeranjang[$i]['id_produk']}', '{$isikeranjang[$i]['jumlah']}')"
- */
- $que = mysqli_query($con,$sql) or die($sql."<hr/>".mysqli_error());
- }
- // 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