v5:reference:connection:inparameter
This is an old revision of the document!
inParameter
Syntax
void inParameter( resource &$statementt, string &$var, string $name, int $maxLen=4000, mixed $type=false )
Description
The function inParameter()
sets an input parameter for a stored procedure. The $statement variable must be a handle to a stored procedure accessed via the prepareSp() method.
Parameters
$statement
A handle to a stored procedure.
$var
The value of the input parameter.
$name
The name of the input parameter.
$maxLen
(optionally) The length of the value. If not assigned then the length is automatically assigned.
$type
(optionally the field type. If not assigned then the type is automatically determined.
Usage
/* * Connection to Oracle database */ $cat = 'Dairy Products'; $yr = '1998'; $stmt = $db->prepareSp('SalesByCategory'); $db->inParameter($stmt,$cat,'CategoryName'); $db->inParameter($stmt,$yr,'OrdYear'); $rs = $db->execute($stmt);
v5/reference/connection/inparameter.1439863513.txt.gz · Last modified: 2017/04/21 11:34 (external edit)