PHP: Membuat Guest Book Sederhana
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Sumber:
http://www.phpeasystep.com/phptu/15.html http://www.phpeasystep.com/workshopview.php?id=16
Yang perlu dibuat
- Table "guestbook" in database "test".
- guestbook.php.
- addguestbook. php.
- viewguestbook.php
Membuat tabel guestbook
mysql -u root -p123456
create database test; use test; grant ALL on root.* to test@localhost;
CREATE TABLE `guestbook` ( `id` int(4) NOT NULL auto_increment, `name` varchar(65) NOT NULL default , `email` varchar(65) NOT NULL default , `comment` longtext NOT NULL, `datetime` varchar(65) NOT NULL default , PRIMARY KEY (`id`) ) DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
guestbook.php
<!DOCTYPE HTML> <html> <body> <form action="addguestbook.php" method="post"> Nama: <input type="text" name="name">
Email: <input type="text" name="email">
Komentar: <input type="text" name="comment">
<input type="submit"> </form> </body> </html>
addguestbook.php
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="123456"; // Mysql password
$db_name="test"; // Database name
$tbl_name="guestbook"; // Table name
$datetime=date("y-m-d h:i:s"); //date time
$name1=$_POST["name"];
$email1=$_POST["email"];
$comment1=$_POST["comment"];
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name1', '$email1', '$comment1', '$datetime')";
$result=mysql_query($sql);
//check if query successful
if($result){
echo "Successful";
echo "
";
// link to view guestbook page
echo "<a href='viewguestbook.php'>View guestbook</a>";
}
else {
echo "ERROR";
}
mysql_close();
?>
viewguestbook.php
<?php
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "test";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT id, name, email, comment, datetime FROM guestbook";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["email"]. " " . $row["comment"]. " " . $row["datetime"]. "
";
}
} else {
echo "0 results";
}
$conn->close();
?>