php实现Mysql简易操作类

php  /  管理员 发布于 7年前   114

自己封装的Mysql简易操作类，已塞在Ben框架中，基于PDO来写的，代码风格上有些无厘头。。。

mysql.class.php

server = $server;    $this->database = $database;    $this->user = $user;    $this->password = $password;    parent::__construct("mysql:host=$server;port=$port;dbname=$database",$user,$password);    $this->query('SET NAMES utf8');  }  public function drop($table){    $sql = 'DROP TABLE '.$table.';';    $re = $this->query($sql);    if($re){      return true;    }else{      return false;    }  }  public function insert($table,$name,$value=null){    $sql = "INSERT INTO ".$table.'(';    if($value == null){    $arrname = array_keys($name);    $arrvalue = array_values($name);    }else{    $arrname = explode('|', $name);    $arrvalue = explode('|', $value);    }    for($i=0;$iquery($sql);    if($re){      return true;    }else{      return false;    }  }  public function delete($table,$Conditionsname,$Conditionsvalue=null){    if($Conditionsvalue!=null){      $sql = "DELETE FROM ".$table." WHERE ".$Conditionsname."='".$Conditionsvalue."';";    }else{      $sql = "DELETE FROM ".$table." WHERE ";      $arrname = array_keys($Conditionsname);      $arrvalue = array_values($Conditionsname);      for($i=0;$iquery($sql);    if($re){      return true;    }else{      return false;    }  }  public function select($table,$name,$Conditionsname,$Conditionsvalue=null){    if($Conditionsvalue!=null){      $sql = "SELECT ".$name." FROM ".$table." WHERE ".$Conditionsname."='".$Conditionsvalue."';";    }else{      $sql = "SELECT ".$name." FROM ".$table." WHERE ";      $arrname = array_keys($Conditionsname);      $arrvalue = array_values($Conditionsname);      for($i=0;$iquery($sql);    $row = $re->fetch();    return $row[$name];  }  public function update($table,$name,$value,$Conditionsname,$Conditionsvalue=null){    if($Conditionsvalue!=null){      $sql = "UPDATE ".$table." SET ".$name."= '".$value."' WHERE ".$Conditionsname."='".$Conditionsvalue."';";    }else{      $sql = "UPDATE ".$table." SET ".$name."= '".$value."' WHERE ";      $arrname = array_keys($Conditionsname);      $arrvalue = array_values($Conditionsname);      for($i=0;$iquery($sql);    if($re){      return true;    }else{      return false;    }  }  public function group($table,$name){    $sql = "SELECT ".$name." FROM ".$table.";";    $return = array();    $re = $this->query($sql);    while($row = $re->fetch(PDO::FETCH_ASSOC)){      array_push($return,$row[$name]);    }    return $return;  }  public function fetchall($sql){    $return = array();    $re = $this->query($sql);    while($row = $re->fetch(PDO::FETCH_ASSOC)){      array_push($return,$row);    }    return $return;  }}

您可能感兴趣的文章:

• php mysql数据库操作类
• 全新的PDO数据库操作类php版（仅适用Mysql）
• PHP数据库操作之基于Mysqli的数据库操作类库
• PHP实现PDO的mysql数据库操作类
• php下mysql数据库操作类(改自discuz)
• 支持php4、php5的mysql数据库操作类
• discuz7 phpMysql操作类
• php实现可用于mysql,mssql,pg数据库操作类
• php mysql数据库操作类(实例讲解)
• php实现的mysqldb读写分离操作类示例
• PHP实现的mysql操作类【MySQL与MySQLi方式】