How to call stored procedure by using PHP and SQL Server 2008 -

i using sql server 2008 php. want call stored procedure in php.

please guide me.

regards

read mssql_execute()

$conn = mssql_connect($host, $user, $pass); mssql_select_db('somedb', $conn);  // call simple query $result = mssql_query('select * sometable', $conn);  // release result resource mssql_free_result($result);  // execute procedure $proc = mssql_init('some_proc', $conn); $proc_result = mssql_execute($proc);  // etc... mssql_free_statement($proc); 

edit

read odbc_exec()

$conn = odbc_connect("driver={sql server native client 10.0};server=$server;database=$database;", $user, $password); $exec = odbc_exec($conn, "call storedproc()"); 

and nice example php.net docs odbc_execute():

examples

example #1 odbc_execute() , odbc_prepare() example in following code, $success true if 3 parameters myproc in parameters:

$a = 1; $b = 2; $c = 3; $stmt    = odbc_prepare($conn, 'call myproc(?,?,?)'); $success = odbc_execute($stmt, array($a, $b, $c)); 

if need call stored procedure using inout or out parameters, recommended workaround use native extension database (for example, mssql ms sql server, or oci8 oracle).