mysql ajax分页_ajax实现无刷新分页(php)

直接给出源代码，可自行分析，写的不好请留言指正，谢谢！

投票结果

function GetXmlHttpObject()

{

var xmlHttp=null;

try

{

// Firefox, Opera 8.0+, Safari

xmlHttp=new XMLHttpRequest();

}

catch (e)

{

// Internet Explorer

try

{

xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");

}

catch (e)

{

xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

}

}

return xmlHttp;

}

function checkajax(){

xmlHttp=GetXmlHttpObject()

if (xmlHttp==null)

{

alert ("您的浏览器不支持AJAX！");

return ;

}else

{

return xmlHttp;

}

}

function preshow(){

ajaxobj = checkajax();

var url = "page.php?page=1";

ajaxobj.onreadystatechange=stateChanged;

ajaxobj.open("GET",url,true);

ajaxobj.send(null);

}

function showHint1(str)

{

ajaxobj = checkajax();

document.getElementById("msg").innerHTML="正在读取数据……";

var url = str;

ajaxobj.onreadystatechange=stateChanged;

ajaxobj.open("GET",url,true);

ajaxobj.send(null);

}

function showHint2(str)

{

ajaxobj=checkajax();

document.getElementById("msg").innerHTML="正在读取数据……";

var url = str;

ajaxobj.onreadystatechange=stateChanged;

ajaxobj.open("GET",url,true);

ajaxobj.send(null);

}

function showHint3(str)

{

ajaxobj=checkajax();

document.getElementById("msg").innerHTML="正在读取数据……";

var url = str;

ajaxobj.onreadystatechange=stateChanged;

ajaxobj.open("GET",url,true);

ajaxobj.send(null);

}

function showHint4(str)

{document.getElementById("msg").style.display="none";

ajaxobj=checkajax();

document.getElementById("msg").innerHTML="正在读取数据……";

var url = str;

ajaxobj.onreadystatechange=stateChanged;

ajaxobj.open("GET",url,true);

ajaxobj.send(null);

}

function stateChanged()

{

if (xmlHttp.readyState==4)

{

document.getElementById("message").innerHTML=xmlHttp.responseText;

}

}

用户留言如下：

$link = mysql_connect('localhost', 'root', '') or die(mysql_error());

mysql_select_db('vote', $link) or die(mysql_error());

mysql_query("set names utf8");

$num = 3;

$url = "page.php";

$con = "

• ";

$page = (isset($_REQUEST['page'])) ? $_REQUEST['page'] : 1;

$offset = ($page - 1) * $num;

$result = mysql_query("SELECT COUNT(*) FROM client");

$total = mysql_fetch_row($result);

$total = $total[0];

$pagenum = ceil($total / $num);

$page = min($pagenum, $page); //获得首页

$prepg = $page - 1; //上一页

if ($prepg <= 1)

$prepg = 1;

$nextpg = ($page == $pagenum ? 1 : $page + 1); //下一页

//如果只有一页则跳出函数：

if ($pagenum <= 1)

return false;

$sql = "SELECT `name`,`content` FROM `client` LIMIT " . $offset . "," . $num;

$res = mysql_query($sql);

while ($content = mysql_fetch_row($res)) {

$con .= "

$content[0]:  $content[1]";

}

$con .= "

";

$con .= <<< PAGE

首页|上一页|下一页|尾页

PAGE;

echo $con;

?>