Login   Register  
PHP Classes
elePHPant
Icontem

Class: Ultimate MySQL wrapper

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Indrek Altpere  >  Ultimate MySQL wrapper  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Ultimate MySQL wrapper
Support forum Support forum
Base name: simplemysqlwrapper
Description: MySQL database access wrapper
Related classes: , , , , , , ,
Version: 1.2
PHP version: 5.0
License: GNU Lesser General Public License (LGPL)
All time users: 917 users
All time rank: 3148
Week users: 2 users
Week rank: 1665
Picture of Indrek Altpere
Author: Indrek Altpere <e-mail contact>
Packages: 3 Browse this author's classes Browse this author's classes
Country: Estonia Estonia - PHP jobs in Estonia
Age: 25
All time rank: 8573 in Estonia Estonia
Week rank: 689 Up2 in Estonia Estonia Up


  Detailed description  
This package implements a MySQL database access wrapper.

There are two classes that provide the same functionality to access MySQL databases. One as a regular class and another that provide static functions so it is not necessary to create an object of the class to call it. It can:

- Connect to MySQL database host delayed connections until the first query is run
- Execute queries
- Escape text literal values to use in SQL queries
- Support transactions
- Retrieve query results as a MySQL resource object, regular arrays and associative arrays
- Collapse multiple rows into single level array
- Retrieve the time spent on the last or all queries
- Retrieve the count of rows that were selected or affected by the last or all queries
- Retrieve the identifier of the last inserted row
- Retrieve the count of row found total when SQL_CALC_FOUND_ROWS is used
- Retrieve the names and explanation of tables and fields of a database
- Retrieve the statistics about of all executed queries using the class
- Retrieve large results with iterator class

When used together with and error handler class/function that also logs stacktrace (like my ErrorManager class) you can get full stacktrace for mysql errors since it calls trigger_error on mysql error.

 

  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

  Rate classes User ratings   Dependents   Applications   Files Files  

  User ratings  
There are not enough user ratings to display for this class.

  Packages that need this class  
Class Dependency Why it is needed
ORM mapping class(like Hibernate), maps database table rows to objects
Required
 Is used to perform queries that keep objects and database synchronized, also for charater escaping

  Applications that use this class  
No application links were specified for this class.
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 example.php Example example file to poll tablenames and table fields from database
Plain text file Mysql.php Class Main file

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