MyPDO.class.php

PHP PDO wrapper

php

<?php
// soubor MyPDO.class.php

class MyPDO{
    private $spojeni;
    private $host, $user, $pass, $name;
    private $options = Array(
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"
    );

    function __construct($host, $user, $pass, $name) {
        $this->host=$host;
        $this->user=$user;
        $this->pass=$pass;
        $this->name=$name;
    }

    function connect() {
        if (!isset($this->spojeni)) {
            $this->spojeni= @new PDO(
                "mysql:host=$this->host;dbname=$this->name",
                $this->user,
                $this->pass,
                $this->options
            );
        }
        return $this->spojeni;
    }

    function query($query, $param = Array()) {
        $navrat = $this->connect()->prepare($query);
        $navrat->execute($param);
        return $navrat->rowCount();
    }

    function queryOne($query, $param = Array()) {
        $navrat = $this->connect()->prepare($query);
        $navrat->execute($param);
        return $navrat->fetch(PDO::FETCH_OBJ);
    }

    function queryAll($query, $param = Array()) {
        $navrat = $this->connect()->prepare($query);
        $navrat->execute($param);
        return $navrat->fetchAll(PDO::FETCH_OBJ);
    }

    function insert($table, $param = Array()) {
        return $this->query("INSERT INTO `$table` (`".
            implode('`, `', array_keys($param)).
            "`) VALUES (".str_repeat('?,', sizeOf($param)-1)."?)",
                array_values($param));
    }
}

Neformátovaný

Přidáno: 10.12.2012
Expirace: Neuvedeno

Autor: Kit