php+ajax实现无刷新的新闻留言系统(附源码)_PHP教程

 //数据库配置信息(用户名,密码，数据库名，表前缀等)

 $cfg_dbhost = "localhost";

 $cfg_dbuser = "root";

 $cfg_dbpwd = "root";

 $cfg_dbname = "ajaxdemo1";

 $cfg_dbprefix = "";

 $link = mysql_connect($cfg_dbhost,$cfg_dbuser,$cfg_dbpwd);

 mysql_select_db($cfg_dbname);

 mysql_query("set names utf8");

?>

 header("Content-type:text/html;charset=utf-8");

 include "config.php";

 //post接收数据,只是演示效果,这里就省去验证了

 $name = $_POST['name'];

 $content = $_POST['content'];

 $sql = "insert into test (name,content) values ('{$name}','{$content}');";

 $res = mysql_query($sql,$link);

 if($res){

  echo '{"name": "'.$name.'","content": "'.$content.'","status": "1"}';

 }

?>

body{color:#555;font-size:14px;padding:0;margin:0;}

#form { background:#dedede; padding:10px 20px; width:300px;}

#show{ background:#f6f6f6;padding:10px 20px; width:300px;}

#show p{ margin:6px; font-size:13px; line-height:22px; border-bottom:1px dashed #cdcdcd;}

$(function(){

 $("#sub").click(function(){

  //只是说明原理,然后这里省去了验证文本框内容的步骤，直接发送ajax请求

  $.post("deal.php",{name : $("#name").val(), content : $("#content").val()}, function(data){

    if(data.status){

     var str = "

"+data.name+" 发表了："+data.content+"

     $("#show").prepend(str);  //在前面追加

    }else{

     alert("评论失败");

    }

   }, 'json'); 

 });    

});

DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;