PHP Classes

MySQLi Database: MySQL database wrapper using MySQLi extension

Recommend this page to a friend!
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 57%Total: 7,147 All time: 271 This week: 135Up
Version License Categories
mysqlidatabase 1.0.0BSD LicensePHP 5, Databases
Description Author

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

Picture of Costin Bereveanu
Name: Costin Bereveanu <contact>
Classes: 1 package by
Country: Romania Romania
Age: 40
All time rank: 3808 in Romania Romania
Week rank: 577 Down8 in Romania Romania Equal

  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

 Version Control Unique User Downloads Download Rankings  
 0%
Total:7,147
This week:0
All time:271
This week:135Up
 User Ratings  
 
 All time
Utility:84%StarStarStarStarStar
Consistency:81%StarStarStarStarStar
Documentation:75%StarStarStarStar
Examples:-
Tests:-
Videos:-
Overall:57%StarStarStar
Rank:1610
  
For more information send a message to info at phpclasses dot org.