ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:preparesp

This is an old revision of the document!


prepareSp

Support for this function is limited. See the feature compatibility matrix

See Also

prepare

Syntax
mixed prepareSp (
    string $procedureName
)

Description

The function prepareSP() accesses an existing stored procedure. If the stored procedure is valid the function return a resource otherwise it returns false.

PrepareSp Correct Usage

prepareSp should only be used with database drivers that support direct access to the procedures. It should not be passed an SQL statement that might access the procedure so, assuming a stored procedure PROC_LIST exists, the statement:

$db->prepareSp('PROC_LIST') 

is correct, however

 $db->prepareSp('CALL PROC_LIST')

is not.


Usage

/*
 * Connection to SQL Server database
*/
 
/*
 * Accessing an existing stored procedure called kmnProc
 */
$stmt = $db->PrepareSP('kmnProc');
$val1 = 'ADMIN';
$par1 = 'users';
$db->InParameter($stmt,$val1,$par1);
$db->OutParameter($stmt,$ret,'RETVAL');
v5/reference/connection/preparesp.1452991319.txt.gz · Last modified: 2017/04/21 11:33 (external edit)