Belajar PHP dan Oracle: Browse, Input, delete dan Edit oracle Via PHP

Melengkapi tulisan saya tentang menampilkan data dan input data database oracle, kali ini saya akan menambahkan bagaimana caranya meng-EDIT dan meng-HAPUS data dari database oracle melalui PHP, dibawah ini adalah tampilan browse data yang sudah saya lengkapi dengan link input,edit, dan hapus data dan di paling bawah ada counter untuk menghitung jumlah data yang sudah di input,

Ini adalah code untuk tampilan diatas (tampil_data.php) :

<title>Menampilkan data Database Oracle dengan PHP</title>
<?php
include "konek.php"; // untuk memanggil koneksi
$PeritahSql="select * from EMP";
$Query = oci_parse($koneksi,$PeritahSql);
oci_execute($Query);
echo "<b>";
echo "<center>DAFTAR KARYAWAN BARISAN SAKIT HATI</center>";
echo "<center>CILEGON - BANTEN</center>";
echo "</b>";
echo "<table width='80%' border='1' align='center'>";
echo "<td width='100%' colspan='6' align='right'><a href='frm_input.php'>TAMBAH DATA</a></td>";
echo "<tr align='center'><td>EMP. NO</td><td>EMP. NAME</td><td>JOB</td><td>HIRE DATE</td><td colspan='2'>ACTION</td></tr>";
while (oci_fetch_array($Query)){
    echo "<tr>
   <td width='10%'>".ociresult($Query,"EMPNO")."</td>
   <td width='30%'>".ociresult($Query,"ENAME")."</td>
   <td width='30%'>".ociresult($Query,"JOB")."</td>
   <td width='10%'>".ociresult($Query,"HIREDATE")."</td>
   <td width='5%' align='center'><a href='frm_edit.php?empno=".ociresult($Query,"EMPNO")."'>".EDIT."</a></td>
   <td width='5%' align='center'><a href='proses_deldata.php?empno=".ociresult($Query,"EMPNO")."'>".HAPUS."</a></td>
   </tr>";


}
//Menghitung jumlah data
$PeritahSqlJumlah="select COUNT (EMPNO) as JUMLAH from EMP";
$QueryJumlah = oci_parse($koneksi,$PeritahSqlJumlah);
oci_execute($QueryJumlah);
oci_fetch_array($QueryJumlah);
echo "<td width='100%' colspan='6'>Jumlah Data : ".ociresult($QueryJumlah,"JUMLAH")."</td>";
echo "</table>";
oci_close($koneksi); // untuk menutup koneksi
?>

Tampilan pada saat link EDIT di klik

Script untuk membuat Form Edit (frm_edit.php)

<!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=utf-8" />
<title>.: EDIT DATA :.</title>

<script language="javascript" src="calendar/calendar.js"></script>

</head>

<body>
<?php
require_once('calendar/classes/tc_calendar.php');
include "konek.php"; // untuk memanggil koneksi
$empno=$_GET['empno'];
$PeritahSql="SELECT EMP.*,DEPT.DNAME FROM EMP,DEPT where EMP.DEPTNO=DEPT.DEPTNO AND EMPNO='$empno'";
//untuk mempercepat proses query field harus di sebutkan
//dengan sintak diatas akan memanggil semua field yang ada di table EMP
$Query = oci_parse($koneksi,$PeritahSql);
oci_execute($Query);
oci_fetch_array($Query);
?>

<form id="form1" name="form1" method="post" action="proses_edtdata.php">
<table width="100%" border="0">
<tr>
    <td> </td>
    <td width="17%"> </td>
    <td width="2%"> </td>
    <td width="36%"> </td>
    <td> </td>
</tr>
<tr>
    <td width="17%"> </td>
    <td colspan="3"><strong>FORM EDIT DATA</strong></td>
    <td width="45%"> </td>
</tr>
<tr>
    <td> </td>
    <td>EMP ID</td>
    <td>
</td>
    <td><label>
      <input name="empno" type="text" id="empno" value="<?php echo ociresult($Query,"EMPNO") ?>" size="20" readonly="readonly" />
    </label></td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td>EMP NAME</td>
    <td> </td>
    <td><input name="empname" type="text" id="empname" value="<?php echo ociresult($Query,"ENAME") ?>" size="60" /></td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td>JOB</td>
    <td> </td>
    <td><input name="job" type="text" id="job" value="<?php echo ociresult($Query,"JOB") ?>" size="60" /></td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td>HIRE DATE</td>
    <td> </td>
    <td><?php
                      $date1_default=ociresult($Query,"HIREDATE");
                      $myCalendar = new tc_calendar("date", true);
                      $myCalendar->setIcon("calendar/images/iconCalendar.gif");
                      $myCalendar->setDate(date('d', strtotime($date1_default))
                      , date('m', strtotime($date1_default))
                   , date('Y', strtotime($date1_default)));
                      $myCalendar->setPath("calendar/");
                      $myCalendar->setYearInterval(1960, 2015);
                      $myCalendar->writeScript();
                      ?></td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td>SALARY</td>
    <td> </td>
    <td><input type="text" name="salary" id="salary" value="<?php echo ociresult($Query,"SAL") ?>" /></td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td>DEPT</td>
    <td> </td>
    <td><label>
    <select name="dept" id="dept">
    <?php
   echo "<option value=".ociresult($Query,"DEPTNO").">".ociresult($Query,"DNAME")."</option>";
    $PeritahSql1="SELECT * FROM DEPT";
   $Query1 = oci_parse($koneksi,$PeritahSql1);
   oci_execute($Query1);
   while (oci_fetch_array($Query1)){
   echo "<option value=".ociresult($Query1,"DEPTNO").">".ociresult($Query1,"DNAME")."</option>";
   }
   ?>
    </select>
    </label></td>
    <td> </td>
</tr>
<tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td><label>
      <input type="submit" name="simpan" id="simpan" value="Save" />
    </label></td>
    <td> </td>
</tr>
</table>
    </form>
</body>
</html>

Download script lengkap (konek.php, tampil_data.php, frm_input.php, frm_edit.php, proses_edtdata.php, proses_indata.php, proses_deldata.php) disini.

Mohon di koreksi jika ada yang salah dan Semoga bermanfaat.... :)

Belajar PHP dan Oracle

Selasa, 20 November 2012

Browse, Input, delete dan Edit oracle Via PHP

12 komentar: