PHP mySQL Database Wrapper Class
PHP mySQL Database Wrapper Class provides a set of methods for interacting with a MySQL database easily and securely. Most of the methods are extended versions of PHP's native functions, but providing a lot more functionality and powerful debugging features. There are also new methods that greatly simplify the process of executing specific queries like returning specific rows or even single values from specific rows, SUM(), COUNT(), and MAX() queries. Starting with version 1.0.9, the class also supports caching.
| Tags | Software Development Libraries php classes |
|---|---|
| Operating Systems | OS Independent |
| Implementation | PHP |
Recent releases
- 01 Apr 2008 06:38
Changes: A full backtrace was added for each query. This is a full list of the file, line, and method that lead to the execution of each specific query. The highlighter is now a bit smarter and it does not highlight keywords in strings. More accurate reporting of queries being run multiple times. Error reporting was improved for cases of not being able to connect to the MySQL server or select a database. An issue with the style sheet file that caused the debug window to position according to the host application's style sheet was fixed. Some new methods were added. optimize() automatically optimizes tables that have overhead. A few minor bugs were fixed.
- 03 Dec 2007 11:04
Changes: This release fixes a bug in the close() method. The debug window will now inform you if you haven't explicitly closed the connection with the close() method. There are some documentation refinements.
- 17 Sep 2007 10:47
Changes: Calling on a fetch method and providing a result resource from a query whose result was taken from cache would send the script into an infinite loop. The speed of the dlookup() method has been improved by adding LIMIT to it. New methods close(), log_debug_info(), and seek() (an alias of mysql_data_seek() that works seamlessly with cached results). Some documentation refinements. A completely rewritten template file and stylesheet. A version with the comments stripped out is also available, and is almost 4 times smaller than the original script.
- 30 May 2007 09:04
Changes: The result of select queries can now be cached. All records returned by SELECT queries were shown in the debug window, which would crash the script if there were lots of rows. The "showMaxRows" allows you to restrict this number. A bug when working with queries using replacements and having apostrophes in the replacements was fixed. Due to a typographical error, no error message was shown if a database could not be selected. New methods were added: "delete", "truncate", "insert", and "update" which are all shorthand for performing the respective SQL tasks.
- 30 Jan 2007 14:25
Changes: A bug when working with queries using replacements, and having question marks in the replacements has been fixed. You no longer have to specify anymore the _FILE__ and __LINE__ magic constants; the class now relies on the debug_backtrace() PHP function to get where the methods are called from. A new "fetch_obj" method is an alias of MySQL's mysql_fetch_object function. Warnings of the same query being run multiple times were incorrectly being displayed.
