欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

php jquery 无刷新评论

程序员文章站 2022-04-29 18:06:22
php jquery 无刷新评论 刷新后删除一个小时前的记录 php jquery 无刷新评论 演示    xml/html code &nbs...
php jquery 无刷新评论

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

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" "https://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">  

<html xmlns="https://www.w3.org/1999/xhtml">  

<head>  

<meta http-equiv="content-type" content="text/html; charset=utf-8" />  

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

  

<link rel="stylesheet" type="text/css" href="demo.css" />  

<script type="text/javascript" src="../../js/jquery-1.9.1.min.js"></script>  

<script type="text/javascript" src="script.js"></script>  

  

  

</head>  

  

<body>  

  

<p id="twitter-container">  

<form id="tweetform" action="submit.php" method="post">  

  

<span class="counter">140</span>  

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

  

<textarea name="inputfield" id="inputfield" tabindex="1" rows="2" cols="40"></textarea>  

<input class="submitbutton inact" name="submit" type="submit" value="提交" disabled="disabled" />  

  

  

<p class="clear"></p>  

  

</form>  

  

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

  

<ul class="statuses"><?php echo $timeline?></ul>  

  

  

</p>  

  

</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> 

    <a href="#"><img class="avatar" src="img/lito_s-ido_0'.$flag.'.png" width="48" height="48" /></a> 

    <p class="tweettxt"> 

    <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).' 

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

    </p> 

    <p class="clear"></p> 

    </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());  

  

?>