【www.gdgbn.com--mysql教程】
代码如下2
3
4
5
6
7 <script type="text/网页特效">
8
9 function getxmlhttpobject()
10 {
11 var xmlhttp=null;
12 try
13 {
14 // firefox, opera 8.0+, safari
15 xmlhttp=new xmlhttprequest();
16 }
17 catch (e)
18 {
19 // internet explorer
20 try
21 {
22 xmlhttp=new activexobject("msxml2.xmlhttp");
23 }
24 catch (e)
25 {
26 xmlhttp=new activexobject("microsoft.xmlhttp");
27 }
28 }
29 return xmlhttp;
30 }
31 function checkajax(){
32 xmlhttp=getxmlhttpobject()
33
34 if (xmlhttp==null)
35 {
36 alert ("您的浏览器不支持ajax!");
37 return ;
38 }else
39 {
40 return xmlhttp;
41 }
42 }
43 function preshow(){
44 ajaxobj = checkajax();
45 var url = "page.php?page=1";
46 ajaxobj.onreadystatechange=statechanged;
47 ajaxobj.open("get",url,true);
48 ajaxobj.send(null);
49 }
50 function showhint1(str)
51 {
52 ajaxobj = checkajax();
53 document.getelementbyid("msg").innerhtml="正在读取数据……";
54
55 var url = str;
56 ajaxobj.onreadystatechange=statechanged;
57 ajaxobj.open("get",url,true);
58 ajaxobj.send(null);
59
60 }
61
代码如下
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 </script>
102
103
104
105
106
用户留言如下:
107
108
109
110
111
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 <= 1)
17 $prepg = 1;
18 $nextpg = ($page == $pagenum ? 1 : $page + 1); //下一页
19 //如果只有一页则跳出函数:
20 if ($pagenum <= 1)
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 .= "";
29 $con .= <<< page
30
首页|上一页|下一页|尾页
31
32 page;
33
34 echo $con;
35 ?>