Advertisement
GWibisono

perbaikan

Jan 31st, 2014
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?
  2. mysql_connect('localhost','root','');
  3. mysql_select_db('db_semester2');
  4. $id = $_POST['id'];
  5. $nis = $_POST['nis'];
  6. $id_buku = $_POST['id_buku'];
  7. $alamat = $_POST['alamat'];
  8. $jumlah = $_POST['jumlah'];
  9. $kelas = $_POST['kelas'];
  10. $sql="UPDATE tb_peminjam SET nis = '$nis', id_buku = '$id_buku', alamat = '$alamat', jumlah = '$jumlah', kelas = '$kelas' WHERE id = '$id' ";
  11.  
  12. if(mysql_query($sql))
  13. {
  14.    if(mysql_affected_rows() ==0)
  15.   {  
  16.     echo 'tidak ada data yang di update';
  17.   }else{
  18.     header('location:lihat_data.php');
  19.   }
  20. }else{
  21.   echo "terjadi error ".mysql_error()."<br>$sql";
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement