오라클접속테스트

오라클접속

<?php

$dbuser="user";

$dbpass="password";

$dbsid = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=아이피주소) (PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=WWW)))";

$conn = oci_connect($dbuser,$dbpass,$dbsid);

if(!$conn) {

  echo "No Connection ".oci_error();

  exit;

} else {

 echo "Connect Success!";

}

$query = 'select * from dual';

$stmt = oci_parse($conn,$query);

oci_execute($stmt);

while($row = oci_fetch_assoc($stmt))

{

    print_r($row);

}

// 오라클 접속 닫기

oci_free_statement($stmt);

// 오라클에서 로그아웃

oci_close($conn);

?>

KO16MSWIN949

AL32UTF8

인코딩문제

http://lkrox.blogspot.com/2014/01/oracle-utf-8.html