Login   Register  
PHP Classes
elePHPant
Icontem

MySQLi Database: MySQL database wrapper using MySQLi extension

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Costin Bereveanu
Name: Costin Bereveanu <contact>
Classes: 1 package by
Country: Romania Romania
Age: 32
All time rank: 3829 in Romania Romania
Week rank: 118 Up3 in Romania Romania Up


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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

  Classes of Costin Bereveanu  >  MySQLi Database  >  Download Download .zip .tar.gz  >  Support forum Support forum (2)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQLi Database
Base name: mysqlidatabase
Description: MySQL database wrapper using MySQLi extension
Version: 1.0.0
PHP version: -
License: BSD License
All time users: 6643 users
All time rank: 275
Week users: 13 users
Week rank: 79 Up
 
  Groups   Rate classes User ratings   Trackback   Applications   Files Files  

  Groups  
Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (82%) Sufficient (78%) Sufficient (71%) - - - Not sure (56%) 1160
Month: Not yet rated by the users

  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 Latest pages that reference packages


  Applications that use this package  
No pages of applications that use this class were specified.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file class.MysqliDatabase.php Class Main classes file
Accessible without login HTML file MysqliDatabase.html Doc. Documentation
Accessible without login HTML file MysqliResult.html Doc. Documentation
Accessible without login HTML file _class_MysqliDatabase_php.html Doc. Documentation

Install with Composer Install with Composer - Download Download all files: mysqlidatabase.tar.gz mysqlidatabase.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.