Guest Book for Your Site

Written by @m_k_amin 10 December 2012

If you are interested in collecting visitors opinions about your web site, you should use guest books. This script prepared it for you. Note that this code is intelligent and doesn't need any further setup. Just enter your MySql info and enjoy!

Code Snippet:

                                                
                                                <!-- this script is provided by https://www.phpfreecode.com coded by: Kerixa Inc. -->
<!-- This Script is from www.phpfreecpde.com, Coded by: Kerixa Inc-->
<?php
	$host="localhost"; // Host name
	$username="root"; // Mysql username
	$password=""; // Mysql password

$link=mysql_connect($host, $username, $password);
if(!$link) die('
<p style="text-align: center;	font-size: 20pt;"><span style="color: #FF0000;">Failed to connect to the database! </span>
<br><span style="font-size: 12pt;">&gt;&gt;Please check the parameters and database server&lt;&lt;</span></p>
');

$db_name="guestbook"; 
$result=mysql_select_db($db_name);
if(!$result){
forumsetup();
}
$result=mysql_select_db($db_name);
$tbl_name="issues";
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql,$link) or die('sss'.mysql_error());
$cn=1;
while($rows=mysql_fetch_array($result)){ // Start looping table row 
	$cn++;
	echo '
	<table align="center" style="width: 500; font-family: \'Times New Roman\', Times, serif;font-size:  12pt; border: 1px solid #000000" cellpadding="5" cellspacing="1">
	<tr>
		<td style="height: 30; border: 1px solid #0000FF; background-color: #DEDEDE;"><strong>From:
		<span style="color: #066B12">'.$rows['name'].'</span></strong></td>
	</tr>
	<tr>
		<td style="height: 30; border: 1px solid #0000FF; color: #066B12;">'.$rows['msg'].'</td>
	</tr>
	<tr>
		<td style="height: 30; border: 1px solid #0000FF; background-color: #DEDEDE;">
		<a href="mailto:'.$rows['email'].'"><span style="color: #440808">Mail</span></a><span style="color: #440808">&nbsp; -&nbsp; 
		</span><a href="'.$rows['site'].'"><span style="color: #440808">Website</span></a></td>
	</tr>
	</table><br>
';
}
echo'
<form method="post" action="'.$_SERVER['PHP_SELF'].'?type=new">
<table align="center" style="width: 500; font-family: \'Times New Roman\', Times, serif;font-size:  12pt; border: 1px solid #000000" cellpadding="5" cellspacing="1">
	<tr>
		<td style="height: 30; border: 1px solid #0000FF; background-color: #DEDEDE;"><strong>
		Name: <input name="name" type="text" id="a_name" size="45"></strong></td>
	</tr>
	<tr>
		<td style="height: 30; border: 1px solid #0000FF; color: #066B12;">
		<textarea name="msg" id="a_answer" style="width: 482px; height: 90px"></textarea></td>
	</tr>
	<tr>
		<td style="height: 30; border: 1px solid #0000FF; background-color: #DEDEDE; color: #440808;">
		<table style="width: 100%">
			<tr>
				<td style="width: 68px">Mail:</td>
				<td><input name="email" type="text" id="email" size="45"></td>
			</tr>
			<tr>
				<td style="width: 68px">Website:</td>
				<td><input name="site" type="text" id="a_email0" size="45"></td>
			</tr>
			<tr>
				<td colspan="2" style="text-align: center">
				<input type="submit" name="Submit" value="Submit" style="height: 34px">&nbsp;&nbsp; 
				<input type="reset" name="Submit2" value="Reset" style="height: 32px"></td>
			</tr>
		</table>
		</td>
	</tr>
</table>
</form>
';
if (isset($_POST['Submit']) && $_GET['type']=='new'){
		//$id=$_POST['ID'];
		$site=$_POST['site'];
		$msg=$_POST['msg'];
		$name=$_POST['name'];
		$email=$_POST['email'];
		$datetime=date("d/m/y h:i:s"); //create date time
		$sql="INSERT INTO issues(msg,  name, email, site,datetime)VALUES('$msg', '$name', '$email', '$site', '$datetime')";
		$result=mysql_query($sql);
		if($result){
			echo '<p style="color: #008000;	text-align: center;	font-size: 15pt;"">Your Opinion is Added successfully!
					<meta http-equiv="refresh" content="0"> ';
		}else {
			echo mysql_error();
		}

}
function forumsetup(){
echo('
<p style="color: #008000;	text-align: left;	font-size: 15pt;"">-Automatic setup is started...</p>
');
global $host,$username,$password,$link;
//$link=mysql_connect($host, $username, $password);
$sql= 'CREATE DATABASE guestbook';
if (!mysql_query ($sql, $link)) die('
<p style="text-align: center;	font-size: 20pt;"><span style="color: #FF0000;">Failed to 
create database! </span><br><span style="font-size: 12pt;">&gt;&gt;Please check the parameters and database server&lt;&lt;</span></p>
');
$sql = "CREATE TABLE `guestbook`.`issues` (
`msg` LONGTEXT NOT NULL ,
`name` TEXT NOT NULL ,
`email` TEXT NOT NULL ,
`site` TEXT NOT NULL ,
`datetime` TEXT NOT NULL 
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;";
mysql_query($sql) or die(mysql_error());
echo('
<p style="color: #008000;	text-align: left;	font-size: 15pt;"">-Automatic setup completed successfully. Your Guest Book is ready!</p>
');
}
?>
<div style="text-align: center">
	<font face="Tahoma"><a target="_blank" href="http://www.phpfreecode.com/">
	<span style="font-size: 8pt; text-decoration: none">PHP Free Code</span></a></font>
</div><a target='_blank' href='https://www.phpfreecode.com' style='font-size: 8pt; text-decoration: none'>Php Best Codes</a>                                                
                                            

Example:


About @m_k_amin

This user is pending a biography.

M

Comments


Here you can leave us commments. Let us know what you think about this code tutorial!

0 / 300

TRENDING POST
1
2
3
4
5
VISITORS
Online Users: 12
Recent Members: grkkid, Manaakividuinfo.com, karticksv, sava, tinatina
advertisement 2