Semua ini adalah kenangan tugas kelompok yang pernah kami kerjakan bersama. Anggota kelompok kami terdiri dari Suryawan Agni Hidayat, Krisna Pandu, Suryani, dan Ane. Namun perlu diketahui bahwa script ini bukan digunakan untuk produksi, akan tetapi hanya sebatas untuk belajar saja, dikarenakan masih banyak terdapat bug dan beberapa script tidak berjalan mulus. Meski begitu struktur programnya masih layak digunakan untuk belajar dasar pemrograman PHP, khususnya lingkup dasar / pengenalan web dinamis.
Script PHP Buku Tamu dan Halaman Sign in / Sign up (Bekas Tugas)
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. Buku_Tamu
<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. Daftar
<?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_Tamu
<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. Hapus_Tamu
<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. Koneksi
<?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. Lihat_Buku_Tamu
<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. Product
<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. Proses_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. Proses_Input
<?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. Proses_Daftar
<?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. Proses_Login
<?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" />
Semoga bermanfaat & selamat belajar!
