Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Sukses</title>
- <style>
- h2{
- text-align:center;
- color:#4CAF50;
- text-shadow: 2px 2px 5px white;
- }
- body {
- background-color: #E6E6FA;
- }
- </style>
- </head>
- <body>
- <?php
- # MEMBUAT KONEKSI DATABASE
- // Definisi Variabel Untuk Koneksi
- $host = "localhost"; // Nama Host
- $user = "root"; // Nama user
- $pass = ""; // Password
- $db = "biodata"; // Nama Database
- // Melakukan Koneksi Ke Database MYSQL
- $mysql = new mysqli($host, $user, $pass, $db);
- /* check koneksi */
- if (mysqli_connect_errno()) {
- printf("Connect failed: %s\n", mysqli_connect_error());
- exit();
- }
- $nama = $_POST['nama'];
- $tanggallahir = $_POST['tanggallahir'];
- $iddata= (isset($_POST['iddata']) ? $_POST['iddata'] : '');
- $jeniskelamin = $_POST['jeniskelamin'];
- $alamat = $_POST['alamat'];
- $notelp = $_POST['notelp'];
- $SQL = $mysql->query("
- UPDATE biodata
- SET nama='$nama', tanggallahir='$tanggallahir', jeniskelamin='$jeniskelamin', alamat='$alamat', notelp='$notelp'
- WHERE iddata='$iddata'
- ");
- if ($SQL){
- echo '<h2>Update Berhasil</h2><br>';
- }else{
- echo $mysql->error;
- }
- ?>
- <table align="center">
- <tr>
- <td>Nama</td>
- <td>:</td>
- <td><?php echo $nama; ?></td>
- </tr>
- <tr>
- <td>Tanggal Lahir</td>
- <td>:</td>
- <td><?php echo $tanggallahir; ?></td>
- </tr>
- <tr>
- <td>Jenis Kelamin</td>
- <td>:</td>
- <td><?php echo $jeniskelamin; ?></td>
- </tr>
- <tr>
- <td>Alamat</td>
- <td>:</td>
- <td><?php echo $alamat; ?></td>
- </tr>
- <tr>
- <td>No Telpon</td>
- <td>:</td>
- <td><?php echo $notelp; ?></td>
- </tr>
- <tr>
- <td colspan="3" align="center"><a href="ubah_data.php"> Kembali</a></td>
- </tr>
- <tr>
- <td colspan="3" align="center"><a href="biodata.php"> Lihat Tampilan</a></td>
- </tr>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement