评论无闪烁刷新

来源：互联网发布：pc安全软件编辑：程序博客网时间：2024/05/16 08:15

index.php的内容<?php//连接数据库header('content-type:text/html;charset=utf-8;');$mysqli=new mysqli('qilinflybaba.gotoftp1.com','qilinflybaba','xxx','qilinflybaba');if($mysqli->connect_error){    die('php连接数据库失败'.$mysqli->connect_error);}else{    echo '<marquee><h1>本期话题:<b style="color:#36F">你还相信爱情吗？</b></h1></marquee>';    $mysqli->query('set names utf8');}$sql='select * from marry';$result=$mysqli->query($sql);?><!DOCTYPE html><html><head><meta charset="utf-8" /><title></title><script type="text/javascript" src="http://libs.baidu.com/jquery/1.9.1/jquery.js"></script></head><style></style><body><h1>来评论吧！</h1><ul id="ajaxshow"><?php    while($row=$result->fetch_assoc()){        ?>        <li><?=$row['name']?>:<?=$row['message']?><?=date('Y-m-d H:i:s',$row['stime'])?></li>    <?php        }?></ul><br><br><br><br><form>    名称<input type="text" id="name"><br><br>    吐槽<textarea id="message"></textarea>    <input type="button" value="提交" id="btn"></form><script>    $(function(){        $('#btn').click(function(){            var name=$("#name").val();            var message=$("#message").val();            $.post('chuli.php',{'name':name,'message':message},function(data){                $("#ajaxshow").html(data);             })              return false;        })      })</script></body></html>

chuli.php内容

<?php//连接数据库header('content-type:text/html;charset=utf-8;');$mysqli=new mysqli('qilinflybaba.gotoftp1.com','qilinflybaba','xxx','qilinflybaba');if($mysqli->connect_error){    die('php连接数据库失败'.$mysqli->connect_error);}else{    $mysqli->query('set names utf8');}$name=$_POST['name'];$message=$_POST['message'];$stime=time();$sql="INSERT INTO marry(name,message,stime) VALUES('$name','$message',$stime)";$mysqli->query($sql);$sql='select * from marry';$result=$mysqli->query($sql);?><?php    while($row=$result->fetch_assoc()){        ?>        <li><span style="color:#39F;padding-right:1rem;"><?=$row['name']?>:</span><?=$row['message']?><span style="color:#ccc;padding-left:1rem;"><?=date('Y-m-d H:i:s',$row['stime'])?></span></li>    <?php        }?>

阅读全文

1 0