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