SqlHelper.class.php
<?php
Class SqlHelper{
public $conn;
public $reslt;
private $ip="localhost";
private $name="root";
private $password="root";
private $dbName="datebase02";
public function getConnect(){
$this->conn=mysql_connect($this->ip,$this->name,$this->password);
if(!$this->conn){
echo "mysql连接失败,请检查数据库连接信息是否正确!".mysql_error();
exit();
}
if(!mysql_select_db($this->dbName,$this->conn)){
echo "mysql 指定数据库失败,请检查数据库是否存在!";
exit();
}
if(!mysql_set_charset("utf8",$this->conn)){
echo "指定字符集失败,程序退出!";
}
}
//执行dql操作,返回一个结果集
public function dql($sql){
$this->reslt=mysql_query($sql,$this->conn);
if(!$this->reslt){
echo "执行sql语句失败".$sql;
exit();
}
return $this->reslt;
}
//执行dql操作,返回一个数组
public function dqlArray($sql){
$array=Array();
$this->reslt=mysql_query($sql,$this->conn);
if(!$this->reslt){
echo "执行sql语句失败".sql;
exit();
}
$i=0;
while($row=mysql_fetch_assoc($this->reslt)){
$i++;
$array[$i]=$row;
}
mysql_free_result($this->reslt);
return $array;
}
//执行dql操作,用于分页
public function dqlPage($sql1,$sql2,$paging){
$array=Array();
$this->reslt=mysql_query($sql1,$this->conn);
if(!$this->reslt){
echo "执行sql语句失败".$sql1;
exit();
}
while($row=mysql_fetch_assoc($this->reslt)){
$array[]=$row;
}
mysql_free_result($this->reslt);
$paging->setRow_array($array);
$this->reslt=mysql_query($sql2,$this->conn);
if(!$this->reslt){
echo "执行sql语句失败".$sql2;
exit();
}
while ($row=mysql_fetch_row($this->reslt)){
$paging->setPageCount(ceil($row[0]/$paging->getPageSize()));
$paging->setRow_count($row[0]);
}
mysql_free_result($this->reslt);
//进行判断能否切换上一页
if($paging->getPageCurrent()>1){
$paging->setNavigation("<a href='PageUIController.php?pageCurrent=".($paging->getPageCurrent()-1)."'>上一页</a> ");
}else{
$paging->setNavigation("<a href='PageUIController.php?pageCurrent=".($paging->getPageCurrent())."'>上一页</a> ");
}
//进行判断能否切换下一页
if($paging->getPageCurrent()<$paging->getPageCount()){
$paging->setNavigation($paging->getNavigation()."<a href='PageUIController.php?pageCurrent=".($paging->getPageCurrent()+1)."'>下一页</a> ");
}else{
$paging->setNavigation($paging->getNavigation()."<a href='PageUIController.php?pageCurrent=".($paging->getPageCurrent())."'>下一页</a> ");
}
$paging->setNavigation($paging->getNavigation()."当前页[".$paging->getPageCurrent()."]/共有[".$paging->getPageCount()."]页");
}
//执行dml操作
public function dml($sql){
$this->reslt=mysql_query($sql,$this->conn);
if(!$this->reslt){
return 0; //执行失败
}
if(mysql_num_rows($this->reslt)>0){
return 1; //执行成功
}else{
return 2; //没有受影响行数
}
}
//关闭数据库
public function close(){
mysql_close($this->conn);
}
}
分页实体类
paging.class.php
<?php
Class Paging{
private $pageSize; //每一页所显示的行数
private $pageCurrent; //当前页
private $row_array; //分页所显示的内容数组
private $row_count; //总共有多少条记录
private $pageCount; //可以分多少行
private $navigation; //导航条
/**
* @return the $navigation
*/
public function getNavigation() {
return $this->navigation;
}
/**
* @param field_type $navigation
*/
public function setNavigation($navigation) {
$this->navigation = $navigation;
}
/**
* @return the $pageSize
*/
public function getPageSize() {
return $this->pageSize;
}
/**
* @return the $pageCurrent
*/
public function getPageCurrent() {
return $this->pageCurrent;
}
/**
* @return the $row_array
*/
public function getRow_array() {
return $this->row_array;
}
/**
* @return the $row_count
*/
public function getRow_count() {
return $this->row_count;
}
/**
* @return the $pageCount
*/
public function getPageCount() {
return $this->pageCount;
}
/**
* @param field_type $pageSize
*/
public function setPageSize($pageSize) {
$this->pageSize = $pageSize;
}
/**
* @param field_type $pageCurrent
*/
public function setPageCurrent($pageCurrent) {
$this->pageCurrent = $pageCurrent;
}
/**
* @param field_type $row_array
*/
public function setRow_array($row_array) {
$this->row_array = $row_array;
}
/**
* @param field_type $row_count
*/
public function setRow_count($row_count) {
$this->row_count = $row_count;
}
/**
* @param field_type $pageCount
*/
public function setPageCount($pageCount) {
$this->pageCount = $pageCount;
}
}