gerhobbelt / ultimatemysql

work based on http://www.phpclasses.org/package/3698-PHP-MySQL-database-access-wrapper.html

ultimatemysql

work based on http://www.phpclasses.org/package/3698-PHP-MySQL-database-access-wrapper.html

Ultimate MySQL Wrapper Class for PHP 5.x

Contributions from

• Frank P. Walentynowicz
• Larry Wakeman
• Nicola Abbiuso
• Douglas Gintz
• Emre Erkan
• Vincent van Daal
• Xander Groesbeek (SQLValue:int quoting; QueryArray tweak)
• Ger Hobbelt

Features

• Establish MySQL server connections easily
• Execute SQL queries
• Retrieve query results into objects or arrays
• Retrieve the last inserted ID
• Manage transactions (transaction processing)
• Retrieve the list tables of a database
• Retrieve the list fields of a table (or field comments)
• Retrieve the length or data type of a field
• Measure the time a query takes to execute
• Display query results in an HTML table
• Easy formatting for SQL parameters and values
• Generate SQL Selects, Inserts, Updates, and Deletes
• Error handling with error numbers and text
• And much more!

License

Free (MIT license)

ultimatemysql's Issues

Not working with 8.1

Hi, I'm getting an error in PHP 8.1 - do you have an update that might work with later versions of PHP?

mod_fcgid: stderr: PHP Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in /home/miklos/public_html/qdb/Class/MySQL.class.php:2148

Switch to mysqli functions

Hi there!

Any chance we can see an update where the mysqli_* functions are used, instead of the deprecated mysql_* functions?

An old version of this class is used in one of the projects I am working on and I would like to upgrade, as first user feedback is coming in regarding deprecation warnings in logfiles.