This time we will discuss how to make a guestbook. The steps we take in making this guestbook are:
- Create a MySQL table that will store the contents of the guest book.
- Create a guest book filling form
- Create a program to receive data input from the form we created previously.
- Create a program to display the contents of a guest book.
Create a table
The table structure for storing the guest book is as follows:
| Kolom/Field | Tipe data | Keterangan |
|-------------|------------------------------------------------------|------------------------------------------------------------------------------------------------------------|
| id | int(10) unsigned auto_increment not null primary key | angka dengan panjang maksimal 10, sebagai primary key, tidak boleh kosong, nilai secara otomatis bertambah |
| posted | date | tanggal |
| name | varchar(80) | teks dengan panjang maksimal 80 karakter |
| email | varchar(128) | teks dengan panjang maksimal 128 karakter |
| address | varchar(128) | teks dengan panjang maksimal 128 karakter |
| city | varchar(80) | teks dengan panjang maksimal 80 karakter |
| msg | longblob | teks panjang |The MySQL command to create a guestbook table with the structure above is:
CREATE TABLE guestbook (
id int(10) unsigned NOT NULL auto_increment, posted date NOT NULL, name varchar(80), email varchar(128), address varchar(128), city varchar(80), msg longblob, PRIMARY KEY (id)
);Create a guest book filling form
Guestbook1.php file
<html>
<head>
<title>
Guestbook
</title>
</head>
<body bgcolor="#99CCFF">
<font color="#000066" face=verdana>
<h3 align=left>
Signup Guestbook
</h3>
<form action="bukutamu2.php" method=POST>
<hr size=1 width=100% align=left>
<pre>
Name : <input type=text name=nama size=20>
E-Mail : <input type=text name=email size=30>
Address : <input type=text name=alamat size=30> City : <input type=text name=kota size=25> Message :
<textarea name=pesan rows=5 cols=30>
</textarea>
</pre>
<input type=submit value="Send"> <input type=reset value="Reset">
</form>
</font>
<font color="#000066" face=verdana size=2>
<a href="bukutamu3.php">View Guestbook</a>
</font>
</body>
</html>
Program to receive data input from a form
Guestbook2.php file
<html>
<head>
<title>
Guestbook
</title>
</head>
<body bgcolor="#99CCFF">
<font color="#000066" face=verdana>
<h3 align=left>
Signup Guestbook
</h3>
<?php require("utama.php"); $link=open_connection();
$tablename="guestbook";
$tgl=date("Y-m-d");
$pesan=addslashes($pesan);
$sqlstr="INSERT INTO $tablename
VALUES('','$tgl','$nama','$email','$alamat','$kota','$pesan')"; if (!mysql_query ($sqlstr))
{
echo("Invalid Query!<br>Please register again...<br>"); exit;
}
mysql_close($link);
echo("Thank you for signing up Guestbook...<p>");
?>
</font>
<font color="#000066" face=verdana size=2>
<a href="bukutamu3.php">View Guestbook</a> <a href="bukutamu1.php">Sign Up</a>
</font>
</body>
</html>
Program to display the contents of the guest book
Guestbook3.php file
<html>
<head>
<title>
Guestbook
</title>
</head>
<body bgcolor="#99CCFF">
<font color="#000066" face=verdana size=1>
<h3 align=left> View Guestbook
</h3>
<?php require("utama.php"); $link=open_connection();
$tablename="guestbook";
$sqlstr="SELECT * FROM $tablename ORDER BY id DESC"; $result = mysql_query ($sqlstr) or die ("Invalid query"); while ($row = mysql_fetch_object ($result))
{
$name=$row->name;
$posted=substr($row->posted,8,2)."-".substr($row->posted,5,2)."-".substr($row-
>posted,0,4);
$email=$row->email;
$address=$row->address;
$city=$row->city;
$msg=stripslashes($row->msg); echo("Posted : $posted<br>"); echo("Name : $name<br>");
echo("E-Mail : <a href=mailto:$email>$email</a><br>"); echo("Address : $address<br>"); echo("City : $city<br>"); echo("Message :<br>"); echo("$msg<br>");
echo("<hr size=1 width=100%>");
}
mysql_close($link);
?>
</font>
<font color="#000066" face=verdana size=2>
<a href="bukutamu1.php">Sign Up</a>
</font>
</body>
</html>
Creating Online Forms with PHP
One of the important parts of a website is the online form filling facility, either for ordering purposes, contacting the website owner or for online registration. In this section, we will discuss the creation of an online form whose data is sent to a specific e-mail address.
Algorithm:
- Create a form using the FORM tag in HTML. With the data entered are name, e-mail, address, city, telephone and order.
- All input data is stored in several variables and sent to another PHP file whose function is to receive variables sent by the form.
- Send to a specific e-mail address the contents of which correspond to those filled in on the form.
- Finished.
Form1.php file
<html>
<head>
<title>
Formulir Online
</title>
</head>
<body bgcolor="#FFFFFF">
<form action=formulir2.php method=POST>
<font face=verdana size=2 color="#000000">
<h3 align=left>
FORMULIR ONLINE
</h3>
</font>
<pre>
Nama : <input type=text name=nama size=15>
E-Mail : <input type=text name=email size=20>
Alamat : <input type=text name=alamat size=20>
Kota : <input type=text name=kota size=12>
Telepon : <input type=text name=telepon size=12>
Tulis pesanan Anda dibawah ini:
<textarea name=pesanan rows=5 cols=30>
</textarea>
<input type=submit value="Kirim"> <input type=reset value="Hapus">
</pre>
</form>
</body>
</html>Form2.php file
<html>
<head>
<title>
Formulir Online
</title>
</head>
<body bgcolor="#FFFFFF">
<font face=verdana size=2 color="#000000">
<h3 align=left>
FORMULIR ONLINE
</h3>
</font>
<pre>
<?php
// ----- buat header email
$to="anonkuncoro@yahoo.com";
$subject="Formulir Online";
$from="From: $nama <$email>";
// ----- isi email
$content="";
$content.="Formulir Online\n";
$content.="Nama : $nama\n";
$content.="E-Mail : $email\n";
$content.="Alamat : $alamat\n";
$content.="Kota : $kota\n";
$content.="Telepon : $telepon\n";
$content.="Pesanan Anda:\n";
$content.="$pesanan\n"; // ----- kirim ke email
mail($to,$subject,$content,$from);
// ----- tampilkan pesan di browser
echo("Terima kasih, data yang Anda kirimkan sebagai berikut:\n"); echo("Nama : $nama\n"); echo("E-Mail : $email\n"); echo("Alamat : $alamat\n"); echo("Kota : $kota\n"); echo("Telepon : $telepon\n"); echo("\n"); echo("Pesanan Anda:\n");
?>
</pre> <?php echo("$pesanan");
?>
</body>
</html>PHP Guest Book Example Login & Registration Page
All of these are memories of group assignments that we have worked on together. Our group members consist of Suryawan Agni Hidayat, Krisna Pandu, Suryani, and Ane. However, it should be noted that this script is not used for production, but only for learning, because there are still many bugs and some scripts do not run smoothly. Even so, the program structure is still suitable for learning the basics of PHP programming, especially the basic scope / introduction to dynamic web.
PHP Script Guestbook and Sign in / Sign up Page (Former Assignment)
1. About_Us
<div class="article">
<h2><span>ABOUT US</span> </h2>
<p class="infopost">Posted <span class="date">on 11 sep 2018</span> by <a href="#">Admin</a> | Filed under <a href="#">templates</a>, <a href="#">internet</a> <a href="#" class="com">Comments <span>11</span></a></p>
<div class="clr"></div>
<p> Kami adalah perusahaan design Web terkemuka, hubungi kami
Nama :</br>
No. Telp :</br>
e-mail :</br>
<div class="post_content">
</div>2. Guest Book
<legend>Komentar</legend>
<div id="products">
<form name='tamu' method='post' action='index.php?page=proses_input'>
Nama : <input type='text' name='nama'><br>
Email : <input type='text' name='email'><br>
Komentar : <br><textarea name='pesan'></textarea><br>
<input type='submit' name='submit' value='Send'>
<input type ='reset' name='reset' value='Reset'>
</form>
</div>3. Config
<?php $host = "localhost";
$user = "root"; $pass ="";
$db = "toko_online";
$konek = mysql_connect($host, $user, $pass) or die ('Koneksi Gagal! ');
mysql_select_db($db);
?>4. Contact
<div class="article">
<h2><span>CONTACT</span> </h2>
<p class="infopost">Posted <span class="date">on 11 sep 2018</span> by <a href="#">Admin</a> | Filed under <a href="#">templates</a>, <a href="#">internet</a> <a href="#" class="com">Comments <span>11</span></a></p>
<div class="clr"></div>
<p>Nama :</br>
No. Telp :</br>
e-mail :</br>
<div class="post_content">
</div>5. Content
<div class="content">
<div class="content_resize">
<div class="mainbar">
<div class="article">
<h2><span>Content</span> </h2>
<p class="infopost">Posted <span class="date">on 11 sep 2018</span> by <a href="#">Admin</a> | Filed under <a href="#">templates</a>, <a href="#">internet</a> <a href="#" class="com">Comments <span>11</span></a></p>
<div class="clr"></div>
<div class="img"><img src="images/img1.jpg" width="198" height="188" alt="" class="fl" /></div>
<div class="post_content">
<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec libero. <a href="#">Suspendisse bibendum. Cras id urna.</a> Morbi tincidunt, orci ac convallis aliquam, lectus turpis varius lorem, eu posuere nunc justo tempus leo. Donec mattis, purus nec placerat bibendum, dui pede condimentum odio, ac blandit ante orci ut diam. Cras fringilla magna. Phasellus suscipit, leo a pharetra condimentum, lorem tellus eleifend magna, eget fringilla velit magna id neque. Curabitur vel urna. In tristique orci porttitor ipsum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec libero. Suspendisse bibendum. Cras id urna. Morbi tincidunt, orci ac convallis aliquam, lectus turpis varius lorem, eu posuere nunc justo tempus leo.</p>
<p><strong>Aenean consequat porttitor adipiscing. Nam pellentesque justo ut tortor congue lobortis. Donec venenatis sagittis fringilla.</strong> Etiam nec libero magna, et dictum velit. Proin mauris mauris, mattis eu elementum eget, commodo in nulla. Mauris posuere venenatis pretium. Maecenas a dui sed lorem aliquam dictum. Nunc urna leo, imperdiet eu bibendum ac, pretium ac massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nulla facilisi. Quisque condimentum luctus ullamcorper.</p>
<p class="spec"><a href="#" class="rm">» Read more</a></p>
</div>6. Register
<?php
session_start();
if(isset($_SESSION['username'])) {
header('location:index.php'); }
?>
<html>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<head>
<title>Registrasi</title>
</head>
<body>
<center>
<form action="prosesdaftar.php" method="post">
<table>
<tr><td colspan="2" align="center"><h1>Registrasi</h1></td></tr><br>
<tr><td>Username</td><td> : <input type="text" name="username"></td></tr>
<tr><td>Password</td><td> : <input type="password" name="password"></td></tr>
<tr><td colspan="2" align="right"><input type="submit" value="Daftar"> <input type="reset" value="Batal"></td></tr><br>
<tr><td colspan="2" align="center">Sudah Punya akun ? <a href="login.php"><b>Login</b></a></td></tr>
</table>
</form>
</center>
</body>
</html>7. Edit_Guest
<legend>Daftar Komentar</legend>
<div id="products">
<hr size=1>
<?php
include('koneksi.php');
$id=$_REQUEST['id'];?>
<form name='tamu' method='post' action='index.php?page=proses_edit'>
<?php
$sql=mysql_query("SELECT * FROM bukutamu WHERE id_tamu=$id");
while($data=mysql_fetch_array($sql))
{
$id=$data['id_tamu'];
$nama=$data['nama'];
$email=$data['email'];
$pesan=$data['pesan'];
echo "No : $id<br>";
echo "Nama : $nama<br>";
echo "E-Mail : $email<br>";
echo "Pesan : $pesan<br>"; ?>
<input type='hidden' name='id' value='<?php echo $id; ?>'>
Nama :<input type='text' name='nama' value='<?php echo $nama; ?>'><br>
Email :<input type='text' name='email' value='<?php echo $email; ?>'><br>
Komentar :<br><textarea name='pesan' ><?php echo $pesan; ?></textarea><br>
<input type='submit' name='submit' value='Send'>
<input type='reset' name='reset' value='Reset'>
<?php } ?>
</form>
</div>8. Delete_Guest
<legend>Hapus Komentar</legend>
<div id="products">
<hr size=1>
<?php
$id=$_REQUEST['id'];
include('koneksi.php');
$tamu="DELETE FROM bukutamu WHERE id_tamu='$id'";
$hasil=mysql_query($tamu);
echo "<font color=red size=5>Data berhasil dihapus.</font>";
echo "<a href='index.php?page=lihat_bukutamu'>Lihat Bukutamu</a>";
?>
<br>
</div>9. Index
<?php
session_start();
if(!isset($_SESSION['username'])) {
header('location:login.php'); }
else { $username = $_SESSION['username']; }
require_once("config.php");
$query = mysql_query("SELECT * FROM user WHERE username = '$username'");
$hasil = mysql_fetch_array($query);
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="css/coin-slider.css" />
<script type="text/javascript" src="js/cufon-yui.js"></script>
<script type="text/javascript" src="js/cufon-times.js"></script>
<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="js/script.js"></script>
<script type="text/javascript" src="js/coin-slider.min.js"></script>
<head>
<title>Halaman Sukses Login</title>
</head>
<body>
<center>
<?php
echo "<h2>Selamat Datang, $username </h2>";
?>
<a href="logout.php"><b>Logout</a>
</center>
<div class="main">
<div class="header">
<div class="header_resize">
<div class="searchform">
<form id="formsearch" name="formsearch" method="post" action="#">
<span>
<input name="editbox_search" class="editbox_search" id="editbox_search" maxlength="80" value="Search our ste:" type="text" />
</span>
<input name="button_search" src="images/search.gif" class="button_search" type="image" />
</form>
</div>
<div class="logo">
<h1><a href="index.html">Magic<span>box</span> <small>Company Slogan Here</small></a></h1>
</div>
<div class="clr"></div>
<div class="menu_nav">
<ul>
<li class="active"><a href="index.php?page=profile"><span>Profile</span></a></li>
<li><a href="index.php?page=product"><span>Product</span></a></li>
<li><a href="index.php?page=bukutamu"><span>Buku Tamu</span></a></li>
<li><a href="index.php?page=lihat_bukutamu"><span>Lihat Buku Tamu</span></a></li>
<li><a href="index.php?page=contact"><span>About Us</span></a></li>
</ul>
</div>
<div class="clr"></div>
</div>
</div>
<div class="content">
<div class="content_resize">
<div class="mainbar">
<div class="article">
</div>
<?php
//KONTENT
$page=$_REQUEST['page'];
if($page=='profile' or $page==null)
include 'profile.php';
else if($page=='product')
include 'product.php';
else if($page=='bukutamu')
include 'bukutamu.php';
else if($page=='lihat_bukutamu')
include 'lihat_bukutamu.php';
else if($page=='edit_tamu')
include 'edit_tamu.php';
else if($page=='hapus_tamu')
include 'hapus_tamu.php';
else if($page=='proses_input')
include 'proses_input.php';
else if($page=='contact')
include 'contact.php';
else if($page=='proses_edit')
include 'proses_edit.php';
?>
<div class="clr"></div>
</div>
<div class="article">
<div class="clr"></div>
</div>
<p class="pages"><small>Page 1 of 2</small> <span>1</span> <a href="#">2</a> <a href="#">»</a></p>
</div>
<div class="sidebar">
<div class="gadget">
<h2 class="star"><span>Sidebar</span> Menu</h2>
<div class="clr"></div>
<ul class="sb_menu">
<li><a href="#">Home</a></li>
<li><a href="#">TemplateInfo</a></li>
<li><a href="#">Style Demo</a></li>
<li><a href="#">Blog</a></li>
<li><a href="#">Archives</a></li>
<li><a href="#">Web Templates</a></li>
</ul>
</div>
</div>
<div class="clr"></div>
</div>
</div>
<div class="fbg">
<div class="footer">
<div class="footer_resize">
<p class="lf">© Copyright <a href="#">MyWebSite</a>.</p>
<p class="rf">Design by Dream <a href="http://www.dreamtemplate.com/">Web Templates</a></p>
<div style="clear:both;"></div>
</div>
</div>
</div>
<div align=center>This template downloaded form <a href='http://all-free-download.com/free-website-templates/'>free website templates</a></div>
</body>
</html>10. Connection
<?php
$host='localhost';
$user='root';
$pass='';
$database='toko_online';
$conn=mysql_connect($host,$user,$pass);
if(!$conn) die ('Gagal Melakukan Koneksi');
mysql_select_db($database,$conn) or die ('Database Tidak DItemukan di Server')
?>11. View_Guest_Book
<script language="javascript">
function Confirm_hapus(){
if(confirm("KONFIRMASI HAPUS DATA\nTekan OK untuk melanjutkan penghapusan data")==true){
return true;
}else{
return false;
}
}
</script>
<legend>Daftar Komentar</legend>
<div id="products">
<hr size=1>
<?php
include('koneksi.php');
$sql=mysql_query("SELECT * FROM bukutamu");
while($data=mysql_fetch_array($sql))
{
$id=$data['id_tamu'];
$nama=$data['nama'];
$email=$data['email'];
$pesan=$data['pesan'];
echo "No : $id<br>";
echo "Nama : $nama<br>";
echo "E-Mail : $email<br>";
echo "Pesan : $pesan<br>";
echo "<a href='index.php?page=edit_tamu&id=$id'> Edit </a>";
echo "<a href='index.php?page=hapus_tamu&id=$id' onClick='return Confirm_hapus()'> Hapus </a>";
echo "<hr size=1>";
}
?>
</div>12. Login
<?php
session_start();
if(isset($_SESSION['username'])) {
header('location:index.php'); }
require_once("config.php");
?>
<html>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<head>
<title>Login</title>
</head>
<body>
<center>
<form action="proseslogin.php" method="post">
<table>
<tr><td colspan="2" align="center"><h1>Masuk</h1></td></tr><br>
<tr><td>Username</td><td> : <input type="text" name="username"></td></tr>
<tr><td>Password</td><td> : <input type="password" name="password"></td></tr>
<tr><td colspan="2" align="right"><input type="submit" value="Login"> <input type="reset" value="Batal"></td></tr><br>
<tr><td colspan="2" align="center">Belum Punya akun ? <a href="daftar.php"><b>Daftar</b></a></td></tr>
</table>
</form>
</center>
</body>
</html>13. Logout
<?php
session_start();
unset($_SESSION['username']);
if($user==null)
echo "Login dulu dong";
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="css/coin-slider.css" />
<script type="text/javascript" src="js/cufon-yui.js"></script>
<script type="text/javascript" src="js/cufon-times.js"></script>
<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="js/script.js"></script>
<script type="text/javascript" src="js/coin-slider.min.js"></script>
<head>
<title>Halaman Sukses Login</title>
</head>
<center>
<h2>Anda telah berhasil logout..</h2>
</center>
<body>
<div class="main">
<div class="header">
<div class="header_resize">
<div class="searchform">
<form id="formsearch" name="formsearch" method="post" action="#">
<span>
<input name="editbox_search" class="editbox_search" id="editbox_search" maxlength="80" value="Search our ste:" type="text" />
</span>
<input name="button_search" src="images/search.gif" class="button_search" type="image" />
</form>
</div>
<div class="logo">
<h1><a href="index.html">Magic<span>box</span> <small>Company Slogan Here</small></a></h1>
</div>
<div class="clr"></div>
<div class="menu_nav">
<ul>
<li class="active"><a href="index.php?page=profile"><span>Profile</span></a></li>
<li><a href="index.php?page=product"><span>Product</span></a></li>
<li><a href="index.php?page=bukutamu"><span>Buku Tamu</span></a></li>
<li><a href="index.php?page=lihat_bukutamu"><span>Lihat Buku Tamu</span></a></li>
<li><a href="index.php?page=contact"><span>About Us</span></a></li>
</ul>
</div>
<div class="clr"></div>
</div>
</div>
<div class="content">
<div class="content_resize">
<div class="mainbar">
<div class="article">
</div>
<?php
//KONTENT
$page=$_REQUEST['page'];
if($page=='profile' or $page==null)
include 'profile.php';
else if($page=='product')
include 'product.php';
else if($page=='bukutamu')
include 'bukutamu.php';
else if($page=='lihat_bukutamu')
include 'lihat_bukutamu.php';
else if($page=='edit_tamu')
include 'edit_tamu.php';
else if($page=='hapus_tamu')
include 'hapus_tamu.php';
else if($page=='proses_input')
include 'proses_input.php';
else if($page=='contact')
include 'contact.php';
else if($page=='proses_edit')
include 'proses_edit.php';
?>
<div class="clr"></div>
</div>
<div class="article">
<div class="clr"></div>
</div>
<p class="pages"><small>Page 1 of 2</small> <span>1</span> <a href="#">2</a> <a href="#">»</a></p>
</div>
<div class="sidebar">
<div class="gadget">
<h2 class="star"><span>Sidebar</span> Menu</h2>
<div class="clr"></div>
<ul class="sb_menu">
<li><a href="#">Home</a></li>
<li><a href="#">TemplateInfo</a></li>
<li><a href="#">Style Demo</a></li>
<li><a href="#">Blog</a></li>
<li><a href="#">Archives</a></li>
<li><a href="#">Web Templates</a></li>
</ul>
</div>
</div>
<div class="clr"></div>
</div>
</div>
<div class="fbg">
<div class="footer">
<div class="footer_resize">
<p class="lf">© Copyright <a href="#">MyWebSite</a>.</p>
<p class="rf">Design by Dream <a href="http://www.dreamtemplate.com/">Web Templates</a></p>
<div style="clear:both;"></div>
</div>
</div>
</div>
<div align=center>This template downloaded form <a href='http://all-free-download.com/free-website-templates/'>free website templates</a></div>
</body>
</html>14. Products
<div class="article">
<h2><span>PRODUCT</span> </h2>
<p class="infopost">Posted <span class="date">on 11 sep 2018</span> by <a href="#">Admin</a> | Filed under <a href="#">templates</a>, <a href="#">internet</a> <a href="#" class="com">Comments <span>11</span></a></p>
<div class="clr"></div>
<div class="img"><img src="images/img1.jpg" width="198" height="188" alt="" class="fl" /></div>
<div class="img"><img src="images/img1.jpg" width="198" height="188" alt="" class="fl" /></div>
<div class="img"><img src="images/img1.jpg" width="198" height="188" alt="" class="fl" /></div>
<div class="post_content">
</div>15. Profile
<div class="article">
<h2><span>Content</span> </h2>
<p class="infopost">Posted <span class="date">on 11 sep 2018</span> by <a href="#">Admin</a> | Filed under <a href="#">templates</a>, <a href="#">internet</a> <a href="#" class="com">Comments <span>11</span></a></p>
<div class="clr"></div>
<div class="img"><img src="images/img1.jpg" width="198" height="188" alt="" class="fl" /></div>
<div class="post_content">
<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec libero. <a href="#">Suspendisse bibendum. Cras id urna.</a> Morbi tincidunt, orci ac convallis aliquam, lectus turpis varius lorem, eu posuere nunc justo tempus leo. Donec mattis, purus nec placerat bibendum, dui pede condimentum odio, ac blandit ante orci ut diam. Cras fringilla magna. Phasellus suscipit, leo a pharetra condimentum, lorem tellus eleifend magna, eget fringilla velit magna id neque. Curabitur vel urna. In tristique orci porttitor ipsum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec libero. Suspendisse bibendum. Cras id urna. Morbi tincidunt, orci ac convallis aliquam, lectus turpis varius lorem, eu posuere nunc justo tempus leo.</p>
<p><strong>Aenean consequat porttitor adipiscing. Nam pellentesque justo ut tortor congue lobortis. Donec venenatis sagittis fringilla.</strong> Etiam nec libero magna, et dictum velit. Proin mauris mauris, mattis eu elementum eget, commodo in nulla. Mauris posuere venenatis pretium. Maecenas a dui sed lorem aliquam dictum. Nunc urna leo, imperdiet eu bibendum ac, pretium ac massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nulla facilisi. Quisque condimentum luctus ullamcorper.</p>
<p class="spec"><a href="#" class="rm">» Read more</a></p>
</div>16. Process_Edit
<legend>Edit Komentar</legend>
<div id="products">
<hr size=1>
<?php
$id=$_POST['id'];
$nama=$_POST['nama'];
$email=$_POST['email'];
$pesan=$_POST['pesan'];
include('koneksi.php');
$tamu="UPDATE bukutamu SET nama='$nama',email='$email',pesan='$pesan'
WHERE id_tamu='$id'";
$hasil=mysql_query($tamu);
echo "<font color=red size=5>Bukutamu berhasil diubah.</font>";
echo "<a href='index.php?page=lihat_bukutamu'>Lihat Bukutamu</a>";
?>
<br>
</div>17. Input_Process
<?php
$nama=$_POST['nama']; //variable yang dikirim dari form tadi
$email=$_POST['email']; //
$pesan=$_POST['pesan'];
include('koneksi.php'); //untuk mengkoneksikan ke database
//input data ke tabel bukutamu
$tamu="INSERT INTO bukutamu VALUES('','$nama','$email','$pesan')";
$hasil=mysql_query($tamu);
echo "<font color=red size=5>Bukutamu berhasil diisi.</font>";
echo "<a href='index.php?page=lihat_bukutamu'><b>Lihat Bukutamu</b></a>";
?>18. Process_List
<?php
require_once("config.php");
$username = $_POST['username'];
$pass = $_POST['password'];
$cekuser = mysql_query("SELECT * FROM user WHERE username = '$username'");
if(mysql_num_rows($cekuser) <> 0) {
echo "Username Sudah Terdaftar!<br/>";
echo "<a href='daftar.php'>Back</a>";
} else {
if(!$username || !$pass) {
echo "Masih ada data yang kosong!<br/>";
echo "<a href='daftar.php'>&amp;laquo; Back</a>";
} else {
$simpan = mysql_query("INSERT INTO user(username, password) VALUES('$username','$pass')");
if($simpan) {
echo "Pendaftaran Sukses, Silahkan <a href='login.php'>Login</a>";
} else {
echo "Proses Gagal!";
}
}
}
?>
<link href="css/style.css" rel="stylesheet" type="text/css" />19. Login_Process
<?php
session_start();
require_once("config.php");
$username = $_POST['username'];
$pass = $_POST['password'];
$cekuser = mysql_query("SELECT * FROM user WHERE username = '$username'");
$jumlah = mysql_num_rows($cekuser);
$hasil = mysql_fetch_array($cekuser);
if($jumlah == 0) {
echo "Username Belum Terdaftar!<br/>";
echo "<a href='login.php'>Back</a>";
} else {
if($pass <> $hasil['password']) {
echo "<h1>Password Salah!</h1><br/>";
echo "<a href='login.php'>Back</a>";
} else {
$_SESSION['username'] = $hasil['username'];
header('location:index.php');
}
}
?>
<link href="css/style.css" rel="stylesheet" type="text/css" />Hope this is useful & happy learning!