Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // koneksi
- require_once "config/koneksi.php";
- // proses tambah
- if (isset($_POST['tambah'])) {
- // tampung inputan bk_tamu
- $nama = trim(mysqli_real_escape_string($con, $_POST['nama']));
- $email = trim(mysqli_real_escape_string($con, $_POST['email']));
- $komentar = trim(mysqli_real_escape_string($con, $_POST['komentar']));
- // query tambah data (SQL)
- mysqli_query($con, "INSERT INTO komentar
- (id, nama, email, komentar) VALUES
- (null, '$nama', '$email', '$komentar')") or die(mysqli_error($con));
- // jika berhasil tampilkan alert dan arahkan ke halaman bk-tamu.php
- echo "<script>alert('Data berhasil ditambahkan.'); window.location = 'bk-tamu.php';</script>";
- } else if (isset($_POST['edit'])) {
- // tampung inputan bk_tamu
- $id = $_POST['id'];
- $nama = trim(mysqli_real_escape_string($con, $_POST['nama']));
- $email = trim(mysqli_real_escape_string($con, $_POST['email']));
- $komentar = trim(mysqli_real_escape_string($con, $_POST['komentar']));
- // query edit data (SQL)
- mysqli_query($con, "UPDATE komentar SET
- nama = '$nama',
- email = '$email',
- komentar = '$komentar'
- WHERE id = $id
- ") or die(mysqli_error($con));
- // jika berhasil tampilkan alert dan arahkan ke halaman bk-tamu.php
- echo "<script>alert('Data berhasil diubah.'); window.location = 'bk-tamu.php';</script>";
- }
Advertisement
Add Comment
Please, Sign In to add comment