http://rohmad.net/2008/07/24/contoh-koneksi-dari-php-ke-oracle/
Dalam artikel ini saya akan membahas bagaimana membuat koneksi dari PHP ke database Oracle. Dalam contoh, saya akan menampilkan view DBA_USERS ke halaman PHP.
Berikut ini source code-nya:
SID = EMREP Username = system Password = systempasswd ORACLE_HOME = /oracle/9.2.0 Query = select username,default_tablespace, temporary_tablespace,account_status, profile from dba_users order by username;Hasilnya nanti akan seperti ini
Berikut ini source code-nya:
<HTML>
<HEAD>
<TITLE>Tablespace</TITLE>
</HEAD>
<BODY TEXT="#000080">
<H1>Current Tablespace Utilization</H1>
<HR>
Query: <? echo (date("d-F-Y h:i A ")); ?>
<BR>
<BR>
<?
$ORACLE_SID = getenv("ORACLE_SID");
$ORACLE_HOME = getenv("ORACLE_HOME");
$user="system";
$pass="systempasswd";
$sid="EMREP";
$tns_name="/oracle/9.2.0/network/admin/tnsnames.ora";
$c1 = ociplogon($user, $pass, $sid, $tns_name);
if ($c1 == false){
echo OCIError($c1)."<BR>";
exit;
}
echo ("<TABLE BORDER=1>");
echo ("<TH BGCOLOR=#99CCCC>User Name</TH>");
echo ("<TH BGCOLOR=#99CCCC>Default Tablespace</TH>");
echo ("<TH BGCOLOR=#99CCCC>Temporary Tablespace</TH>");
echo ("<TH BGCOLOR=#99CCCC>Account Status</TH>");
echo ("<TH BGCOLOR=#99CCCC>Profile</TH>");
$query = "select username,default_tablespace,";
$query .= "temporary_tablespace,account_status,";
$query .= "profile from dba_users order by username";
$stmt = OCIparse($c1,$query);
OCIexecute($stmt,OCI_DEFAULT);
while (OCIfetchInto($stmt,&$userinfo)) {
?>
<TR>
<TD ALIGN="left"><? echo $userinfo[0]; ?></TD>
<TD ALIGN="right"><? echo $userinfo[1]; ?></TD>
<TD ALIGN="right"><? echo $userinfo[2]; ?></TD>
<TD ALIGN="right"><? echo $userinfo[3]; ?></TD>
<TD ALIGN="right"><? echo $userinfo[4]; ?></TD>
</TR>
<?} // endwhile
OCIFreeStatement($stmt);
OCILogoff($c1);
//}
?>
</BODY>
</HTML>
Tidak ada komentar:
Posting Komentar