MySQL数据库封装和分页查询

1.数据库封装

<?php

//我用的数据库名是housedb

class DBDA

{public $host="localhost";
public $uid="root";
public $pwd="root";
public $dbname="housedb";

public function Query($sql,$type=1)
{
$db=new mysqli($this->host,$this->uid,$this->pwd,$this->dbname);

$result=$db->query($sql);
if($type=="1")
{
return $result->fetch_all();
}
elsle
{
return $result;
}
}

}

?>

 

---

 

 

2.分页查询

<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>地区代号</td>
<td>地区名称</td>
<td>父级代号</td>
</tr>

<?php
include("DBDA.class.php");
$db = new DBDA(); //调用封装的数据库
include("page.class.php");

//查总条数
$sz = "select count(*) from chinastates";
$az = $db->Query($sz);

//1.造对象
$page = new Page($az[0][0],10);

//2.将分页类的limit变量拼接在SQL语句后面
$sql = "select * from chinastates ".$page->limit;

$arr = $db->Query($sql);

foreach($arr as $v)
{
echo "<tr>
<td>{$v[0]}</td>
<td>{$v[1]}</td>
<td>{$v[2]}</td>
</tr>";
}
?>

</table>

<?php

//3.输出分页信息
echo $page->fpage(); //括号（）里面可以根据需要显示的内容加入0,1,2,3,4,5,6,7 需要显示什么可以从引用的工具表中查找