1.查看php的位数
去http://pecl.php.net/package/oci8 php官方扩展库下载扩展
http://pecl.php.net/package/oci8/2.0.8/windows
php.ini中加入
extension=php_oci8.dll
extension=php_oci8_11g.dll
将extension=php_oci8_12c.dll;extension=php_pdo_oci.dll前面";"打开
2.下载oracle数据库客户端:
https://www.oracle.com/database/technologies/instant-client/downloads.html
放入固定位置后将路径加入 系统环境变量
重启php服务
3.pdo链接oracle数据库
$dsn_con="oci:dbname=//ip/数据库名称;charset=UTF8";
try{
$dbh= new \PDO($dsn_con,"数据库账号","数据库密码 ",array(\PDO::ATTR_PERSISTENT => true));
} catch (PDOException $e) {
print "oci: " . $e->getMessage() . "<br/>";
die();
}
$sql="select * from s_user";
$dbh->setAttribute(PDO::ATTR_CASE,PDO::CASE_LOWER);
$rs=$dbh->prepare($sql);
$rs->execute($array);
$rs->setFetchMode(PDO::FETCH_ASSOC);
$result_arr = $rs->fetchAll();
print_r($result_arr);
php链接oracle数据库
于 2024-02-20 10:40:25 首次发布