doubeizhong5178 2015-05-25 02:35
浏览 22

用php编辑数据

I edit my database on php, it said I success editing my data, but when I check on my sql database, It's not change yet ...

here is the code

<?php
$koneksi = mysql_connect("localhost", "root", "") or die("Gagal konek ke  server.");
mysql_select_db("kasatrian") or die("Gagal membuka database.");
$nis = isset($_GET['nis']) ? $_GET['nis'] :null;
$query = "select * from siswa where nis='$nis'";
$hasil = mysql_query($query, $koneksi) or die("Gagal melakukan query.");
$buff = mysql_fetch_array($hasil);
    mysql_close($koneksi);?>

<form name="form1" method="post" action="edit2.php">
<input type="hidden" name="nis" value="<?php echo $buff['nis']; ?>" />
<table>
<tr>
<td colspan=3><center><font size=5>EDIT DATA SISWA</font></center></td>
</tr>
<tr>
<td>Nama</td><td>:</td><td><input type="text" name="nama" value="<?php echo $buff['nama']; ?>"></td>
</tr>

<tr>
<td colspan=2></td>
<td colspan="3"><input type="submit" name="submit" value="Simpan" /></td>
</tr>
</table>
</form>
<p>Batal mengedit data. Kembali ke <a href="datasiswa.php">Data Siswa</a></p>
</tr>
</table>

and here is the edit process

<?php
$koneksi = mysql_connect("localhost", "root", "") or die("Gagal konek ke server.");

mysql_select_db("kasatrian") or die("Gagal membuka database.");

$nama = isset($_POST['nama']) ? $_POST['nama']: " ";

$query = mysql_query("update siswa set 
nama='$nama' where nis='$nis' ");

mysql_close($koneksi);

?>

<p>Data sudah ter-update. Silakan dicek di <a href="datasiswa.php">data siswa</a></p>

</body>

</html>

the code said it already save, but when I check my DB on SQL, nothing change.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥500 火焰左右视图、视差(基于双目相机)
    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本