humaidi

proses.php

Oct 14th, 2023
750
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.49 KB | Source Code | 0 0
  1. <?php
  2.  
  3. // koneksi
  4. require_once "config/koneksi.php";
  5.  
  6. // proses tambah
  7. if (isset($_POST['tambah'])) {
  8.  
  9.     // tampung inputan bk_tamu
  10.     $nama       = trim(mysqli_real_escape_string($con, $_POST['nama']));
  11.     $email      = trim(mysqli_real_escape_string($con, $_POST['email']));
  12.     $komentar   = trim(mysqli_real_escape_string($con, $_POST['komentar']));
  13.  
  14.     // query tambah data (SQL)
  15.     mysqli_query($con, "INSERT INTO komentar
  16.                    (id, nama, email, komentar) VALUES
  17.                    (null, '$nama', '$email', '$komentar')") or die(mysqli_error($con));
  18.  
  19.     // jika berhasil tampilkan alert dan arahkan ke halaman bk-tamu.php
  20.     echo "<script>alert('Data berhasil ditambahkan.'); window.location = 'bk-tamu.php';</script>";
  21. } else if (isset($_POST['edit'])) {
  22.  
  23.     // tampung inputan bk_tamu
  24.     $id         = $_POST['id'];
  25.  
  26.  
  27.     $nama       = trim(mysqli_real_escape_string($con, $_POST['nama']));
  28.     $email      = trim(mysqli_real_escape_string($con, $_POST['email']));
  29.     $komentar   = trim(mysqli_real_escape_string($con, $_POST['komentar']));
  30.  
  31.     // query edit data (SQL)
  32.     mysqli_query($con, "UPDATE komentar SET
  33.        nama        = '$nama',
  34.        email       = '$email',
  35.        komentar    = '$komentar'
  36.        WHERE id    = $id
  37.    ") or die(mysqli_error($con));
  38.  
  39.     // jika berhasil tampilkan alert dan arahkan ke halaman bk-tamu.php
  40.     echo "<script>alert('Data berhasil diubah.'); window.location = 'bk-tamu.php';</script>";
  41. }
  42.  
Advertisement
Add Comment
Please, Sign In to add comment