Function Module
Function Module – Module to handle SQL function abstraction
Description
The Function module provides methods for executing non-standard SQL database functions in a consistent way. The following document lists the available methods, providing examples of their use. To include the Function module functionality, you need to load it first.
Loading the Function module
<?php
require_once 'MDB2.php';
$dsn = 'pgsql://someuser:apasswd@somehost';
$mdb2 =& MDB2::factory($dsn);
if (PEAR::isError($mdb2)) {
die($mdb2->getMessage());
}
// loading the Function module
$mdb2->loadModule('Function');
?>
After including the module, you can access its methods like this:
Get the length of a string expression
<?php
// PHP5
$mdb2->length('expression');
// PHP4 and PHP5
$mdb2->function->length('expression');
?>
Further in the document the PHP5-compatible way will be used.
Concatenate strings
<?php
$mdb2->concat('string1', 'string2');
?>
Execute a Stored Procedure
Supposing we have the following Stored Procedure (MySQL syntax):
DELIMITER //
CREATE PROCEDURE procedure1 (IN parameter1 INTEGER)
BEGIN
DECLARE variable1 CHAR(10);
IF parameter1 = 17 THEN
SET variable1 = 'birds';
ELSE
SET variable1 = 'beasts';
END IF;
INSERT INTO table1 VALUES (variable1);
END
//
DELIMITER ;
we can call it this way:
Execute a Stored Procedure
<?php
$params = array(17);
$mdb2->executeStoredProc('procedure1', $params);
?>