update.php

<html>
<head>
<title>Update Data Mahasiswa Baru</title>
</head>
<body background="coral">
<?php
include "koneksi.php";
if (isset($_POST['simpan'])){
$koneksi = mysql_connect ("localhost","root","");
mysql_select_db("ta",$koneksi);

$kode= $_POST ['kode'];
$nisn= $_POST ['nisn'];
$nama= $_POST ['nama'];
$tgl_lahir= $_POST ['tgl_lahir'];
$tempat= $_POST ['tempat'];
$kelamin= $_POST ['kelamin'];
$warga= $_POST ['warga'];
$agama= $_POST ['agama'];
$status=$_POST ['status'];
$rumah= $_POST ['rumah'];
$smg=$_POST ['smg'];
$telp=$_POST ['telp'];
$asal= $_POST ['asal'];
$jenis= $_POST ['jenis'];
$statuss= $_POST ['statuss'];
$jurusan=$_POST ['jurusan'];
$thun=$_POST ['thun'];
$jurusan_pilihan= $_POST ['jurusan_pilihan'];
$sts_mhs= $_POST ['sts_mhs'];
$pilih_kuliah= $_POST ['pilih_kuliah'];
$ayah= $_POST ['ayah'];
$ibu= $_POST ['ibu'];
$almt_ort= $_POST ['almt_ort'];
$pdk_orta= $_POST ['pdk_orta'];
$pdk_orti= $_POST ['pdk_orti'];
$pkrayah= $_POST ['pkrayah'];
$pkribu= $_POST ['pkribu'];


$query = "UPDATE admin ".
        "SET kode=$kode,nisn=$nisn,nama=$nama,tgl_lahir=$tgl_lahir,tempat=$tempat,kelamin=$kelamin,'warga'=[value-7],
'agama'=[value-8],'status'=[value-9],'rumah'=[value-10],'smg'=[value-11],'telp'=[value-12],'asal'=[value-13],'jenis'=[value-14],'statuss'=[value-15],
'jurusan'=[value-16],'thun'=[value-17],'jurusan_pilihan'=[value-18],'sts_mhs'=[value-19],
'pilih_kuliah'=[value-20],'ayah'=[value-21],'ibu'=[value-22],'almt_ort'=[value-23],'pdk_orta'=[value-24],
'pdk_orti'=[value-25],'pkrayah'=[value-26],'pkribu'=[value-27] WHERE kode=$kode";

$hasil=mysql_query($query);
if($hasil){
echo "Data Telah Diupdate";
echo "<br>";
}}
?>
[<a href=view.php>Lihat Data Mahasiswa Baru</a>]
</body>
</html>