php

<?php
class Databaze {
    private static $dbattr = array(
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"
    );  
    private $host;
    private $db_name;
    private $user;
    private $password;
    private $pdo = NULL;

    public function __construct($host, $db_name, $user, $password) {
        $this->host = $host;
        $this->db_name = $db_name;
        $this->user = $user;
        $this->password = $password;
    }   

    private function getDB() {
        if (is_null($this->pdo)) {
            $this->pdo = new PDO("mysql:host=$this->host;dbname=$this->db_name",
                $this->user, $this->password, self::$dbattr);
        }   
        return $this->pdo;
    }

    public function vloz($ip) {
        $vloz = $this->getDB()->prepare('INSERT INTO pristupy (ip, datum) VALUES (?, now())');
        $vloz->execute(array($ip));
    }
}

$pripoj = new Databaze("localhost", "test", "root", "");
$pripoj->vloz($_SERVER['REMOTE_ADDR']);

Neformátovaný

Přidáno: 2.1.2014
Expirace: Neuvedeno

Autor: Kit