当前位置:Gxlcms > PHP教程 > phpjquery无刷新评说

phpjquery无刷新评说

时间:2021-07-01 10:21:17 帮助过:3人阅读

php jquery 无刷新评论

php jquery 无刷新评论

刷新后删除一个小时前的记录

?

php jquery 无刷新评论

演示

?

?XML/HTML Code

?

  1. php??
  2. ??
  3. define('INCLUDE_CHECK',1);??
  4. require?"functions.php";??
  5. require?"conn.php";??
  6. ??
  7. ??
  8. //?remove?tweets?older?than?1?hour?to?prevent?spam??
  9. mysql_query("DELETE?FROM?add_delete_record?WHERE?id>1?AND?updatetime<SUBTIME(NOW(),'0?1:0:0')");??
  10. ??????
  11. //fetch?the?timeline??
  12. $q?=?mysql_query("SELECT?*?FROM?add_delete_record?ORDER?BY?ID?DESC");??
  13. ??
  14. $timeline='';??
  15. while($row=mysql_fetch_assoc($q))??
  16. {??
  17. ????$timeline.=formatTweet($row['text'],$row['updatetime']);??
  18. }??
  19. ??
  20. //?fetch?the?latest?tweet??
  21. $lastTweet?=?'';??
  22. ??
  23. ?>??
  24. ??
  25. >??
  26. <html?xmlns="http://www.w3.org/1999/xhtml">??
  27. <head>??
  28. <meta?http-equiv="Content-Type"?content="text/html;?charset=utf-8"?/>??
  29. <title>php?jquery?无刷新评论?www.freejs.nettitle>??
  30. ??
  31. <link?rel="stylesheet"?type="text/css"?href="demo.css"?/>??
  32. <script?type="text/javascript"?src="../../js/jquery-1.9.1.min.js">script>??
  33. <script?type="text/javascript"?src="script.js">script>??
  34. ??
  35. ??
  36. head>??
  37. ??
  38. <body>??
  39. ??
  40. <div?id="twitter-container">??
  41. <form?id="tweetForm"?action="submit.php"?method="post">??
  42. ??
  43. <span?class="counter">140span>??
  44. <label?for="inputField">请留言测试label>??
  45. ??
  46. <textarea?name="inputField"?id="inputField"?tabindex="1"?rows="2"?cols="40">textarea>??
  47. <input?class="submitButton?inact"?name="submit"?type="submit"?value="提交"?disabled="disabled"?/>??
  48. ??
  49. ??
  50. <div?class="clear">div>??
  51. ??
  52. form>??
  53. ??
  54. <h3?class="timeline">Freejs.neth3>??
  55. ??
  56. <ul?class="statuses">php?echo?$timeline?>ul>??
  57. ??
  58. ??
  59. div>??
  60. ??
  61. body>??
  62. html>??

?functions.php

?

PHP Code

  1. ??
  2. if(!defined('INCLUDE_CHECK'))?die('You?are?not?allowed?to?execute?this?file?directly');??
  3. ??
  4. function?formatTweet($tweet,$updatetime)??
  5. {??
  6. ??
  7. ??
  8. ????$tweet=htmlspecialchars(stripslashes($tweet));??
  9. ????$flag?=?mt_rand(1,9);??
  10. ??
  11. ????return'?
  12. ????
  13. ?
  14. ????.$flag.'.png"?width="48"?height="48"?/>?
  15. ?????
  16. ????demo?'.?preg_replace('/((?:http|https|ftp):\/\/(?:[A-Z0-9][A-Z0-9_-]*(?:\.[A-Z0-9][A-Z0-9_-]*)+):?(\d+)?\/?[^\s\"\']+)/i','$1',$tweet).'?
  17. ????'.strtotime($updatetime).'?
  18. ?????
  19. ?????
  20. ????
  21. ';??
  22. ??
  23. }??
  24. ??
  25. ?>??

submit.php

PHP Code

  1. ??
  2. define('INCLUDE_CHECK',1);??
  3. require?"functions.php";??
  4. require?"conn.php";??
  5. ??
  6. ??
  7. if(ini_get('magic_quotes_gpc'))??
  8. $_POST['inputField']=stripslashes($_POST['inputField']);??
  9. ??
  10. ??
  11. ??
  12. $_POST['inputField']?=?mysql_real_escape_string(strip_tags($_POST['inputField']),$lr);??
  13. ??
  14. if(mb_strlen($_POST['inputField'])?$_POST['inputField'])>140)??
  15. die("0");??
  16. ??
  17. mysql_query("INSERT?INTO?add_delete_record?SET?text='".$_POST['inputField']."',updatetime=NOW()");??
  18. ??
  19. if(mysql_affected_rows($lr)!=1)??
  20. die("0");??
  21. ??
  22. echo?formatTweet($_POST['inputField'],time());??
  23. ??
  24. ?>??
  25. ?


原文地址:http://www.freejs.net/article_biaodan_88.html

人气教程排行