azmicolejr

add to cart

Jan 28th, 2015
324
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. <?php session_start();
  2. include "config.php";
  3.  
  4. $id = $_GET['id'];
  5.  
  6. $cari_barang = "SELECT * FROM barangtbl WHERE id=$id";
  7. $hasil_barang = mysql_query($cari_barang);
  8. $data_barang = mysql_fetch_array($hasil_barang);
  9.  
  10. $ciri = $data_barang['id'];
  11. $nam = $data_barang['judul_barang'];
  12. $berat = $data_barang['berat'];
  13. $jumlah_berat = $data_barang['jumlah_berat'];
  14. $har = $data_barang['harga'];
  15. if((isset($_SESSION['userlogin'])) =='')
  16. {
  17. header("location:fail_buy.php");
  18. }
  19. else
  20. {
  21. $member = $_SESSION['userlogin'];
  22. if($hasil_barang)
  23. {
  24. require ("faktur.php");
  25. $cari_transaksi = "SELECT * FROM transaksirincitbl WHERE username='".$member."' AND id = '".$id."' AND notransaksi ='".$faktur."'";
  26. $hasil_transaksi = mysql_query($cari_transaksi);
  27. $temukan = mysql_num_rows($hasil_transaksi);
  28. $data_transaksi = mysql_fetch_array($hasil_transaksi);
  29. if($temukan==0)
  30. {
  31. $query = "INSERT into transaksirincitbl (notransaksi,username,id,nama,berat,jumlah_berat,harga,jumlah,subtotal)
  32. VALUES ('$faktur','$member','$ciri','$nam','$berat','$berat','$har','1.0','$har')";
  33. $result = mysql_query($query);
  34.  
  35. header("location:shopping_cart.php");
  36. }
  37. else
  38. {
  39. $jmllama = $data_transaksi['jumlah'];
  40. $jmltambah = $jmllama + 1;
  41. $subtotaltambah = $jmltambah * $har;
  42.  
  43. $jmlberatlama = $data_transaksi['berat'];
  44. $jmlberattambah = $jmlberatlama * $data_transaksi['jumlah_berat'];
  45.  
  46. $query = "UPDATE transaksirincitbl SET jumlah = '".$jmltambah."',jumlah_berat = '".$jmlberattambah."',subtotal = '".$subtotaltambah."'
  47. WHERE notransaksi ='".$faktur."' and id ='".$id."'";
  48. $result = mysql_query($query);
  49. header("location:shopping_cart.php");
  50. }
  51. }
  52. else
  53. {
  54. echo "Data gagal diInput..!";
  55. }
  56. }
  57. ?>
Advertisement
Add Comment
Please, Sign In to add comment