14c06-1.php

来自「介绍PHP5的给类型函数应用」· PHP 代码 · 共 33 行

<?php
// Open the database:
if (!($db = sqlite_open('tools.db'))) {
    // Handle errors
    die('SQL ERROR: Open failed: ' . 
        sqlite_error_string(sqlite_last_error($db)));
}

// Prepare the database creation:
$sql = "
create table tools (
    id   integer  primary key,
    desc text     not null,
    qty  integer  not null
);

insert into tools (desc, qty) values ('Screwdriver', 10);
insert into tools (desc, qty) values ('Tablesaw', 1);
insert into tools (desc, qty) values ('Router', 2);
";

// Create it all:
if (!(sqlite_exec($db, $sql))) {
    // Give an error statement:
    die('SQL ERROR: ' . sqlite_error_string(sqlite_last_error($db)) . 
        " - Query was: {$sql}");
} else {
    echo 'SUCCESS!';
}

// Now close the database
sqlite_close($db);
?>