PHP代码:php+jquery实现无刷新留言板 ajax运用.doc
文本预览下载声明
PHP代码:php+jquery实现无刷新留言板 ajax运用
meta charset=’utf-8′
titleajax无刷新留言板-制作/title
script src=”/ajax/libs/jquery/1.4/jquery.min.js” type=”text/javascript”//script
script type=”text/javascript”
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=”+$(“input[name=user]“).val()+”pwd=”+$(“input[name=pwd]“).val(),
success: function(msg){
$(“input[name=user]“).val(“”);
$(“input[name=pwd]“).val(“”);
//向每个匹配的元素内部前置内容。
//这是向所有匹配元素内部的开始处插入内容的最佳方式。
$(‘#post_result’).prepend(msg);
}
});
});
})
/script
p align=center–a href=”” target=_blank/a/p
div id=post_result
/div
div id=post
用户名:input type=text name=user value=”br
密码:input type=password name=pwd value=”br
input type=button name=tj id=tj value=”提交”br
/div
———————————————————————-
留言数据处理页面: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 (‘Can\’t use test : ‘ . mysql_error());
mysql_query(“SET NAMES ‘utf8′”);
mysql_query(“SET CHARACTER_SET_CLIENT=utf8″);
mysql_query(“SET CHARACTER_SET_RESULTS=utf8″);
if($_REQUEST[user]){//提交数据
$user=$_REQUEST[user];
$pwd=$_REQUEST[pwd];
$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_arr[page_content].=’id:’.$arr[id].’bruser:’.$arr[user].’brhr’;
}
echo $ajax_arr[page_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($p
显示全部