OracleXE：PHP链接Oracle XE 简单语句

最新推荐文章于 2024-09-13 21:40:38 发布

chuyuan0129

最新推荐文章于 2024-09-13 21:40:38 发布

阅读量113

点赞数

文章标签：数据库 php 网络

原文链接：https://my.oschina.net/alkz/blog/3067900

版权

<?php
//本PHP小程序链接到本机oracle XE 服务器上，使用PDO_OCI链接到OracleXE
$tns = "
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XE)
)
)";
$db_username = "hr";
$db_password = "aking7";
try{
$conn = new PDO("oci:dbname=".$tns,$db_username,$db_password);

$sth = $conn->prepare('select * from person');
$sth->execute();

$result = $sth->fetchAll(PDO::FETCH_ASSOC);
echo '<pre>';
var_dump($result);
echo '</pre>';
}catch(PDOException $e){
echo ($e->getMessage());
}

转载于:https://my.oschina.net/alkz/blog/3067900