note 108073 added to sqlite3.querysingle
| From: | Sascha | Date: | Tue, 27 Mar 2012 07:06:05 +0000 |
| Subject: | note 108073 added to sqlite3.querysingle | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-186830@lists.php.net to get a copy of this message | ||
You ask, what this method is good for â it's just for convenience.
Compare these examples:
// readable, short, nice...
$name = $db->querySingle ("SELECT name FROM persons WHERE id = 1");
// well, ask yourself... :)
$res = $db->query ("SELECT name FROM persons WHERE id = 1");
$row = $res->fetchArray (SQLITE3_NUM);
$name = $row [0];
// a bit shorter, but even not the optimal way
$res = $db->query ("SELECT name FROM persons WHERE id = 1");
list ($name) = $res->fetchArray (SQLITE3_NUM);
----
Server IP: 85.214.154.209
Probable Submitter: 212.91.252.75
----
Manual Page -- http://www.php.net/manual/en/sqlite3.querysingle.php
Edit -- https://master.php.net/note/edit/108073
Del: integrated -- https://master.php.net/note/delete/108073/integrated
Del: useless -- https://master.php.net/note/delete/108073/useless
Del: bad code -- https://master.php.net/note/delete/108073/bad+code
Del: spam -- https://master.php.net/note/delete/108073/spam
Del: non-english -- https://master.php.net/note/delete/108073/non-english
Del: in docs -- https://master.php.net/note/delete/108073/in+docs
Del: other reasons-- https://master.php.net/note/delete/108073
Reject -- https://master.php.net/note/reject/108073
Search -- https://master.php.net/manage/user-notes.php