DB.php edits by Faguss

[faguss]

EDIT: I've changed this topic to be a list of things I've added instead of just about one function.

====

https://pastebin.com/Jp2EbDTw
Based on the version by @plb . My changes to his code are listed there.

30 - charset=utf8 added because of this issue

50 - results are cleaned before every query

195 - delete() won't work if argument is empty

204-221 - insert() can add multiple records

202, 223-232 - added optional argument for insert() so that it can update records on duplicate id

238 - column names are wrapped in grave accents in update()

239-252 - optionally condition array may be passed to update() instead of record id

265 - added optional argument for first() which works in the same way as for results() (aka returns array instead of an object). Also if there are no results the function will return empty array.

300-309 - added cell() for getting single field out of first record

[mudmin]

You can also do

$query->results(true) on your db query and it will create an array instead of an object

[faguss]

Let's talk about

Code:

results(true)

as well. Variables with results are now cleaned before every query so I can do this:

Code:

$array = $db->query($sql,$input)->results(true);

instead of:

Code:

$array = !$db->query($sql,$input)->error() ? $db->results(true) : [];

https://pastebin.com/Jp2EbDTw (line 50)

[faguss]

I should have started a more general thread. Instead, I'm repurposing this one. Anyway, there's a new function cell() for getting one field out of the first result. Examples:

Code:

$bio = $db->cell("profiles.bio",1);

Code:

if (isset($bio)) echo $bio;

Code:

$number = $db->cell("users.COUNT(*)",["TIMESTAMPDIFF(DAY,join_date,CURRENT_TIMESTAMP)","<",30]);

Code:

if (!empty($number)) echo "$number new user".($number!=1?"s":"")." recently";

[picassoo]

wow, nice... where you update your project ? can you send me or post the link pleasee ?

[faguss]

DB.php code is in the pastebin link: https://pastebin.com/Jp2EbDTw