PHP Tutorials : Create Simple ShoutBox

[t4vn.net]

Hi,this is simple tutorials to create shoutbox.
Full tutorial you can view here :
http://www.t4vn.net/tutorials/showtu...-ShoutBox.html

Step 1 : Create database with information :

PHP Code:

CREATE TABLE `tagboard` ( 
`id` int(7) NOT NULL auto_increment, 
`name` varchar(250) NOT NULL default '', 
`comments` text NOT NULL, 
`date` timestamp(14) NOT NULL, 
PRIMARY KEY (`id`), 
) TYPE=MyISAM AUTO_INCREMENT=419 ; 


Step 2 : Create file config.php with content

PHP Code:

<? 
$dbuser=""; //Database Username 
$dbname=""; //Database Name 
$dbpass=""; // Database Password 
?>

Step 3: Create File tag.php with content :

PHP Code:

<iframe src="view.php" name="tag" width="179" height="130" frameborder=0 marginwidth="0" marginheight="0"></iframe><form method="POST" ACTION="todo.php"> 
<input type="text" NAME="name" Value=">"> 
<textarea NAME="post" cols="27" rows="3"></textarea> 
<br> 
<input TYPE="submit" value="Submit"> 


Step 4: Create file todo.php with content :

PHP Code:

<?php 
if ($name == '' || $post == ''") 
{ 
die ("Please fill all fields. Click <a HREF=tag.php>here</a> to return."); 
} 
include('config.php'); 

$post = preg_replace("/</","&lt;",$post); 
$post = preg_replace("/>/","&gt;",$post); 
$post = nl2br($post); 
$comments = "$post"; 
} 

$c=mysql_connect("localhost","$dbuser","$dbpass"); 
mysql_select_db($dbname); 
$todo="INSERT INTO tagboard (id,name,comments,date) VALUES('','$name','$comments',now())"; 
$solution = mysql_query($todo) or die (mysql_error()); 
if ($solution) 
{ 
?> 
<meta http-equiv="refresh" content="0;url=tag.php" > 
<? 
} ?>

Step 5 : Finally,create file view.php with content :

PHP Code:

<?php 
include('config.php'); 

$c=mysql_connect("localhost","$dbuser","$dbpass"); 

mysql_select_db($dbname); 

$todo='SELECT * FROM `tagboard` order by id desc LIMIT 50'; 
$solution=mysql_query($todo); 
while ($place = mysql_fetch_array($solution)) 
{ 
$id=$place["id"]; 
$comments=$place["comments"]; 

?> 
»<b><? echo "$place[name]"; ?></b><? echo ": $comments<br>" ; ?> 
<? 
}?>

You're done.
Good luck: