Example: Use PHP3 to call the stored procedure of Microsoft SQL Server

Stored procedure (procedure. SQL ):
Create procedure hello
@ Yourname varchar (50) = "No Name"
As
Select @ yourname + ", hello! "
Go
PHP3 Program (procedure. php3 ):
<?
$ Server = mssql_connect ("localhost", "sa", "") or die ("unable to connect to the database server! ");
$ Db = mssql_select_db ("test", $ server) or die ("cannot connect to the test database! ");
Echo "<table border =" 1 "cellspacing =" 0 "cellpadding =" 0 "> ";
Echo "<tr> ";
$ Query = "exec hello @ yourname =" friend "";
$ Rst = mssql_query ($ query, $ db) or die ("unable to execute SQL: $ query ");
$ Fields_num = mssql_num_fields ($ rst );
$ I = 0;
While ($ I <$ fields_num ){
$ Fields [$ I] = mssql_field_name ($ rst, $ I );
Echo "<th>". $ fields [$ I]. "</th> ";
$ I ++;
}
Echo "</tr> ";
While ($ record = mssql_fetch_array ($ rst )){
Echo "<tr> ";
$ I = 0;
While ($ I <$ fields_num ){
$ Value = $ record [$ fields] [$ I];
If ($ value = "")
Echo "<td> </td> ";
Else
Echo "<td>". $ value. "</td> ";
$ I ++;
}
Echo "</tr> ";
}
Mssql_free_result ($ rst );
Echo "</table> ";
　　
Mssql_close ($ server) or die ("unable to disconnect from the database server! ");
?>