wherd / database
Database
v2.1.0
2023-02-12 15:52 UTC
Requires (Dev)
README
Yet another database wrapper.
Installation
Install using composer:
composer require wherd/database
Usage
use Wherd\Database\Connection; use Wherd\Database\Fetch; $db = new Connection('sqlite::memory:'); $db->prepare('CREATE TABLE users (username TEXT, email TEXT, password TEXT)')->execute(); $stmt = $db->prepare('INSERT INTO users (username, email, password) VALUES (?, ?, ?)'); $stmt->execute('wherd', 'ola@wherd.name', '*****'); // Can allso invoke execute method directly // $stmt('wherd', 'ola@wherd.name', '*****'); $users = $db ->prepare('SELECT username, email FROM users') ->as(Fetch::KeyValuePair) ->fetchAll() // Optional - Statement is traversables ; foreach ($users as $username => $email) { echo $username, ' - ', $email; }