导读:<?php/** * @author Dzx * */class Sqlhelper{ var $dbname = "dzxphp"; var $host = "localhost"; var $username ...
<?php
/**
* @author Dzx
*
*/
class Sqlhelper
{
var $dbname = "dzxphp";
var $host = "localhost";
var $username = "root";
var $userpass = "123456";
var $conn;
function __construct ()
{
$this->conn = mysql_connect($this->host,
$this->username, $this->userpass);
if (! $this->conn) {
die(
"数据库连接失败" . mysql_error());
}
mysql_query("set names utf8");
mysql_query("use $this->dbname",
$this->conn) or die("选择数据出错");
}
//提供查询语句
function execute_dql ($sql)
{
$res = mysql_query($sql) or die(
"SQL查询语句有误");
$rs = mysql_fetch_assoc($res);
return $rs;
}
function execute_dql2 ($sql)
{
$res = mysql_query($sql) or die(
"SQL查询语句有误");
$rs_arr = array();
while ($rs = mysql_fetch_assoc($res)) {
$rs_arr[] = $rs;
}
//可以立马释放资源
mysql_free_result($res);
$this->my_close();
return $rs_arr; //返回一个数组
}
//添加,删除,修改
function execute_dml ($sql)
{
$res = mysql_query($sql) or die(
"dml语句有误");
if ($res) {
$rows = mysql_affected_rows(
$this->conn);
if ($rows > 0) {
return "ok";
} else {
return "no";
}
} else {
return "nono";
}
}
//分页的查询调用
//因为分页功能是一个通用的功能.所有也一个函数来处理
function execute_dql_page($sqls,$fenyepage){
//执行SQL语句,查出有多少条记录
$fenyepage->rowcount = mysql_num_rows ( mysql_query ( $sqls[0] ) );
//echo $fenyepage->rowcount; exit();
//执行SQL语句,查出要查看的记录
$fenyepage->res=$this->execute_dql2($sqls[1]);
}
//关掉连接
function my_close ()
{
if (! empty($this->conn)) {
mysql_close(
$this->conn);
}
}
}