php引入odbc模块,php如何用odbc调用存储过程？

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

//网上的例子

//存储过程-------------------

create proc MyStoredProc

@MyOutputValue int output

as

set @MyOutputValue = 5

//php语言-----------------------

test.php

$server = 'myservername';

$database = 'mydatabasename';

$username = 'myusername';

$password = 'mypassword';

$connection = odbc_connect("Driver={SQL Server};Server=192.168.11.107;Database=Northwind;",'sa','sa');

/*

$connection_string =

'DRIVER={SQL SERVER};SERVER=' . $server . ';DATABASE=' . $database;

$connection = odbc_connect($connection_string, $username, $password);

*/

$sql = "BEGIN ";

$sql .= " declare @MyOutputValue int ";

$sql .= " execute MyStoredProc @MyOutputValue output select @MyOutputValue ";

$sql .= "END ";

echo '

' . chr(13);

echo '

echo '

';

echo '

Valor';

echo '

';

$query = odbc_exec($connection, $sql);

while(odbc_fetch_row($query))

{

echo '

' . chr(13);

// "odbc_result" = "FieldByNumber(Index)",

// "Index" starts with 1 not 0 !!! :

$returnvalue = odbc_result($query, 1);

echo '

' . $returnvalue . '';

echo '

' . chr(13);

echo chr(13);

}

echo '

' . chr(13);

echo '

' . chr(13);

odbc_free_result($query);

odbc_close($connection);

/*

$callstore = odbc_exec($conn, "{CALL procedurename('" . $para1 . "','" . $para2 . "',1,'125478')}");

odbc_fetch_row($callstore);

$returnmessage = odbc_result($callstore,1);

echo $returnmessage;

*/

?>