PHP: Membuat Guest Book Sederhana

From OnnoWiki
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(); ?>


Pranala Menarik