Example #1
0
        } else {
            return false;
        }
    }
}
$db = false;
if (file_exists(MICROSITE_CONFIG)) {
    include MICROSITE_CONFIG;
    $db = new DB($config['connect_string']);
    /*
    $db->exec('CREATE TABLE pages (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, url VARCHAR(255) NOT NULL);');
    $db->exec('
    CREATE TABLE components (
      id       integer PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE,
      page_id  integer NOT NULL,
      name     varchar(50) NOT NULL,
      type     varchar(50) NOT NULL,
      value    text
    );');
    $db->exec('
    CREATE INDEX components_page_id
      ON components
      (page_id);');
    $db->exec("INSERT INTO pages (url) VALUES ('');");
    $page_id = $db->lastInsertID();
    $db->query("INSERT INTO components (page_id, name, type, value) VALUES (?,?,?,?);", array($page_id, 'title', '', 'Hello'));
    $db->query("INSERT INTO components (page_id, name, type, value) VALUES (?,?,?,?);", array($page_id, '_view', '', 'template.php'));
    */
}
Controller::startup($db);