Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $host = '127.0.0.1';
- $user = 'root';
- $password = '';
- $database = 'undian';
- // Koneksi dan memilih database di server
- $conect=mysqli_connect($host,$user,$password) or die("Koneksi gagal");
- mysqli_select_db($conect, $database) or die("Database tidak bisa dibuka");
- $lblAngka = $_POST ['pAngka'];
- $tanggal = date("Y-m-d H:i:s");
- $sql2 = mysqli_query($conect, "SELECT * FROM `undian` WHERE `nmr_undian` = '$lblAngka'");
- $r=mysqli_fetch_array($sql2);
- $nama=$r[nama_pelanggan];
- mysqli_query($conect, "INSERT INTO pemenang(nama_pemenang, nmr_undian, tanggal)
- VALUES ('$nama', '$lblAngka', '$tanggal')");
- mysqli_close($conect);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement