Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. $host = '127.0.0.1';
  2. $user = 'root';
  3. $password = '';
  4. $database = 'undian';
  5.  
  6. // Koneksi dan memilih database di server
  7. $conect=mysqli_connect($host,$user,$password) or die("Koneksi gagal");
  8. mysqli_select_db($conect, $database) or die("Database tidak bisa dibuka");
  9.  
  10. $lblAngka = $_POST ['pAngka'];
  11. $tanggal = date("Y-m-d H:i:s");
  12.  
  13. $sql2 = mysqli_query($conect, "SELECT * FROM `undian` WHERE `nmr_undian` = '$lblAngka'");
  14. $r=mysqli_fetch_array($sql2);
  15. $nama=$r[nama_pelanggan];
  16.  
  17. mysqli_query($conect, "INSERT INTO pemenang(nama_pemenang, nmr_undian, tanggal)
  18. VALUES ('$nama', '$lblAngka', '$tanggal')");
  19.  
  20. mysqli_close($conect);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement