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::Robert Plank

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
Freelance Project | Chatroom Live Online 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 ...

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.

PHP - Strange Error Message | DreamInCode.net
Warning: Invalid argument supplied for foreach() in on line 206. The thing is, the pages work flawlessly on the live server. I have Apache 2.2 and the latest releases of MySQL and PHP installed. Can anyone offer an explanation and/or ...

PHP - User Authentication System -- Theory | DreamInCode.net
Join 136002 PHP Programmers for FREE! Get instant access to thousands of PHP experts, tutorials, code snippets, and more! There are 2393 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a PHP Expert ...

Chat Room Design 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 ...

a good affiliate program - Webdigity webmaster forums
You just add the room on your website.Even if those who buy products is in your chat room, you will be paid for as well. Of course, When you download the free flash chat room, you can full in your affiliate ID. ...

Freelance Project | Gaming Portal
Want to have a similar lobby like that one but based on our requirements and our game) - Practice Rooms - Live Rooms - Online Players (with stats) - Open Challenges - Players can create Tournament & Invite Players - Chat (player can ...

Maker Mortificationcreation 8.0
Chat Client, Booter, Boot, Yazak, Ymlite, Yahaven, Ytunnel, YTK, Yahelite, Pidgin, Room Booter, Lagg, Voice, Yahoo, Bots, Spam,Chat, Crack, Proxy, Pinoy Room Conquer, YmHook, Yhook, Yahoo Messenger, Yahoo Ace, No5, Scanner, Yahfox, ...

design an online chat room with php and mysql
in this article, you will learn how to design and develop asimple online chat room with php and mysql. this tutorialexplains every steps of the development, including both databasedesign and php programming. basic computer skills and ...

Flash Chat For Joomla & Community Builder by BigBox | Freelance ...
I need someone with Joomla & flash experience to create a chat room base on flash and php. I have the description of the project on the images i attached. (Budget: $250-750, Jobs: Flash, Joomla, PHP)

 

 

© 2007 articlesreader.com - All Rights Reserved