DB.php patch - error handling, flexible WHERE clauses, fix bug

[faguss]

I'm not sure what you mean because UserSpice already has functions

Code:

update()

,

Code:

insert()

, and

Code:

delete()

. See documentation.

It's not called ADD but INSERT and it doesn't have a WHERE clause. See SQL tutorial.

===

With this patch you can already use nested triads for

Code:

delete()

. For example:

Code:

$db->delete("Products", ["or", ["Stock","<=",0], ["Legal","=",false]]);

I've noticed that the query is still being run even if the argument was incorrect. This is also the case with the original DB.php. For example:

Code:

delete("Products",NULL)

is going to clear the table. To fix it I've added an error flag. Lines 86-91, 98, 159, 186 in my paste.

Passing empty array is now prohibited (line 195).

===

Statement UPDATE uses WHERE clause so I might as well implement triads. Lines 239-253 in my paste. Now you can do this:

Code:

$db->update("Suppliers", ["Country","=","Greece"], ["Currency"=>"GRD"]);