PHP代码：php+jquery实现无刷新留言板 ajax运用.doc

PHP代码：php+jquery实现无刷新留言板 ajax运用ajax无刷新留言板-制作jQuery(function() $.ajax( type: “POST”, url: “ajax.php”, success: function(msg) $(#post_result).html(msg); );)jQuery(function() $(“#tj”).click(function() $.ajax( type: “POST”, url: “ajax.php”, data: “user=”+$(“inputname=user“).val()+”&pwd=”+$(“inputname=pwd“).val(), success: function(msg) $(“inputname=user“).val(“”); $(“inputname=pwd“).val(“”); /向每个匹配的元素内部前置内容。 /这是向所有匹配元素内部的开始处插入内容的最佳方式。 $(#post_result).prepend(msg); ); );)用户名：密码：-留言数据处理页面：ajax.php-?php$host=”localhost”;$user=”root”;$pwd=”root”;$dbname=”test”;$link = mysql_connect($host, $user, $pwd)or die(“Could not connect: ” . mysql_error();mysql_select_db($dbname, $link) or die (Cant use test : . mysql_error();mysql_query(“SET NAMES utf8”);mysql_query(“SET CHARACTER_SET_CLIENT=utf8);mysql_query(“SET CHARACTER_SET_RESULTS=utf8);if($_REQUESTuser)/提交数据$user=$_REQUESTuser;$pwd=$_REQUESTpwd;$sql_insert=”INSERT INTO test.user (id ,user ,pwd)VALUES (NULL , $user, $pwd);”;mysql_query($sql_insert);if($id=mysql_insert_id()$sql_page=”select * from user where id= $id”;$page_res=mysql_query($sql_page);while ($arr=mysql_fetch_array($page_res) $ajax_arrpage_content.=id:.$arrid.user:.$arruser.;echo $ajax_arrpage_content;else echo mysql_error();else/载入页面时读取数据$sql_page=”select * from user order by id desc”;$page_res=mysql_query($sql_page);while ($arr=mysql_fetch_array($page_res) $ajax_arrpage_content.=id:.$arrid.user:.$arruser.;echo $ajax_arrpage_content;?测试数据sql语句： phpMyAdmin SQL Dump version 主机: localhost 生成日期: 2002 年 01 月 01 日 16:50 服务器版本: 5.5.9 PHP 版本: 5.3.5SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;/*!40101 SET OLD_CHARACTER_SET_CLIENT=CHARACTER_SET_CLIENT */;/*!40101 SET OLD_CHARACTER_SET_RESULTS=CHARACTER_SET_RESULTS */;/*!40101 SET OLD_COLLATION_CONNECTION=COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */; 数据库: test 表的结构 userCREATE TABLE IF NOT EXISTS user ( id int(10) unsigned NOT NULL AUTO_INCREMENT, user varchar(6) NOT NULL, pwd varchar(30) NOT NULL, PRIMARY KEY (id) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; 转存表中的数据 userINSERT INTO us