Hy semua sudah lama aku tidak pernah posting maaf ada banyak hal yang harus dikerjain.
ok hari ini kita akan membahasa bagaimana cara membuat Guestbook dengan php dan database.
Berikut ini adalah file-file yang akan kita buat ...
1. Buat database dan table di database.
2. Buat config.php
3. Script Security.php
3. Script index.html
4. Script save.php
5. Script view.php
===================================
1. kita buat database buat database terserah kalian buat nama apa.
===================================
Setelah buat database
buat table seperti dibawah ini:
CREATE TABLE `guestbook` (
`id` int(11) NOT NULL auto_increment,
`nama` varchar(90) character set latin1 collate latin1_general_ci NOT NULL,
`email` varchar(60) character set latin1 collate latin1_general_ci NOT NULL,
`url` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`alamat` varchar(70) character set latin1 collate latin1_general_ci NOT NULL,
`komentar` varchar(255) character set latin1 collate latin1_general_ci NOT NULL,
`time` varchar(30) character set latin1 collate latin1_general_ci default NULL,
`date` varchar(30) character set latin1 collate latin1_general_ci default NULL,
`ip` varchar(30) character set latin1 collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
===================================
2. Buat file baru dengan nama (Config.php)
===================================
<?php
mysql_connect("$db_host","$db_user","$db_pass");
mysql_select_db("$db_name");
?>
===================================
3. Buat file baru dengan nama (index.html)
===================================
<?php
session_start();
class CaptchaSecurityImages {
var $font = 'monofont.ttf';
function generateCode($characters) {
/* list all possible characters, similar looking characters and vowels have been removed */
$possible = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
$code = '';
$i = 0;
while ($i < $characters) {
$code .= substr($possible, mt_rand(0, strlen($possible)-1), 1);
$i++;
}
return $code;
}
function CaptchaSecurityImages($width='120',$height='40',$characters='6') {
$code = $this->generateCode($characters);
/* font size will be 75% of the image height */
$font_size = $height * 0.75;
$image = @imagecreate($width, $height) or die('Cannot Initialize new GD image stream');
/* set the colours */
$background_color = imagecolorallocate($image, 255, 255, 255);
$text_color = imagecolorallocate($image, 50, 10, 175);
$noise_color = imagecolorallocate($image, 200, 150, 100);
/* generate random dots in background */
for( $i=0; $i<($width*$height)/3; $i++ ) {
imagefilledellipse($image, mt_rand(0,$width), mt_rand(0,$height), 1, 1, $noise_color);
}
/* generate random lines in background */
for( $i=0; $i<($width*$height)/150; $i++ ) {
imageline($image, mt_rand(0,$width), mt_rand(0,$height), mt_rand(0,$width), mt_rand(0,$height), $noise_color);
}
/* create textbox and add text */
$textbox = imagettfbbox($font_size, 0, $this->font, $code);
$x = ($width - $textbox[4])/2;
$y = ($height - $textbox[5])/2;
imagettftext($image, $font_size, 0, $x, $y, $text_color, $this->font , $code);
/* output captcha image to browser */
imagejpeg($image);
imagedestroy($image);
$_SESSION['security_code'] = $code;
}
}
$width = isset($_GET['width']) ? $_GET['width'] : '120';
$height = isset($_GET['height']) ? $_GET['height'] : '40';
$characters = isset($_GET['characters']) ? $_GET['characters'] : '6';
header('Content-Type: image/jpeg');
$captcha = new captchasecurityimages($width,$height,$characters);
?>
===================================
4. Buat file baru dengan nama (index.html)
===================================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Guestbook</title>
</head>
<body>
<div align="justify"></div>
<form name="form1" method="post" action="save.php">
<pre>
<table border="0">
<tr>
<th align="right" valign="top">Nama</th>
<th align="right" valign="top">:</th>
<td valign="top"><input name="nama" type="text" id="nama" size="35"/></td></tr>
<tr><th align="right" valign="top">Email</th>
<th align="right" valign="top">:</th>
<td valign="top"><input name="email" type="text" size="35"/></td></tr>
<tr><th align="right" valign="top">Website</th>
<th align="right" valign="top">:</th>
<td valign="top"><input name="url" type="text" size="35"/></td></tr>
<tr><th align="right" valign="top">Alamat</th>
<th align="right" valign="top">:</th>
<td><input name="alamat" type="text" size="35"/></td></tr>
<tr><th align="right" valign="top">Isi</th>
<th align="right" valign="top">:</th>
<td valign="top"><textarea name="komentar" rows="5" cols="40"/></textarea></td></tr><tr><th align="right" valign="top">Secrutiy</th><th align="right" valign="top">:</th><td valign="top"><img src="security.php?width=100&height=40&character=5"><br /><input id="security_code" name="security_code" type="text" /></td></tr><tr><th align="right" valign="top"> </th><th align="right" valign="top"> </th><td valign="top"><input type="submit" name="submit" value="Submit" /><input type="reset" name="Reset" value="Reset" /></td></tr></table></pre>
</form>
</body>
</html>
===================================
5. Buat file baru dengan nama (Save.php)
===================================
<?php
session_start();
require 'config.php';
if( isset($_POST['submit'])) {
if(($_SESSION['security_code'] == $_POST['security_code']) && (!empty($_SESSION['security_code'])) ) {
$nama = $_POST['nama'];
$email = $_POST['email'];
$url = $_POST['url'];
$alamat = $_POST['alamat'];
$komentar = $_POST['komentar'];
$time = date("H:i:s");
$date = date ("d/m/Y");
$ip = $_SERVER['REMOTE_ADDR'];
$sql ="INSERT INTO guestbook (nama,email,url,alamat,komentar,time,date,ip) VALUES('$nama','$email','$url','$alamat','$komentar','$time','$date','$ip')";
mysql_query($sql);
echo"<h2>Pesan Berhasil Dikirim</h2><br />
<a href= viewmsg.php>Klik Disini</a> Untuk Melihat pesan Yang Sudah Dikirim";
include "index.php";
} else {
// Insert your code for showing an error message here
echo '<h2>Maaf Code Secruity Yang Anda Masukkan Salah Silahkan Coba Lagi</h2>';
include "index.php";
}
} else {
include "index.php";
}
?>
===================================
6. Buat file baru dengan nama (View.php)
===================================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body bgcolor="#66FF00">
<table align="center" cellspacing="1" border="1">
<tr>
<th colspan="2"><span class="hisyam" ><font color="#ff0000">*</font><font color="#ff3300">*</font><font color="#ff6600">*</font><font color="#ff9900">.</font><font color="#ffcc00">:</font>M<font color="#ccff00">Y</font> <font color="#66ff00">G</font><font color="#00ff00">U</font><font color="#00ff33">E</font><font color="#00ffff">S</font><font color="#00ccff">T</font><font color="#0099ff">B</font><font color="#0066ff">O</font><font color="#ff0000">OK </font><font color="#00ccff">:</font><font color="#0099ff">.</font><font color="#0066ff">*<font color="#ff0000">*</font><font color="#ff3300">*</font> </font></span></th>
</tr>
<tr>
<th width="350"><center>
<font size="4"><font color="#ffcc00">P</font>e<font color="#ccff00">n</font><font color="#99ff00">g</font><font color="#00ffff">i</font><font color="#00ccff">r</font><font color="#0099ff">i</font><font color="#ffcc00">m</font><font color="#ffff00"> :</font></font>
</center></th>
<th width="350"><center>
<font size="4"><font color="lime">C</font><font color="#ccff00">o</font><font color="#99ff00">m</font><font color="#66ff00">m</font><font color="#00ff00">e</font><font color="#00ff33">m</font><font color="#00ffff">e</font><font color="#00ccff">n</font><font color="#0099ff">t</font><font color="#0066ff"> :</font></font>
</center></th>
</tr>
<?
require 'config.php';
$yahya = " SELECT * FROM guestbook ORDER BY ID DESC";
$karya = mysql_query($yahya);
while ($hisyam = mysql_fetch_array($karya)) {
echo "
<tr >
<td valign='top' align='left'><font size='2'><img src='../images/buku.gif' style='border:0;margin:0;' > Nama: <b><a href='$hisyam[url]'>$hisyam[nama]</a></b><br>
<img src='../images/inbox.gif' style='border:0;margin:0;' > Email : <a href='mailto:$hisyam[email]'>$hisyam[email]</a> <br>
Website : <a href='$hisyam[url]'>$hisyam[url]</a>
<br /> Lokasi : $hisyam[alamat]<br>
<img src='../images/ip.gif' style='border:0;margin:0;' >$hisyam[ip]<br></td>
<td valign='top' align='left'><font size='2'><img src='../images/post.gif' style='border:0;margin:0;' > $hisyam[date], $hisyam[time]<br>
<hr color='#FF6600' style='border: dashed 1px;'>
$hisyam[komentar]</td>"; } ?>
</table>
</body>
</html>