Advertisement
andri_ganda_saputra1

php error

Nov 19th, 2017
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.45 KB | None | 0 0
  1. function isi_keranjang(){
  2.   $isikeranjang = array($con);
  3.   $sid = $_SESSION[email];
  4.   $sql1 ="SELECT * FROM orders_temp WHERE id_session='$sid'";
  5.   $hasil1 = mysqli_query($con,$sql1);
  6.  
  7.   while ($r3=mysqli_fetch_array($hasil1)) {
  8.     $isikeranjang[] = $r3;
  9.   }
  10.   return $isikeranjang;
  11. }
  12. date_default_timezone_set('Asia/Jakarta');
  13. $tgl_skrg = date("Ymd");
  14. $jam_skrg = date("H:i:s");
  15.  
  16. $id = mysqli_fetch_array(mysqli_query($con,"SELECT id_kustomer FROM kustomer WHERE email='$email' AND password='$password'"));
  17.  
  18. // mendapatkan nomor kustomer
  19. $id_kustomer=$id[id_kustomer];
  20.  
  21. // simpan data pemesanan
  22. mysqli_query($con,"INSERT INTO orders(tgl_order,jam_order,id_kustomer) VALUES('$tgl_skrg','$jam_skrg','$id_kustomer')");
  23.  
  24.  
  25. // mendapatkan nomor orders
  26. $id_orders=mysqli_insert_id($con);
  27.  
  28. // panggil fungsi isi_keranjang dan hitung jumlah produk yang dipesan
  29. $isikeranjang = isi_keranjang();
  30. $jml          = count($isikeranjang);
  31.  
  32. // simpan data detail pemesanan  
  33. for ($i = 0; $i < $jml; $i++){
  34.  
  35. mysqli_query($con,"INSERT INTO orders_detail(id_orders, id_produk, jumlah)
  36.              VALUES('$id_orders','{$isikeranjang[$i]['id_produk']}', '{$isikeranjang[$i]['jumlah']}')");
  37. }
  38.  
  39. // setelah data pemesanan tersimpan, hapus data pemesanan di tabel pemesanan sementara (orders_temp)
  40. for ($i = 0; $i < $jml; $i++) {
  41. mysqli_query($con,"DELETE FROM orders_temp
  42.              WHERE id_orders_temp = {$isikeranjang[$i]['id_orders_temp']}");
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement