dwioentariyono: Latihan PHP dengan Oracle

http://www.scribd.com/doc/23801302/Modul-Php-Oracle

Latihan-1:
-------------------------------------------------

<?php
echo "<h1>Welcome to PHP Programming!</h1>";
?>

Latihan-2:
-------------------------------------------------

<?php
$username="anju";
$password="anju";
$dbname="localhost/XE";
$c=oci_connect($username, $password, $dbname);
if (!$c) {
echo "Koneksi ke server database gagal dilakukan";
exit();
}else{
echo "Koneksi ke server database sukses";
}
?>

Latihan-3a:
-------------------------------------------------

<?php
$db_conn= ocilogon("anju","anju","XE");
$query = "SELECT * FROM BUKU";
$parsed = ociparse($db_conn, $query);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);
for ($i=0; $i<$nrows; $i++) {
echo " ".$results ["BUKU_ISBN"][$i]." ";
echo " ".$results ["BUKU_JUDUL"][$i]." ";
echo " ".$results ["BUKU_JMLHALAMAN"][$i].""; }
?>

Latihan-3b:
-------------------------------------------------

<html>
<head>
<title> PHP Oracle</title>
</head>
<body>
<h2>Demo menampilkan data dari database ke halaman web</h2>
<?php
include("oraconn.php");

$query="select
buku_isbn,
buku_judul,
buku_jmlhalaman
from buku order by buku_isbn";
$statemen=oci_parse($c,$query);
oci_execute($statemen);
echo"<p>query: $query</p>";
echo"<p><strong>hasil query:</strong></p>";
while($baris=oci_fetch_array($statemen))
{

echo $baris['BUKU_ISBN'].
" - ".
$baris['BUKU_JUDUL'].
" - ".
$baris['BUKU_JMLHALAMAN'].
"<br/>";
}
oci_free_statement($statemen);
oci_close($c);
?>
</body>
</html>

Latihan-3C:
----------------------------------------------------------

<?php
include("oraconn.php");

echo"Daftar Buku<hr><p></p>
<table border=1 cellpadding=4 cellspacing=0>
<tr bgcolor='#ccc'><td>ISBN</td><td>Title</td><td>Jml_Halaman</td></tr>";

$query="select * from BUKU order by BUKU_ISBN";

$statmen=oci_parse($c,$query);
oci_execute($statmen,OCI_DEFAULT);

while($data=oci_fetch_array($statmen,OCI_BOTH)){
echo"<tr><td>".$data['BUKU_ISBN']."</td><td>".$data['BUKU_TITLE']."</td><td>".$data['BUKU_JMLHALAMAN']."</td></tr>";
}

echo"</table>";

oci_free_statement($statmen);
oci_close($c);
?>

Latihan-4:
----------------------------------------------------------

<?php
//$c=oci_connect("anju","anju","XE");
include("oraconn.php");
echo"MASTER USER <hr><p></p>";

//if($_GET['menu']=='')
$vMenu=$_GET['menu'];
if ($vMenu=='')
{

echo"<a href='?menu=tambah_data'><input type=submit value='Tambah'></a><p></p>
<table border=1 cellpadding=4 cellspacing=0>
<tr bgcolor='#ccc'><td>ID</td><td>Nama</td><td>Company</td><td>Channel</td><td>Level</td><td>Password</td><td>Edit</td><td>Hapus</td></tr>";

$query="select * from tb_user";

$statmen=oci_parse($c,$query);
oci_execute($statmen,OCI_DEFAULT);
while($data=oci_fetch_array($statmen,OCI_BOTH)){
echo"<tr><td>".$data['ID_USER']."</td><td>".$data['NAMA_USER']."</td><td>".$data['COMPANY_USER']."</td><td>".$data['CHANNEL_USER']."</td><td>".$data['LEVEL_USER']."</td><td>".$data['PASSWORD_USER']."</td><td><a href='?menu=edit&id=$data[ID_USER]'>edit</a></td><td><a href=\"aksi.php?act=hapus_data&id=$data[ID_USER]\" onclick=\"return confirm('Yakin Mau Hapus $data[NAMA_USER]??')\"'>Hapus</a></td></tr>";
}

echo"</table>";

oci_free_statement($statmen);

}
//if($_GET['menu']=='edit'){
if ($vMenu=='edit'){
$sql="select * from TB_USER where id_USER='$_GET[id]'";
$statment=oci_parse($c,$sql);
oci_execute($statment,OCI_DEFAULT);
$data=oci_fetch_array($statment);
echo"
<form method=POST action='aksi.php?act=edit_data'>
<input type=hidden name='id_ubah' value='$data[ID_USER]'>
<table border=1 cellpadding=4 cellspacing=0>
<tr><td>ID</td><td><input type=text name='ID_UBAH' value='$data[ID_USER]' size=1 disabled></td></tr>
<tr><td>Nama</td><td><input type=text name='NAMA_FUBAH' value='$data[NAMA_USER]'></td><tr>
<tr><td>Company</td><td><input type=text name='COMPANY_FUBAH' value='$data[COMPANY_USER]'></td><tr>
<tr><td>Channel</td><td><input type=text name='CHANNEL_FUBAH' value='$data[CHANNEL_USER]'></td><tr>
<tr><td>Level</td><td><input type=text name='LEVEL_FUBAH' value='$data[LEVEL_USER]'></td><tr>
<tr><td>Password</td><td><input type=text name='PASSWORD_FUBAH' value='$data[PASSWORD_USER]'></td><tr>
<tr><td></td><td><input type=submit value='Update'></td><tr>
</table>
</form>
";
}

//if($_GET['menu']=='tambah_data'){
if ($vMenu=='tambah_data'){
echo"
<form method=POST action='aksi.php?act=tambah_data'>
<table border=1 cellpadding=4 cellspacing=0>
<tr><td>ID</td><td><input type=text name='ID_TMP'></td></tr>
<tr><td>NAMA</td><td><input type=text name='NAMA_TMP'></td></tr>
<tr><td>COMPANY</td><td><input type=text name='COMPANY_TMP'></td></tr>
<tr><td>CHANNEL</td><td><input type=text name='CHANNEL_TMP'></td></tr>
<tr><td>LEVEL</td><td><input type=text name='LEVEL_TMP'></td></tr>
<tr><td>PASSWORD</td><td><input type=text name='PASSWORD_TMP'></td></tr>
<tr><td></td><td><input type=submit value='SIMPAN'></td><tr>
</table>
</form>
";
}
?>

----------------------------------------------------------------------------

<?php
$c=oci_connect("anju","anju","XE");

$act=$_GET['act'];

if($act=='edit_data'){
$sql="update TB_USER set NAMA_USER='$_POST[NAMA_FUBAH]',COMPANY_USER='$_POST[COMPANY_FUBAH]',CHANNEL_USER='$_POST[CHANNEL_FUBAH]',
LEVEL_USER='$_POST[LEVEL_FUBAH]',PASSWORD_USER='$_POST[PASSWORD_FUBAH]' where ID_USER='$_POST[id_ubah]'";
$statment=oci_parse($c,$sql);
oci_execute($statment,OCI_DEFAULT);
oci_commit($c);
header('location:latihan_aplikasi.php');
}

if($act=='tambah_data'){
$sql="insert into TB_USER(ID_USER,NAMA_USER,COMPANY_USER,CHANNEL_USER,LEVEL_USER,PASSWORD_USER)
values('$_POST[ID_TMP]','$_POST[NAMA_TMP]','$_POST[COMPANY_TMP]','$_POST[CHANNEL_TMP]','$_POST[LEVEL_TMP]','$_POST[PASSWORD_TMP]')";
$statment=oci_parse($c,$sql);
oci_execute($statment,OCI_DEFAULT);
oci_commit($c);
header('location:latihan_aplikasi.php');
}

if($act=='hapus_data'){
$sql="delete from TB_USER where ID_USER='$_GET[id]'";
$statment=oci_parse($c,$sql);
oci_execute($statment,OCI_DEFAULT);
oci_commit($c);
header('location:latihan_aplikasi.php');
}

?>

Latihan-5:
----------------------------------------------------------

<?php
@session_start();
unset($_SESSION['nama_user']);
if (ISSET($_SESSION['nama_user']))
{
header ("location:index.php");
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Login</title>
<style type="text/css">

</style>
</head>
<body>
<center>
<form id="form1" name="form1" method="post" action="proses_login.php">
<table width="400" border="1">
<tr>
<td colspan="3" align="center" valign="top" bgcolor="#000000"><span class="style1">Login</span></td>
</tr>
<tr>
<td width="100"><span class="style4">Username</span></td>
<td width="3"><span class="style4">:</span></td>
<td width="275"><input name="nama_user" type="text" id="nama_user" /></td>
</tr>
<tr>
<td><span class="style4">Password</span></td>
<td><span class="style4">:</span></td>
<td><input name="password_user" type="password" id="password_user" /></td>
</tr>
<tr>
<td colspan="3" align="right"><input type="submit" name="Submit" value="Login" /></td>
</tr>
</table>
</form>
</center>
</body>
</html>

----------------------------------------------------------------------------
<
<?php @session_start();
//koneksi database
include ("oraconn.php");
$username = $_POST['nama_user'];
$password = $_POST['password_user'];
$query = "SELECT * FROM TB_USER WHERE nama_user='$username' and password_user='$password'";
$hasil = oci_parse($c,$query);
$data = oci_execute($hasil,OCI_DEFAULT);

//Validasi Data dari form dengan database
if ($data >= 1)
{
$_SESSION['nama_user']=$username;
header("location:index.php");
}
else
{
echo "<script type='text/javascript'>alert('Maaf! Data yang anda masukan tidak benar');document.location='login.php'</script>";
}
?>
----------------------------------------------------------------------------

<?php @session_start();
if (ISSET($_SESSION['nama_user']))
{
echo "Login Berhasil.."."<br />";
echo "Anda Login Sebagai"." : ".$_SESSION['nama_user']."<br />";
echo "<a href='latihan_login.php'>Logout</a>"."<br />";
}
else
{
unset($_SESSION['nama_user']);
echo "<script type='text/javascript'>alert('Silahkan Login dahulu!');document.location='latihan_login.php'</script>";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Index</title>
<style type="text/css">

</style>
</head>
<body>
<span class="style4">Welcome...</span>
</body>
</html>

dwioentariyono

Rabu, 19 Juni 2013

Latihan PHP dengan Oracle

1 komentar: