Advertisement
Guest User

Untitled

a guest
Mar 21st, 2016
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Insert Data Mahasiswa</title>
  4. </head>
  5.  
  6. <body>
  7. <?php
  8. $host = "localhost";
  9. $username = "root";
  10. $password = "";
  11. $nama_db = "1084_db";
  12.  
  13. $koneksi_db = mysqli_connect($host,$username,$password,$nama_db) or die (mysqli_error());
  14.  
  15. if($koneksi_db)
  16. {
  17.  
  18.  
  19. $student_number = (isset($_POST['student_number']))? $_POST['student_number']: '';
  20. $student_name = (isset($_POST['student_name']))? $_POST['student_name']: '';
  21. $province = (isset($_POST['province']))? $_POST['province']: '';
  22. $distric = (isset($_POST['distric']))? $_POST['distric']: '';
  23. $region= (isset($_POST['region']))? $_POST['region']: '';
  24.  
  25.  
  26.  
  27.  
  28.  
  29.  
  30. $perintah_sql = "INSERT INTO student set
  31. student_number = '".$_POST['student_number']."',
  32. student_name = '".$_POST['student_name']."',
  33. province = '".$_POST['province']."',
  34. distric = '".$_POST['distric']."',
  35. region = '".$_POST['region']."' ";
  36. echo "$perintah_sql";
  37. echo "<br>";
  38. mysqli_query($koneksi_db,$perintah_sql) or die ("Proses Insert data GAGAL! <br> mysqli_error()");
  39.  
  40. echo "Proses Insert data Berhasil";
  41. echo "<br>";
  42. echo "[<a href=view.php>Lihat Data Mahasiswa</a>]";
  43. }
  44.  
  45.  
  46. ?>
  47. </body>
  48. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement