PHP Classes
elePHPant
Icontem

Ultimate MySQL: MySQL database access wrapper

Recommend this page to a friend!
  Info   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum (76)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2013-08-16 (5 years ago) RSS 2.0 feedStarStarStarStar 72%Total: 21,113 This week: 1All time: 29 This week: 367Down
Version License PHP version Categories
ultimatemysql 3.0Freeware5.0PHP 5, Databases, Performance and opt...
Description Author

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

Recommendations

Arrays from database
I need arrays from a database ; also json format

MySQL Search
Search several fields in MySQL database and create results page

  Performance   Level  
Name: Jeff Williams <contact>
Classes: 6 packages by
Country: United States United States
Innovation award
Innovation award
Nominee: 1x

  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)

 Version Control Unique User Downloads Download Rankings  
 0%
Total:21,113
This week:1
All time:29
This week:367Down
User Ratings User Comments (16)
 All time
Utility:92%StarStarStarStarStar
Consistency:89%StarStarStarStarStar
Documentation:87%StarStarStarStarStar
Examples:88%StarStarStarStarStar
Tests:-
Videos:-
Overall:72%StarStarStarStar
Rank:242
 
Very useful class, thanks
3 years ago (Migliori)
80%StarStarStarStarStar
very nice work.
5 years ago (Ashok kumar kashyap)
80%StarStarStarStarStar
Excellent class, make database manipulation extremely easy.
5 years ago (Fauzi Gomez)
80%StarStarStarStarStar
than for sahring
6 years ago (Claudio DS)
75%StarStarStarStar
Good database class
10 years ago (j whitaker)
77%StarStarStarStar
Hello, i am unsing this class for all my systems und scripts,...
7 years ago (RHF)
80%StarStarStarStarStar
Great Class! :) it seems solid.
8 years ago (Giuseppe)
80%StarStarStarStarStar
Very good and solid class.
9 years ago (Vincent)
80%StarStarStarStarStar
Tanks Good class easy php + mysql
9 years ago (everton melo)
80%StarStarStarStarStar
Great MySQL-Wrapper!
9 years ago (Stefan Hepe)
80%StarStarStarStarStar
excellent mysql wrapper
10 years ago (Sarfraz Ahmed)
80%StarStarStarStarStar
thanks
10 years ago (Carlos Martins)
80%StarStarStarStarStar
Good work, excellent class
11 years ago (Johal)
77%StarStarStarStar
A very usefull MySQL wrapper Class
11 years ago (Walter Krause)
80%StarStarStarStarStar
the "if (MySQL::IsDate("20070127")) " always true.
11 years ago (cusson)
75%StarStarStarStar
perfect job !
11 years ago (gregg)
80%StarStarStarStarStar