PDO->sqliteCreateFunction()

Registers a User Defined Function for use in SQL statements ()

Example 2342. PDO::sqliteCreateFunction() example

copy to clipboard

<?php
function md5_and_reverse($string) 

{

    return strrev(md5($string));

}

$db = new PDO('sqlite:sqlitedb');
$db->sqliteCreateFunction('md5rev', 'md5_and_reverse', 1);
$rows = $db->query('SELECT md5rev(filename) FROM files')->fetchAll();
?>

Change Language

PDO_SQLITE DSN
PDO->sqliteCreateAggregate()
PDO->sqliteCreateFunction()