<div class="codebody" id="code70824">
<?PHP
class sqlTools{
private $host="localhost";
private $dbname="test";
private $dbuser="root";
private $dbpwd="";
private $conn;
public function __construct(){
$this->conn=MysqL_connect($this->host,$this->dbuser,$this->dbpwd);
if(!$this->conn){
die("连接数据库失败".MysqL_error());
}
MysqL_select_db($this->dbname,$this->conn) or die("找不到该数据库".MysqL_error());
MysqL_query("set names utf8");
}
public function execute_dml($sql){
$bool=MysqL_query($sql);
if ($bool){
if ($bool>0) {
return 1;
}else{
return 2;
}
}else {
return 0;
}
}
public function execute_dql($sql){
$res=MysqL_query($sql);
return $res;
}
public function close_conn(){
MysqL_close($this->conn);
}
}
?>