<?php
class Sql
{
private $_db;
function __construct($db)
{
$this->_db = $db;
}
private function keyParse($array)
{
}
private function valueParse($array)
{
}
private function valueQuote($array)
{
foreach($array as $k => $v)
$array[$k] = $this->_db->quote($v);
return $array;
}
private function keyValueParse($array)
{
foreach($array as $k => $v){
$keyValue .= $k." = ".$v.", ";}
}
public function insert($table,$params)
{
$params = $this->valueQuote($params);
$keys = $this->keyParse($params);
$values = $this->valueParse($params);
$sql = "INSERT INTO `{$table}` ({$keys}) VALUES({$values})";
$insert = $this->_db->exec($sql);
return $insert;
}
public function update($table,$params,$where = '')
{
$params = $this->valueQuote($params);
$params = $this->keyValueParse($params);
$sql = "UPDATE {$table} SET {$params} WHERE {$where}";
$update = $this->_db->exec($sql);
if($update) return true;
else return false;
}
public function delete($table,$where)
{
$sql = "DELETE FROM {$table} WHERE {$where}";
$delete = $this->_db->exec($sql);
return $delete;
}
public function select($table,$selection,$where = "",$type = null,$fetch="fetch")
{
switch($type)
{
case "num": $pdo = PDO::FETCH_NUM;break;
case "assoc": $pdo = PDO::FETCH_ASSOC;break;
case "obj": $pdo = PDO::FETCH_OBJ;break;
default: $pdo = PDO::FETCH_OBJ;
}
if($where != "") $where = "WHERE {$where}";
$sql = "SELECT {$selection} FROM {$table} {$where}";
$stmt = $this->_db->query($sql);
$select = $stmt->$fetch($pdo);
return $select;
}
}
?>
)Для простых запросов в самый раз.