PHPzz

simple PHP guestbook tutorial script

First create a table.

SQL code:

DROP TABLE IF EXISTS `test`.`gbook`;
CREATE TABLE `test`.`gbook` (
`id` int(10) unsigned NOT NULL auto_increment,
`user` varchar(45) NOT NULL default '',
`text` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Then insert this PHP code into your page.

guestbook PHP code:

<form method="POST" action="">
<input type="text" name="T1" size="20"><br>
<textarea rows="5" name="S1" cols="40"></textarea><br>
<input type="submit" value="Submit" name="B1"><br>
</form>
<?php
mysql_pconnect("localhost","root","qwertyr") or die("Unable to connect to SQL server");
mysql_select_db("test") or die("Unable to select database");
if (isset($_POST['B1'])){
$f1=$_POST['T1'];
$f2=$_POST['S1'];
$query="INSERT INTO gbook (user,text) VALUES ('$f1','$f2');";
mysql_query($query);
}
$query="SELECT * FROM gbook;";
$result=mysql_query($query);
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
?>
<div>
<?php echo $line['user']; ?>
</div>
<div>
<?php echo $line['text']; ?>
</div>
<br>

<?php
}
?>