Login   Register  
PHP Classes
elePHPant
Icontem

Ultimate MySQL: MySQL database access wrapper

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

  Author Author  
Picture of Jeff Williams
Name: Jeff Williams <contact>
Classes: 5 packages by
Country: United States United States
Age: 43
All time rank: 435 in United States United States
Week rank: 23 Up2 in United States United States Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
This class is the ultimate MySQL database access wrapper

It can:

- Establish MySQL server connections
- Execute SQL queries
- Query a single value or a single row
- Retrieve query results into arrays or resource objects
- Retrieve the last inserted ID
- Manage transactions (transaction processing)
- Retrieve the list tables of a database
- Retrieve the list fields of a table
- Retrieve the length or position of a field
- Measure the time a query takes to execute
- Display query results in an HTML table
- Format SQL parameters (safe against SQL injection hacks)
- Generate SQL
- Handle errors (optional Exception handling)
- Convert records into XML or JSON
- Uses the mysqli extension

  Classes of Jeff Williams  >  Ultimate MySQL  >  Download Download .zip .tar.gz  >  Support forum Support forum (69)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Ultimate MySQL
Base name: ultimatemysql
Description: MySQL database access wrapper
Version: 3.0
PHP version: 5.0
License: Freeware
All time users: 18466 users
All time rank: 33
Week users: 41 users
Week rank: 22 Up
 
  Groups   Rate classes User ratings   Trackback  
  Applications   Related pages   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
Group folder image Performance and optimization Tools to measure and optimize the performance of systems View top rated classes


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (92%) Good (90%) Good (88%) Good (88%) - - Sufficient (72%) 118
Month: Not yet rated by the users

  Pages that reference this package  
Good PHP class to work with MySQL
Until recently, in every application I have written code to work with the database...
Linked Remote Comboboxes with EXTJS
To created linked combo boxes with EXTJS it requires 3 steps:...

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.

  Related pages  
UltimateMySQL.chm
Tutorial and Class Documentation CHM Help File
UltimateMySQL.pdf
Tutorial and Class Documentation PDF File

  Files folder image Files  
File Role Description
Plain text file mysql.class.php Class UltimateMySQL Class File
Accessible without login HTML file help.html Doc. Help for UltimateMySQL class
Accessible without login Plain text file example.php Example Examples for UltimateMySQL
Accessible without login Plain text file example.select.php Example Example (SQL SELECT)
Accessible without login Plain text file example.queries.php Example Example (Query Tutorial)
Accessible without login Plain text file example.new_features.php Example Example (SQL generation and try/catch blocks)

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