gan mau tanya kan ane mau bikin tombol update dari data2 yang ada, saat tombol simpan diklik sihhh berhasil tapi saat cek database tetap gak ada perubahan kira-kira apa yang salahhhh??
ini script form yang nampilih editingnya
Quote:
<?
include "../program/koneksi.php";
$EditId = @$_GET['kdedit'];
$sqltampil = "select * from subkriteria where kode_sub='$EditId'";
$qry = mysql_query ($sqltampil) or die ("GAGAL QUERY".mysql_error());
$data=mysql_fetch_array($qry);
?>
<!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>Ubah Kriteria Jasa Telematika</title>
<style type="text/css">
<!-- -->
</style></head>
<link rel="stylesheet" href="css.css"/>
<link rel="stylesheet" href="css/tabel2.css"/>
<!-- <link rel="stylesheet" href="css/tabel1.css"/> -->
<body>
<div class="container">
<div class="header"><a href="home_admin.php"><img name="LOGO" src="../gambar/LOGO.gif" width="180" height="90" border="0" alt="Insert Logo Here"></a>
</div>
<div id="menu">
<ul>
<li><a href="home_admin.php?menu=home"> Home </a></li>
<li><a href="adm_daftar_kriter.php"> Kriteria Jasa Telematika</a></li>
<li><a href="#"> About Us </a></li>
<li><a href="index.php"> Logout </a></li>
</ul>
</div>
<h1>JASA TELEMATIKA</h1>
<p>isinya. </p>
<form action="../program/simpan_edit_krit.php" method="post">
<table width="600" border="1" bordercolor="#CCCCCC">
<tr bgcolor="#CCCCCC" class="form">
<th colspan="3" align="center" >Edit Kriteria</th>
</tr>
<tr>
<td width="170">Nama Kriteria</td>
<td width="11" align="center">:</td>
<td width="585"><input name="n_krit" type="text" id="n_krit" value="<?php echo $data['nama_kriteria']; ?>" maxlength="100" width="585"></td>
</tr>
<tr>
<td>Kode Sub Kriteria</td>
<td>:</td>
<td><input name="kode" type="text" id="kode" value="<?php echo $data['kode_sub']; ?>" maxlength="100" width="585" disabled="disabled"/></td>
</tr>
<tr>
<td width="170">Nama Sub Kriteria</td>
<td align="center">:</td>
<td width="597"><input type="text" id="n_Skrit" name="n_Skrit" width="585" value="<?php echo $data['nama_sub']; ?>" required/></td>
</tr>
<tr><td colspan="3" align="right">
<input name="simpan" type="submit" id="simpan" value="Simpan" width="100px" class="ok"/>
</td></tr>
</table></form>
<h3> </h3>
<div class="footer">
<p><center>© Devi Oktaviana</center></p>
<!-- end .footer --></div>
<!-- end .container --></div>
</body>
</html>
ini script Prosesnya
Quote:
<?php
include "koneksi.php";
$kode = @$_POST['kode'];
$sub = $_POST['n_Skrit'];
$krit = $_POST['n_krit'];
if (trim($krit) == '') {
include "../tampil/ubah_kriteria_adm.php";
echo "Kolom Kriteria Masih Kosong, Silahkan Isi !!!";
}
else if (trim($sub) == ''){
echo "Kolom Sub Kriteria Masih Kosong, Silahkan Isi !!!";
include "../tampil/ubah_kriteria_adm.php";
}
else {
$sqlubah= "UPDATE subkriteria SET
nama_sub = '$sub',
nama_kriteria = '$krit'
WHERE kode_sub = '$kode' ";
mysql_query($sqlubah)
or die ("Koneksi Sql Salah".mysql_error());
echo "Pengubahan Data Sukses";
/*echo"<meta http-equiv='refresh' content='0; url=../tampil/adm_daftar_kriter.php'>";*/
exit;
}
?>
ini gambar databasenya
Kira2 apa yang salah yahhh??? kenapa updatenya ga ngaruh walaupun dinyatakan sukses
???
