ajax+php+mysql无刷新分页代码

62 function showhint2(str)
63 {
64 ajaxobj=checkajax();
65 document.getelementbyid("msg").innerhtml="正在读取数据……";
66
67 var url = str;
68 ajaxobj.onreadystatechange=statechanged;
69 ajaxobj.open("get",url,true);
70 ajaxobj.send(null);
71 }
72 function showhint3(str)
73 {
74 ajaxobj=checkajax();
75 document.getelementbyid("msg").innerhtml="正在读取数据……";
76
77 var url = str;
78 ajaxobj.onreadystatechange=statechanged;
79 ajaxobj.open("get",url,true);
80 ajaxobj.send(null);
81 }
82 function showhint4(str)
83 {document.getelementbyid("msg").style.display="none";
84 ajaxobj=checkajax();
85 document.getelementbyid("msg").innerhtml="正在读取数据……";
86
87 var url = str;
88 ajaxobj.onreadystatechange=statechanged;
89 ajaxobj.open("get",url,true);
90 ajaxobj.send(null);
91 }
92
93
94 function statechanged()
95 {
96 if (xmlhttp.readystate==4)
97 {
98 document.getelementbyid("message").innerhtml=xmlhttp.responsetext;
99 }
100 }
101
102
103
104

2 $link = mysql_connect('localhost', 'root', '') or die(mysql_error());
3 mysql_select_db('vote', $link) or die(mysql_error());
4 mysql_query("set names utf8");
5 $num = 3;
6 $url = "page.php";
7 $con = "

";
8 $page = (isset($_request['page'])) ? $_request['page'] : 1;
9 $offset = ($page - 1) * $num;
10 $result = mysql_query("select count(*) from client");
11 $total = mysql_fetch_row($result);
12 $total = $total[0];
13 $pagenum = ceil($total / $num);
14 $page = min($pagenum, $page); //获得首页
15 $prepg = $page - 1; //上一页
16 if ($prepg 17 $prepg = 1;
18 $nextpg = ($page == $pagenum ? 1 : $page + 1); //下一页
19 //如果只有一页则跳出函数：
20 if ($pagenum 21 return false;
22
23 $sql = "select `name`,`content` from `client` limit " . $offset . "," . $num;
24 $res = mysql_query($sql);
25 while ($content = mysql_fetch_row($res)) {
26 $con .= "
• $content[0]: $content[1]
";
27 }
28 $con .= "

|||