ceritanya dewaarjuna

<table width="617" border="1"> <tr> <td width="68">id_pesanan</td> <td width="72">id_pemesan</td> <td width="84">id_pegawai</td> <td width="91">tgl_pesan</td> <td width="32">lama</td> <td width="57">id_kamar</td> <td width="65">id_meeting</td> <td width="60">total_harga</td> <td width="96">action</td> </tr> <? $conn = mysql_connect("localhost","root",""); mysql_select_db("basdat",$conn); $sql = "select * from pesanan ord...

<? $conn = mysql_connect("localhost","root",""); $db = mysql_select_db("basdat",$conn); $id_pesanan = $HTTP_GET_VARS['id_pesanan']; $tmp_id_kamar = $HTTP_GET_VARS['id_kamar']; $tmp_id_meeting = $HTTP_GET_VARS['id_meeting']; $sql = "delete from pesanan where id_pesanan='$id_pesanan'"; $que = mysql_query($sql); if ($tmp_id_kamar!="") { $sql2 = mysql_query("update kamar set status = 'kosong' where id_kamar = '$tmp_id_kamar'"); } if ($tmp_id_meeting!="") { $sql3 = mysql_query("update meeting set status = 'kosong' where id_meeting = '$tmp_id_meeting'"); } header("location:viewpesanan.php"); mysql_close($conn); ?>

<? $conn = mysql_connect("localhost","root",""); mysql_select_db("basdat",$conn); $tmp_id_pesanan = $HTTP_GET_VARS['id_pesanan']; $tmp_id_pemesan = $HTTP_POST_VARS['id_pemesan']; $tmp_id_pegawai = $HTTP_GET_VARS['id_pegawai']; $tmp_tgl_pesan = $HTTP_POST_VARS['tgl_pesan']; $tmp_lama = $HTTP_POST_VARS['lama']; $tmp_id_kamar = $HTTP_POST_VARS['id_kamar']; $tmp_id_meeting = $HTTP_POST_VARS['id_meeting']; $sql = "update pesanan set id_pemesan='$tmp_id_pemesan' , tgl_pesan='$tmp_tgl_pesan', lama='$tmp_lama' where id_pesanan='$tmp_id_pesanan'"; mysql_query($sql); header("location:viewpesanan.php"); mysql_close($conn); ?>

<? $conn = mysql_connect("localhost","root",""); mysql_select_db("basdat",$conn); $tmp_id_pesanan = $HTTP_POST_VARS['id_pesanan']; $tmp_id_pemesan = $HTTP_POST_VARS['id_pemesan']; $tmp_id_pegawai = $HTTP_GET_VARS['id_pegawai']; $tmp_tgl_pesan = $HTTP_POST_VARS['tgl_pesan']; $tmp_lama = $HTTP_POST_VARS['lama']; $tmp_id_kamar = $HTTP_POST_VARS['id_kamar']; $tmp_id_meeting = $HTTP_POST_VARS['id_meeting']; if ($tmp_id_meeting!="") { $sql3 = mysql_query("update meeting set status = 'isi' where id_meeting = '$tmp_id_meeting'"); $a= mysql_query("select harga from meeting where id_meeting = '$tmp_id_meeting'"); $sql = "insert into pesanan (id_pesanan, id_pemesan, id_pegawai, tgl_pesan, lama, id_kamar, id_meeting, total_harga) values('$tmp_id_pesanan', '$tmp_id_pemesan','$tmp_id_pegawai', '$tmp...

include ("connect.php"); $id_peserta = $HTTP_GET_VARS['id_peserta']; $tmp_nama = $HTTP_POST_VARS['nama_b']; $tmp_alamat = $HTTP_POST_VARS['alamat_b']; $tmp_no_telepon = $HTTP_POST_VARS['no_telepon_b']; $ubah = OCIParse($conn,"update peserta set nama='$tmp_nama', alamat='$tmp_alamat', no_telepon='$tmp_no_telepon' where id_peserta='$id_peserta'"); $s = ociexecute($ubah); OCICommit($conn); if(!$s){ echo "PROSES UBAH DATA GAGAL".var_dump(ocierror()); }else{ echo "PROSES UBAH DATA BERHASIL"; } header("location:viewpeserta.php"); oci_close($conn); ?>

include ("connect.php"); $id_peserta = $HTTP_GET_VARS['id_peserta']; $hapus = OCIParse($conn,"delete from peserta where id_peserta='$id_peserta'"); $s = ociexecute($hapus); OCICommit($conn); if(!$s){ echo "PROSES HAPUS DATA GAGAL".var_dump(ocierror()); }else{ echo "PROSES HAPUS DATA BERHASIL"; } oci_close($conn); ?>

include ("connect.php"); $nama = $HTTP_POST_VARS['nama']; $alamat = $HTTP_POST_VARS['alamat']; $no_telepon = $HTTP_POST_VARS['no_telepon']; $stmt = OCIParse($conn,"insert into peserta values ('','$nama','$alamat','$no_telepon')"); $s = ociexecute($stmt); if(!$s){ echo " PROSES INSERT DATA PESERTA GAGAL".var_dump(ocierror()); }else{ echo " PROSES INSERT DATA PESERTA SUKSES "; } oci_close($conn); ?>

$conn=OCILogon("system", "system"); if (!$conn) { echo "Status koneksi : Gagal". var_dump(OCIError() ); }else{ echo "Status koneksi : Sukses"; } ?>