Membuat buku tamu PHP sederhana

Overview

In this tutorial create 3 files 1. guestbook.php 2. addguestbook.php 3. viewguestbook.php Step 1. Create table name "guestbook" in database "test". 2. Create file guestbook.php. 3. Create file addguestbook. php. 4. Create file viewguestbook.php

Set up database 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`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; If you don't know how to create database and table, read this tutorial

Create file guestbook.php View in Browser ############### Code Test Sign Guestbook Name : Email : Comment : View Guestbook

	create file addguestbook.php
############### Code $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="guestbook"; // Table name // 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"); $datetime=date("y-m-d h:i:s"); //date time $sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment', '$datetime')"; $result=mysql_query($sql); //check if query successful if($result){ echo "Successful"; echo " "; echo "View guestbook"; // link to view guestbook page } else { echo "ERROR"; } mysql_close(); ?> Referensi By : www.phpeasystep.com  Download Buku Tamu.zip