ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:preparesp

prepareSp

Support for this function is limited. See the Feature Comparison 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.txt · Last modified: 2016/11/02 12:45 by dregad