Untitled

tampil

<html>
<head>
<title>Contact</title>
</head>
<body>
<h1>BUKU TAMU</h1>
<a href="index.php"> Kembali ke Buku Tamu</a>
<br>
<h2>BUKU TAMU</h2>
<a href="tampil.php"> Lihat Buku Tamu</a>
<hr size=1>

<?php
include ("connect.php");

$sql = "SELECT id, name, email, address, city, msg FROM bukutamu";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
  echo "<br>".
  "id: ". $row["id"]. "<br>".
  "Name: ". $row["name"]. "<br>".
  "Email: ". $row["email"]. "<br>".
  "Alamat: ". $row["address"]. "<br>".
  "Kota: ". $row["city"]. "<br>".
  "Pesan: ". $row["msg"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close()
?>
</body>
</html>


simpan
<html>
<head>
<title>Contact</title>
</head>
<body>
<h1>BUKU TAMU</h1>
<a href="index.php"> Kembali ke Buku Tamu</a>
<br>
<h2>BUKU TAMU</h2>
<a href="tampil.php"> Lihat Buku Tamu</a>
<hr size=1>

<?php
include ("connect.php");
$nama=$_POST['name'];
$email=$_POST['email'];
$alamat=$_POST['address'];
$kota=$_POST['city'];
$pesan=$_POST['msg'];

$sql = "INSERT INTO bukutamu (name, email, address, city, msg)
VALUES ('$nama','$email','$alamat','$kota','$pesan')";
if ($conn->query($sql) === TRUE) {
    echo "Pesan telah terkirim!";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>
</body>
</html>


index
<html>
<head>
<title>Buku Tamu</title>
</head>
<body>
<h2>Contact</h2>
<hr size="1">
<form name="tamu" method="post" action="simpan.php">
Nama  <input  style="margin: 5px 5px 5px 20px;" type="text" name="name"><br>
Email  <input style="margin: 5px 5px 5px 24px;" type="text" name="email"><br>
Alamat  <input style="margin: 5px 5px 5px 14px;" type="text" name="address"><br>
Kota  <input style="margin: 5px 5px 5px 26px;" type="text" name="city"><br>
Pesan <br><textarea style="width: 210px; margin-bottom: 10px;" name="msg"></textarea><br>
<input type="submit" name="submit" value="Send"> <input type="reset" name="reset" value="Reset">
</form>
</body>
</html>


connect
<?php
$hostmysql = "localhost";
$username = "root";
$password = "";
$database = "buku tamu";
$conn = mysqli_connect ($hostmysql, $username, $password, $database);
if ($conn){
 echo "<b> Koneksi Berhasil </b>";
}
else{
 die ("<b> Koneksi Gagal </b>");
}

?>