ArticlesReader.com Menu
Newest Articles
Most Viewed Articles
ArticlesReader.com RSS
Submit Article
Login
Signup
Search the articles

Articles Main Categories
Advice
Animals
Automobiles
Business
Career
Communications
Computer Programming
Computers
Entertainment
Environment
Family
Fashion
Finance
Food
Health & Medical
Home & Garden
Humor
Internet Business
Internet Marketing
Legal
Leisure & Recreation
Marketing
Other
Politics
Reference & Education
Religion
Self Improvement
Sports
Technology & Science
Travel
Writing
Subscribe
Receive alert message from us when new articles submitted to our site for free.

Enter your name

Enter your email

Syndicate

















Related Products
Home::CGI

Design an Online Chat Room with PHP and MySQL

Author : Rory Canyon

In this article, you will learn how to design and develop a
simple online chat room with PHP and MySQL. This tutorial
explains every steps of the development, including both database
design and PHP programming. Basic computer skills and knowledge
of HTML and PHP are required. Ok, let's begin now.

Step 1: Design Database Table. Create table "chat" in MySQL
database to store basic chat information: chtime (chat time),
nick (user nickname) and words (chat message, less than 150
characters)

mysql> CREATE TABLE chat

-> chtime DATATIME,

-> nick CHAR (10) NOT NULL,

-> words CHAR (150);

Step 2: Design Structure. This simple online chat room includes
the following four sections: user login, message display,
message input and a main frame integrating the display and input
sections. Thus, it needs the following four files to work:
login.php, main.php, display.php and speak.php.



Step 3: Write the code

1. login.php (just a HTML form)





User Login





Please input your nickname and enter















2. main.php


setcookie("nick",$nick) //use cookie to store user nickname

?>



My Chat Room











3. display.php

This file is used to get message records from database and
display the results. To keep the size of database, old messages
are deleted and only the newest 15 messages are displayed.





Display Messages








//connect to mysql server, server name: main, database username:
root

$link_ID=mysql_connect("main","root");

mysql_select_db("abc"); //abc is the database name

$str="select * from chat ORDER BY chtime;" ;

$result=mysql_query($str, $link_ID);

$rows=mysql_num_rows($result);

//get the latest 15 messages

@mysql_data_seek($resut,$rows-15);

//if the number of messages<15, get all of the messages

if ($rows<15) $l=$rows; else $l=15; for ($i=1;$i<=$l; $i++) {

list($chtime, $nick, $words)=mysql_fetch_row($result);

echo $chtime; echo " "; echo $nick; echo":" ; echo $words; echo
"
";

} //delete the old messages(only keep the newest 20 only)

@mysql_data_seek($result,$rows-20);

list($limtime)=mysql_fetch_row($result);

$str="DELETE FROM chat WHERE chtime<'$limtime' ;" ;

$result=mysql_query($str,$link_ID);

mysql_close($link_ID);

?>





4. speak.php





Speak






If ($words)

{ $link_ID=mysql_connect("main","root");

mysql_select_db("abc"); // abc is the database name

$time=date(y).date(m).date(d).date(h).date(i).(date(s); //get
current time

$str="INSERT INTO chat(chtime,nick,words) values
('$time','$nick','$words');" ;

mysql_query($str,$link_ID); //save message record into database

mysql_close($link_ID); )

?>

//the following is the message input form













Now, you have finished the design and coding of a simple online
chat system. Put all the files into your website root and see
how it works, :)

Spam emails More free articles

Related articles


  1. 5 CGI Scripts You Must Use to Turn Your Site Into a Powerhouse
  2. Clever Profit Growth Software
  3. Why Aren't You Using CGI
  4. Use CGI to Automate Your Web Site
  5. CGI: What the Heck Is That?
  6. CGI Security Issues
  7. How to Stop Digital Thieves with CGI
  8. Quick Intro to PHP Development
  9. Better Writing: What Works and What Doesn't
  10. Password Protection and File Inclusion With PHP
  11. Autoresponders With PHP
  12. Track your visitors, using PHP
  13. PHP On-The-Fly!
  14. PHP and Cookies; a good mix!
  15. Screen scraping your way into RSS
  16. Mastering Regular Expressions in PHP
  17. ASP, CGI and PHP Scripts and Record-Locking: What Every Webmaster Needs To Know
  18. Open Source Scripts
  19. this is a test
  20. An Extensive Examination of the PHP:DataGrid Component: Part 1
  21. PHP:Form Series, Part 1: Validators & Client-side Validation
  22. Design an Online Chat Room with PHP and MySQL
More related feeds
Design an Online Chat Room with PHP and MySQL
Material Image, In this article, you will learn how to design and develop a simple online chat room with PHP and MySQL. Author: PHPreg.com Date: May 13, 2008.

Design an Online Chat Room with PHP and MySQL
In this article, you will learn how to design and develop a simple online chat room with PHP and MySQL. This tutorial explains every steps of the development, including both database design and PHP programming. Basic computer skills and ...

FlashChat v 4.7.12 ( Full )
With over 50 configuration options available in the FlashChat config.php file, you can make the chat behave in any of dozens of ways. Set IP limits, log limits, flood intervals, inactivity limits, and much more! ...

Install Flash Chat Room
Need person who is familiar with Install Tufat Flash Chat Room scripts.

Chatroom Installation/status
Installation of chatroom and that I can modify and add more as I go along 2. Online status, which means that each Reader will have a chatroom when entering the chatroom will show them online, when Busy , busy will show but not the ...

Aim Chat Bot
I am looking for a programmer who can code me a multi-socket AIM Chatroom Bot. The AIM Chatrooms are found here at http://chat.aim.com Please note, these are not the AIM chatrooms that are found on your AIM messenger service, ...

Script Editing-insert Widget
I need someone to add a chat room widget code so that it appears on the right side of all the games on my arcade website. It should be very simple and take less then 30 minutes. I have also attached a picture of how I would like the end ...

Dating Website
Hi, I want someone to build a dating website, similar to match.com. Need to do the complete programming. Same functionality including chat room. Thank you.

Jumbo Software Pack
PHP and MySQL for Dynamic Web Sites Icons Collection .Mac with iWeb, Second Edition (Visual QuickStart Guide) by David Reynolds lynda.com CorelDRAW Graphics Suite X3 Essential Training Witcobber Super Video Joiner ver.4.6.0 ...

Choosing Right Content Management System
Is there a forum, mailing list, or a chatroom where you can go and ask questions. There are many Free and Open Source CMS available on the web. They come with great community support, plugins, templates and themes. ...

 


 

© 2007 articlesreader.com - All Rights Reserved