mysql数据库链接操作类_php+mysql数据库连接操作类

class sql {

public $nums;

public $sql;

public $id;

public $mysqli;

public $conn;

function __construct(){

$this->mysqli=mysqli_connect("127.0.0.1","root","root");

mysqli_query($this->mysqli, "set names utf8");

mysqli_select_db($this->mysqli, "dbname");

}

function __destruct(){

$this->mysqli->close();

}

public function cont($cd){

$this->mysqli->close();

$this->mysqli=mysqli_connect("localhost",'root',"root");

mysqli_query($this->mysqli, "set names utf8");

mysqli_select_db($this->mysqli,$cd);

}

public function sel($db,$where,$data='*'){

$sql='select '.$data.' from '.$db.' '.$where;

$this->sql=$sql;

return $this->select($sql);

}

public function select($sql){

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

if($result){

$row=$result->fetch_array();

if(isset($row['times'])){

if($row['times']!=''){

$row['_times']=date('Y-m-d H:i',$row['times']);

}

}

if(isset($row['time'])){

if($row['time']!=''){

$row['_time']=date('Y-m-d H:i',$row['time']);

}

}

if(isset($row['cont'])){

$row['conts']=sub($row['cont'],600);

}

return $row;

}else{

return false;

}

}

public function showData($sql){

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

$data=array();

if($result->num_rows==0){

return $data;

}

$this->nums=$result->num_rows;

while($row=$result->fetch_array()){

$data[$row['Field']]=1;

}

return $data;

}

public function shows($sql){

$this->sql=$sql;

return $this->showsData($sql);

}

public function showsData($sql){

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

$data=array();

if($result->num_rows==0){

return false;

}

$this->nums=$result->num_rows;

while($row=$result->fetch_array()){

$data[]=$row;

}

return $data;

}

public function sels($db,$where='',$data='*',$server=false){

if($server){

$this->cont($server);

}

$sql='select '.$data.' from '.$db.' '.$where;

$this->sql=$sql;

return $this->selects($sql);

}

public function selects($sql){

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

$data=array();

if($result->num_rows==0){

return $data;

}

$this->nums=$result->num_rows;

while($row=$result->fetch_array()){

if(isset($row['times'])){

if($row['times']!=''){

$row['_times']=date('Y-m-d H:i',$row['times']);

}

}

if(isset($row['time'])){

if($row['time']!=''){

$row['_time']=date('Y-m-d H:i',$row['time']);

$row['_time_d']=date('Y/m/d',$row['time']);

}

}

if(isset($row['cont'])){

$row['conts']=sub($row['cont'],60);

}

if(array_key_exists('role',$row)){

$row['r_id']=$row['role'];

switch($row['role']){

case 'all':$row['role']='超级管理员';break;

default:$row['role']=$this->role($row['role']);

}

}

$data[]=$row;

}

return $data;

}

public function role($str){

$arr=explodes($str,',');

$brr=array();

$num=count($arr);

for($i=0;$i

$brr[]=$this->sel('acar_menu','where id='.$arr[$i]);

}

return $brr;

}

public function update($db,$data=array(),$where=''){

$s=$a='';

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

if(is_array($val)){

$a=$key.'='';

foreach($val as $va){

$a.=$va.',';

}

$a=sub_s($a);

$a.='',';

}else{

if($key=='img' || $key=='image')

$val=$val?addslashes($val):$val;

$s.=$key.'=''.$val.'' ,';

}

}

$s=sub_s($s);

$s=$a.$s.' '.$where;

$sql='update '.$db.' set '.$s;

$this->sql=$sql;

return $this->query($sql);

}

public function del($db,$id){

$sql='delete from '.$db.' where id='.$id;

$this->sql=$sql;

return $this->query($sql);

}

public function insert($db,$data=array()){

$k=$v='';

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

$k.=$key.',';

if(is_array($val)){

$v.="'";

foreach($val as $va){

$v.="{$va},";

}

$v=sub_s($v);

$v.="',";

}else{

if($key=='img' || $key=='image')

$val=$val?addslashes($val):$val;

$v.="'{$val}',";

}

}

$k=sub_s($k);

$v=sub_s($v);

//$s=$s.$a.$where;

$sql='insert into '.$db.'('.$k.') values('.$v.')';

$this->sql=$sql;

return $this->query($sql);

}

public function query($sql){

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

$this->id=$this->mysqli->insert_id;

$this->nums=$result->num_rows;

if($result){

return true;

}else{

return false;

}

}