当前位置:首页> PHP教程> PHP&MYSQL
关键字
文章内容
用PHP3调用MicrosoftSQLServer的存储过程
 
 
修改时间:[2012/04/01 16:43]    阅读次数:[485]    发表者:[起缘]
 
存储过程(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("无法与数据库服务器断开连接!");

  ?&