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
|
Name: |
MySQLi Database |
Base name: |
mysqlidatabase |
Description: |
MySQL database wrapper using MySQLi extension |
Version: |
1.0.0 |
PHP version: |
- |
License: |
BSD License |
|
|
|
Pages that reference this package |
|
|
MySQLi Wrapper here is a well documented and extensive MySQLi extention (wrapper) with various refined features:... |
Latest pages that reference packages
|
Applications that use this package |
|
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
|
Files |
|