Release notes from ezsql

5.1.2

2025-10-30T14:13:24Z

What's Changed

Example usage fixed by @if3lc in #221
Fix Error: Uncaught TypeError: Argument 1 passed by @kazimolmez in #223
Update Constants.php by @dpDesignz in #213
Fix reference to argument in closure for params by @zag2me in #225

New Contributors

@if3lc made their first contribution in #221
@kazimolmez made their first contribution in #223
@zag2me made their first contribution in #225

Full Changelog: 5.1.1...5.1.2

5.1.1

2021-02-22T20:29:58Z

update version, removed unrelated methods from ezQuery class to globa…

…l functions only

- added/tested two additional security related functions, `is_traversal` and `sanitize_path` to go along with `clean_string`

minor bc, update docs/doc-blocks, new functions

2021-02-20T01:24:19Z

renamed cleanInput to clean_string
renamed createCertificate to create_certificate
added global get_results to return result sets in different formats
added alter, altering shortcuts to modify table columns
tests/code coverage updates
many docs/doc-blocks corrections

new version, major breacking changes, updated docs/doc-blocks

2021-02-16T19:48:12Z

The use of namespace in the global functions ezFunctions.php file.
Usage of the global functions will require the user to begin a .php file something like:

use function ezsql\functions\where;
// Or
use function ezsql\functions\{
    getInstance,
    selecting,
    inserting,
};

Class properties that was accessible by magic methods get/set, now PSR 1 camelCase.
update class libraries and tests to match PSR 1, but still backwards with previous way.
Renamed select of ez_mysqli to dbSelect.
Renamed class method and behavior of selecting to select.
selecting, and new inserting methods, can be called without table name, only the other necessary parameters:
- The table name with prefix, can be preset/stored with methods tableSetup(name, prefix), or setTable(name), setPrefix(append), if called without presetting, false is returned.
- This feature will be added to all database CRUD access methods , each method name will have an ing ending added.
Removed global functions where table name passed in, use functions as outlined above using preset table names ending with ing.

Updates for PHP 8 compatibility, add GitHub Actions for macOS CI, doc-block fixes/updates

2021-02-12T00:09:44Z

some unknown phpunit configuration issue causing macOS CI error, otherwise test passes
unable to include Microsoft Sql Server, docker throws:
Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?

Code cleanup, refactor for PHP 8 compatibility, and bug fixes discovered in doing so

2021-02-08T18:27:45Z

bug fixes, prior to PHP 8, **@** silenced errors which this library used to return **false** instead, that is not no longer possible with PHP 8
Linux and Windows CI tests move to GitHub Actions
General code style fixes
merged bug fix #199
fixed tests in issue #200, and corrections for PR #201

Added features, and bug fixes

2020-04-27T02:29:13Z

merged #183 fixes exhausting memory issue
merged #185 where() was not handling additional _OR conditions
merged #186 added feature where() conditional grouping()

4.0.9: Merge pull request #180 from dpDesignz/table-joins

2020-02-02T13:01:13Z

Merge pull request #180 from dpDesignz/table-joins

fixBug: Conditional Stacked Functions in selecting

4.0.8: Merge pull request #170 from dpDesignz/master

2019-08-31T01:43:20Z

Merge pull request #170 from dpDesignz/master

continue fixBug: Error when trying to use $db->vardump()

4.0.7: Merge pull request #166 from dpDesignz/master

2019-08-19T17:08:37Z

bug fix #163
added debugOn() and debugOff() methods for simpler way to turn On/Off echoing output for varDump()