Download the PHP package scottchiefbaker/dbquery without Composer
On this page you can find all versions of the php package scottchiefbaker/dbquery. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download scottchiefbaker/dbquery
More information about scottchiefbaker/dbquery
Files in scottchiefbaker/dbquery
Package dbquery
Short Description DBQuery is a PHP database library to simplify fetching and iterating over your data.
License MIT
Homepage https://github.com/scottchiefbaker/DBQuery
Informations about the package dbquery
DBQuery
DBQuery is a PHP database library to simplify fetching and iterating over your data. It supports any database that PDO supports, and has been tested extensively with MySQL and SQLite. DBQuery has been tested on PHP versions: 8.1, 8.2 and 8.3.
Installation
Example Usage
DBQuery simplifies the act of sending queries and iterating over the results.
The core of DBQuery is in the query() function, which handles sending
queries and building an iterable recordset.
DBQuery does its best job to give you the datatype you want, but you can provide hints to guide it.
Return Hints
info_hash return an array of associative arrays (Note: this is the default return type)
info_list return an array of numeric arrays
one_data return a single scalar
key_value return an associative array key/value pair
one_row return a single associtive array
one_column return a single numeric array
Parameter Binding
Unit Tests
DBQuery contains standalone unit tests which use an in-memory SQLite database to test the functionality of DBQuery. You can run this unit tets from the command line with: