6 replies to this topic

[fedekiller]

In this tutorial i will explain how to make a simple shoutbox
For this tutorial, you will need an sql host, if you dont have one, you can get it in http://freesql.org

1. Create a new table, for that, run this code

CREATE TABLE `shoutbox` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`message` longtext NOT NULL,
PRIMARY KEY  (`id`)
) TYPE=MyISAM;

2. Now make a new document and paste this code

<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #000000;
}
-->
</style><table width="200" height="200" border="0">

  <tr>
    <td><iframe scrolling="auto" src="show.php">
	</iframe>
	</td>
  </tr>
</table>
<form action="shoutbox2.php" method="post">
  <p>Name<br>  
    <input name="name_txt" type="text" id="name_txt">
</p>
  <p>Message<br>
    <textarea name="message_txt" id="message_txt"></textarea>
  </p>
</p>
  <p>
    <input type="submit" name="Submit" value="blah">  
  </p>
</form>

Save it as shout.php
In that code, im bassically making the "form" and the "style"

2. Make nother document, and paste this code

<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #000000;
}
-->
</style><?
$name= $_POST["name_txt"];
$message= $_POST["message_txt"];
mysql_connect("localhost","your_username","your_pass");
mysql_select_db("your_database");
MYSQL_QUERY("INSERT INTO shoutbox (id,name,message)".
      "VALUES ('NULL','$name', '$message')");
?>
<? 
echo "Shout posted, <a href=shout.php>go back</a>"
?>

Now save it as shoutbox2.php . Here i aply style too but im sending the form too

3. Make another document and paste this code

<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #000000;
}
-->
</style><?
mysql_connect("freesql.org","spoono_db","pokemon") or die(mysql_error());
    mysql_select_db("spoono_db") or die(mysql_error());
    $query = "SELECT message, name
FROM shoutbox order by id DESC LIMIT 10";
    $result = mysql_query($query);
    echo "<TABLE>";
    while($r=mysql_fetch_array($result))    
    {
        echo "<TR>
            <TD><font-size: 10px;>
<strong>$r[name]</A></font></TD></strong>
        </TR>
        <TR>
            <TD><font-size: 10px;>$r[message]</font></TD>
        </TR>
        <TR>
            <TD><HR></TD>
        </TR>";
        
    }
    echo "</TABLE>"; 
?>

Here i apply style too but im bassicaly showing the information of the database
save this as show.php.

4. Now upload all the files to your server and enjoy your shoutbox

Attached Files

•  shoutbox.zip   1.48KB   860 downloads

Edited by fedekiller, 29 June 2005 - 03:01 PM.

[/quit]

Wow, nice tut, I was gonna search that on hotscripts, but now i dont have to!

[Donna]

Wow, nice tut, I was gonna search that on hotscripts, but now i dont have to!

http://www.pixel2lif...d=1&ss=shoutbox

[fedekiller]

but my code is much more easure

[Klubba]

I don't like that you use iframes, i would had used the PHP-command; include. But nice tutorial anyways, keep up the good work

[fedekiller]

you can also make a new page and put

<?
include ("show.php")
?>

[eric81]

why not just have it post to itself rather then using more then one page?