php jquery 无刷新评论

浏览： ℃

字体：大中小

发布时间：2013-12-09 23:23:58

来源：

php jquery 无刷新评论

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

php jquery 无刷新评论

演示

XML/HTML Code

<?php

define('INCLUDE_CHECK',1);

require "functions.php";

require "conn.php";

// remove tweets older than 1 hour to prevent spam

mysql_query("DELETE FROM add_delete_record WHERE id>1 AND updatetime<SUBTIME(NOW(),'0 1:0:0')");

//fetch the timeline

$q = mysql_query("SELECT * FROM add_delete_record ORDER BY ID DESC");

$timeline='';

while($row=mysql_fetch_assoc($q))

{

$timeline.=formatTweet($row['text'],$row['updatetime']);

}

// fetch the latest tweet

$lastTweet = '';

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>php jquery 无刷新评论 www.freejs.net</title>

</head>

<body>

<label for="inputField">请留言测试</label>

</form>

<h3 class="timeline">Freejs.net</h3>

</div>

</body>

</html>

functions.php

PHP Code

<?php

if(!defined('INCLUDE_CHECK')) die('You are not allowed to execute this file directly');

function formatTweet($tweet,$updatetime)

{

$tweet=htmlspecialchars(stripslashes($tweet));

$flag = mt_rand(1,9);

return'

<li>

<strong><a href="#">demo</a></strong> '. preg_replace('/((?:http|https|ftp):////(?:[A-Z0-9][A-Z0-9_-]*(?:/.[A-Z0-9][A-Z0-9_-]*)+):?(/d+)?//?[^/s/"/']+)/i','<a href="$1" rel="nofollow" target="blank">$1</a>',$tweet).'

<div class="date">'.strtotime($updatetime).'</div>

</div>

</li>';

}

submit.php

PHP Code

<?php

define('INCLUDE_CHECK',1);

require "functions.php";

require "conn.php";

if(ini_get('magic_quotes_gpc'))

$_POST['inputField']=stripslashes($_POST['inputField']);

$_POST['inputField'] = mysql_real_escape_string(strip_tags($_POST['inputField']),$lr);

if(mb_strlen($_POST['inputField']) < 1 || mb_strlen($_POST['inputField'])>140)

die("0");

mysql_query("INSERT INTO add_delete_record SET text='".$_POST['inputField']."',updatetime=NOW()");

if(mysql_affected_rows($lr)!=1)

die("0");

echo formatTweet($_POST['inputField'],time());

>更多相关文章

首页推荐

东方联盟网培训质量如何?靠谱吗?

　　佛山市东联科技有限公司一直秉承“一切以用户价值为依归

相关文章

24小时热门资讯

24小时回复排行

热门推荐

最新资讯

网络安全

操作系统

黑客防御

站长知识