developer's diary

最近はc#のエントリが多いです

PHP 5.2.14でoracle10gに接続

PHPの設定(php.ini)

extension_dir = "./"
extension=php_pdo.dll
extension=php_pdo_oci.dll

ソース(C:\oracle_test.php)

<?php
$user = "";
$password = "";
$tns = "";
$db = new PDO("oci:dbname=".$tns, $user, $password);
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$stmt = $db->prepare("SELECT SYSDATE FROM DUAL ");
$stmt->execute();
if($row = $stmt->fetch(PDO::FETCH_ASSOC)){
	echo $row['SYSDATE'];
}

結果

C:\>php oracle.php
10-08-18