PHP Classes

Ultimate MySQL: MySQL database access wrapper

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 72%Total: 21,278 This week: 1All time: 30 This week: 41Down
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: 44
All time rank: 384 in United States United States
Week rank: 22 Up3 in United States United States Up
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 (6)  
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)

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:21,278
This week:1
All time:30
This week:41Down
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:174
 
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
16 years ago (j whitaker)
77%StarStarStarStar
Hello, i am unsing this class for all my systems und scripts,...
13 years ago (RHF)
80%StarStarStarStarStar
Great Class! :) it seems solid.
13 years ago (Giuseppe)
80%StarStarStarStarStar
Very good and solid class.
14 years ago (Vincent)
80%StarStarStarStarStar
Tanks Good class easy php + mysql
15 years ago (everton melo)
80%StarStarStarStarStar
Great MySQL-Wrapper!
15 years ago (Stefan Hepe)
80%StarStarStarStarStar
excellent mysql wrapper
15 years ago (Sarfraz Ahmed)
80%StarStarStarStarStar
thanks
16 years ago (Carlos Martins)
80%StarStarStarStarStar
Good work, excellent class
16 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