note 109677 added to pdo.sqlitecreatefunction
| From: | RoboTamer | Date: | Wed, 08 Aug 2012 10:50:24 +0000 |
| Subject: | note 109677 added to pdo.sqlitecreatefunction | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-189963@lists.php.net to get a copy of this message | ||
groups looks like this '1,2,3,999'
<?php
/**
* int strpos ( string $haystack , mixed $needle [, int $offset = 0 ] )
*/
$dbUser = new PDO('sqlite:'.ROOT.'/var/db/users.db3');
$dbUser->sqliteCreateFunction('strpos', 'strpos', 2);
$sql = 'SELECT username FROM users WHERE strpos(groups,",2,");';
$rows = $dbUser->query($sql)->fetchAll(PDO::FETCH_ASSOC);
print_r($rows);
?>
----
Server IP: 182.18.132.21
Probable Submitter: 72.197.36.72
----
Manual Page -- http://www.php.net/manual/en/pdo.sqlitecreatefunction.php
Edit -- https://master.php.net/note/edit/109677
Del: integrated -- https://master.php.net/note/delete/109677/integrated
Del: useless -- https://master.php.net/note/delete/109677/useless
Del: bad code -- https://master.php.net/note/delete/109677/bad+code
Del: spam -- https://master.php.net/note/delete/109677/spam
Del: non-english -- https://master.php.net/note/delete/109677/non-english
Del: in docs -- https://master.php.net/note/delete/109677/in+docs
Del: other reasons-- https://master.php.net/note/delete/109677
Reject -- https://master.php.net/note/reject/109677
Search -- https://master.php.net/manage/user-notes.php