drimlen

insert

Jun 6th, 2012
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.80 KB | None | 0 0
  1. <html>
  2.  
  3. <head>
  4.   <title>View Data</title>
  5. </head>
  6.  
  7. <body>
  8.  
  9. <?php
  10.  
  11.     include("../connect.php");
  12. //ini skrip terakhir yang saya buat ka
  13. //sebelumnya udah saya pake in $_POST['nama_button']{...} ga mau
  14. //pake $doTrans = $_GET['nama_button'];
  15. //$_POST[$doTrans]{..} ga bisa juga
  16.  
  17.     $idproduk = $_POST['idproduk'];
  18.     $merk = $_POST['merk'];
  19.     $kategori = $_POST['kategori'];
  20.     $harga = $_POST['harga'];
  21.     $qty = $_POST['QTY'];
  22.  
  23.     $sql = "insert into detail_transaksi (id_produk, merk_produk, kategori, harga_jual, qty) " .
  24.         "value ('$idproduk', '$merk', '$kategori', '$harga', '$qty')";
  25.     $result = mysql_query($sql, $conn)or
  26.     die(mysql_error()."An error occure in SQL Query <br> Query: $sql");
  27.  
  28.     echo "<font face='calibri' size='32' >Terima kasih telah membeli produk kami";
  29.    
  30. ?>
  31.  
  32. </body>
  33.  
  34. </html>
Advertisement
Add Comment
Please, Sign In to add comment