PHPでSQLite

//DBをオープン
$objCon = sqlite_open('test.db') or die ('Opening table failed');


//テーブルを作成
$sql = "create table user (id int, name varchar(10))";
$result = sqlite_query($objCon, $sql) or die ('Creating table failed');


//データを挿入
$sql = "insert into user values(1, 'Sodo Mojo')";
$result = sqlite_query($objCon, $sql) or die('Inserting data failed');


//データの取得
$sql = "select * from user";
$result = sqlite_query($objCon, $sql) or die('Selecting data failed');


while($row = sqlite_fetch_array($result)){
echo $row['id']." ".$row['name'];
}


//DBコネクションをクローズ
sqlite_close($objCon);