Guestbook #2
owh tak dapat tidur di malam minggu di bulan puasa yang esok tak tau lagi nak buat ape. owh..
apa dibawah ialah guestbook php + mysql yang dimod dari versi php + txt file yang tahun lepas. boleh tengok di sini untuk yang dulu.
<?php
$con = mysql_connect(“localhost”,”guestbook_user”,”password”); //ubah ikut kesusaian
mysql_select_db(“guestbook”, $con); //ubah nama db jika berkenaan.
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
if (!isset($_POST['SubmitForm'])) {
} else {
echo “<span class=’mid’>”;
echo “Terima Kasih =)”;
echo “<br>”;
echo “<br>”;
$nama = $_POST['nama'];
$msj = $_POST['msj'];$tag = array(“<”, “>”);
$nama = str_replace($tag, “_”, $nama);
$msj = str_replace($tag, “_”, $msj);$masa = “(“.date(“F j, Y, g:i a”).”)”;
$nama = mysql_real_escape_string($nama);
$msj = mysql_real_escape_string($msj);
$masa = mysql_real_escape_string($masa);mysql_query(“INSERT INTO entry (masa, nama, msj) VALUES (‘$masa’,'$nama’,'$msj’)”);
}
?>
</p>
<center>
<form action’”.$_SERVER['PHP_SELF'].”‘ method=”POST”>
<span>Tinggalkan mesej/ucapan anda disini:</span><br>
<table>
<tr>
<td><span>Name</span>::</td>
<td><input type=”text” name=”nama”></td>
</tr>
<tr>
<td>Message: </td>
<td><textarea name=”msj”></textarea></td>
</tr></table>
<input type=”submit” name=”SubmitForm” value=”Send”>
</form><span>
- – - – - – - – - – - <br>
<?php
$entry = mysql_query(“SELECT * FROM entry”);while($row = mysql_fetch_array($entry))
{
echo $row['nama'] . $row['masa'];
echo “<br />”;
echo $row['msj'];
echo “<br />”;
echo “———-”;
echo “<br />”;
echo “<br />”;
}
mysql_close($con);
?>
</center>
untuk yang ni, instead of simpan msj dalam txt file, msj semuanya disimpan dalam MySQL db. code sedikit pendek, tapi memerlukan MySQL server untuk berfungsi.
utk db, bleh dump ape yang ad dibawah:
CREATE TABLE IF NOT EXISTS `entry` (
`no` int(11) NOT NULL AUTO_INCREMENT,
`masa` text NOT NULL,
`nama` text NOT NULL,
`msj` text NOT NULL,
PRIMARY KEY (`no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;INSERT INTO `entry` (`no`, `masa`, `nama`, `msj`) VALUES
(10, ‘(August 13, 2010, 7:10 pm)’, ‘gsbgse’, ‘brstbrtsn’),
(4, ‘(August 13, 2010, 6:59 pm)’, ‘aebgerbewt’, ‘hbtwbryn’),
(5, ‘(August 13, 2010, 7:00 pm)’, ‘faeger’, ‘gergwe4h35′),
(6, ‘(August 13, 2010, 7:01 pm)’, ‘faeger’, ‘gergwe4h35′),
(7, ‘(August 13, 2010, 7:01 pm)’, ‘gaergera’, ‘gergreh3′),
(8, ‘(August 13, 2010, 7:01 pm)’, ‘fwef3qwrhgw354′, ‘gbw45gw34hgw354th’),
(9, ‘(August 13, 2010, 7:08 pm)’, ‘gseb’, ‘esbb’);
db kat atas ni dh ada testing data yang tah paper. feel free to create a new one, fresh one.
camne nak guna? pastikan httpserver (eg: apache) dan MySQL up and running.
copy the code, paste kedalam .php file.
create database nama guestbook (kalau nak guna nama lain pun boleh, tapi pastikan ubah db pada msql_select_db. da create db, boleh dump sql kat atas. ataupun create sendiri table.
do comments kalau ada bug, comments, critics n etc.
selamat testing2 dan selamat berpuasa =)
—–
and for unknown reason, I smileeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee =)
Computer, Sharing | aalim | 
Comments (2)
begitu tegar scripter itu.
