- Beranda
- Programmer Forum
Mengedit data mysql dgn php tdk berubah
...
TS
myusupanwari
Mengedit data mysql dgn php tdk berubah
ini source code pada form_edit
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit Data Transaksi</title>
</head>
<body>
<center>
<?php
include "koneksi.php";
$edit = mysql_query("SELECT * FROM t_transaksi");
$r = mysql_fetch_array($edit)
?>
<form id="form1" name="form1" method="post" action="proses_edit.php">
<table width="S E N S O R" border="1">
<tr>
<td colspan="3" align="center">EDIT DATA TRANSAKSI</td>
</tr>
<input type="hidden" name="id" value="<? echo $id; ?>"/>
<tr>
<td width="98">ID Nasabah</td>
<td width="4">:</td>
<td width="187"><label>
<input name="id_nasabah" type="text" id="id_nasabah" value="<?php echo $r['id_nasabah'];?>" />
</label></td>
</tr>
<tr>
<td width="98">Transaksi</td>
<td width="4">:</td>
<td width="187"><label>
<input name="transaksi" type="text" id="transaksi" value="<?php echo $r['jenis_trans'];?>" />
</label></td>
</tr>
<tr>
<td width="98">Jumlah</td>
<td width="4">:</td>
<td width="187"><label>
<input name="Jumlah" type="text" id="jumlah" value="<?php echo $r['value'];?>" />
</label></td>
</tr>
<tr>
<td width="98">Tanggal</td>
<td width="4">:</td>
<td width="187"><label>
<input name="anggal" type="text" id="tanggal" value="<?php echo $r['tanggal'];?>" />
</label></td>
</tr>
<tr>
<td width="98">ID User</td>
<td width="4">:</td>
<td width="187"><label>
<input name="id_user" type="text" id="id_user" value="<?php echo $r['id_user'];?>" />
</label></td>
</tr>
<tr>
<td width="98">Keterangan</td>
<td width="4">:</td>
<td width="187"><label>
<input name="ket" type="text" id="ket" value="<?php echo $r['keterangan'];?>" />
</label></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><label>
<input type="submit" name="button" id="button" value="Simpan" />
<input name="id_trans" type="hidden" id="id_trans" value="<?php echo $r[id_transaksi];?>" />
</label></td>
</tr>
</table>
</form>
</body>
</html>
Ini Source Code pada proses_edit
<?php
include ("koneksi.php");
$id=$_POST['id'];
$in=$_POST['id_nasabah'];
$tr=$_POST['jenis_trans'];
$jml=$_POST['value'];
$tgl=$_POST['tanggal'];
$iu=$_POST['id_user'];
$ket=$_POST['keterangan'];
$edit = mysql_query("update t_transaksi set id_nasabah='$in', jenis_trans='$tr', value='$jml', tanggal='$tgl', id_user='$iu', keterangan='$ket' where id_transaksi='$id'");
Mhon bantuannya para master, dmn letak kesalahan source codenya, error tdk ada tp tdk bs update data
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit Data Transaksi</title>
</head>
<body>
<center>
<?php
include "koneksi.php";
$edit = mysql_query("SELECT * FROM t_transaksi");
$r = mysql_fetch_array($edit)
?>
<form id="form1" name="form1" method="post" action="proses_edit.php">
<table width="S E N S O R" border="1">
<tr>
<td colspan="3" align="center">EDIT DATA TRANSAKSI</td>
</tr>
<input type="hidden" name="id" value="<? echo $id; ?>"/>
<tr>
<td width="98">ID Nasabah</td>
<td width="4">:</td>
<td width="187"><label>
<input name="id_nasabah" type="text" id="id_nasabah" value="<?php echo $r['id_nasabah'];?>" />
</label></td>
</tr>
<tr>
<td width="98">Transaksi</td>
<td width="4">:</td>
<td width="187"><label>
<input name="transaksi" type="text" id="transaksi" value="<?php echo $r['jenis_trans'];?>" />
</label></td>
</tr>
<tr>
<td width="98">Jumlah</td>
<td width="4">:</td>
<td width="187"><label>
<input name="Jumlah" type="text" id="jumlah" value="<?php echo $r['value'];?>" />
</label></td>
</tr>
<tr>
<td width="98">Tanggal</td>
<td width="4">:</td>
<td width="187"><label>
<input name="anggal" type="text" id="tanggal" value="<?php echo $r['tanggal'];?>" />
</label></td>
</tr>
<tr>
<td width="98">ID User</td>
<td width="4">:</td>
<td width="187"><label>
<input name="id_user" type="text" id="id_user" value="<?php echo $r['id_user'];?>" />
</label></td>
</tr>
<tr>
<td width="98">Keterangan</td>
<td width="4">:</td>
<td width="187"><label>
<input name="ket" type="text" id="ket" value="<?php echo $r['keterangan'];?>" />
</label></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><label>
<input type="submit" name="button" id="button" value="Simpan" />
<input name="id_trans" type="hidden" id="id_trans" value="<?php echo $r[id_transaksi];?>" />
</label></td>
</tr>
</table>
</form>
</body>
</html>
Ini Source Code pada proses_edit
<?php
include ("koneksi.php");
$id=$_POST['id'];
$in=$_POST['id_nasabah'];
$tr=$_POST['jenis_trans'];
$jml=$_POST['value'];
$tgl=$_POST['tanggal'];
$iu=$_POST['id_user'];
$ket=$_POST['keterangan'];
$edit = mysql_query("update t_transaksi set id_nasabah='$in', jenis_trans='$tr', value='$jml', tanggal='$tgl', id_user='$iu', keterangan='$ket' where id_transaksi='$id'");
Mhon bantuannya para master, dmn letak kesalahan source codenya, error tdk ada tp tdk bs update data
Diubah oleh myusupanwari 10-04-2019 12:55
nona212 memberi reputasi
1
609
5
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.9KAnggota
Urutkan
Terlama
Komentar yang asik ya