ajur-media / dbwrapper
0.2.0
2022-11-22 15:03 UTC
Requires
- ext-mysqli: *
- ext-pdo: *
- ext-pgsql: *
- psr/log: ^1.1
Requires (Dev)
- karelwintersky/arris.cache: ^v0.6.1
This package is not auto-updated.
Last update: 2024-04-10 20:36:59 UTC
README
require_once __DIR__ . '/vendor/autoload.php'; $dbh = new AJUR\DBWrapper\DBWrapper([ 'driver' => 'pdo', 'username' => 'root', 'password' => 'password', 'database' => 'test', 'slow_query_threshold' => 1 ]); // exposes normal $sth = $dbh->prepare("/* insert data */ INSERT INTO test (setting, value) VALUES (:s, :v)"); $sth->execute([ 's' => 'option', 'v' => mt_rand(100, 10000) ]); var_dump($dbh->getLastState()); var_dump( $dbh->query("/* select query */ SELECT * FROM test ORDER BY RAND() LIMIT 1")->fetchAll() ); var_dump($dbh->getLastState()); $sth = $dbh->query('SELECT id, title FROM articles ORDER BY id DESC LIMIT 10000'); var_dump($sth->fetchAll()); var_dump($dbh->getLastState()); var_dump($dbh->getStats());