Критикуйте кароче полностью
ибо я рад буду критике ну в данном случае рад
<?php
class sql
{
private $db;
private $count = 0;
public function __construct ($host,$user,$pass,$name,$charset = 'utf-8')
{
$dsn = 'mysql:host='.$host.';dbname='.$db.';charset='.$charset;
$this->db = new PDO($dsn, $user, $pass);
$this->db->query('SET NAMES '.$charset);
}
public function num_rows ($sql, $value=NULL)
{
if ($this->db == FALSE)
{
return FALSE;
}
$this->count++;
if ($value == NULL)
{
return $this->db->query($sql)->rowCount();
}
if ($value != NULL)
{
$query=$this->db->prepare($sql);
$query->execute($value);
return $query->rowCount();
}
}
public function query ($sql, $value=NULL)
{
if ($this->db == FALSE)
{
return FALSE;
}
$this->count++;
if ($value == NULL)
{
return $this->db->query($sql);
}
if ($value != NULL)
{
$query=$this->db->prepare($sql);
$query->execute($value);
return $query;
}
}
public function check ($var)
{
if ($this->db == FALSE)
{
return FALSE;
}
return $this->db->quote($var);
}
public function fetch_assoc ($query)
{
if ($this->db == FALSE)
{
return FALSE;
}
return $query->fetch(PDO::FETCH_ASSOC);
}
public function fetch_array ($query)
{
if ($this->db == FALSE)
{
return FALSE;
}
return $query->fetch(PDO::FETCH_ARRAY);
}
public function set ($key, $value)
{
$this->db->setAttribute($key, $value);
}
public function result ($query)
{
if ($this->db == FALSE)
{
return FALSE;
}
return $query->rowCount();
}
}
?>
"Обёртка" для работы с бд PDO