Advertisement
Guest User

insert.php

a guest
Jul 22nd, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.30 KB | None | 0 0
  1. <?php
  2. include "koneksi.php"; //memanggil file koneksi
  3. ?>
  4. <form action="" method="POST">
  5. <table>
  6. <h3>::FORM INPUT DATA MAHASISWA::</h3>
  7. <tr><td>NPM</td><td>:</td><td><input type="text" name="npm" value=""></td></tr>
  8. <tr><td>Nama</td><td>:</td><td><input type="text" name="nama" value=""></td></tr>
  9. <tr><td>Alamat</td><td>:</td><td><textarea name="alamat" rows="2" col="5"></textarea></td></tr>
  10. <tr><td colspan="2"></td><td><input type="submit" name="simpan" value="SIMPAN"> <a href="tampil.php">KEMBALI</a></td></tr>
  11. </table>
  12. </form>
  13. <?php
  14. if(isset($_POST['simpan'])){ //Kondisi if jika value/ nilai simpan ada
  15.     $npm=$_POST['npm']; //Ampil value npm pada form dan simpan pada variable $npm
  16.     $nama=$_POST['nama']; //Ampil value nama pada form dan simpan pada variable $nama
  17.     $alamat=$_POST['alamat']; //Ampil value alamat pada form dan simpan pada variable $alamat
  18.    
  19.     $query=mysql_query("INSERT INTO mahasiswa(npm,nama,alamat)
  20.                                     VALUES
  21.                                     ('$npm','$nama','$alamat')") or die(mysql_error()); //Query insert database
  22.     if($query){ //kondisi if jika query bernilai true
  23.         echo "<script>alert('Sukses Insert Data'); window.location='tampil.php';</script>"; //menampilkan pesan sukses dan redirect halaman
  24.     }else{
  25.         echo "<script>alert('Gagal Insert Data');</script>"; //menampilkan pesan gagal
  26.     }
  27. }
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement