FORM TAMU PHP MYSQL
koneksi.php
<?php
$host = mysqli_connect("localhost","root","","bukutamu");
function tambah($data){
global $host;
$nama = $_POST["nama"];
$email = $_POST["email"];
$pesan = $_POST["pesan"];
$tampil = mysqli_query($host, "INSERT INTO tamu (nama, email, pesan) VALUES ('$nama','$email','$pesan')");
return mysqli_affected_rows($host);
}
?>
input.php
<?php
require 'koneksi.php';
if (isset($_POST["submit"])) {
if (tambah($_POST) > 0) {
echo "data berhasil ditambahkan";
header("Location: index.php");
} else {
echo "data gagal ditambahkan";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<center>
<form method="POST">
<label>Nama Tamu : </label>
<input type="text" name="nama">
<br>
<label>Email : </label>
<input type="email" name="email">
<br>
<label>Pesan : </label>
<input type="pesan" name="pesan">
<br>
<input type="submit" name="submit">
</form>
</center>
</body>
</html>
index.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<center>
<h1>DATA TAMU</h1>
<table border="1">
<tr>
<th>NOMOR</th>
<th>NAMA TAMU</th>
<th>EMAIL</th>
<th>PESAN</th>
</tr>
<?php
include 'koneksi.php';
$tampil = mysqli_query($host, "SELECT * FROM tamu");
$angka = 1;
foreach ($tampil as $data ) {
?>
<tr>
<td><?php echo $angka++; ?></td>
<td><?php echo $data["nama"]; ?></td>
<td><?php echo $data["email"]; ?></td>
<td><?php echo $data["pesan"]; ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>
formlagi.php
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<?php
include 'koneksi.php';
?>
<center>
<a href="index.php">LIHAT SEMUA DATA</a>
<h1>DATA TAMU</h1>
<form action="input.php" method="POST">
<table>
<tr>
<td>NOMOR</td>
<td><input type="number" name="nomor"></td>
</tr>
<tr>
<td>NAMA</td>
<td><input type="name" name="nama"></td>
</tr>
<tr>
<td>EMAIL</td>
<td><input type="email" name="email"></td>
</tr>
<tr>
<td>PESAN</td>
<td><input type="textarea" name="pesan"></textarea></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="submit"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
Hasil output:
Tidak ada komentar:
Posting Komentar