PHP Classes

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 (78)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 72%Total: 21,272 This week: 2All time: 30 This week: 40Down
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

Picture of Jeff Williams
  Performance   Level  
Name: Jeff Williams <contact>
Classes: 7 packages by
Country: United States United States
Age: 43
All time rank: 384 in United States United States
Week rank: 22 Up4 in United States United States Equal
Innovation award
Innovation award
Nominee: 1x

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

  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,272
This week:2
All time:30
This week:40Down
User Ratings User Comments (16)
 All time
Utility:92%StarStarStarStarStar
Consistency:89%StarStarStarStarStar
Documentation:87%StarStarStarStarStar
Examples:87%StarStarStarStarStar
Tests:-
Videos:-
Overall:72%StarStarStarStar
Rank:180
 
Very useful class, thanks
8 years ago (Migliori)
80%StarStarStarStarStar
very nice work.
10 years ago (Ashok kumar kashyap)
80%StarStarStarStarStar
Excellent class, make database manipulation extremely easy.
10 years ago (Fauzi Gomez)
80%StarStarStarStarStar
than for sahring
11 years ago (Claudio DS)
75%StarStarStarStar
Good database class
15 years ago (j whitaker)
77%StarStarStarStar
Hello, i am unsing this class for all my systems und scripts,...
12 years ago (RHF)
80%StarStarStarStarStar
Great Class! :) it seems solid.
12 years ago (Giuseppe)
80%StarStarStarStarStar
Very good and solid class.
14 years ago (Vincent)
80%StarStarStarStarStar
Tanks Good class easy php + mysql
14 years ago (everton melo)
80%StarStarStarStarStar
Great MySQL-Wrapper!
14 years ago (Stefan Hepe)
80%StarStarStarStarStar
excellent mysql wrapper
15 years ago (Sarfraz Ahmed)
80%StarStarStarStarStar
thanks
15 years ago (Carlos Martins)
80%StarStarStarStarStar
Good work, excellent class
15 years ago (Johal)
77%StarStarStarStar
A very usefull MySQL wrapper Class
16 years ago (Walter Krause)
80%StarStarStarStarStar
the "if (MySQL::IsDate("20070127")) " always true.
16 years ago (cusson)
75%StarStarStarStar
perfect job !
16 years ago (gregg)
80%StarStarStarStarStar