例子:用PHP3调用Microsoft SQL Server的存储过程
类别: PHP教程
存储过程(procedure.sql):
create procedure hello
@yourname varchar(50) = "无名士"
as
select @yourname + ",你好!"
go
PHP3程序(procedure.php3):
<?
$server = mssql_connect("localhost","sa","") or die("无法连接数据库服务器!");
$db = mssql_select_db("test",$server) or die("无法连接test数据库!");
echo "<table border=/"1/" cellspacing=/"0/" cellpadding=/"0/">";
echo "<tr>";
$query = "exec hello @yourname=/"朋友/"";
$rst = mssql_query($query,$db) or die("无法执行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("无法与数据库服务器断开连接!");
?>
create procedure hello
@yourname varchar(50) = "无名士"
as
select @yourname + ",你好!"
go
PHP3程序(procedure.php3):
<?
$server = mssql_connect("localhost","sa","") or die("无法连接数据库服务器!");
$db = mssql_select_db("test",$server) or die("无法连接test数据库!");
echo "<table border=/"1/" cellspacing=/"0/" cellpadding=/"0/">";
echo "<tr>";
$query = "exec hello @yourname=/"朋友/"";
$rst = mssql_query($query,$db) or die("无法执行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("无法与数据库服务器断开连接!");
?>
-= 资 源 教 程 =-
文 章 搜 索