Dibi is Database Abstraction Library for PHP 5.
Dibi currently supports a lot of significant databases: MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Access and generic PDO and ODBC.
- Quick Start
- API documentation
- La Trine: dibi – pokrokový databázový layer
- La Trine: Téměř v cíli: dibi 0.9b
- Extrémě rychlý „load SQL file“
- Závěrem dibitýdne…
- Licence
- Podpořte vývoj
Code samples
// connect to database
dibi::connect(array(
'driver' => 'mysql',
'host' => 'localhost',
'username' => 'root',
'password' => '***',
));
// select, insert, update
dibi::query('SELECT * FROM [table] WHERE [id] = %i', $id);
$arr = array(
'name' => 'John',
'is_admin' => TRUE,
);
dibi::query('INSERT INTO [table]', $arr);
// INSERT INTO `table` (`name`, `is_admin`) VALUES ('John', 1)
dibi::query('UPDATE `table` SET ', $arr, 'WHERE `id`=%i', $x);
// UPDATE `table` SET `name`='John', `is_admin`=1 WHERE `id` = 123
// getting results
$result = dibi::query('SELECT * FROM `table`');
$value = $result->fetchSingle(); // single value
$all = $result->fetchAll(); // all rows
$assoc = $result->fetchAssoc('id'); // all rows as associative array
$pairs = $result->fetchPairs('customerID', 'name'); // all rows as key => value pairs
// iterating
foreach ($result as $n => $row) {
print_r($row);
}See more examples.
