
database
create database db_gb ;
use db_gb;
create table guestbook (id int unsigned not null primary key auto_increment, nama varchar(50) not null, email varchar(100) not null, pesan text not null);
file koneksi.php
$host="localhost"; $uname="root"; $pass=""; $db="db_gb";
$koneksi=mysql_connect($host,$uname,$pass);
mysql_select_db($db,$koneksi);
?>
file lihatgb.php
$queryGb = mysql_query("select * from guestbook");
$jmlGb = mysql_num_rows($queryGb);
if($jmlGb==0)
{
echo"Data buku tamu masih kosong";
}
else
{
$queryTampil=mysql_query("select * from guestbook order by id desc");
echo"
DATA BUKU TAMU
";
while($dataGb=mysql_fetch_row($queryTampil))
{
echo"$dataGb[1]
";
echo"".wordwrap($dataGb[3],85,"
",1)." ";
echo"
";
}
}
?>
file gb.php
include'koneksi.php';
if(isset($_POST['kirim']) && ($_POST['kirim']=='Kirim'))
{
$nama=trim(strip_tags($_POST['nama']));
$email=trim(strip_tags($_POST['email']));
$pesan=trim(strip_tags($_POST['pesan']));
//validasi form
if($nama=='')
$error1= " « Nama belum diisi
";
if($email=='')
$error2= " « Email belum diisi
";
if($pesan=='')
$error3= " « Pesan belum diisi
";
if($email!='')
{
$polaemail = "^.+@.+\..+$"; //nyontek tutorial validasi email yg ditulis b_scorpio

$cek=eregi($polaemail,$email);
if(!$cek)
{
$error4=" « Pola email salah";
}
}
//jika semua data valid
if(($nama!='') && ($email!='') && $cek && ($pesan!=''))
{
//simpan data buku tamu
$queryAddGb=mysql_query("insert into guestbook
values(NULL,'$nama','$email','$pesan')");
if($queryAddGb) //jika query simpan buku tamu berhasil
{
//tampilkan pesan berhasil
echo"Guestbook berhasil disimpan";
echo"";
exit;
}
else //jika query gagal
{
//tampilkan pesan gagal
echo"Data gagal disimpan";
echo"";
exit;
}
}
if(isset($error1) || isset($error2) || isset($error3) || isset($error4))
{
//tangkap variabel post untuk menampilkan kembali data yang sudah diisi pada form
$ex_nama=trim(strip_tags($_POST['nama']));
$ex_email=trim(strip_tags($_POST['email']));
$ex_pesan=trim(strip_tags($_POST['pesan']));
}
}
include'lihatgb.php';
//semua value variabel diset kosong jika belum diisi
if(empty($ex_nama))
{
$ex_nama='';
}
if(empty($ex_email))
{
$ex_email='';
}
if(empty($ex_pesan))
{
$ex_pesan='';
}
?>
FORM BUKU TAMU
0 komentar:
Posting Komentar