Buatlah file koneksi oracle
<?php
$username=""; //Nama user sama dengan skema di oracle
$password=""; //Password sama dengan skema di oracle
$database="localhost/XE"; //localhost bisa di isi dengan IP adress
$koneksi=oci_connect($username,$password,$database);
if($koneksi){
echo "";
}else{
$err=oci_error();
echo "Gagal tersambung ke ORACLE". $err['text'];
}
?>
Buatlah file pencariannya
!-- form quick search -->
<form name="form1" method="get" action="">
Search : <input type="text" name="q" id="q"/> <input type="submit" value="Search"/>
</form>
<!-- menampilkan hasil pencarian -->
<html>
<title> PHP Oracle</title>
<h1>Demo menampilkan data dari <br>
database Oracle ke halaman web
</h1>
<?php
if(isset($_GET['q']) && $_GET['q']){?>
include("ocicon.php");
$q = $_GET['q'];
$query="select * from USERAPLIKASI where IDUSER like '%$q%' or
NOMORPOKOK like '%$q%' or
NAMA like '%$q%' or
TELP like '%$q%' or
HP like '%$q%'
";
$statemen=oci_parse($koneksi,$query);
oci_execute($statemen);
<table border="1">
<tr>
<td>ID USER</td></tr>
<td>Nomor Pokok</td>
<td>Nama</td>
<td>Telp</td>
<td>HP</td>
<?php
while($baris=oci_fetch_assoc($statemen))?>
{
<tr>
<td><?php echo $baris['IDUSER'];?></td><?php
<td><?php echo $baris['NOMORPOKOK'];?></td>
<td><?php echo $baris['NAMA'];?></td>
<td><?php echo $baris['TELP'];?></td>
<td><?php echo $baris['HP'];?></td>
</tr>
}
oci_free_statement($statemen);?>
oci_close($koneksi);
}else{
echo 'Data not found!';
}
</table>
</html>
Hasilnya :
Search Data Pada PHP Oracle
![Search Data Pada PHP Oracle]()
Reviewed by Bank Ifoel
on
November 26, 2004
Rating:
No comments: