自己封装的MysqL简易操作类，已塞在Ben框架中，基于PDO来写的，代码风格上有些无厘头。。。
PHP;">
server = $server;
$this->database = $database;
$this->user = $user;
$this->password = $password;
parent::__construct("MysqL:host=$server;port=$port;dbname=$database",$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;$isql = $sql.$arrname[$i];
}else{
$sql = $sql.$arrname[$i].",";
}
}
$sql = $sql.")VALUES(";
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,$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,$value,$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;
}
}
