Advertisement
Guest User

hasil_ubah

a guest
Jul 4th, 2017
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.81 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Sukses</title>
  4. <style>
  5. h2{
  6. text-align:center;
  7. color:#4CAF50;
  8. text-shadow: 2px 2px 5px white;
  9. }
  10. body {
  11. background-color: #E6E6FA;
  12. }
  13. </style>
  14. </head>
  15. <body>
  16. <?php
  17. # MEMBUAT KONEKSI DATABASE
  18. // Definisi Variabel Untuk Koneksi
  19. $host = "localhost"; // Nama Host
  20. $user = "root"; // Nama user
  21. $pass = ""; // Password
  22. $db = "biodata"; // Nama Database
  23.  
  24. // Melakukan Koneksi Ke Database MYSQL
  25. $mysql = new mysqli($host, $user, $pass, $db);
  26.  
  27. /* check koneksi */
  28. if (mysqli_connect_errno()) {
  29. printf("Connect failed: %s\n", mysqli_connect_error());
  30. exit();
  31. }
  32. $nama = $_POST['nama'];
  33. $tanggallahir = $_POST['tanggallahir'];
  34. $iddata= (isset($_POST['iddata']) ? $_POST['iddata'] : '');
  35. $jeniskelamin = $_POST['jeniskelamin'];
  36. $alamat = $_POST['alamat'];
  37. $notelp = $_POST['notelp'];
  38.  
  39. $SQL = $mysql->query("
  40. UPDATE biodata
  41. SET nama='$nama', tanggallahir='$tanggallahir', jeniskelamin='$jeniskelamin', alamat='$alamat', notelp='$notelp'
  42. WHERE iddata='$iddata'
  43. ");
  44.  
  45. if ($SQL){
  46. echo '<h2>Update Berhasil</h2><br>';
  47. }else{
  48. echo $mysql->error;
  49. }
  50.  
  51. ?>
  52. <table align="center">
  53. <tr>
  54. <td>Nama</td>
  55. <td>:</td>
  56. <td><?php echo $nama; ?></td>
  57. </tr>
  58. <tr>
  59. <td>Tanggal Lahir</td>
  60. <td>:</td>
  61. <td><?php echo $tanggallahir; ?></td>
  62. </tr>
  63. <tr>
  64. <td>Jenis Kelamin</td>
  65. <td>:</td>
  66. <td><?php echo $jeniskelamin; ?></td>
  67. </tr>
  68. <tr>
  69. <td>Alamat</td>
  70. <td>:</td>
  71. <td><?php echo $alamat; ?></td>
  72. </tr>
  73. <tr>
  74. <td>No Telpon</td>
  75. <td>:</td>
  76. <td><?php echo $notelp; ?></td>
  77. </tr>
  78. <tr>
  79. <td colspan="3" align="center"><a href="ubah_data.php"> Kembali</a></td>
  80. </tr>
  81. <tr>
  82. <td colspan="3" align="center"><a href="biodata.php"> Lihat Tampilan</a></td>
  83. </tr>
  84. </table>
  85. </body>
  86. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement