SQLiteとは

; Directory in which the loadable extensions (modules) reside.
extension_dir = "C:wwwphpextensions"
 
extension=php_sqlite.dll

pear install sqlite

pear install SQLite-1.0.3.tgz
 
#pear install sqlite
 
色々作業をした後……
----------------------------------------------------------------------
 
Build complete.
(It is safe to ignore warnings about tempnam and tmpnam).
 
sqlite.so copied to /tmp/tmpgUNgoB/SQLite-1.0/sqlite.so
 
Build process completed successfully
Installing 'sqlite.so' at ext_dir (/usr/local/lib/php/extensio
ns/no-debug-non-zt
s-20020429/sqlite.so)
install ok: SQLite 1.0
 
 
cd /usr/local/lib/php/extensions/

ln -s ./no-debug-non-zts-20020429/sqlite.so

<?php    
$sqliteerror = null;
 
/* SQLiteハンドルの取得 */
$dbh = sqlite_open('test.db', '0666', $sqliteerror);
 
/* テーブルの作成 */
/* idをプライマリ宣言し自動シーケンス */
$query = <<<QUERY
CREATE TABLE account_tbl (
    id INTEGER,
    number INTEGER,
    name VARCHAR(64) NOT NULL,
    email VARCHAR(128),
    PRIMARY KEY (id)
);
QUERY;
$result = sqlite_query($query, $dbh);
 
/* ステートメントの生成 */
$query = "INSERT INTO account_tbl (number,name,email) VALUES ".
                "('30248','高橋','yujiro@rakuto.net') ";
$result = sqlite_query($query, $dbh);
 
$query = "INSERT INTO account_tbl (number,name,email) VALUES ".
                "('45567','藤井','fuzy@rakuto.net') ";
$result = sqlite_query($query, $dbh);
 
 
/* データの取得 */
$result = sqlite_query('SELECT * FROM account_tbl', $dbh);
 
$cols = array();
while ($cols = sqlite_fetch_array($result, SQLITE_ASSOC)) { 
    echo "----------------------n";
    echo "id    = {$cols['id']}n";
    echo "number= {$cols['number']}n";
    echo "name  = {$cols['name']}n";
    echo "email = {$cols['email']}n";
    echo "----------------------n";
} 
 
/* ステートメントの開放 */
$result = null;
?>