Membuat Database Buku Tamu
Menggunakan Bahasa Pemrograman Mysql Dan PHP
1.
//membuat
database
create database guestbook;
a. Create
table bukutamu(
Nama varchar(50),
Pesan text
);
2.
//membuat
koneksi antara mysql dan php dengan notepad, simpan file dengan nama koneksi.php
dan letakan dalam folder yang anda buat dan letakan ke drive C:\xampp\htdocs
<?php
$host = "localhost";
$username = "root";
$password = "";
$database = "guestbook";
$koneksi = mysql_connect($host, $username, $password);
$pilihdatabase = mysql_select_db($database, $koneksi);
if ($pilihdatabase) echo "Berhasil";
else echo "Gagal Koneksi";
?>
3.
//membuat
perintah-perintah dalam notepad
//simpan
dengan nama tampil.php
<html>
<head>
<title>Tutorial Buku Tamu</title>
</head>
<?php
$id_massage = isset($_GET["id_massage"]) ?
$_GET["id_massage"] : "";
switch($id_massage)
{
case 1:
$tls_pesan = "Isikan seluruh masukkan data dengan benar";
break;
case 2:
$tls_pesan = "Data Berhasil Dimasukkan";
break;
case 3:
$tls_pesan = "Data Gagal dimasukkan";
break;
default:
$tls_pesan = "";
break;
}
?>
<body>
<table width="310" border="1"
align="center" cellpadding="0"
cellspacing="0">
<tr>
<td
width="306"><table width="298" border="1"
cellspacing="0" cellpadding="0">
<tr>
<td
width="294"><p align="center">Catatan
Sehari-hari</p>
<p
align="center"><a
href="http://manjihmaulana.blogspot.com">http://manjihmaulana.blogspot.com
</a> </p>
<Header></td>
</tr>
<tr>
<td><form action="proses.php" method="post"
name="guestbook" id="guestbook">
<table width="85%"
border="0" align="center" cellpadding="0"
cellspacing="0">
<tr>
<td width="25%"> </td>
<td width="75%"> </td>
</tr>
<tr><td>Nama</td>
<td><input name="nama" type="text"
id="nama" size="25" maxlength="75"></td>
</tr>
<tr>
<td>Pesan</td>
<td><textarea name="pesan" cols="35"
rows="7" id="pesan"></textarea></td>
</tr>
<tr>
<td> </td>
<td><?php echo $tls_pesan?></td>
</tr>
<tr>
<td> </td>
<td><input name="submit" type="submit"
id="submit" value="Submit">
<input name="reset" type="reset"
id="reset" value="Reset"></td>
</tr>
</table>
</form>
<?php
$db_host ="localhost";
$db_user ="root";
$db_password ="";
$db_name ="guestbook";
$conn_db = @mysql_connect($db_host, $db_user,
$db_password) or die("Settingan database server salah");
$select_db = @mysql_select_db($db_name) or
die("Database tidak diketemukan");
$query = "SELECT * FROM bukutamu";
$result = mysql_query($query);
while ($data = mysql_fetch_array($result))
{
$tls_nama =
$data["nama"];
$tls_catatan = $data["pesan"];
echo "<table width='85%'
cellpadding='4' cellspacing='1' align='center' bgcolor='#000000'>";
echo
"<tr><td bgcolor='#EEEEEE'> $tls_nama ::<br>";
echo
"<tr><td bgcolor='#F5F5F5'>$tls_catatan
<br></td></tr></table><br />";
}
mysql_close($conn_db);
?>
</td>
</tr>
<tr>
<td
align="center"><span class="style2">Sumber: Manjih
Maulana, Belajar IT Programmer</span></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
4.
//perintah
yang terakhir
//simpan
dengan nama proses.php
<?php
$db_host = "localhost";
$db_user = "root";
$db_password = "";
$db_name = "guestbook";
$conn_db = mysql_connect($db_host, $db_user,
$db_password) or die("settingan database server salah");
$select_db = mysql_select_db($db_name) or
die("Database tidak diketemukan");
//include("koneksi.php");
$nama = $_POST['nama'];
$catatan = $_POST['pesan'];
if (!$nama || !$catatan)
{
header("location: tampil.php?id_massage=1");
exit;
}
$query = "INSERT INTO bukutamu (nama, pesan)
VALUES ('$nama', '$catatan')";
$result = mysql_query($query);
mysql_close($conn_db);
if ($result)
{
header("location: tampil.php?id_massage=2");
exit;
}
else
{
header("location: tampil.php?id_massage=3");
exit;
}
?>
5.
Selesai dan
coba cek hasilnya di browser kamu
Terimakasih telah berkunjung, dan semoga bermanfaat
untuk semua _^
sumber http://manjihmaulana.blogspot.com