<?php
//工具类
class sqlhelper{
public $conn;
public $host='localhost';
public $user='root';
public $pw='';
public $db='admin';
//构造函数
function __construct(){
$this->conn=new mysqli($this->host, $this->user, $this->pw, $this->db);
if(mysqli_connect_errno()){
die("can not connect".mysqli_connect_error());
}
}
//DQL语句执行方法
public function dql($sql){
$arr=array();
$res=$this->conn->query($sql) or die("执行DQL失败".mysqli_errno());
$i=0;
while ($rows=$res->fetch_assoc()){
$arr[$i++]=$rows;
}
$res->free_result();
return $arr;
}
//DML语句执行方法
public function dql1($sql){
$res=$this->conn->query($sql) or die("执行DML失败".mysqli_errno()); 错误在这,它说我没给参数?
return $res;
}
//关闭连接
public function resfree() {
$this->conn->close();
}
这个是工具类全文: <?php
//工具类
class sqlhelper{
public $conn;
public $host='localhost';
public $user='root';
public $pw='';
public $db='admin';
//构造函数
function __construct(){
$this->conn=new mysqli($this->host, $this->user, $this->pw, $this->db);
if(mysqli_connect_errno()){
die("can not connect".mysqli_connect_error());
}
}
//DQL语句执行方法
public function dql($sql){
$arr=array();
$res=$this->conn->query($sql) or die("执行DQL失败".mysqli_errno());
$i=0;
while ($rows=$res->fetch_assoc()){
$arr[$i++]=$rows;
}
$res->free_result();
return $arr;
}
//DML语句执行方法
public function dql1($sql){
$res=$this->conn->query($sql) or die("执行DML失败".mysqli_errno());
return $res;
}
//关闭连接
public function resfree() {
$this->conn->close();
}
}
?>