This package is a wrapper around the MySQLi extension to access MySQL databases.
The package is composed of two classes: one extends the MySQLi class to execute several types of database access functions and another extends the mysqli_result class to manipulate result sets.
It features:
- Optional exception throwing on connection or query errors
- All the result fetching functions use the fetch_object function. Support for retrieving results in associative arrays can be implemented later
- Perform several types querying and retrieval of results: query, query_all (fetches all rows), query_one (fetches only the first row), query_value (fetches only the first field and casts it to desired type)
- Retrieve the number of rows affected by the query, that can be used if you just want to know if a certain record exists
- Paginated queries (query_page, query_page_all, query_page_one) to retrieve only a given page of results
- Return the total number of rows in a paginated query (not only that on the current page)
- Support a complete set of MySQL error codes and data type constants
- Provides a function to compare the last error to a constant code
- Automaticaly cast the query results to given data type equivalent to database data types
- Altered mysqli constructor to accept a flexible connection string that can be used with database abstraction layers
- PHPDoc documentation