[PHP,AJAX ASK] Mohon pencerahannya ..

Beranda
Komunitas
Tech
Programmer Forum
[PHP,AJAX ASK] Mohon pencerahannya ..

syncb

14-09-2015 05:19

[PHP,AJAX ASK] Mohon pencerahannya ..

Mohon bantuannya gan , ane stuck nih ..

Spoiler for Scriptnya:

<html>
<head>
<title>Form Barang</title>
[removed][removed]
[removed]

//mengidentifikasikan variabel yang kita gunakan
var id;
var kode;
var nama;
var satuan;
var harga;
var merk;
var stok;
$(function(){
$("#kode").load("proses.php","op=kode");
$("#barang").load("proses.php","op=barang");

//jika ada perubahan di kode barang
$("#kode").change(function(){
kode=$("#kode").val();

//tampilkan status loading dan animasinya
$("#status").html("loading. . .");
$("#loading").show();

//lakukan pengiriman data
$.ajax({
url:"proses.php",
data:"op=ambildata&kode="+kode,
cache:false,
success:function(msg){
data=msg.split("|");

//masukan isi data ke masing - masing field
$("#nama") .val(data[0]);
$("#harga") .val(data[1]);
$("#merk") .val(data[2]);
$("#satuan").val(data[3]);
$("#stok") .val(data[4]);

//hilangkan status animasi dan loading
$("#status").html("");
$("#loading").hide();
}
});
});

//cek kode barang yang sudah ada
$("#kode2").change(function(){
var kd=$("#kode2").val();

$.ajax({
url:"proses.php",
data:"op=cek&kd="+kd,
success:function(data){
if(data==0){
$("#pesan").html('Kode Barang Bisa digunakan');
$("#kode2").css('border','3px #090 solid');
}else{
$("#pesan").html('Kode Barang sudah ada');
$("#kode2").css('border','3px #c33 solid');
}
}
});
});

//ketika tombol update di klik
$("#update").click(function(){
//cek apakah kode barang kosong atau tidak
kode_barang=$("#kode").val();
if(kode=="Kode Barang"){
alert("Pilih Kode barang dulu");
exit();
}
nama_barang =$("#nama").val();
harga =$("#harga").val();
id_merk =$("#merk").val();
id_satuan =$("#satuan").val();
stok =$("#stok").val();

//tampilkan status update
$("#status").html('sedang diupdate. . .');
$("#loading").show();

$.ajax({
url:"proses.php",
data:"op=update&kode="+kode_barang
+"&nama="+nama_barang
+"&harga="+harga
+"&merk="+id_merk
+"&satuan="+id_satuan
+"&stok="+stok,
cache:false,
success:function(msg){
if(msg=='Sukses'){
$("#status").html('Update Berhasil. . .');
}else{
$("#status").html('ERROR. . .')
}
$("#loading").hide();
$("#nama").val("");
$("#harga").val("");
$("#merk").val("");
$("#satuan").val("");
$("#stok").val("");
$("#barang").load("proses.php","op=barang");
$("#kode").load("proses.php","op=kode");
}
});
});

//ketika tombol hapus diklik
$("#hapus").click(function(){
kode_barang=$("#kode").val();
if(kode=="Kode Barang"){
alert("Kode barang belum dipilih");
exit();
}
$("#status").html('Sedang Dihapus. . .');
$("#loading").show();

$.ajax({
url:"proses.php",
data:"op=delete&kode="+kode_barang,
cache:false,
success:function(msg){
if(msg=="sukses"){
$("#status").html('Berhasil Dihapus. . .');
}else{
$("#status").html('ERROR. . .');
}
$("#nama").val("");
$("#merk").val("");
$("#harga").val("");
$("#satuan").val("");
$("#stok").val("");
$("#barang").load("proses.php","op=barang");
$("#kode").load("proses.php","op=kode");

}
});
});

//ketika tombol simpan diklik
$("#simpan").click(function(){
kode_barang=$("#kode2").val();
if(kode==""){
alert("Kode Barang Harus diisi");
exit();
}
nama_barang=$("#nama").val();
harga=$("#harga").val();
id_merk=$("#merk").val();
id_satuan=$("#satuan").val();
stok=$("#stok").val();

$("#status").html("sedang diproses. . .");
$("#loading").show();

$.ajax({
url:"proses.php",
data:"op=simpan&kode="+kode_barang
+"&nama="+nama_barang
+"&harga="+harga
+"&merk="+id_merk+
"&satuan="+id_satuan
+"&stok="+stok,
cache:false,
success:function(msg){
if(msg=="sukses"){
$("#status").html("Berhasil disimpan. . .");
}else{
$("#status").html("ERROR. . .");
}
$("#loading").hide();
$("#nama").val("");
$("#harga").val("");
$("#merk").val("");
$("#satuan").val("");
$("#stok").val("");
$("#kode2").val("");
}
});
});
});
[removed]
</head>
<body>
<?php
$p=isset($_GET['act'])?$_GET['act']:null;
switch($p){
default:
echo'

<legend>Data Barang</legend>

<label>Kode Barang</label>
<select id="kode"></select>

<input type="text" id="nama" placeholder="Nama Barang" class="span2">
<input type="text" id="harga" placeholder="Harga" class="span2">
<input type="text" id="merk" placeholder="Merk" class="span2">
<input type="text" id="satuan" placeholder="satuan" class="span2">
<input type="text" id="stok" placeholder="Stok" class="span2">
<button id="update" class="btn">Update</button>
<button id="hapus" class="btn">Hapus</button>
<div id="status"></div><br>
<div id="barang"></div>
';
break;
case "tambah":
echo'<legend>Tambah Data Barang</legend>
<label>Kode Barang</label>
<input type="text" id="kode2"> <span id="pesan"></span>
<label>Nama Barang</label>
<input type="text" id="nama" >
<label>Harga</label>
<input type="text" id="harga" >
<label>merk</label>
<input type="text" id="merk" >
<label>Satuan</label>
<input type="text" id="satuan" >
<label>Stok</label>
<input type="text" id="stok" class="span1">
<label></label>
<button id="simpan" class="btn">Simpan</button>
<a href="?page=barang" class="btn">Kembali</a>
<div id="status"></div>';
break;
}
?>
</body>
</html>

Spoiler for Proses.php:

<?php
$path = $_SERVER['DOCUMENT_ROOT'];
$root = 'http://localhost/orderproses/';
include $path.'/orderproses/lib/koneksi.php';

$data=mysql_query("select * from barang");
$op=isset($_GET['op'])?$_GET['op']:null;

if($op=='kode'){
echo"<option>Kode Barang</option>";
while($r=mysql_fetch_array($data)){
echo "<option value='$r[kode_barang]'>$r[kode_barang]</option>";
}
}elseif($op=='barang'){
echo'<table id="barang" class="table table-hover">
<thead>
<tr>
<Td colspan="5"><a href="?page=barang&act=tambah" class="btn btn-primary">Tambah Barang</a></td>
</tr>
<tr>
<td>Kode Barang</td>
<td>Nama Barang</td>
<td>Harga</td>
<td>Merk Barang</td>
<td>Satuan Barang</td>
<td>Stok</td>
</tr>
</thead>';
while ($b=mysql_fetch_array($data)){
echo"<tr>
<td>$b[kode_barang]</td>
<td>$b[nama_barang]</td>
<td>$b[harga]</td>
<td>$b[id_merk]</td>
<td>$b[id_satuan]</td>
<td>$b[stok]</td>
</tr>";
}
echo "</table>";

}elseif($op=='ambildata'){
$kode=$_GET['kode'];
$dt=mysql_query("select * from barang where kode_barang='$kode'");
$d=mysql_fetch_array($dt);
echo $d['nama_barang']."|".$d['harga']."|".$d['id_merk']."|".$d['id_satuan']."|".$d['stok'];

}elseif($op=='cek'){
$kd=$_GET['kd'];
$sql=mysql_query("select * from barang where kode_barang='$kd'");
$cek=mysql_num_rows($sql);
echo $cek;

}elseif($op=='update'){
$kode =$_GET['kode'];
$nama =htmlspecialchars($_GET['nama']);
$harga =htmlspecialchars($_GET['harga']);
$merk =htmlspecialchars($_GET['merk']);
$satuan =htmlspecialchars($_GET['satuan']);
$stok =htmlspecialchars($_GET['stok']);

$update=mysql_query("update barang set
nama_barang ='$nama',
harga ='$harga',
id_merk ='$merk',
id_satuan ='$satuan',
stok ='$stok'
where kode_barang='$kode'");
if($update){
echo "Sukses";
}else{
echo "ERROR. . .";
}

}elseif($op=='delete'){
$kode=$_GET['kode'];
$del=mysql_query("delete from barang where kode_barang='$kode'");
if($del){
echo "sukses";
}else{
echo "ERROR";
}
}elseif($op=='simpan'){
$kode=$_GET['kode'];
$nama =htmlspecialchars($_GET['nama']);
$harga =htmlspecialchars($_GET['harga']);
$merk =htmlspecialchars($_GET['merk']);
$satuan =htmlspecialchars($_GET['satuan']);
$stok =htmlspecialchars($_GET['stok']);

$tambah=mysql_query("insert into barang (kode_barang,nama_barang,harga,id_merk,id_satuan,stok)
values ('$kode','$nama','$harga','$merk','$satuan','$stok')");
if($tambah){
echo "sukses";
}else{
echo "error";
}
}
?>

Spoiler for Output: