2.11.1

• version bump

2.11.0

• the library can now log queries run via AJAX requests; see the newly added debug_ajax property
• debug information is now also shown when running in CLI (when debugging is enabled, of course)
• added a new debug_show_database_manager property for editing queries in your favorite database manager
• the "unsuccessful queries" tab is now open by default if there are any unsuccessful queries
• fixed #79 where the library would try to connect to the database even when using lazy connection because of the logic in the free_result method; thanks to Brian Hare for reporting!
• fixed an issue where having the debug property set to a string but debugging not being activated, would result in errors not being logged
• fixed bug where the library would try to EXPLAIN queries that could not be explained; like SHOW TABLE for example; see #76 - thank you cosinus90!
• fixed potential warnings being thrown in PHP 8; see #74 - thank you Rémi!
• fixed a potential issue when encountering connection errors
• updated the CSS and the icons for the debug interface

2.10.2

• fixed a deprecation warning shown in PHP 8.1+; see #70, thanks Harry
• fixed a potential bug with INC keyword being incorrectly detected in strings looking like INC(foo)
• fixed EXPLAIN not working in the debug console
• fixed debug console being always shown once enabled via string

2.10.1

• fixed bug introduced in previous release, for the implode method; see #65, thanks pbm845

2.10.0

• added option for enabling debugging on the fly via a query string parameter - see documentation
• added support for caching query results to a redis server
• the default value of disable_warnings is now FALSE
• updated German language; thanks to Bernhard Morgenstern!
• major documentation overhaul

2.9.14

• fixed bug with XSS in the debug console; see #62
• fixed incorrect handling of NULL values; see #60
• the global section in the debugging console can now be disabled or configured to show only specific subsections via the newly added debug_show_globals property; see #59
• fixed bug with setting the caching method to "memcache" but not having memcache properly set up, or setting up memcache but not having the caching method set to "memcache"
• minor layout updates for the debugging console

2.9.13

• fixed a bug where the library would incorrectly handle MySQL functions in certain scenarios
• fixed #57 where in PHP 7.4.0 a warning was shown about get_magic_quotes_gpc function being deprecated; thanks userc479 for reporting!
• added the return_error_number argument to the error() method
• added property auto_quote_replacements allowing to disable the library's default behavior of automatically quoting escaped values

2.9.12

• the insert_bulk method now supports INSERT IGNORE and INSERT...ON DUPLICATE KEY UPDATE; this fixes #42 and deprecates the insert_update method
• the insert method now also supports INSERT...ON DUPLICATE KEY UPDATE - this slightly changes the functionality of the method's 3rd agument but stays compatible with previous versions of the library
• fixed #47 where setting log_path property to a full path to a file with extension would not change the log file's name, as stated in the documentation
• fixed #37 where unsuccessful queries were not written to the log file
• fixed bug when the first argument for fetch_assoc_all and fetch_obj_all methods was skipped
• logs can now be handled via a custom callback function instead of being written to a log file, by setting the $log_path property; this answers #48
• changed output written to the log files which is now less verbose, cleaner and taking up less space
• dates in log files are now in Y-m-d format instead of Y M d
• changed how entries are separated in the log file
• updated minimum required PHP version from 5.2.0 to 5.4.0. This fixes #44

2.9.11

• fixed issue #43 where some strings were incorrectly detected as MySQL functions
• fixed issue #45 where the table_exists method was always returning true
• fixed issue #46 where the select_database was always returning false
• fixed issue #49
• fixed issue #50 where MySQL functions were incorrectly recognized
• source code improvements

2.9.10

• updated Russian translation; thanks @rayzru!
• fixed bug with MySQL functions not being properly handled by the select method when the columns argument was given as an array
• improved documentation for the select method
• fixed an issue that would trigger an error if other PHP scripts were including the SqlFormatter library
• added support for using the AS keyword in the columns argument for the select method. Fixes #34.