Shutbox jquery refreshing comments

The database in this example is very simple and you will understand it at a glance.

Demo

XML/HTML Code

3. • Shoutbox
6. Latest Messages
8. • • Shoutbox. php

       PHP Code
       2. /************************
       3. CONSTANTS
       4. /************************/
       5. Define ("HOST", "localhost ");
       6. Define ("USER", "root ");
       7. Define ("PASSWORD ","");
       8. Define ("DB ","");
       10. /************************
       11. FUNCTIONS
       12. /************************/
       13. Function connect ($ db, $ user, $ password ){
       14. $ Link = @ mysql_connect ($ db, $ user, $ password );
       15. Mysql_query ("set names utf8 ;");
       16. If (! $ Link)
       17. Die ("cocould not connect:". mysql_error ());
       18. Else {
       19. $ Db = mysql_select_db (DB );
       21. If (! $ Db)
       22. Die ("cocould not select database:". mysql_error ());
       23. Else return $ link;
       24. }
       25. }
       26. Function getContent ($ link, $ num ){
       27. $ Res = @ mysql_query ("SELECT * FROM content order by updatetime desc limit". $ num, $ link );
       28. If (! $ Res)
       29. Die ("Error:". mysql_error ());
       30. Else
       31. Return $ res;
       32. }
       33. Function insertMessage ($ user, $ message ){
       34. $ Updatetime = date ("Y-m-d H: I: s", time ());
       35. $ Query = sprintf ("insert into content (name, message, updatetime) VALUES ('% s',' % s', '$ updatetime ');", mysql_real_escape_string (strip_tags ($ user), mysql_real_escape_string (strip_tags ($ message )));
       36. $ Res = @ mysql_query ($ query );
       37. If (! $ Res)
       38. Die ("Error:". mysql_error ());
       39. Else
       40. Return $ res;
       41. }
       43. /******************************
       44. MANAGE REQUESTS
       45. /******************************/
       46. If (! $ _ POST ['action']) {
       47. // We are redirecting people to our shoutbox page if they try to enter in our shoutbox. php
       48. Header ("Location: index.html ");
       49. }
       50. Else {
       51. $ Link = connect (HOST, USER, PASSWORD );
       52. Switch ($ _ POST ['action']) {
       53. Case "update ":
       54. $ Res = getContent ($ link, 20 );
       55. While ($ row = mysql_fetch_array ($ res )){
       56. $ Result. ="
       57. ". $ Row ['name']."". $ Row ['message'].". $ row ['updatetime']."
       ";
       58. }
       59. Echo $ result;
       60. Break;
       61. Case "insert ":
       63. Echo insertMessage ($ _ POST ['Nick '], $ _ POST ['message']);
       64. Break;
       65. }
       66. Mysql_close ($ link );
       67. }
       70. ?>
           Address: http://www.freejs.net/article_biaodan_125.html