ezsql icon indicating copy to clipboard operation
ezsql copied to clipboard

PHP class to make interacting with a database ridiculusly easy

Results 5 ezsql issues
Sort by recently updated
recently updated
newest added

``` $CTasks = $db->get_results("SELECT * FROM a_table WHERE a_id LIKE '921j0jd2' AND p_id LIKE '' ORDER BY execution_order"); $NoTasks = $db->num_rows; echo "Number of Tasks to start: {$NoTasks}"; ``` This...

**Describe the bug** upon upgrade to php 8.0, you will get several deprecated function errors and warnings: Deprecated: Required parameter $fromTable follows optional parameter $totable in vendor/ezsql/ezsql/lib/ezFunctions.php on line 324...

warning-bug
error-bug

Update `_isNULL` and `_notNULL` constants to allow checks to run correctly. Discovered that the `isNull` and `isNotNull` where conditions were not firing correctly due to incorrectly declared constants.

I'm probably missing something out, but the query is simple and the row is correctly inserted into the db. I installed it with composer ezsql/ezsql on windows, xampp, php 8.1.4...

warning-bug
error-bug

There are still a lot of deprecation warnings with PHP 8.4 which I'm documenting here. If I find the time, I might create a PR myself later this week. [deprecation_warnings.txt](https://github.com/user-attachments/files/23299637/deprecation_warnings.txt)