爱情话题互动网站-优快云博客

本文链接：https://blog.youkuaiyun.com/daydaymiddle/article/details/72770197

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    
    }
?>

评论无闪烁刷新