Example: Using PHP3 to invoke a stored procedure for Microsoft SQL Server _php Tutorial

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 test database! ");
echo "

























"; echo " ";　　$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 " ";　　$i + +; } echo " "; while ($record =mssql_fetch_array ($rst)) {echo " ";　　 $i = 0;　　 while ($i < $fields _num) {$value = $record [$fields] [$i]]; if ($value = = "") echo " "; else echo " ";　　 $i + +; } echo " ";　　} mssql_free_result ($rst); echo "

". $fields [$i].　　 "
	" . $value. "

";
　　
Mssql_close ($server) or Die ("Cannot disconnect from the database server! ");
?>

http://www.bkjia.com/PHPjc/631832.html www.bkjia.com true http://www.bkjia.com/PHPjc/631832.html techarticle stored Procedure (procedure.sql): CREATE PROCEDURE Hello @yourname varchar (50) = nameless as Select @yourname +, Hello! Go PHP3 Program (PROCEDURE.PHP3):? $server = Mssql_connect ...

