Attogram Database

SQLite database access for PHP 7. Small, one class, and highly opinionated.

Install

composer require attogram/database

Examples

one table:

declare(strict_types = 1);
useAttogram\Database\Database;
require'../vendor/autoload.php';
$database = newDatabase();
$database->setDatabaseFile('./test.one.sqlite');
$database->setCreateTables("CREATE TABLE 'one' ('foo' TEXT)");
try {
$database->raw("INSERT INTO one ('foo') VALUES (CURRENT_TIMESTAMP)");
$arrayResults = $database->query("SELECT * FROM 'one'");
print_r($arrayResults);
} catch (Throwable$error) {
print'ERROR: ' . $error->getMessage();
}

two tables:

declare(strict_types = 1);
useAttogram\Database\Database;
require'../vendor/autoload.php';
$database = newDatabase();
$database->setDatabaseFile('./test.two.sqlite');
$tables = [
"CREATE TABLE 'one' ('foo' TEXT)",
"CREATE TABLE 'two' ('bar' TEXT)",
];
$database->setCreateTables($tables);
try {
$database->raw("INSERT INTO one ('foo') VALUES (CURRENT_TIMESTAMP)");
$database->raw("INSERT INTO two ('bar') VALUES (CURRENT_TIMESTAMP)");
$arrayResults = $database->query("SELECT * FROM 'one'");
print_r($arrayResults);
$arrayResults = $database->query("SELECT * FROM 'two'");
print_r($arrayResults);
} catch (Throwable$error) {
print'ERROR: ' . $error->getMessage();
}