<?php
    $db = sqlite_open(dirname(__FILE__)."/db.sqlite");

    /* CREATE TABLE auth_tbl (login VARCHAR(32), passwd CHAR(32)); */
    $result = sqlite_query("SELECT * FROM auth_tbl", $db);

    echo '<pre>';
    /* array sqlite_fetch_array(resource result [, int result_type [, bool decode_binary]] ) */
    while (($row = sqlite_fetch_array($result))) {
        print_r($row);
    }
    echo '</pre>';

    sqlite_close($db);
?>