- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
Edit data dengan PHP selalu gagal
TS
lemanxzibit
Edit data dengan PHP selalu gagal
Mohon bantuannya suhu,master php atau siapa saja yang bisa bantu menyelesaikan permasalahan dengan PHP,
ane punya script gini
<?php
include('koneksi.php');
$query = "select * from download where id = '$_GET[id]'";
$result = mysql_query($query);
$data = mysql_fetch_array($result);
?>
<form action="download_ubah_query.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="id" value="<?php echo $data['id']; ?>" />
<table width="100%" align="center" border="0" bgcolor="#eee" cellpadding="2" cellspacing="0">
<tr>
<td><b>Tanggal Claim</b></td><td> </td><td><input type="text" class="form-control" name="tanggal_claim" value="<?php echo $data['tanggal_claim']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Claim OLO</b></td><td> </td><td><input type="text" class="form-control" name="claim_olo" value="<?php echo $data['claim_olo']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Detail Claim</b></td><td> </td><td><textarea class="form-control" name="detail_claim" rows="3" value="<?php echo $data['detail_claim'] ; ?>" /></textarea></td>
<td> </td>
</tr>
<tr>
<td><b>Customer</b></td><td> </td><td><input type="text" class="form-control" name="customer" value="<?php echo $data['customer']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>No ADSL / Link</b></td><td> </td><td><input type="text" class="form-control" name="no_adsl" value="<?php echo $data['no_adsl']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Id Trans</b></td><td> </td><td><input type="text" class="form-control" name="id_trans" value="<?php echo $data['id_trans']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>AO MO DO</b></td><td> </td><td><input type="text" class="form-control" name="aomodo" value="<?php echo $data['aomodo']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Konfirmasi Awal</b></td><td> </td><td><textarea class="form-control" name="kofirmasi_awal" rows="3" value="<?php echo $data['kofirmasi_awal']; ?>" /></textarea></td>
<td> </td>
</tr>
<tr>
<td><b>Hasil RAM</b></td><td> </td><td><input type="text" class="form-control" name="hasil_ram" value="<?php echo $data['hasil_ram']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Status</b></td><td> </td>
<td>
<select name="status" class="form-control" id="status">
<?php
if ($data['status']=="OPEN"){
$pilih_open = "selected";
}else if($data['status']=="IN_PROGRESS"){
$pilih_in_progress = "selected";
}else if($data['status']=="CLOSED"){
$pilih_closed = "selected";
}
?>
<option value="OPEN"<?php echo $pilih_open ?>>OPEN</option>
<option value="IN_PROGRESS"<?php echo $pilih_in_progress ?>>IN PROGRESS</option>
<option value="CLOSED"<?php echo $pilih_closed ?>>CLOSED</option>
</select></td>
<td> </td>
</tr>
<tr>
<td><b>Keterangan</b></td><td> </td><td><input type="text" class="form-control" name="keterangan" value="<?php echo $data['keterangan']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Nama File</b></td><td> </td><td><input type="text" class="form-control" name="nama" value="<?php echo $data['nama_file']; ?>" readonly="true" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><div class="alert alert-info" role="alert">*Upload ukuran file maksimal 2 Mb !</div></td>
</tr>
<tr>
<td><b>Pilih File</b></td><td> </td><td><input type="file" class="#" name="file" value="<?php echo $data['file']; ?>" readonly="true" /></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td><td> </td><td><input type="submit" class="btn btn-info" name="update" value="Update" /></td>
</tr>
</table>
</form>
dan
<?php
include("koneksi.php");
if (isset($_POST['update'])) {
$id = $_GET['id'];
$query = "(update download set id_trans = '$_POST[id_trans]',
tanggal = '$_POST[tanggal]',
claim_olo = '$_POST[claim_olo]',
detail_claim = '$_POST[detail_claim]',
customer = '$_POST[customer]',
no_adsl = '$_POST[no_adsl]',
aomodo = '$_POST[aomodo]',
kofirmasi_awal = '$_POST[kofirmasi_awal]',
hasil_ram = '$_POST[hasil_ram]',
status = '$_POST[status]',
keterangan = '$_POST[keterangan]',
where id = '$_POST[id]')";
$result = mysql_query($query);
if($result){
header("location:view_tables.php");
}else{
echo '<div class="error">ERROR: Gagal update file! <meta http-equiv="refresh" content="5; url=./tables_view.php"></div>';
}
}
?>
setiap ane edit data selalu gagal, apakah querynya ada yang salah gan ?
mohon pencerahannya , thks
ane punya script gini
Spoiler for form edit:
<?php
include('koneksi.php');
$query = "select * from download where id = '$_GET[id]'";
$result = mysql_query($query);
$data = mysql_fetch_array($result);
?>
<form action="download_ubah_query.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="id" value="<?php echo $data['id']; ?>" />
<table width="100%" align="center" border="0" bgcolor="#eee" cellpadding="2" cellspacing="0">
<tr>
<td><b>Tanggal Claim</b></td><td> </td><td><input type="text" class="form-control" name="tanggal_claim" value="<?php echo $data['tanggal_claim']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Claim OLO</b></td><td> </td><td><input type="text" class="form-control" name="claim_olo" value="<?php echo $data['claim_olo']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Detail Claim</b></td><td> </td><td><textarea class="form-control" name="detail_claim" rows="3" value="<?php echo $data['detail_claim'] ; ?>" /></textarea></td>
<td> </td>
</tr>
<tr>
<td><b>Customer</b></td><td> </td><td><input type="text" class="form-control" name="customer" value="<?php echo $data['customer']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>No ADSL / Link</b></td><td> </td><td><input type="text" class="form-control" name="no_adsl" value="<?php echo $data['no_adsl']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Id Trans</b></td><td> </td><td><input type="text" class="form-control" name="id_trans" value="<?php echo $data['id_trans']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>AO MO DO</b></td><td> </td><td><input type="text" class="form-control" name="aomodo" value="<?php echo $data['aomodo']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Konfirmasi Awal</b></td><td> </td><td><textarea class="form-control" name="kofirmasi_awal" rows="3" value="<?php echo $data['kofirmasi_awal']; ?>" /></textarea></td>
<td> </td>
</tr>
<tr>
<td><b>Hasil RAM</b></td><td> </td><td><input type="text" class="form-control" name="hasil_ram" value="<?php echo $data['hasil_ram']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Status</b></td><td> </td>
<td>
<select name="status" class="form-control" id="status">
<?php
if ($data['status']=="OPEN"){
$pilih_open = "selected";
}else if($data['status']=="IN_PROGRESS"){
$pilih_in_progress = "selected";
}else if($data['status']=="CLOSED"){
$pilih_closed = "selected";
}
?>
<option value="OPEN"<?php echo $pilih_open ?>>OPEN</option>
<option value="IN_PROGRESS"<?php echo $pilih_in_progress ?>>IN PROGRESS</option>
<option value="CLOSED"<?php echo $pilih_closed ?>>CLOSED</option>
</select></td>
<td> </td>
</tr>
<tr>
<td><b>Keterangan</b></td><td> </td><td><input type="text" class="form-control" name="keterangan" value="<?php echo $data['keterangan']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Nama File</b></td><td> </td><td><input type="text" class="form-control" name="nama" value="<?php echo $data['nama_file']; ?>" readonly="true" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><div class="alert alert-info" role="alert">*Upload ukuran file maksimal 2 Mb !</div></td>
</tr>
<tr>
<td><b>Pilih File</b></td><td> </td><td><input type="file" class="#" name="file" value="<?php echo $data['file']; ?>" readonly="true" /></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td><td> </td><td><input type="submit" class="btn btn-info" name="update" value="Update" /></td>
</tr>
</table>
</form>
dan
Spoiler for query proses edit data:
<?php
include("koneksi.php");
if (isset($_POST['update'])) {
$id = $_GET['id'];
$query = "(update download set id_trans = '$_POST[id_trans]',
tanggal = '$_POST[tanggal]',
claim_olo = '$_POST[claim_olo]',
detail_claim = '$_POST[detail_claim]',
customer = '$_POST[customer]',
no_adsl = '$_POST[no_adsl]',
aomodo = '$_POST[aomodo]',
kofirmasi_awal = '$_POST[kofirmasi_awal]',
hasil_ram = '$_POST[hasil_ram]',
status = '$_POST[status]',
keterangan = '$_POST[keterangan]',
where id = '$_POST[id]')";
$result = mysql_query($query);
if($result){
header("location:view_tables.php");
}else{
echo '<div class="error">ERROR: Gagal update file! <meta http-equiv="refresh" content="5; url=./tables_view.php"></div>';
}
}
?>
setiap ane edit data selalu gagal, apakah querynya ada yang salah gan ?
mohon pencerahannya , thks
0
9.4K
Kutip
17
Balasan
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan