PHP Classes
Icontem

Class: Ultimate MySQL wrapper


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend!
      Classes of Indrek Altpere  >  Ultimate MySQL wrapper  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description  
  Rate classes User ratings   Dependents   Applications   Files Files  

  • Supplied by:

    Picture of Indrek Altpere
    Name: Indrek Altpere <e-mail contact>
    Published packages: 3
    Country: Estonia Estonia - PHP jobs in Estonia
    Home page: http://www.whiteboardmeeting.com/
    Age: 22
    All time rank: 1220
    Week rank: 452

    Browse this author's classes

  • 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

  • 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.

  • 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:

    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.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  
For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products