<?php
/**
 * Created by PhpStorm.
 * User: efik
 * Date: 12.11.15
 * Time: 20:45
 */
class Post
{
    private $id;
    private $tytul;
    private $tresc;

    /**
     * @return mixed
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * @param mixed $id
     * @return Post
     */
    public function setId($id)
    {
        $this->id = $id;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getTytul()
    {
        return $this->tytul;
    }

    /**
     * @param mixed $tytul
     * @return Post
     */
    public function setTytul($tytul)
    {
        $this->tytul = $tytul;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getTresc()
    {
        return $this->tresc;
    }

    /**
     * @param mixed $tresc
     * @return Post
     */
    public function setTresc($tresc)
    {
        $this->tresc = $tresc;
        return $this;
    }


}

#############################################################
$db = new PDO('sqlite:./db/files.sqlite');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

####################################################################
$db->query('CREATE TABLE IF NOT EXISTS tabelka (id INTEGER PRIMARY KEY, tytul TEXT, tresc TEXT);');
########################################################################

$statement = $db->prepare('INSERT INTO tabelka (id,tytul, tresc) VALUES (?,?, ?);');
$statement->bindValue(1, rand(2, 1000));
$statement->bindValue(2, 'hejka');
$statement->bindValue(3, 'dd');

try {
    $statement->execute();
} catch (PDOException $e) {
    die("Record already exists");
}



$data = $db->query("SELECT * FROM tabelka")->fetchAll( PDO::FETCH_CLASS, 'Post');

var_dump($data);