PHP SQLite::fetch 예제들

예제 #1

파일: index.php 프로젝트: kikoseijo/BootPress

$profile = isset($profile) && $profile === false ? false : true;
if (isset($mssql)) {
    if ($export = ci_load_database('mssql', $mssql, $query_builder, $profile)) {
        $export = new Database($export);
    }
} elseif (isset($mysql)) {
    if ($export = ci_load_database('mysqli', $mysql, $query_builder, $profile)) {
        $export = new Database($export);
    }
} elseif (isset($oracle)) {
    if ($export = ci_load_database('oci8', $oracle, $query_builder, $profile)) {
        $export = new Database($export);
    }
} elseif (isset($postgre)) {
    if ($export = ci_load_database('postgre', $postgre, $query_builder, $profile)) {
        $export = new Database($export);
    }
} elseif (isset($sqlite)) {
    $export = new SQLite($sqlite, $query_builder, $profile);
} elseif (isset($fts)) {
    $export = array();
    list($search, $values) = each($fts);
    $db = new SQLite();
    $db->fts->create('results', 'search', 'porter');
    $db->fts->upsert('results', 'search', $values);
    $db->query('SELECT docid, search FROM results WHERE search MATCH ?', array($search));
    while (list($docid, $value) = $db->fetch('row')) {
        $export[$docid] = $value;
    }
    unset($db);
}