halaman edit data tidak bisa tampil

Rynda · Sep 8, 2013
mas maaf saya mau tanya, halaman edit data saya kok tidak bisa tampil ya mas?
padahal saya sudah mengacu di script aplikasi2 saya sebelumnya..
ini script lihat data, edit data dan proses edit data saya mas..
tlong bantuannya ya mas..
kira2 kesalahanyya dimana..
terima kasih
<!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>Aplikasi Pembelajaran Bahasa Korea</title>
<link href="css/faizal_style.css" rel="stylesheet" type="text/css" />

<style type="text/css">
<!--
.style21 {font-weight: bold; font-size: 24px;}
.style23 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #000000; }
.style12 {	font-family: Arial, Helvetica, sans-serif;
	color: #000000;
	font-size: 10;
}
.style13 {font-size: 12px}
.style17 {color: #FFFFFF}
.style18 {font-family: Arial, Helvetica, sans-serif; font-size: 10; font-weight: bold; color: #000000; }
.style19 {	color: #000000;
	font-size: 10px;
}
.style20 {font-size: 10}
.style22 {color: #000000; font-size: 10; }
-->
</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
  <label> </label>
  <div id="coba">
    </p>
    <p>&nbsp;</p>
  </div>
  <table width="64%" border="2" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td width="8%" bgcolor="#66CCFF"><div align="center">No</div></td>
      <td width="28%" bgcolor="#66CCFF"><div align="center">Kata </div></td>
      <td width="51%" bgcolor="#66CCFF"><div align="center">Arti</div></td>
      <td colspan="2" bgcolor="#66CCFF">Action</td>
    </tr>
    <?php
   include("conn.php");//koneksi kedatabase
   mysql_select_db("kamus2");//membuka database
   mysql_query ('SET NAMES utf8');
   $warnaGenap = "#C7FEFD";   // warna abu-abu
   $warnaGanjil = "#FFFFFF";  // warna putih
   $pilih_database=" SELECT *
FROM `kamus_id`
LIMIT 0 , 1000
";
$ambil=mysql_query($pilih_database);
   $no=1;
   $counter = 1;
   while($c=mysql_fetch_row($ambil)){
       if ($counter % 2 == 0) $warna = $warnaGenap;
              else $warna = $warnaGanjil;
			  ?>
    <tr bgcolor="<?=$warna?>">
      <td><div align="center"><span class="style20">
        <?=$no?>
      </span></div></td>
      <td><div align="center"><span class="style20">
        <?=$c[0]?>
      </span></div></td>
      <td><div align="center"><span class="style20">
        <?=$c[1]?>
      </span></div></td>
      <td width="7%" bgcolor="<?=$warna?>"><div align="center" id="coba"><a title="Edit Data" href="edit.php?kata=<?=$c[0]?>"><img src="images/edit.png" width="17" height="16" /></a> </div></td>
      <td width="6%"><div align="center"><a onclick="return confirm('Apakah Anda yakin?')" title="Apa anda yakin akan menghapus data" href="proseshapus.php?kata=<?=$c[0]?>"><img src="images/hapus.png" width="15" height="15" /></a></div></td>
    </tr>
    <?php
				  $no++;
				  $counter++;
				  $c++;
       }
   ?>
  </table>
  <p>&nbsp;</p>
</form>
</body>
</html>
<style type="text/css">
<!--
body {
	background-image: url(images/main_bg.png);
}
.style5 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; }
-->
</style><div id="content">
	<h2 align="center">EDIT KATA KAMUS </h2>
	<FORM ACTION="prosesedit.php" METHOD="POST" NAME="" />
	<?php
include "conn.php";
	$query = ("SELECT *
FROM `kamus_id`
WHERE `kata` LIKE '$kta'
LIMIT 0 , 30 ");
	$sql = mysql_query ($query);
	while($c=mysql_fetch_array($sql)){
?>
	
		<table width="391" border="0" align="center" cellpadding="3" cellspacing="0" background="gambar/g.png">
			
			<tr>
			  <td width="17">&nbsp;</td>
				<td width="129" height="24"><span class="style5">Kata</span></td>
				<td width="227"><label>
				  <input name="kta" type="text" value="<?php echo $c[0] ?>" size="30" />
			  </label></td>
			</tr>
			<tr>
			  <td>&nbsp;</td>
				<td height="51"><span class="style5">Arti</span></td>
				<td><input type="text" name="art" size="30" maxlength="30" value="<?php echo $c[1] ?>"></td>
			</tr>
			<tr>
			  <td>&nbsp;</td>
				<td>&nbsp;</td>
				<td>&nbsp;&nbsp;
				<input name="Submit" type="submit" value="Simpan">
				&nbsp;</td>
			</tr>
  </table>
		<div align="center"></div>
		<div align="center">
		  <?php
		
}
?>
		  </FORM>
        </div>
</div>

<?php
include "conn.php";
 $edit = mysql_query ("UPDATE `kamus2`.`kamus_id` SET `kata` = '$kta',
`arti` = '$art'
 WHERE `kamus_id`.`kata` =$kta LIMIT 1 ");
  if ($edit) { ?><script type="text/javascript">
          alert("EDIT BERHASIL");
		  document.location="http://localhost/ta/lihat.php";
			</script>  
			<? } else {
			?><script type="text/javascript">
          alert("GAGAL");
		  document.location="http://localhost/ta/lihat.php";
			</script> <? }
  
   
      ?>
Silahkan login untuk menjawab!
0
Robert James M · Sep 12, 2013 · 0 Suka · 0 Tidak Suka
jadi erronya ga tampil atau proses dari update itu sendiri yang ga jalan?
0
Rynda · Sep 16, 2013 · 0 Suka · 0 Tidak Suka
halamnya sudah bisa tampil, tapi proses updatenya g bisa jalan mas..
kira-kira letak kesalahan script saya dimana ya??
tolong bantuannya..
terima kasih..
0
Robert James M · Sep 17, 2013 · 0 Suka · 0 Tidak Suka
gini banyak kemungkinan errornya umumnya si kurang teliti..
coba tiap variable yang dari form di post dulu untuk memastikan data muncul..
kalo udah muncul semua coba liat statementnya apakah sudah benar...

terus tambahakan mysql_error() setelah query agar jelas terlihat erro dimana