-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlTool.class.php
67 lines (65 loc) · 2.63 KB
/
sqlTool.class.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<html>
<head>
<meta http-equiv="content-type"content="text/html;charset=utf-8"/>
</head>
<?php
require_once 'paging.class.php';
class SqlTool{
public function dql($sql){
$mysql=new SaeMysql();
$res=$mysql->getData($sql);
if($mysql->errno()!=0){
die("错误:".$mysql->errmsg());
}
$mysql->closeDb();
return $res;
}
public function dml($sql){
$mysql=new SaeMysql();
$mysql->setCharset("utf8");
$mysql->runSql($sql);
if($mysql->errno()!=0){
die("错误:".$mysql->errmsg());
}
$mysql->closeDb();
}
public function dql_paging($sql1,$sql2,$paging){
$mysql=new SaeMysql();
$res1=$mysql->getData($sql2);
$paging->pageCount=ceil($res1[0]["count(id)"]/$paging->pageSize);
$paging->rowCount=$res1[0]["count(id)"];
$paging->rowCount=(int)$paging->rowCount;
$paging->res=$mysql->getData($sql1);
$mysql->closeDb();
if($paging->pageNow>1){
$prePage=$paging->pageNow-1;
$paging->navigate="<a href='{$paging->gotoUrl}?pageNow=$prePage'>上一页</a> ";
}
if($paging->pageNow<$paging->pageCount){
$nextPage=$paging->pageNow+1;
$paging->navigate.="<a href='{$paging->gotoUrl}?pageNow=$nextPage'>下一页</a> ";
}
$page_whole=10;
$start=floor(($paging->pageNow-1)/$page_whole)*$page_whole+1;
$index=$start;
if($paging->pageCount<$page_whole)
{
for(;$start<$index+$paging->pageCount;$start++){
$paging->navigate.="<a href='{$paging->gotoUrl}?pageNow=$start'>[$start]</a>";
}
}
elseif($paging->pageNow>$page_whole){
$index1=$start-($page_whole+1);
$paging->navigate.=" <a href='{$paging->gotoUrl}?pageNow=$index1'> <<</a>  ";
for(;$start<$index+$page_whole;$start++){
if($start>$paging->rowCount)
break;
$paging->navigate.="<a href='{$paging->gotoUrl}?pageNow=$start'>[$start]</a>";
}
if($start<$paging->rowCount)
$paging->navigate.="<a href='{$paging->gotoUrl}?pageNow=$start'>>></a>  ";
}
}
}
?>
</html>