phpの覚書

database_create.php

<?
$dbp = sqlite_open('./test.db');
sqlite_close($dbp);
?>

Apacheを通して使用し, 永続的なオープンを期待する場合は sqlite_popenを使用すべき。

table_create.php

<?
$sql = 'create table foo_t ('
          .'foo_id number, '
          .'foo_name varchar(200), '
          .'foo_date date)';
$dbp = sqlite_open('./test.db');

if(sqlite_exec($dbp, $sql)) {
   print('テーブルを作成しました。'."\n");
} else {
   print('テーブルの作成に失敗しました'."\n");
}
sqlite_close($dbp);
?>

record_add.php

<?
$dbp = sqlite_open('./test.db');

$sql = "insert into foo_t values ("
         ."1, "
         ."'scott', "
         ."date('2007-08-03'));";
if(!sqlite_exec($dbp, $sql)) {
   print("failure\n");
}

$sql = "insert into foo_t values ("
         ."2, "
         ."'john', "
         ."datetime('2007-08-04 01:02:03'));";
if(!sqlite_exec($dbp, $sql)) {
   print("failure\n");
}

$sql = "insert into foo_t values ("
         ."3, "
         ."'cobache', "
         ."datetime('now'));";
if(!sqlite_exec($dbp, $sql)) {
   print("failure\n");
}

sqlite_close($dbp);
?>

record_select.php

<?
$dbp = sqlite_open('./test.db');

$sql = 'select * from foo_t;';

$sql_result = sqlite_query($dbp, $sql);

while(($record=sqlite_fetch_array($sql_result))!==false) {
    print("-\n");
    print("  foo_id: ".$record["foo_id"]."\n");
    print("  foo_name: ".$record["foo_name"]."\n");
    print("  foo_date: ".$record["foo_date"]."\n");
}

sqlite_close($dbp);
?>