<?php

/*
    CREATE TABLE bukutamu (
        id      SERIAL      PRIMARY KEY,
        nama    VARCHAR(50) NOT NULL,
        email   VARCHAR(50) NOT NULL,
        pesan   TEXT        NOT NULL
    );
*/

pg_connect("host=localhost dbname=student user=student password=student")
    or exit("CONNECT ERROR");

if ($_POST['tambah'] === "Tambah") {
    $nama  = $_POST['nama'];
    $email = $_POST['email'];
    $pesan = $_POST['pesan'];
    $ok    = pg_query_params("INSERT INTO bukutamu (nama, email, pesan) VALUES ($1, $2, $3)", array($nama, $email, $pesan));
    if (!$ok) echo "<pre>".pg_last_error()."</pre>";
}

if ($_POST['update'] === "Update") {
    $id    = $_POST['id'];
    $nama  = $_POST['nama'];
    $email = $_POST['email'];
    $pesan = $_POST['pesan'];
    $ok    = pg_query_params("UPDATE bukutamu SET nama=$1, email=$2, pesan=$3 WHERE id=$4", array($nama, $email, $pesan, $id));
    if (!$ok) echo "<pre>".pg_last_error()."</pre>";
}

if ($_POST['hapus']  === "Hapus") {
    $id = $_POST['id'];
    $ok = pg_query_params("DELETE FROM bukutamu WHERE id=$1", array($id));
    if (!$ok) echo "<pre>".pg_last_error()."</pre>";
}

if ($_POST['edit']   === "Edit") {
    $id = $_POST['id'];
    $result = pg_query_params("SELECT * FROM bukutamu WHERE id=$1", array($id));
    if (!$result)
        echo "<pre>".pg_last_error()."</pre>";
    else
        $row = pg_fetch_array($result);
}
?>

<h2>Form Pesan</h2>

<form method="post" action="">
                 <input type="hidden" name="id"     value="<?php echo $row['id'];    ?>">
    <p>Nama: <br><input type="text"   name="nama"   value="<?php echo $row['nama'];  ?>" required></p>
    <p>Email:<br><input type="email"  name="email"  value="<?php echo $row['email']; ?>" required></p>
    <p>Pesan:<br><textarea required   name="pesan"        ><?php echo $row['pesan']; ?></textarea></p>
    <p>
<?php if ($_POST['edit'] === "Edit") { ?>
                 <input type="submit" name="update" value="Update">
<?php } else { ?>
                 <input type="submit" name="tambah" value="Tambah">
<?php } ?>
    </p>
</form>

<h2>Daftar Pesan</h2>

<?php
$result = pg_query("SELECT * FROM bukutamu ORDER BY id DESC");
if (!$result)
    echo "<pre>".pg_last_error()."</pre>";
else {
    while ($row = pg_fetch_array($result)) {
?>
    <article>
        <i>"<?php echo $row['pesan']; ?>"</i><br>
        &ndash; <a href="mailto:<?php echo $row['email']; ?>"><?php echo $row['nama']; ?></a>
        <form method="post" action="">
            <input type="hidden" name="id"    value="<?php echo $row['id']; ?>">
            <input type="submit" name="edit"  value="Edit">
            <input type="submit" name="hapus" value="Hapus">
        </form>
    </article>
<?php
    }
}
?>