DokuWiki

<?php
 
try {
    $db = new PDO('sqlite:rene_pictures.sqlite');
 
    $db->exec("CREATE TABLE picture (id INTEGER, name TEXT)");
    $db->exec("CREATE UNIQUE INDEX idx_picture_id ON picture (id)");
    $db->exec("CREATE INDEX idx_picture_name_id ON picture (name)");
 
 
    $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
 
    $res = $db->query("INSERT INTO picture (name, timestamp) VALUES ('test pilt 1', 12341234)");
    $res = $db->query("INSERT INTO picture (name, timestamp) VALUES ('test pilt 2', 12341234)");
    $res = $db->query("INSERT INTO picture (name, timestamp) VALUES ('test pilt 3', 12341234)");
 
    $res = $db->query("SELECT * FROM picture");
    foreach($res->fetchAll() AS $row) {
        print_r($row);
    }
 
    $db = NULL;
}
catch(PDOException $e) {
    print 'Exception : '.$e->getMessage();
}