<?php
class PDO_ extends PDO {
public function __construct($dsn, $username, $password) {
parent:: __construct($dsn, $username, $password);
$this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
}
public function querySingle($sql, $params = array()) {
$stmt = $this->query($sql, $params);
$stmt->execute($params);
return $stmt->fetchColumn(0);
}
public function query($sql, $params = array()) {
$stmt = $this->prepare($sql);
$stmt->execute($params);
return $stmt;
}
public function prepare($sql, $options = null) {
$stmt = parent::prepare($sql, array(
PDO::ATTR_STATEMENT_CLASS => array('PDOStatement_')
));
return $stmt;
}
public function queryFetch($sql, $params = array()) {
$stmt = $this->query($sql, $params);
$stmt->execute($params);
return $stmt->fetch();
}
}