<?php
class sqlHelper
{
private $conn;
private $db = "test";
private $host = "127.0.0.1";
private $user = "root";
private $password = "";
function __construct()
{
$this->conn = @mysql_connect($this->host,$this->user,$this->password) or die(mysql_error);
mysql_select_db($this->db);
mysql_query("set names utf8") or die(mysql_error);
}
function execute_dml($sql)
{
$b = mysql_query($sql);
if(!$b)
{
return 0;
}
else if(mysql_affected_rows()>0)
{
return 1;
}
else
{
return 2;
}
}
function execute_dql($sql)
{
$res = mysql_query($sql) or die(mysql_error());
$arr = array();
$i = 0;
while($row = mysql_fetch_assoc($res))
{
$arr[$i++] = $row;
}
mysql_free_result($res);
return $arr;
}
function execute_dql_fenye($sqls,$fenye)
{
$res1 = $this->execute_dql($sqls[0]);
$res2 = $this->execute_dql($sqls[1]);
if($res1)
{
$fenye->rowCount = $res1[0]["count(id)"];
}
else
{
echo "没获取到rowCount";
}
if(empty($res2))
{
echo "内容为空";
}
$fenye->content = $res2;
$fenye->pageCount = ceil($fenye->rowCount/$fenye->pageSize);
echo "pageCount:".$fenye->pageCount;
$nav = "";
$start = floor(($fenye->pageNow-1)/10)*10+1;
$index = $start;
$pre = $fenye->pageNow-1;
$next = $fenye->pageNow+1;
if($fenye->pageNow-10>=1)
{
$p = $start-1;
$nav.="<a href='$fenye->gotoUrl?pageNow=$p'><<<</a>";
}
if($pre>=1)
{
$nav.="<a href='$fenye->gotoUrl?pageNow=$pre'>上一页</a>";
}
for($i=$start;$i<=$fenye->pageCount&&$i<$index+10;$i++)
{
$nav.="<a href='$fenye->gotoUrl?pageNow=$i'><$i></a>";
}
if($next<=$fenye->pageCount)
{
$nav.="<a href='$fenye->gotoUrl?pageNow=$next'>下一页</a>";
}
if($fenye->pageNow+10<=$fenye->rowCount)
{
$nav.="<a href='$fenye->gotoUrl?pageNow=$i'>>>></a>";
}
$fenye->navigator = $nav;
}
function my_close()
{
if(!empty($this->conn))
mysql_close($this->conn);
}
}
?>