README

SQLite3 database driver for the Tina4 PHP framework.

Installation

composer require tina4stack/tina4php-sqlite3

Requirements

• PHP >= 8.1
• ext-sqlite3
• tina4stack/tina4php-database ^2.0

Usage

// Connection format: path to .db file (no user/pass needed)
$DBA = new \Tina4\DataSQLite3("test.db");

// Execute queries
$DBA->exec("create table users (id integer primary key, name varchar(200))");
$DBA->commit();

// Insert with parameters
$DBA->exec("insert into users (id, name) values (?, ?)", 1, "Alice");

// Fetch records
$result = $DBA->fetch("select * from users");
$records = $result->asArray();

// Fetch with limit and offset
$result = $DBA->fetch("select * from users", 10, 0);

// Fetch single record
$record = $DBA->fetchOne("select * from users where id = 1");

// Check if table exists
$exists = $DBA->tableExists("users");

// Get database metadata
$metadata = $DBA->getDatabase();

Testing

composer test

License

MIT - see LICENSE

Our Sponsors

Sponsored with 🩵 by Code Infinity

Supporting open source communities • Innovate • Code • Empower