小弟现在有1个php连接mysql的页面,想转化为连接oracle的方式,希望与mysql的页面相类似,请高手们参考参考:php连接mysql:
<?php $db_server = "localhost";
$db_login = "root";
$db_password = "asd!@#";
$db_name = "baddut";
$con = mysql_connect($db_server, $db_login, $db_password);
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db($db_name, $con);
mysql_query("set names 'gb2312'");
?>
<?php $db_server = "localhost";
$db_login = "root";
$db_password = "asd!@#";
$db_name = "baddut";
$con = mysql_connect($db_server, $db_login, $db_password);
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db($db_name, $con);
mysql_query("set names 'gb2312'");
?>
if($dbconn!=false)
{
echo "连接成功"; if(OCILogOff($dbconn)==true)
{
echo "关闭连接成功!";//=这里有问题
}
}
else
{
echo "连接失败";
}
?>
用ODBC,oracle接口有时候不行。上面是用OCI接口的方法
$db_login = "store11";
$db_password = "store11";
$db_name = "oradnb";
$conn = odbc_connect($db_name,$db_login, $db_password ) or die("数据库服务器连接失败");
$sql="SELECT * FROM article where rownum<3";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
echo "<table><tr>";
echo "<th>Companyname</th>";
echo "<th>Contactname</th></tr>";
while (odbc_fetch_row($rs))
{
$compname=odbc_result($rs,"art_no");
$conname=odbc_result($rs,"descr");
echo "<tr><td>$compname</td>";
echo "<td>$conname</td></tr>";
}
odbc_close($conn);
echo "</table>";?>
WIN2003+ORACLE 817测试通过,其中odbc_connect()的第一个参数$db_name是通过“管理工具--数据源(ODBC)--系统DSN--添加”实现的
odbc_connect(“你所设置的系统DSN名称”,“用户名”,“密码”)