Example: A stored procedure that invokes Microsoft SQL Server with PHP3

server| stored procedure stored procedure (PROCEDURE.SQL):
CREATE PROCEDURE Hello
@yourname varchar (50) = "No celebrities"
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 ("Unable to 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 ("Cannot 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!") ");
?>