tutorial GuestBook

Setelah sekian lama tak muncul..

Akhirnya Si Cupu beraksi kembali. Kali ini gimana cara membuat guest book dengan php. Sebenernya konsepnya mudah. tinggal buat table mysqlnya..

Create database guestbook;
use guestbook;
create table guestbook(
id int(3) auto_increment primary key,
nama varchar(50) not null,
email varchar(50) not null,
coment text not null);

Setelah itu selesai…
kita buat koneksinya…

$my['host'] = “localhost”;
$my['user'] = “root”;
$my['pass'] = “1234″;
$my['dbs'] = “guestbok”;

$koneksi = mysql_connect($my['host'], $my['user'], $my['pass']);
if (! $koneksi) {
echo “Gagal koneksi boss..!”;
mysql_error();
}
// memilih database pda server
mysql_select_db($my['dbs'])
or die (“Database nggak ada tuh”.mysql_error());

?>

setelah itu selesai.
kita buat Form-nya…

<?php
include_once “sys/koneksi.php”;
$sql =”select * from guestbook order by date desc;”;
$qry= mysql_query($sql,$koneksi) or die (“Gagal Query “.mysql_error());
while ($data=mysql_fetch_array($qry)){
echo $data['name'].”<br>”;
echo $data['email'].”<br>”;
echo $data['pesan'].”<br> <hr>”;
}
?>
<form action=”insertform.php” name=”data” method=”post”>
<table>
<tr>
<td colspan=”2″></td></tr>
<tr>
<td>Masukkan nama</td><td><input name=”nama” type=”text” title=”nama”/></td></tr>
<tr>
<td>Masukkan email</td><td><input name=”email” type=”text” title=”alamat email” /></td></tr>
<tr><td>Masukkan Pesan</td><td><textarea name=”pesan” cols=”10″ rows=”2″></textarea></td></tr>
<tr><td><input type=”hidden” name=”tanggal” value=”<?php echo date(); ?>” /><input type=”hidden” name=”time” value=”<?php echo time(); ?>” /></td><td><input type=”submit” name=”submit” value=”Masukkan” /></td></tr>
</table>
</form>

lalu kita buat buat pengecekan sekaligus insert into guestbook

<?php
include_once “sys/koneksi.php”;
$sql =”select * from guestbook order by date desc;”;
$qry= mysql_query($sql,$koneksi) or die (“Gagal Query “.mysql_error());
while ($data=mysql_fetch_array($qry)){
echo $data['name'].”<br>”;
echo $data['email'].”<br>”;
echo $data['pesan'].”<br> <hr>”;
}
?>
<form action=”insertform.php” name=”data” method=”post”>
<table>
<tr>
<td colspan=”2″></td></tr>
<tr>
<td>Masukkan nama</td><td><input name=”nama” type=”text” title=”nama”/></td></tr>
<tr>
<td>Masukkan email</td><td><input name=”email” type=”text” title=”alamat email” /></td></tr>
<tr><td>Masukkan Pesan</td><td><textarea name=”pesan” cols=”10″ rows=”2″></textarea></td></tr>
<tr><td><input type=”hidden” name=”tanggal” value=”<?php echo date(); ?>” /><input type=”hidden” name=”time” value=”<?php echo time(); ?>” /></td><td><input type=”submit” name=”submit” value=”Masukkan” /></td></tr>
</table>
</form>

Alhamdullilah…

selesai dech…

gampang kn..