note 98110 added to sqlite3.createfunction

Since regular expression is not supported by default SQLite, we can create a user function to do the job. <?php $db = new SQLite3("database.sqlit3", 0666); // create a function named "preg_match" // with the php core function "preg_match" if ($db->createFunction("preg_match", "preg_match", 2) === FALSE) exit("Failed creating function\n"); // this query will then works as expected $result = $db->query("SELECT * FROM table1 WHERE preg_match('/^(apple|orange)$/', variable1)"); ?> ---- Server IP: 69.147.83.197 Probable Submitter: 202.81.253.15 ---- Manual Page -- http://www.php.net/manual/en/sqlite3.createfunction.php Edit -- https://master.php.net/note/edit/98110 Del: integrated -- https://master.php.net/note/delete/98110/integrated Del: useless -- https://master.php.net/note/delete/98110/useless Del: bad code -- https://master.php.net/note/delete/98110/bad+code Del: spam -- https://master.php.net/note/delete/98110/spam Del: non-english -- https://master.php.net/note/delete/98110/non-english Del: in docs -- https://master.php.net/note/delete/98110/in+docs Del: other reasons-- https://master.php.net/note/delete/98110 Reject -- https://master.php.net/note/reject/98110 Search -- https://master.php.net/manage/user-notes.php