1. Buat Table pengunjung:
CREATE TABLE `komputerbelajar`.`pengunjung` (
`ID_PENGUNJUNG` INT NOT NULL AUTO_INCREMENT ,
`NAMA` VARCHAR( 50 ) NOT NULL ,
`EMAIL` VARCHAR( 50 ) NOT NULL ,
`PESAN` VARCHAR( 50 ) NOT NULL ,
`TANGGAL` DATETIME NOT NULL ,
PRIMARY KEY ( `ID_PENGUNJUNG` )
) ENGINE = MYISAM
2. Siapkan koneksi. Bisa lihat di sini atau download di sini
3. Buat form guestbook
<?php
require_once('class.mysql.php');
$mysql = new Mysql();
$mysql->connect();
// we check if everything is filled in
if(isset($_POST['kirim'])){
if(empty($_POST['nama']) || empty($_POST['email']) || empty($_POST['pesan']) )
{
die('{"pengiriman Gagal. Data harus diisi semua"}');
}
else {
$mysql2 = new Mysql();
$mysql2->connect();
$mysql2->execute("INSERT INTO pengunjung ( NAMA , EMAIL , PESAN ) VALUES ( '$_POST[nama]', '$_POST[email]', '$_POST[pesan]' ) ");
}
}
if($mysql->execute("select * from pengunjung")){
$data = $mysql->getDataSet();
}else{
$data = -1;
}
?>
<table width="445" border="0">
<?php
for($i=0;$i<count($data);$i++){
?>
<tr>
<td width="147"><?=$data[$i][1]?> (<?=$data[$i][2]?>)</td>
</tr>
<tr>
<td ><strong>pesan:<?=$data[$i][3]?></strong></td>
</tr>
<?php
}
echo "</table>";
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Guest Book</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<table width="422" border="1">
<tr>
<td width="65">Nama</td>
<td width="15">:</td>
<td width="320">
<input type="text" name="nama" size="50" />
</td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input type="text" name="email" size="50" /></td>
</tr>
<tr>
<td>Pesan</td>
<td>:</td>
<td><textarea name="pesan" cols="50" rows="5"> </textarea></td>
</tr>
<tr>
<td colspan="3"><div align="right">
<input type="submit" name="kirim" id="kirim" value="Kirim pesan" />
</div></td>
</tr>
</table>
</form>
</body>
</html>
4. Selesai. Download source code lengkap di sini
No comments:
Post a Comment