View source for PHP: Membuat Guest Book Sederhana

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"><br>
 Email: <input type="text" name="email"><br>
 Komentar: <input type="text" name="comment"><br>
 <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 "<BR>";
 
 // 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"]. "<br>";
     }
 } else {
     echo "0 results";
 }
 $conn->close();
 ?>



==Pranala Menarik==

* [[Arduino: RFID RC522]]