mysqli扩展库通用数据库查询更新方…

<?php

//mysqli扩展库的通用方法

class  sqliTool{

private $mysqli;

private $host="localhost";

private $name="root";

private $passwd="123456";

private $db="worddb";

function sqliTool(){

$this->mysqli=new mysqli($this->host,$this->name,$this->passwd,$this->db);

if($this->mysqli->connect_error){

die("连接失败".$this->mysqli->connect_error);

}

}

//查询方法

function sqli_dql($sql){

$res=$this->mysqli->query($sql);

if(!$res){

die("查询过程出错".$this->mysqli->error);

}

return $res;

}

//更新和删除方法

function sqli_dml($sql){

echo "$sql";

$res=$this->mysqli->query($sql);

if(!$res){

echo "更新/删除失败";

return 0;

}

else{

if($this->mysqli->affected_rows>0){

echo "执行成功";

return 1;

}

else{

echo "没有受影响的行数";

return 2;//没有受影响的行

}

}

$this->mysqli->close();

}

}

?>

测试方法

<?php

require_once 'sqliTool.class.php';

$sqliTool=new sqliTool();

$sql="insert into words(enword,chword) values('baohanqing','包汉青')";

$res=$sqliTool->sqli_dml("$sql");

$sql2="select * from words";

$res2=$sqliTool->sqli_dql($sql2);

echo "<br/>";

while ($row=$res2->fetch_row()){

foreach ($row as $key=>$val){

echo "--$val";

}

echo "<br/>";

}

$res2->free;

?>