index.php
<!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>Untitled Document</title>
</head>
<body>
<form method="post" action="save.php">
<table border="0">
<td><h1>Input Data</h1></td>
<tr>
<td>NIS</td>
<td> : </td>
<td><input type="text" name="nis" placeholder="1" /></td><br />
</tr>
<tr>
<td>Nama Siswa</td>
<td> : </td>
<td><input type="text" name="nama" placeholder="Rizaldha" /></td><br />
</tr>
<tr>
<td>Kelas</td>
<td> : </td>
<td><input type="text" name="kelas" placeholder="XII RPL 3" /></td><br />
</tr>
<tr>
<td>Wali Kelas</td>
<td> : </td>
<td><input type="text" name="wkelas" placeholder="Ibu Trie" /></td><br />
</tr>
<tr>
<td>Alamat</td>
<td> : </td>
<td><input type="text" name="alamat" placeholder="Rancaekek" /></td><br />
</tr>
<tr>
<td>No Telp</td>
<td> : </td>
<td><input type="text" name="tlp" placeholder="089877172711" maxlength="12"/></td><br />
</tr>
<tr><td><input type="submit" value="SIMPAN" /></td></tr>
</table>
</form>
</body>
</html>
save.php
<!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>Save</title>
</head>
<body>
<?php
include('konek.php');
$nis=$_POST['nis'];
$nama=$_POST['nama'];
$kelas=$_POST['kelas'];
$wkelas=$_POST['wkelas'];
$alamat=$_POST['alamat'];
$tlp=$_POST['tlp'];
$sql1="insert into siswa (nis,nama) values ('$nis','$nama')";
$sql2="insert into alamat (nis,alamat,tlp) values ('$nis','$alamat','$tlp')";
$sql3="insert into kelas (nis,kelas,wkelas) values ('$nis','$kelas','$wkelas')";
$hasil1 = mysql_query($sql1);
$hasil2 = mysql_query($sql2);
$hasil3 = mysql_query($sql3);
if($hasil1,$hasil2,$hasil3){
echo " <h1><center>Input Data Berhasil<br> <a href='lihat.php'>lihat Hasil</a></h1></center> ";
}else {
echo " <h1><center>Input Data Gagal. Nis Yang Anda Masukan Sudah Ada Yang Memiliki.!<br><a href='index.php'>Kembali</a></h1></center>";
}
?>
</body>
</html>
lihat.php
<!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>Untitled Document</title>
</head>
<body>
<table border="0" align="center">
<tr>
<td>NIS</td>
<td>Nama Siswa</td>
<td>Kelas</td>
<td>Wali Kelas</td>
<td>Alamat</td>
<td>No Telp</td>
<td>Update</td>
</tr>
<?php
include('koneksi.php');
$sql=mysql_query("select k.nis, s.nama, k.kelas, k.wkelas, a.alamat, a.tlp
from kelas k, siswa s, alamat a
where k.nis = s.nis and s.nis = a.nis and a.nis = k.nis;");
while($table=mysql_fetch_array($sql)){
?>
<tr>
<td><?php echo $a['nis']; ?></td>
<td><?php echo $a['nama']; ?></td>
<td><?php echo $a['kelas']; ?></td>
<td><?php echo $a['wkelas']; ?></td>
<td><?php echo $a['alamat']; ?></td>
<td><?php echo $a['tlp']; ?></td>
<td><a href='edit.php?nis=<?php echo $a['nis']; ?>'>Edit</a> | <a href='hapus.php?nis=<?php echo $a['nis']; ?>'>Hapus</a></td>
</tr>
<?php } ?>
</table>
</body>
</html>
hapus.php
<!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>Untitled Document</title>
</head>
<body>
<?php
include('koneksi.php');
$nis=$_GET['nis'];
$sql=mysql_query('delete from siswa where nis='$nis';');
$sql=mysql_query('delete from alamat where nis='$nis';');
$sql=mysql_query('delete from kelas where nis='$nis';');
header('Location: lihat.php');
?>
</body>
</html>
edit.php
<!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>Untitled Document</title>
</head>
<body>
<?php
include('koneksi.php');
$nis=$_GET['nis'];
$sql=mysql_query("select * from siswa where nis='$nis';");
$sql2=mysql_query("select * from alamat where nis='$nis';");
$sql3=mysql_query("select * from kelas where nis='$nis';");
while($a=mysql_fetch_array($sql,$sql2,$sql3)){
?>
<form method="post" action="edit_data.php">
<table border="0">
<tr>
<td><h1>Edit Data</h1></td>
</tr>
<tr>
<td>NIS</td>
<td> : </td>
<td><input type="text" name="nis" value="<?php echo $b['nis']; ?>"/></td><br />
</tr>
<tr>
<td>Nama Siswa</td>
<td> : </td>
<td><input type="text" name="nama" value="<?php echo $a['nama']; ?>"/></td><br />
</tr>
<tr>
<td>Kelas</td>
<td> : </td>
<td><input type="text" name="kelas" value="<?php echo $c['kelas']; ?>"/></td><br />
</tr>
<tr>
<td>Wali Kelas</td>
<td> : </td>
<td><input type="text" name="wkelas" value="<?php echo $c['wkelas']; ?>"/></td><br />
</tr>
<tr>
<td>Alamat</td>
<td> : </td>
<td><input type="text" name="alamat" value="<?php echo $b['alamat']; ?>"/></td><br />
</tr>
<tr>
<td>No Telp</td>
<td> : </td>
<td><input type="text" name="tlp" maxlength="12" value="<?php echo $b['tlp']; ?>"/></td><br />
</tr>
<tr><td><input type="submit" value="SIMPAN" /></td></tr>
<?php } } } ?>
</form>
</body>
</html>
edit_data.php
<!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>Untitled Document</title>
</head>
<body>
<?php
include('koneksi.php');
$nis=$_POST['nis'];
$nama=$_POST['nama'];
$kelas=$_POST['kelas'];
$wkelas=$_POST['wkelas'];
$alamat=$_POST['alamat'];
$tlp=$_POST['tlp'];
$sql1='update kelas set kelas='$kelas', wkelas='$wkelas' where nis='$nis'';
$sql2='update siswa set nama='$nama' where nis='$nis'';
$sql3='update alamat set alamat='$alamat', tlp='$tlp' where nis='$nis'';
$a=mysql_query($sql1);
$b=mysql_query($sql2);
$c=mysql_query($sql3);
if($a,$b,$c){
echo " <h1><center>Edit Data Berhasil<br> <a href='lihat.php'>lihat Hasil</a></h1></center> ";
}else {
echo " <h1><center>Edit Data Gagal. Coba Lagi.!<br><a href='index.php'>Kembali</a></h1></center>";
}
?>
</body>
</html>
NOTE : JANGAN ASAL MAEN COPAS AJA YA,, HARUS TELITI...
