Login   Register  
PHP Classes
elePHPant
Icontem

Ultimate MySQL wrapper

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

  Author  
Picture of Indrek Altpere
Name: Indrek Altpere <e-mail contact>
Packages: 3 Browse all classes by Indrek Altpere Browse all classes by
Country: Estonia Estonia - PHP jobs in Estonia
Age: 27
All time rank: 8183 in Estonia Estonia
Week rank: 555 Up2 in Estonia Estonia Up


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

  Classes of Indrek Altpere  >  Ultimate MySQL wrapper  >  Download .zip .tar.gz  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Ultimate MySQL wrapper
Base name: simplemysqlwrapper
Description: MySQL database access wrapper
Version: 1.3
PHP version: 5.0
License: GNU Lesser General Public License (LGPL)
All time users: 1045 users
All time rank: 3090
Week users: 2 users
Week rank: 1335 Up
 
  Groups   Rate classes User ratings   Dependents   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  
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
Accessible without login Plain text file example.php Example example file to poll tablenames and table fields from database
Accessible without login 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.