Wallogit.com
2017 © Pedro Peláez
Facilitating day-to-day SQL queries with PDO., (*1)
ATTENTION: it's a experimental version. Don't use it in production., (*2)
composer require dbfit/pdo
Simple queries:, (*3)
$dbfit = new Dbfit($host, $user, $password, $database);
$result = $dbfit->query("SELECT * FROM users");
Transactions queries:, (*4)
$dbfit->getConnection()->beginTransaction(); $dbfit->query($sql); $dbfit->query($sql); $dbfit->query($sql); $dbfit->getConnection()->endTransaction();
You can cancel a transaction using $dbfit->getConnection()->cancelTransaction();, (*5)
prepareQuery methodConnectionManager
composer.json
select method that returns result datainsert method that returns insert_id
update method that returns number of affected rowsdelete method that returns number of affected rowsjoin, where, groupBy, having, orderBy limit, offset
count, distinctCount, max, min, avg, sum
PDO database library for any project php
MIT
database pdo
PDO database library for any project php
MIT
database pdo