PHP: Membuat Guest Book Sederhana
Jump to navigation
Jump to search
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 (jangan lupa view source)
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(); ?>