otula

//cesta k db
    $pathinfo = pathinfo(__FILE__);
    $this->path = realpath($pathinfo['dirname']) . "/database/rtest.sqlite";
    $dbh = new PDO("sqlite:$this->path");
    $this->table = $dbh->quote($table);

// test, zda se má vytvořit tabulka
    $table_check = $dbh->query("SELECT * FROM $this->table WHERE id='1'");
    if(!$table_check){
    // vytvořit tabulku
        $dbh->query("CREATE TABLE $this->table (id INTEGER PRIMARY KEY, rating FLOAT(3,2), ip VARCHAR(15))");
        $dbh->query("INSERT INTO $this->table (rating, ip) VALUES (0, 'master')");
        }

// spočítat počet hlasů od jednoho člena
    $this->votes = ($dbh->query("SELECT COUNT(*) FROM $this->table WHERE (ip='x.x.x.x' or ip='y.y.y.y' or ip='z.z.z.z')")->fetchColumn());
    while ($this->votes > 1) {
        //pomocná proměnná, protože zde pro DELETE nefunguje LIMIT
        //(tenhle záznam se bude mazat)
        $delid = ($dbh->query("SELECT id FROM $this->table WHERE (ip='x.x.x.x' or ip='y.y.y.y' or ip='z.z.z.z') LIMIT 1")->fetchColumn());
        $dbh->exec("DELETE FROM $this->table WHERE id=$delid");
//      print_r($dbh->errorInfo());
        $this->votes = ($dbh->query("SELECT COUNT(*) FROM $this->table WHERE (ip='x.x.x.x' or ip='y.y.y.y' or ip='z.z.z.z')")->fetchColumn());
}