PHP to Store Procedure in MSSQL

[mokshi]

I have to pass two values to sp first value is nvarchar and second value is Int in SQL server,but i am not getting values, is my code is correct.Please help me out

    $query = mssql_init("courseofferedbyprof", $dbhandle); 
                    mssql_bind($query,"@facultyID",&$facname,SQLVARCHAR,false,false,50);
                    mssql_bind($query,"@count",&$year,SQLINT2,false,false,50);
                    $result=mssql_execute($query);

[ryantroop]

I suppose a simple question is can you actually connect and run anything using the mssql commands? It's been a while for sure, but last time I did PHP to mssql I had to go through ODBC...

[diafol]

I think there's a direct driver.

http://php.net/manual/en/book.mssql.php

http://php.net/manual/en/book.sqlsrv.php

PDO work?

Example: http://stackoverflow.com/questions/21466503/calling-stored-procedure-from-php-using-pdo-to-mssql-server-using-input-paramter