日期:2014-05-17  浏览次数:20429 次

这句PHP操作MYSQL的代码要怎么改才能操作ORACLE?
$sql1= "select   *   from   s_sblb ";
  $rst1=mysql_query($sql1);
  $ar=mysql_num_rows($rst1);

现在要改成ORACLE的,其中的两个函数要怎么改?谢谢

------解决方案--------------------
http://cn.php.net/manual/zh/ref.oci8.php

建议你用ADODB
------解决方案--------------------
$sql= "select * from s_sblb ";
$result=OciParse($DBCONN,$sql);
ociexecute($result);

while (OciFetchInto ($result, &$arr))
{
$js = ' <script language= "JavaScript "> ShowTree(0, "+$arr[0]+ "); </script> ';
echo $js;
echo "$arr[0] ";
}