modul aplikasi pelaporan hasil belajar siswa
DESCRIPTION
Modul Aplikasi Pelaporan Hasil Belajar SiswaTRANSCRIPT
SISTEM INFORMASI MANAJEMEN PENILAIAN SISWA SEDERHANA
buat databse dengan nama : Pls
Buat table : user
Buat table : siswa
Buat table : guru
Buat table : nilai
Buat table : kompetensi_keahlian
Buat table : bidang_studi_guru
Buat table : bidang_studi
Buat folder dengan nama : pls dan buat sript dengan kode berikut .
1. Koneksi<?php
session_start();mysql_connect('localhost','root','')or die('NO CONNECT');mysql_select_db('PLS')or die('NO DB');
function session_reporting(){
if(!isset($_SESSION['logged_in'])){$_SESSION['logged_in'] = FALSE;
}if(!isset($_SESSION['user'])){
$_SESSION['user'] = NULL;}if(!isset($_SESSION['pass'])){
$_SESSION['pass'] = NULL;}if(!isset($_SESSION['akses'])){
$_SESSION['akses'] = NULL;}
}
function add_user($user,$pass,$akses){
mysql_query("INSERT INTO user SETkode_user = '".($user)."',pass_user = '".(md5($pass))."',akses_user = '".($akses)."'
");}
session_reporting();
?>
2. Header<!DOCTYPE html><html>
<head><title>..:: PENILAIAN SISWA (PLS) ::..</title><link rel="stylesheet" type="text/css" href="style.css" />
</head><body bgcolor="#fff">
<table width="100%" border="1" align="top" cellspacing="1" cellpadding="1"><tr>
<td height="110" colspan="3" bgcolor="#fff"><h1> PENILAIAN SISWA (PLS) </h1>
</td></tr><tr>
<td rowspan="2" width="2" colspan="2" valign="top">
3. Footer<tr>
<td height="1" colspan="3" bgcolor="#fff"><center><p>Copy Gigir © Penilaian Siswa akademik
2015</p></center></td>
</tr></table>
</body></html>
4. Menu
</td></tr><tr>
<td width="250" valign="top"><ul class="menu"><?
if($_SESSION['akses'] == "ADMIN" AND$_SESSION['logged_in'] == TRUE){
?><li><a href="home.php"
><button>Home</button></a></li><li><a href="siswa.php" ><button>Data
Siswa</button></a></li><li><a href="penilaian.php" ><button>Data
Penilaian</button></a></li><li><a href="guru.php" ><button>Data
Guru</button></a></li><li><button
onClick="window.open('http://localhost/pls/user.php','popuppage','width=500,toolbar=0,resizable=0,scrollbars=no,height=400,top=100,left=100');">User</button></li>
<li><a href="logout.php"><button>Logout</button></a></li>
<?}elseif($_SESSION['akses'] == "GURU" AND
$_SESSION['logged_in'] == TRUE){?>
<li><a href="home.php"><button>Home</button></a></li>
<li><a href="siswa.php" ><button>DataSiswa</button></a></li>
<li><a href="penilaian.php" ><button>DataPenilaian</button></a></li>
<li><a href="detail_guru.php"><button>Detail Guru</button></a></li>
<li><a href="logout.php"><button>Logout</button></a></li>
<?}elseif($_SESSION['akses'] == "SISWA" AND
$_SESSION['logged_in'] == TRUE){?>
<li><a href="home.php"><button>Home</button></a></li>
<li><a href="detail_siswa.php"><button>Detail Siswa</button></a></li>
<li><a href="detail_nilai.php"><button>Detail Nilai Siswa</button></a></li>
<li><a href="logout.php"><button>Logout</button></a></li>
<?}else{
?><li><a href="home.php"
><button>Home</button></a></li><li><a href="login.php"
><button>Login</button></a></li><?
}?></ul>
</td></tr>
5. Index
<?phpif(!isset($_GET['hal'])){
header('location: home.php');}else{
$hal = $_GET['hal'];switch($hal){
case 'home':header('location: home.php');break;case 'login':header('location: login.php');break;case 'logout':header('location: logout.php');break;
}}
?>
6. Home<?php
include('koneksi.php');include('header.php');
?><fieldset>
<center><h1>SELAMAT DATANG DI PENILAIAN SISWA (PLS) </h1>
<? if($_SESSION['logged_in']!=TRUE){ ?><p>Silahkan <a href="login.php" >Login</a> Dulu dong .. ! dan Selamat datang di
aplikasi penilaian siswa W</p><? }else{ ?>
<p>Hai <? echo $_SESSION['user']; ?> , Selamat datang kembali di sistem informasipenilaian siswa . </p>
<? } ?><p>Silahkan pilih menu di sebelah kanan</p>
</center></fieldset>
<?include('menu.php');include('footer.php');
?>
7. Login<?php
include('koneksi.php');include('header.php');if(isset($_POST['login'])){
$query = mysql_query(" SELECT * FROM user WHERE kode_user ='".($_POST['username'])."' AND pass_user = '".(md5($_POST['password']))."' ");
if(mysql_num_rows($query)!=0){while($sessi = mysql_fetch_array($query)){
$_SESSION['user'] = $sessi['kode_user'];$_SESSION['pass'] = $sessi['pass_user'];$_SESSION['akses'] = $sessi['akses_user'];$_SESSION['logged_in'] = TRUE;
}echo "<script>location.assign('index.php')</script>";echo "<script>alert('LOGIN BERHASIL')</script>";
}else{echo "<script>alert('LOGIN GAGAL')</script>";
}}
?><fieldset>
<center><style>
#login {background-color: #fffffff;
}#login:hover {
background: #fff;box-shadow: 5px 5px 50px 5px #fffddd;
}#input {
width: 400px;height: 55px;background-color: #f9f9f9;
}#input:hover {
width: 400px;height: 55px;background-color: #ffffff;
}#login button , input{
width: 400px;}.keresek {
width: 200px;margin: 20px auto;
}</style><fieldset class="keresek"><legend>Administrator Login</legend><form action="<?= $_SERVER['PHP_SELF']; ?>?login" name="login"
method="post">
<table align="center" border="1" cellspacing="0" cellpadding="5"id="login" width="0">
<thead><tr>
<th colspan="3"bgcolor="white"><center><h2>SILAHKAN LOGIN DULU DONG</h2></center></th>
</tr><tr>
<thalign="center"><label>NIP / NISN</label></th>
<td align="center">:</td><td align="center"><input type="text"
name="username" value="" id="input" placeholder="NIP / NISN" /></td></tr><tr>
<thalign="center"><label>Nama User</label></th>
<td align="center">:</td><td align="center"><input type="password"
name="password" value="" id="input" placeholder="Kunci / Nama User" /></td></tr><tr>
<thalign="center"><label> </label></th>
<td align="center">:</td><td align="center"><input type="submit"
name="login" class="button" value="Login" /><input type="reset" name="reset" value="Reset" /><ahref="<? echo $_SERVER['PHP_SELF']; ?>" ><button>Refresh</button></a></td>
</tr><tr>
<th colspan="3"bgcolor="white"><center><i>copy gigir © Login dulu dong 2015</i></center></th>
</tr></thead>
</table></form></fieldset>
</center></fieldset>
<?include('menu.php');include('footer.php');
?>
8. Logout<?php
include('koneksi.php');unset($_SESSION['user']);unset($_SESSION['pass']);unset($_SESSION['logged_in']);$_SESSION['logged_in'] = FALSE;//header('location:index.php');session_destroy();echo "<script>location.assign('index.php')</script>";
?>
9. User<? include('koneksi.php'); ?><?php
if(isset($_POST['insert'])){if(md5($_POST['pass_user']) == md5($_POST['confir_pass'])){
$insert = mysql_query("INSERT INTO user SETkode_user = '".($_POST['kode_user'])."',pass_user = '".(md5($_POST['pass_user']))."',akses_user = 'ADMIN'
");if($insert){
echo "<script>alert('INSERT DATA BERHASIL')</script>";}else{
echo "<script>alert('INSERT DATA GAGAL')</script>";}
}else{echo "<script>alert('PASSWORD TIDAK SAMA')</script>";
}}elseif(isset($_GET['delete_record'])){
mysql_query("DELETE FROM user WHERE id_user = '".($_GET['delete_record'])."' ");}
?><?
if(isset($_GET['add_record'])){?>
<fieldset><h2> Add Record Data User </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?insert'; ?>" name="insert"
method="post"><table>
<tr><th align="left"><label>Nama User</label></th><th>:</th><td><input type="text" name="kode_user" value="" /></td>
</tr><tr>
<th align="left"><label>Pass User</label></th>
<th>:</th><td><input type="password" name="pass_user" value=""
/></td></tr><tr>
<th align="left"><label>Confirm Pass</label></th><th>:</th><td><input type="password" name="confir_pass" value=""
/></td></tr><tr>
<td colspan="3"><input type="submit" name="insert" value="Save
Record" /><input type="reset" name="reset" value="Reset" />
</td></tr>
</table></form>
</fieldset><?
}?>
<fieldset><h2>Data User</h2><hr>
<span class="left"><a href="<? echo $_SERVER['PHP_SELF']; ?>" ><button>Refresh</button></a><a href="<? echo $_SERVER['PHP_SELF'].'?add_record'; ?>" ><button>Add
Record</button></a></span>
</fieldset><fieldset><table border="1" cellspacing="1" cellpadding="1" width="100%">
<tr><th width="1"> No </th><th>Kode User</th><th>Pass User</th><th>Akses User</th><th width="1"> Menu </th>
</tr><?
$i = 1;$query = mysql_query(" SELECT * FROM user ORDER BY akses_user ASC ");while($rows = mysql_fetch_array($query)){
?><tr>
<td><? echo $i; ?></td><td><? echo $rows['kode_user']; ?></td><td><? echo $rows['pass_user']; ?></td><td><? echo $rows['akses_user']; ?></td><td class="tool">
<a href="<? echo$_SERVER['PHP_SELF'].'?delete_record='.$rows['id_user']; ?>" ><button>Remove</button></a>
</td></tr>
<?$i++;}if(mysql_num_rows($query)=='0'){
echo "<tr><td colspan='4'><h3><b> DATA TIDAK ADA </b></h3></td>";}
?></table></fieldset>
10. Siswa<?php
include('koneksi.php');include('header.php');
if(isset($_POST['insert'])){$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM siswa WHERE nisn_siswa =
'".($_POST['nisn_siswa'])."' "));if($rowz['nisn_siswa']!=$_POST['nisn_siswa']){
$insert = mysql_query("INSERT INTO siswa SETnisn_siswa = '".($_POST['nisn_siswa'])."',nama_siswa = '".($_POST['nama_siswa'])."',alamat_siswa = '".($_POST['alamat_siswa'])."',tanggal_lahir = '".($_POST['tanggal_lahir'])."',kompetensi_keahlian = '".($_POST['kompetensi_keahlian'])."',kelas_siswa = '".($_POST['kelas_siswa'])."',nama_ayah = '".($_POST['nama_ayah'])."',pekerjaan_ayah = '".($_POST['pekerjaan_ayah'])."',nama_ibu = '".($_POST['nama_ibu'])."',pekerjaan_ibu = '".($_POST['pekerjaan_ibu'])."',alamat_orangtua = '".($_POST['alamat_orangtua'])."',telepon_orangtua = '".($_POST['telepon_orangtua'])."'
");if($insert){
add_user($_POST['nisn_siswa'],$_POST['nama_siswa'],'SISWA');echo "<script>alert('INSERT DATA BERHASIL')</script>";
}else{echo "<script>alert('INSERT DATA GAGAL')</script>";
}}else{
echo "<script>alert('DUPLICATE NISN SISWA')</script>";}
}elseif(isset($_POST['update'])){
$update = mysql_query("UPDATE siswa SETnisn_siswa = '".($_POST['nisn_siswa'])."',nama_siswa = '".($_POST['nama_siswa'])."',
alamat_siswa = '".($_POST['alamat_siswa'])."',tanggal_lahir = '".($_POST['tanggal_lahir'])."',kompetensi_keahlian = '".($_POST['kompetensi_keahlian'])."',kelas_siswa = '".($_POST['kelas_siswa'])."',nama_ayah = '".($_POST['nama_ayah'])."',pekerjaan_ayah = '".($_POST['pekerjaan_ayah'])."',nama_ibu = '".($_POST['nama_ibu'])."',pekerjaan_ibu = '".($_POST['pekerjaan_ibu'])."',alamat_orangtua = '".($_POST['alamat_orangtua'])."',telepon_orangtua = '".($_POST['telepon_orangtua'])."'WHEREkode_siswa = '".($_POST['kode_siswa'])."'
");if($update){
echo "<script>alert('UPDATE DATA BERHASIL')</script>";}else{
echo "<script>alert('UPDATE DATA GAGAL')</script>";}
}elseif(isset($_GET['delete_record'])){
mysql_query("DELETE FROM siswa WHERE kode_siswa = '".($_GET['delete_record'])."'");
mysql_query("DELETE FROM nilai WHERE nisn_siswa = '".($_GET['remove_record'])."' ");mysql_query("DELETE FROM user WHERE kode_user = '".($_GET['remove_record'])."' ");
}?>
<?if(isset($_GET['add_record'])){
?><fieldset>
<h2> Add Record Data Siswa </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?insert'; ?>" name="insert"
method="post"><table>
<tr><th
align="left"><label>NISN / User</label></th><th>:</th><td><input type="text" name="nisn_siswa" value="" required
/></td></tr><tr>
<thalign="left"><label>Nama Siswa / Pass</label></th>
<th>:</th><td><input type="text" name="nama_siswa" value=""
/></td></tr><tr>
<th align="left"><label>Alamat</label></th>
<th>:</th><td><input type="text" name="alamat_siswa" value=""
/></td></tr><tr>
<th align="left"><label>Tangal Lahir</label></th><th>:</th><td><input type="text" name="tanggal_lahir" value=""
/></td></tr><tr>
<th align="left"><label>Kompetensi Keahlian</label></th><th>:</th><td>
<select name="kompetensi_keahlian" ><option value="" >---[ Kompetensi Keahlian
]---</option><?
$qkateg = mysql_query(" SELECT * FROMkompetensi_keahlian ORDER BY nama_kompetensi ASC ");
while($rkateg = mysql_fetch_array($qkateg)){?>
<option value="<? echo$rkateg['nama_kompetensi']; ?>" >[ <? echo $rkateg['kode_kompetensi']; ?> ] - <? echo$rkateg['nama_kompetensi']; ?></option>
<? } ?></select>
</td><td><button
onClick="window.open('http://localhost/pls/kompetensi_keahlian.php','popuppage','width=500,toolbar=0,resizable=0,scrollbars=no,height=400,top=100,left=100');">+</button></td>
</tr><tr>
<th align="left"><label>Kelas Siswa</label></th><th>:</th><td>
<select name="kelas_siswa"><option value="" >---[ Kelas ]----</option>
<? $kelas_siswa = array('X','XII','XIII');foreach($kelas_siswa as $kelas): ?>
<option value="<? echo $kelas; ?>" ><?echo $kelas; ?></option>
<? endforeach; ?></select>
</td></tr><tr>
<th align="left"><label>Nama Ayah</label></th><th>:</th><td><input type="text" name="nama_ayah" value="" /></td>
</tr><tr>
<th align="left"><label>Pekerjaan Ayah</label></th>
<th>:</th><td><input type="text" name="pekerjaan_ayah" value=""
/></td></tr><tr>
<th align="left"><label>Nama Ibu</label></th><th>:</th><td><input type="text" name="nama_ibu" value="" /></td>
</tr><tr>
<th align="left"><label>Pekerjaan Ibu</label></th><th>:</th><td><input type="text" name="pekerjaan_ibu" value=""
/></td></tr><tr>
<th align="left"><label>Alamat Orangtua</label></th><th>:</th><td><input type="text" name="alamat_orangtua" value=""
/></td></tr><tr>
<th align="left"><label>Telepon Orangtua</label></th><th>:</th><td><input type="text" name="telepon_orangtua" value=""
/></td></tr><tr>
<td colspan="3"><input type="submit" name="insert" value="Save
Record" /><input type="reset" name="reset" value="Reset" />
</td></tr>
</table></form>
</fieldset><?
}elseif(isset($_GET['edit_record'])){
$edit = $_GET['edit_record'];$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM siswa WHERE kode_siswa =
'".($_GET['edit_record'])."' "));?>
<fieldset><h2> Edit Record Data Siswa </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?update'; ?>" name="update"
method="post"><table>
<tr>
<thalign="left"><label>NISN / User</label></th>
<th>:</th><td><input type="text" name="nisn_siswa" value="<? echo
$rowz['nisn_siswa']; ?>" disabled /></td></tr><tr>
<thalign="left"><label>Nama Siswa / User</label></th>
<th>:</th><td><input type="text" name="nama_siswa" value="<? echo
$rowz['nama_siswa']; ?>" /></td></tr><tr>
<th align="left"><label>Alamat</label></th><th>:</th><td><input type="text" name="alamat_siswa" value="<?
echo $rowz['alamat_siswa']; ?>" /></td></tr><tr>
<th align="left"><label>Tangal Lahir</label></th><th>:</th><td><input type="text" name="tanggal_lahir" value="<? echo
$rowz['tanggal_lahir']; ?>" /></td></tr><tr>
<th align="left"><label>Kompetensi Keahlian</label></th><th>:</th><td>
<select name="kompetensi_keahlian" ><option value="" ><? echo
$rowz['kompetensi_keahlian']; ?></option><?
$qkateg = mysql_query(" SELECT * FROMkompetensi_keahlian ORDER BY nama_kompetensi ASC ");
while($rkateg = mysql_fetch_array($qkateg)){?>
<option value="<? echo$rkateg['nama_kompetensi']; ?>" >[ <? echo $rkateg['kode_kompetensi']; ?> ] - <? echo$rkateg['nama_kompetensi']; ?></option>
<? } ?></select>
</td><td><button
onClick="window.open('http://localhost/pls/kompetensi_keahlian.php','popuppage','width=500,toolbar=0,resizable=0,scrollbars=no,height=400,top=100,left=100');">+</button></td>
</tr><tr>
<th align="left"><label>Kelas Siswa</label></th><th>:</th><td>
<select name="kelas_siswa">
<option value="<? echo$rowz['kelas_siswa']; ?>" ><? echo $rowz['kelas_siswa']; ?></option>
<? $kelas_siswa = array('X','XII','XIII');foreach($kelas_siswa as $kelas): ?>
<option value="<? echo $kelas; ?>" ><?echo $kelas; ?></option>
<? endforeach; ?></select>
</td></tr><tr>
<th align="left"><label>Nama Ayah</label></th><th>:</th><td><input type="text" name="nama_ayah" value="<? echo
$rowz['nama_ayah']; ?>" /></td></tr><tr>
<th align="left"><label>Pekerjaan Ayah</label></th><th>:</th><td><input type="text" name="pekerjaan_ayah" value="<?
echo $rowz['pekerjaan_ayah']; ?>" /></td></tr><tr>
<th align="left"><label>Nama Ibu</label></th><th>:</th><td><input type="text" name="nama_ibu" value="<? echo
$rowz['nama_ibu']; ?>" /></td></tr><tr>
<th align="left"><label>Pekerjaan Ibu</label></th><th>:</th><td><input type="text" name="pekerjaan_ibu" value="<?
echo $rowz['pekerjaan_ibu']; ?>" /></td></tr><tr>
<th align="left"><label>Alamat Orangtua</label></th><th>:</th><td><input type="text" name="alamat_orangtua" value="<?
echo $rowz['alamat_orangtua']; ?>" /></td></tr><tr>
<th align="left"><label>Telepon Orangtua</label></th><th>:</th><td><input type="text" name="telepon_orangtua" value="<?
echo $rowz['telepon_orangtua']; ?>" /></td></tr><tr>
<td colspan="3"><input type="hidden" name="kode_siswa"
value="<? echo $rowz['kode_siswa']; ?>" /><input type="submit" name="update"
value="Update Record" /><input type="reset" name="reset" value="Reset" />
</td></tr>
</table></form>
</fieldset><?
}elseif(isset($_GET['detail_record'])){
$detail = $_GET['detail_record'];$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM siswa WHERE kode_siswa =
'".($_GET['detail_record'])."' "));?>
<fieldset><h2> Detail Record Data Siswa </h2><hr>
<table><tr>
<th align="left"><label>NISN</label></th><th>:</th><td><? echo $rowz['nisn_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Nama Siswa</label></th><th>:</th><td><? echo $rowz['nama_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Alamat</label></th><th>:</th><td><? echo $rowz['alamat_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Tangal Lahir</label></th><th>:</th><td><? echo $rowz['tanggal_lahir']; ?></td>
</tr><tr>
<th align="left"><label>Kompetensi Keahlian</label></th><th>:</th><td><? echo $rowz['kompetensi_keahlian']; ?></td>
</tr><tr>
<th align="left"><label>Kelas Siswa</label></th><th>:</th><td><? echo $rowz['kelas_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Nama Ayah</label></th><th>:</th><td><? echo $rowz['nama_ayah']; ?></td>
</tr><tr>
<th align="left"><label>Pekerjaan Ayah</label></th><th>:</th><td><? echo $rowz['pekerjaan_ayah']; ?></td>
</tr><tr>
<th align="left"><label>Nama Ibu</label></th><th>:</th><td><? echo $rowz['nama_ibu']; ?></td>
</tr><tr>
<th align="left"><label>Pekerjaan Ibu</label></th><th>:</th><td><? echo $rowz['pekerjaan_ibu']; ?></td>
</tr><tr>
<th align="left"><label>Alamat Orangtua</label></th><th>:</th><td><? echo $rowz['alamat_orangtua']; ?></td>
</tr><tr>
<th align="left"><label>Telepon Orangtua</label></th><th>:</th><td><? echo $rowz['telepon_orangtua']; ?></td>
</tr></table>
</fieldset><?
}?>
<fieldset><h2>Data Siswa</h2><hr>
<span class="left"><a href="<? echo $_SERVER['PHP_SELF']; ?>" ><button>Refresh</button></a><? if($_SESSION['akses'] == "ADMIN"){ ?><a href="<? echo $_SERVER['PHP_SELF'].'?add_record'; ?>" ><button>Add
Record</button></a><? } ?>
</span><span class="right">
<form action="<? echo $_SERVER['PHP_SELF'].'?search'; ?>" name="search"method="get" >
<select name="kelas_siswa"><option value="" >---[ Kelas ]---</option>
<? $class_siswa = array('X','XII','XIII');foreach($class_siswa as $kelas): ?>
<option value="<? echo $kelas; ?>" ><?echo $kelas; ?></option>
<? endforeach; ?></select><select name="kompetensi_keahlian" >
<option value="" >---[ Kompetensi Keahlian]---</option>
<?$qjurus = mysql_query(" SELECT * FROM
kompetensi_keahlian ORDER BY nama_kompetensi ASC ");while($rjurus = mysql_fetch_array($qjurus)){
?><option value="<? echo
$rjurus['nama_kompetensi']; ?>" ><? echo $rjurus['nama_kompetensi']; ?></option><? } ?>
</select><input type="text" name="keyword" value="" /><input type="submit" name="search" value="Search" />
</form></span>
</fieldset><fieldset><table border="1" cellspacing="1" cellpadding="1" width="100%">
<tr><th width="1"> No </th><th>NISN</th><th>Nama</th><th>Kompetensi Keahlian</th><th>Kelas</th><th>Alamat</th><th width="1"> Menu </th>
</tr><?
if(isset($_GET['search'])){$where = "WHERE kelas_siswa LIKE '%".($_GET['kelas_siswa'])."%' AND
kompetensi_keahlian LIKE '%".($_GET['kompetensi_keahlian'])."%' AND nisn_siswa LIKE'%".($_GET['keyword'])."%' ";
}else{$where = "";
}
$i = 1;$query = mysql_query(" SELECT * FROM siswa $where ORDER BY nama_siswa ASC ");while($rows = mysql_fetch_array($query)){
?><tr>
<td><? echo $i; ?></td><td><? echo $rows['nisn_siswa']; ?></td><td><? echo $rows['nama_siswa']; ?></td><td><? echo $rows['kompetensi_keahlian']; ?></td><td><? echo $rows['kelas_siswa']; ?></td><td><? echo $rows['alamat_siswa']; ?></td><td class="tool">
<a href="<? echo$_SERVER['PHP_SELF'].'?detail_record='.$rows['kode_siswa']; ?>" ><button>Detail</button></a>
<? if($_SESSION['akses'] == "ADMIN"){ ?><a href="<? echo
$_SERVER['PHP_SELF'].'?edit_record='.$rows['kode_siswa']; ?>" ><button>Edit</button></a>
<a href="<? echo$_SERVER['PHP_SELF'].'?delete_record='.$rows['kode_siswa'].'&remove_record='.$rows['nisn_siswa'];?>" ><button>Delete</button></a>
<? } ?></td>
</tr><?
$i++;}if(mysql_num_rows($query)=='0'){
echo "<tr><td colspan='7'><h3><b> DATA TIDAK ADA </b></h3></td>";}
?></table></fieldset>
<?include('menu.php');include('footer.php');
?>
11. Guru<?php
include('koneksi.php');include('header.php');
if(isset($_POST['insert'])){$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM guru WHERE nip_guru =
'".($_POST['nip_guru'])."' "));if($rowz['nip_guru']!=$_POST['nip_guru']){
$insert = mysql_query("INSERT INTO guru SETnip_guru = '".($_POST['nip_guru'])."',nama_guru = '".($_POST['nama_guru'])."',alamat_guru = '".($_POST['alamat_guru'])."',telphon = '".($_POST['telphon'])."',kompetensi_keahlian = '".($_POST['kompetensi_keahlian'])."',bidang_studi = '".($_POST['bidang_studi'])."'
");if($insert){
add_user($_POST['nip_guru'],$_POST['nama_guru'],'GURU');echo "<script>alert('INSERT DATA BERHASIL')</script>";
}else{echo "<script>alert('INSERT DATA GAGAL')</script>";
}}else{
echo "<script>alert('DUPLICATE NIP GURU')</script>";}
}elseif(isset($_POST['update'])){
$update = mysql_query("UPDATE guru SET
nip_guru = '".($_POST['nip_guru'])."',nama_guru = '".($_POST['nama_guru'])."',alamat_guru = '".($_POST['alamat_guru'])."',telphon = '".($_POST['telphon'])."',kompetensi_keahlian = '".($_POST['kompetensi_keahlian'])."',bidang_studi = '".($_POST['bidang_studi'])."'WHEREkode_guru = '".($_POST['kode_guru'])."'
");if($update){
echo "<script>alert('UPDATE DATA BERHASIL')</script>";}else{
echo "<script>alert('UPDATE DATA GAGAL')</script>";}
}elseif(isset($_GET['delete_record'])){
mysql_query("DELETE FROM guru WHERE kode_guru = '".($_GET['delete_record'])."' ");mysql_query("DELETE FROM bidang_studi_guru WHERE kode_bidang =
'".($_GET['remove_record'])."' ");mysql_query("DELETE FROM user WHERE kode_user = '".($_GET['remove_record'])."' ");
}?>
<?if(isset($_GET['add_record'])){
?><fieldset>
<h2> Add Record Data Guru </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?insert'; ?>" name="insert"
method="post"><table>
<tr><th align="left"><label>NIP / User</label></th><th>:</th><td><input type="text" name="nip_guru" value="" required
/></td></tr><tr>
<thalign="left"><label>Nama / Pass</label></th>
<th>:</th><td><input type="text" name="nama_guru" value="" /></td>
</tr><tr>
<th align="left"><label>Alamat</label></th><th>:</th><td><input type="text" name="alamat_guru" value=""
/></td></tr><tr>
<th align="left"><label>Telepon</label></th>
<th>:</th><td><input type="text" name="telphon" value="" /></td>
</tr><tr>
<th align="left"><label>Kompetensi Keahlian</label></th><th>:</th><td>
<select name="kompetensi_keahlian" ><option value="" >---[ Kompetensi Keahlian
]---</option><?
$qkateg = mysql_query(" SELECT * FROMkompetensi_keahlian ORDER BY nama_kompetensi ASC ");
while($rkateg = mysql_fetch_array($qkateg)){?>
<option value="<? echo$rkateg['nama_kompetensi']; ?>" >[ <? echo $rkateg['kode_kompetensi']; ?> ] - <? echo$rkateg['nama_kompetensi']; ?></option>
<? } ?></select>
</td><td><button
onClick="window.open('http://localhost/pls/kompetensi_keahlian.php','popuppage','width=500,toolbar=0,resizable=0,scrollbars=no,height=400,top=100,left=100');">+</button></td>
</tr><tr>
<td colspan="3"><input type="submit" name="insert" value="Save
Record" /><input type="reset" name="reset" value="Reset" />
</td></tr>
</table></form>
</fieldset><?
}elseif(isset($_GET['edit_record'])){
$edit = $_GET['edit_record'];$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM guru WHERE kode_guru =
'".($_GET['edit_record'])."' "));?>
<fieldset><h2> Edit Record Data Guru </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?update'; ?>" name="update"
method="post"><table>
<tr><th align="left"><label>NIP / User</label></th><th>:</th>
<td><input type="text" name="nip_guru" value="<? echo$rowz['nip_guru']; ?>" disabled /></td>
</tr><tr>
<thalign="left"><label>Nama / Pass</label></th>
<th>:</th><td><input type="text" name="nama_guru" value="<? echo
$rowz['nama_guru']; ?>" /></td></tr><tr>
<th align="left"><label>Alamat</label></th><th>:</th><td><input type="text" name="alamat_guru" value="<? echo
$rowz['alamat_guru']; ?>" /></td></tr><tr>
<th align="left"><label>Telepon</label></th><th>:</th><td><input type="text" name="telphon" value="<? echo
$rowz['telphon']; ?>" /></td></tr><tr>
<th align="left"><label>Kompetensi Keahlian</label></th><th>:</th><td>
<select name="kompetensi_keahlian" ><option value="<? echo
$rowz['kompetensi_keahlian']; ?>" ><? echo $rowz['kompetensi_keahlian']; ?></option><?
$qkateg = mysql_query(" SELECT * FROMkompetensi_keahlian ORDER BY nama_kompetensi ASC ");
while($rkateg = mysql_fetch_array($qkateg)){?>
<option value="<? echo$rkateg['nama_kompetensi']; ?>" >[ <? echo $rkateg['kode_kompetensi']; ?> ] - <? echo$rkateg['nama_kompetensi']; ?></option>
<? } ?></select>
</td><td><button
onClick="window.open('http://localhost/pls/kompetensi_keahlian.php','popuppage','width=500,toolbar=0,resizable=0,scrollbars=no,height=400,top=100,left=100');">+</button></td>
</tr><tr>
<td colspan="3"><input type="hidden" name="kode_guru" value="<?
echo $rowz['kode_guru']; ?>" /><input type="submit" name="update"
value="Update Record" /><input type="reset" name="reset" value="Reset" />
</td></tr>
</table></form>
</fieldset><?
}elseif(isset($_GET['detail_record'])){
$detail = $_GET['detail_record'];$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM guru WHERE kode_guru =
'".($_GET['detail_record'])."' "));?>
<fieldset><h2> Detail Record Data Guru </h2><hr>
<table><tr>
<th align="left"><label>NIP</label></th><th>:</th><td><? echo $rowz['nip_guru']; ?></td>
</tr><tr>
<th align="left"><label>Nama</label></th><th>:</th><td><? echo $rowz['nama_guru']; ?></td>
</tr><tr>
<th align="left"><label>Kompetensi Keahlian</label></th><th>:</th><td><? echo $rowz['kompetensi_keahlian']; ?></td>
</tr><tr>
<td colspan="3"><fieldset>
<legend>Bidang Studi Guru</legend><table>
<?$no = 1;$qnil = mysql_query(" SELECT * FROM
bidang_studi_guru WHERE kode_bidang = '".($rowz['nip_guru'])."' ORDER BY nama_bidang ASC ");while($rnil = mysql_fetch_array($qnil)){
?><tr>
<th align="left"><label>Bidang Studi <? echo $no;?></label></th>
<th>:</th><td><? echo $rnil['nama_bidang']; ?></td><td>|</td><th align="left"><label>Kelas</label></th><th>:</th><td><? echo $rnil['kelas_bidang']; ?></td>
</tr><? $no++; } ?>
</table>
</fieldset><td>
</tr><tr>
<th align="left"><label>Alamat</label></th><th>:</th><td><? echo $rowz['alamat_guru']; ?></td>
</tr><tr>
<th align="left"><label>Telepon</label></th><th>:</th><td><? echo $rowz['telphon']; ?></td>
</tr></table>
</fieldset><?
}?>
<fieldset><h2>Data Guru</h2><hr>
<span class="left"><a href="<? echo $_SERVER['PHP_SELF']; ?>" ><button>Refresh</button></a><? if($_SESSION['akses'] == "ADMIN"){ ?><a href="<? echo $_SERVER['PHP_SELF'].'?add_record'; ?>" ><button>Add
Record</button></a><button
onClick="window.open('http://localhost/pls/bidang_studi.php','popuppage','width=500,toolbar=0,resizable=0,scrollbars=no,height=400,top=100,left=100');">Add Bidang Studi</button>
<? } ?></span><span class="right">
<form action="<? echo $_SERVER['PHP_SELF'].'?search'; ?>" name="search"method="get" >
<input type="text" name="keyword" value="" /><input type="submit" name="search" value="Search" />
</form></span>
</fieldset><fieldset><table border="1" cellspacing="1" cellpadding="1" width="100%">
<tr><th width="1"> No </th><th>Kode Guru</th><th>NIP</th><th>Nama</th><th>Kompetensi Keahlian</th><th width="1"> Menu </th>
</tr><?
if(isset($_GET['search'])){$where = "WHERE nama_guru LIKE '%".($_GET['keyword'])."%'";
}else{
$where = "";}$i = 1;$query = mysql_query(" SELECT * FROM guru $where ORDER BY nama_guru ASC ");while($rows = mysql_fetch_array($query)){
?><tr>
<td><? echo $i; ?></td><td><? echo $rows['kode_guru']; ?></td><td><? echo $rows['nip_guru']; ?></td><td><? echo $rows['nama_guru']; ?></td><td><? echo $rows['kompetensi_keahlian']; ?></td><td class="tool">
<a href="<? echo$_SERVER['PHP_SELF'].'?detail_record='.$rows['kode_guru']; ?>" ><button>Detail</button></a>
<? if($_SESSION['akses'] == "ADMIN"){ ?><a href="#"
onClick="window.open('http://localhost/pls/bidang_studi_guru.php?bidang_record=<? echo$rows['kode_guru'];?>','popuppage','width=500,toolbar=0,resizable=0,scrollbars=no,height=400,top=100,left=100');"><button>Bidang</button></a>
<a href="<? echo$_SERVER['PHP_SELF'].'?edit_record='.$rows['kode_guru']; ?>" ><button>Edit</button></a>
<a href="<? echo$_SERVER['PHP_SELF'].'?delete_record='.$rows['kode_guru'].'&remove_record='.$rows['nip_guru']; ?>"><button>Delete</button></a>
<? } ?></td>
</tr><?
$i++;}if(mysql_num_rows($query)=='0'){
echo "<tr><td colspan='9'><h3><b> DATA TIDAK ADA </b></h3></td>";}
?></table></fieldset>
<?include('menu.php');include('footer.php');
?>
12. Penilaian<?php
include('koneksi.php');include('header.php');
if($_SESSION['akses'] == "GURU"){$rowg = mysql_fetch_array(mysql_query(" SELECT * FROM guru WHERE nip_guru =
'".($_SESSION['user'])."' "));}
if(isset($_POST['insert_nilai'])){$qnil = mysql_query(" SELECT * FROM nilai WHERE nisn_siswa =
'".($_POST['nisn_siswa'])."' ");$rnil = mysql_fetch_array($qnil);if($rnil['nisn_siswa']!=$_POST['nisn_siswa']){
$qibid = mysql_query(" SELECT DISTINCT nama_bidang FROMbidang_studi_guru WHERE kelas_bidang = '".($_POST['kelas_siswa'])."' ORDER BY nama_bidang ASC ");
$i = 1;while($ribed = mysql_fetch_array($qibid)){
$insert = mysql_query("INSERT INTO nilai SETnisn_siswa = '".($_POST['nisn_siswa'])."',bidang_studi = '".($_POST['bidang_'.$i.''])."',nilai_angka = '".($_POST['angka_'.$i.''])."',nilai_huruf = '".($_POST['huruf_'.$i.''])."'
");$i++;}if($insert){
echo "<script>alert('INSERT DATA BERHASIL')</script>";}else{
echo "<script>alert('INSERT DATA GAGAL')</script>";}
}else{echo "<script>alert('DUPLICATE NISN SISWA')</script>";
}}elseif(isset($_POST['update_nilai'])){
$qibid = mysql_query(" SELECT * FROM nilai ");while($ribed = mysql_fetch_array($qibid)){
$update = mysql_query("UPDATE nilai SETnilai_angka =
'".($_POST['angka_'.($ribed['kode_nilai']).''])."',nilai_huruf =
'".($_POST['huruf_'.($ribed['kode_nilai']).''])."'WHEREkode_nilai =
'".($_POST['kode_'.($ribed['kode_nilai']).''])."'");
}if($update){
echo "<script>alert('UPDATE DATA BERHASIL')</script>";}else{
echo "<script>alert('UPDATE DATA GAGAL')</script>";}
}elseif(isset($_GET['remove_record'])){
mysql_query("DELETE FROM nilai WHERE nisn_siswa = '".($_GET['remove_record'])."' ");}
if(isset($_GET['add_nilai'])){$add_nilai = $_GET['add_nilai'];$rsis = mysql_fetch_array(mysql_query(" SELECT * FROM siswa WHERE nisn_siswa =
'".($_GET['add_nilai'])."' "));?>
<fieldset><h2> Add Record Data Nilai Siswa </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?insert_nilai'; ?>" name="insert_nilai"
method="post"><input type="hidden" name="nisn_siswa" value="<? echo $rsis['nisn_siswa']; ?>" /><input type="hidden" name="kelas_siswa" value="<? echo $rsis['kelas_siswa']; ?>" />
<table><tr>
<th align="left"><label>NISN</label></th><th>:</th><td><? echo $rsis['nisn_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Nama Siswa</label></th><th>:</th><td><? echo $rsis['nama_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Kempetensi Keahlian</label></th><th>:</th><td><? echo $rsis['kompetensi_keahlian']; ?></td>
</tr><tr>
<th align="left"><label>Kelas</label></th><th>:</th><td><? echo $rsis['kelas_siswa']; ?></td>
</tr><!---
<tr><th align="left"><label>NISN</label></th><th>:</th><td colspan="2">
<select name="nisn_siswa" required ><option value="" >---[ NISN SISWA ]---
</option><?
$qkateg = mysql_query(" SELECT * FROM siswaORDER BY nisn_siswa ASC ");
while($rkateg = mysql_fetch_array($qkateg)){?>
<option value="<? echo$rkateg['nisn_siswa']; ?>" >[ <? echo $rkateg['nisn_siswa']; ?> ] - <? echo $rkateg['nama_siswa'];?></option>
<? } ?></select>
</td></tr>
---><?
$i = 1;$qbid = mysql_query(" SELECT DISTINCT
nama_bidang FROM bidang_studi_guru WHERE kelas_bidang = '".($rsis['kelas_siswa'])."' ORDER BYnama_bidang ASC ");
while($rbid = mysql_fetch_array($qbid)){?><tr>
<th align="left"><label><? echo $rbid['nama_bidang'];?></label></th>
<th>:</th><td>
<input type="hidden" name="bidang_<? echo $i; ?>"value="<? echo $rbid['nama_bidang']; ?>" />
<input type="text" name="angka_<? echo $i; ?>"value="0" placeholder="Nilai Angka" />
</td><td>
<input type="text" name="huruf_<? echo $i; ?>"value="" placeholder="Nilai Huruf" />
</td></tr>
<? $i++; ?><? } ?><tr>
<td colspan="3"><input type="submit" name="insert_nilai"
value="Save Nilai" /><input type="reset" name="reset" value="Reset" />
</td></tr>
</table></form>
</fieldset><?
}if(isset($_GET['edit_record'])){
$edit = $_GET['edit_record'];$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM nilai WHERE nisn_siswa =
'".($_GET['edit_record'])."' "));
$rsis = mysql_fetch_array(mysql_query(" SELECT * FROM siswa WHERE nisn_siswa ='".($_GET['edit_record'])."' "));
//$guru = mysql_fetch_array(mysql_query(" SELECT * FROM guru WHERE nip_guru ='".($_SESSION['user'])."' "));
//$guru = mysql_fetch_array(mysql_query(" SELECT * FROM bidang_studi_guru WHEREkode_bidang = '".($_SESSION['user'])."' "));
?><fieldset>
<h2> Edit Data Nilai Siswa </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?update_nilai'; ?>" name="update_nilai"
method="post"><table>
<tr><th align="left"><label>NISN</label></th><th>:</th><td>[ <? echo $rsis['nisn_siswa']; ?> ] - <? echo
$rsis['nama_siswa']; ?></td></tr>
<?$query_nilai = mysql_query("
SELECTnilai.*,bidang_studi_guru.*,siswa.* FROM
nilai,bidang_studi_guru,siswaWHERE
nilai.bidang_studi =bidang_studi_guru.nama_bidang AND
siswa.kelas_siswa =bidang_studi_guru.kelas_bidang AND
bidang_studi_guru.kode_bidang ='".($_SESSION['user'])."' AND
nilai.nisn_siswa ='".($rowz['nisn_siswa'])."' AND
siswa.nisn_siswa ='".($rowz['nisn_siswa'])."'
ORDER BY nilai.bidang_studi ASC");//$qnil = mysql_query(" SELECT * FROM nilai WHERE
nisn_siswa = '".($rowz['nisn_siswa'])."' ORDER BY bidang_studi ASC ");$nnil = mysql_num_rows($query_nilai);while($rnil = mysql_fetch_array($query_nilai)){
?><tr>
<th align="left"><label><? echo $rnil['bidang_studi'];?></label></th>
<th>:</th><td>
<input type="hidden" name="kode_<? echo$rnil['kode_nilai']; ?>" value="<? echo $rnil['kode_nilai']; ?>" />
<? if($rnil['nama_bidang'] == $rnil['bidang_studi']and $rnil['kelas_siswa'] == $rnil['kelas_bidang']){ ?>
<input type="text" name="angka_<? echo$rnil['kode_nilai']; ?>" value="<? echo $rnil['nilai_angka']; ?>" placeholder="Nilai Angka" />
<? }else{ ?><? if($_SESSION['akses'] == "ADMIN"){ ?>
<input type="text"name="angka_<? echo $rnil['kode_nilai']; ?>" value="<? echo $rnil['nilai_angka']; ?>" placeholder="NilaiAngka" />
<? }else{ ?><input type="text"
name="angka_<? echo $rnil['kode_nilai']; ?>" value="<? echo $rnil['nilai_angka']; ?>" placeholder="NilaiAngka" disabled />
<? } ?><? } ?>
</td><td>
<? if($rnil['nama_bidang'] == $rnil['bidang_studi']){?>
<input type="text" name="huruf_<? echo$rnil['kode_nilai']; ?>" value="<? echo $rnil['nilai_huruf']; ?>" placeholder="Nilai Huruf" />
<? }else{ ?><? if($_SESSION['akses'] == "ADMIN"){ ?>
<input type="text"name="huruf_<? echo $rnil['kode_nilai']; ?>" value="<? echo $rnil['nilai_huruf']; ?>" placeholder="NilaiHuruf" />
<? }else{ ?><input type="text"
name="huruf_<? echo $rnil['kode_nilai']; ?>" value="<? echo $rnil['nilai_huruf']; ?>" placeholder="NilaiHuruf" disabled />
<? } ?><? } ?>
</td></tr><? } ?><?
if($nnil == 0){echo "<tr><td colspan='4'><fieldset><h5>NO AKSESS
INPUT !!</h5><script>alert('Maaf Anda Tidak Punya Hak Untuk Mengubah Nilai Anak Ini')</script></fieldset></td></tr>";
}else{?><tr>
<td colspan="3"><!-- <input type="hidden" name="kode_nilai"
value="<?// echo $rowz['kode_nilai']; ?>" /> --><input type="hidden" name="nisn_siswa" value="<?
echo $_GET['edit_record']; ?>" /><input type="submit" name="update_nilai"
value="Update Record" /><input type="reset" name="reset" value="Reset" />
</td></tr><? } ?>
</table>
</form></fieldset>
<?}elseif(isset($_GET['detail_record'])){
$detail = $_GET['detail_record'];$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM nilai WHERE nisn_siswa =
'".($_GET['detail_record'])."' "));$rsis = mysql_fetch_array(mysql_query(" SELECT * FROM siswa WHERE nisn_siswa =
'".($_GET['detail_record'])."' "));?>
<fieldset><h2> Detail Record Data Nilai Siswa </h2><hr>
<table><tr>
<th align="left"><label>NISN</label></th><th>:</th><td><? echo $rsis['nisn_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Nama Siswa</label></th><th>:</th><td><? echo $rsis['nama_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Kempetensi Keahlian</label></th><th>:</th><td><? echo $rsis['kompetensi_keahlian']; ?></td>
</tr><tr>
<th align="left"><label>Kelas</label></th><th>:</th><td><? echo $rsis['kelas_siswa']; ?></td>
</tr><tr>
<td colspan="3"><fieldset>
<legend>Nilai Siswa</legend><table>
<?$qnil = mysql_query(" SELECT * FROM nilai WHERE
nisn_siswa = '".($rowz['nisn_siswa'])."' ORDER BY bidang_studi ASC ");while($rnil = mysql_fetch_array($qnil)){
?><tr>
<th align="left"><label><? echo $rnil['bidang_studi'];?></label></th>
<th>:</th><td>
<? echo $rnil['nilai_angka']; ?></td>
<td><? echo $rnil['nilai_huruf']; ?>
</td></tr><? } ?>
</table></fieldset><td>
</tr></table>
</fieldset><?
}?>
<fieldset><h2>Data Penilaian Siswa</h2><hr>
<span class="left"><a href="<? echo $_SERVER['PHP_SELF']; ?>" ><button>Refresh</button></a>
<? if($_SESSION['akses'] == "ADMIN"){ ?><!-- <a href="<? echo $_SERVER['PHP_SELF'].'?add_nilai'; ?>" ><button>Add
Nilai Siswa</button></a> --><? } ?>
</span><span class="right">
<form action="<? echo $_SERVER['PHP_SELF'].'?search'; ?>" name="search"method="get" >
<input type="text" name="keyword" value="" /><input type="submit" name="search" value="Search" />
</form></span>
</fieldset><fieldset><table border="1" cellspacing="1" cellpadding="1" width="100%">
<tr><th width="1"> No </th><th>NISN</th><th>Nama</th><th>Alamat</th><th>Kelas</th><th>Kompetensi Keahlian</th><th width="1"> Menu </th>
</tr><?
$i = 1;if($_SESSION['akses'] == "GURU"){
if(isset($_GET['search'])){$where = "AND nama_siswa LIKE '%".($_GET['keyword'])."%' OR nisn_siswa
LIKE '%".($_GET['keyword'])."%' ";}else{
$where = "";
}$query = mysql_query(" SELECT * FROM siswa WHERE kompetensi_keahlian =
'".($rowg['kompetensi_keahlian'])."' $where ORDER BY nama_siswa ASC ");}else{
if(isset($_GET['search'])){$where = "WHERE nama_siswa LIKE '%".($_GET['keyword'])."%' OR nisn_siswa
LIKE '%".($_GET['keyword'])."%' ";}else{
$where = "";}$query = mysql_query(" SELECT * FROM siswa $where ORDER BY nama_siswa ASC ");
}while($rows = mysql_fetch_array($query)){
$ronil = mysql_num_rows(mysql_query(" SELECT * FROM nilai WHERE nisn_siswa ='".($rows['nisn_siswa'])."' "));?>
<tr><td><? echo $i; ?></td><td><? echo $rows['nisn_siswa']; ?></td><td><? echo $rows['nama_siswa']; ?></td><td><? echo $rows['alamat_siswa']; ?></td><td><? echo $rows['kelas_siswa']; ?></td><td><? echo $rows['kompetensi_keahlian']; ?></td><td class="tool"><? if($_SESSION['akses'] == "ADMIN"){ ?>
<? if($ronil == 0){ ?><a href="<? echo
$_SERVER['PHP_SELF'].'?add_nilai='.$rows['nisn_siswa']; ?>" ><button>Add Nilai</button></a><? }else{ ?>
<a href="<? echo$_SERVER['PHP_SELF'].'?add_nilai='.$rows['nisn_siswa']; ?>" disabled ><buttondisabled>Add Nilai</button></a>
<? } ?><? } ?>
<a href="<? echo$_SERVER['PHP_SELF'].'?detail_record='.$rows['nisn_siswa']; ?>" ><button>Detail</button></a>
<? if($_SESSION['akses'] == "GURU" ){ ?><a href="<? echo
$_SERVER['PHP_SELF'].'?edit_record='.$rows['nisn_siswa']; ?>" ><button>Edit Nilai</button></a><? } ?><? if($_SESSION['akses'] == "ADMIN"){ ?>
<? if($ronil != 0){ ?><a href="<? echo
$_SERVER['PHP_SELF'].'?remove_record='.$rows['nisn_siswa']; ?>" ><button>Remove</button></a><? }else{ ?>
<a href="<? echo$_SERVER['PHP_SELF'].'?remove_record='.$rows['nisn_siswa']; ?>" disabled ><button disabled>Remove</button></a>
<? } ?><? } ?></td>
</tr><?
$i++;}if(mysql_num_rows($query)=='0'){
echo "<tr><td colspan='7'><h3><b> DATA TIDAK ADA </b></h3></td>";}
?></table></fieldset><script>
function remove(){return confirm('Apakah Anda Yakin yang ingin menhapus ini ? ');
}</script>
<?include('menu.php');include('footer.php');
?>
13. Kompetensi_keahlian<? include('koneksi.php'); ?><?php
if(isset($_POST['insert'])){$insert = mysql_query("
INSERT INTO kompetensi_keahlian SETnama_kompetensi = '".($_POST['nama_kompetensi'])."'
");if($insert){
echo "<script>alert('INSERT DATA BERHASIL')</script>";}else{
echo "<script>alert('INSERT DATA GAGAL')</script>";}
}elseif(isset($_GET['delete_record'])){
mysql_query("DELETE FROM kompetensi_keahlian WHERE kode_kompetensi ='".($_GET['delete_record'])."' ");
}?><?
if(isset($_GET['add_record'])){?>
<fieldset><h2> Add Record Data Kompetensi Keahlian </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?insert'; ?>" name="insert" method="post">
<table><tr>
<th align="left"><label>Nama Kompetensi</label></th>
<th>:</th><td><input type="text" name="nama_kompetensi" value="" /></td>
</tr><tr>
<td colspan="3"><input type="submit" name="insert" value="Save Record" /><input type="reset" name="reset" value="Reset" />
</td></tr>
</table></form>
</fieldset><?
}?>
<fieldset><h2>Data Kompetensi</h2><hr>
<span class="left"><a href="<? echo $_SERVER['PHP_SELF']; ?>" ><button>Refresh</button></a><a href="<? echo $_SERVER['PHP_SELF'].'?add_record'; ?>" ><button>Add
Record</button></a></span>
</fieldset><fieldset><table border="1" cellspacing="1" cellpadding="1" width="100%">
<tr><th width="1"> No </th><th>Kode Kompetensi</th><th>Nama Kompetensi</th><th width="1"> Menu </th>
</tr><?
$i = 1;$query = mysql_query(" SELECT * FROM kompetensi_keahlian ORDER BY nama_kompetensi ASC ");while($rows = mysql_fetch_array($query)){
?><tr>
<td><? echo $i; ?></td><td><? echo $rows['kode_kompetensi']; ?></td><td><? echo $rows['nama_kompetensi']; ?></td><td class="tool">
<a href="<? echo$_SERVER['PHP_SELF'].'?delete_record='.$rows['kode_kompetensi']; ?>" ><button>X</button></a>
</td>
</tr><?
$i++;}if(mysql_num_rows($query)=='0'){
echo "<tr><td colspan='4'><h3><b> DATA TIDAK ADA </b></h3></td>";}
?></table></fieldset>
14. Bidang_studi<? include('koneksi.php'); ?><?php
if(isset($_POST['insert'])){$insert = mysql_query("
INSERT INTO bidang_studi SETnama_bidang = '".($_POST['nama_bidang'])."'
");if($insert){
echo "<script>alert('INSERT DATA BERHASIL')</script>";}else{
echo "<script>alert('INSERT DATA GAGAL')</script>";}
}elseif(isset($_GET['delete_record'])){
mysql_query("DELETE FROM bidang_studi WHERE kode_bidang ='".($_GET['delete_record'])."' ");
}?><?
if(isset($_GET['add_record'])){?>
<fieldset><h2> Add Record Data Bidang Studi </h2><hr><form action="<? echo $_SERVER['PHP_SELF'].'?insert'; ?>" name="insert"
method="post"><table>
<tr><th align="left"><label>Nama Bidang</label></th><th>:</th><td><input type="text" name="nama_bidang" value=""
/></td></tr>
<tr><td colspan="3">
<input type="submit" name="insert" value="SaveRecord" />
<input type="reset" name="reset" value="Reset" /></td>
</tr></table>
</form></fieldset>
<?}
?>
<fieldset><h2>Data Bidang Studi</h2><hr>
<span class="left"><a href="<? echo $_SERVER['PHP_SELF']; ?>" ><button>Refresh</button></a><a href="<? echo $_SERVER['PHP_SELF'].'?add_record'; ?>" ><button>Add
Record</button></a></span>
</fieldset><fieldset><table border="1" cellspacing="1" cellpadding="1" width="100%">
<tr><th width="1"> No </th><th>Kode Bidang</th><th>Nama Bidang</th><th width="1"> Menu </th>
</tr><?
$i = 1;$query = mysql_query(" SELECT * FROM bidang_studi ORDER BY nama_bidang ASC ");while($rows = mysql_fetch_array($query)){
?><tr>
<td><? echo $i; ?></td><td><? echo $rows['kode_bidang']; ?></td><td><? echo $rows['nama_bidang']; ?></td><td class="tool">
<a href="<? echo$_SERVER['PHP_SELF'].'?delete_record='.$rows['kode_bidang']; ?>" ><button>X</button></a>
</td></tr>
<?
$i++;}if(mysql_num_rows($query)=='0'){
echo "<tr><td colspan='4'><h3><b> DATA TIDAK ADA </b></h3></td>";}
?></table></fieldset>
15. Bidang_studi_guru<?
include('koneksi.php');$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM guru WHERE kode_guru =
'".($_GET['bidang_record'])."' "));?><?php
if(isset($_POST['insert'])){$rowr = mysql_fetch_array(mysql_query(" SELECT * FROM bidang_studi_guru WHERE
nama_bidang = '".($_POST['nama_bidang'])."' AND kelas_bidang = '".($_POST['kelas_bidang'])."' "));if($rowr['nama_bidang']!=$_POST['nama_bidang'] AND
$rowr['kelas_bidang']!=$_POST['kelas_bidang']){$insert = mysql_query("
INSERT INTO bidang_studi_guru SETkode_bidang = '".($_POST['nip_guru'])."',nama_bidang = '".($_POST['nama_bidang'])."',kelas_bidang = '".($_POST['kelas_bidang'])."'
");if($insert){
echo "<script>alert('INSERT DATA BERHASIL')</script>";}else{
echo "<script>alert('INSERT DATA GAGAL')</script>";}
}else{echo "<script>alert('DUPLICATE BIDANG STUDI')</script>";echo "<script>window.close();</script>";
}}
?>
<fieldset><h2>Data Bidang Studi <? echo $rowz['nama_guru']; ?></h2><hr>
<?
if(isset($_GET['delete_record'])){
mysql_query("DELETE FROM bidang_studi_guru WHERE id_bidang ='".($_GET['delete_record'])."' ");
echo "<script>alert('BIDANG BERHASIL DI HAPUS')</script>";echo "<script>window.close();</script>";
}else{?>
<form name="insert" method="post"><table>
<tr><td>
<select name="nama_bidang" required><option value="" >---[ Nama Bidang ]---
</option><?
$qkateg = mysql_query(" SELECT * FROMbidang_studi ORDER BY nama_bidang ASC ");
while($rkateg = mysql_fetch_array($qkateg)){?>
<option value="<? echo$rkateg['nama_bidang']; ?>" ><? echo $rkateg['nama_bidang']; ?></option>
<? } ?></select>
</td><th>:</th><td>
<select name="kelas_bidang" required><option value="" >---[ Kelas Bidang ]---
</option><? $kelas_siswa = array('X','XII','XIII');
foreach($kelas_siswa as $kelas): ?><option value="<? echo $kelas; ?>" ><?
echo $kelas; ?></option><? endforeach; ?></select>
</td><td colspan="3">
<input type="hidden" name="nip_guru" value="<?echo $rowz['nip_guru']; ?>" />
<input type="submit" name="insert" value="Save"/>
<input type="reset" name="reset" value="Reset" /></td>
</tr></table>
</form><hr>
<? } ?></fieldset><fieldset><table border="1" cellspacing="1" cellpadding="1" width="100%">
<tr><th width="1"> No </th><th>Kode Bidang</th><th>Nama Bidang</th><th>Kelas Bidang</th><th width="1"> Menu </th>
</tr><?
$i = 1;$query = mysql_query(" SELECT * FROM bidang_studi_guru WHERE kode_bidang =
'".($rowz['nip_guru'])."' ORDER BY id_bidang DESC ");while($rows = mysql_fetch_array($query)){
?><tr>
<td><? echo $i; ?></td><td><? echo $rows['kode_bidang']; ?></td><td><? echo $rows['nama_bidang']; ?></td><td><? echo $rows['kelas_bidang']; ?></td><td class="tool">
<a href="?delete_record=<? echo $rows['id_bidang']; ?>"><button>X</button></a>
</td></tr>
<?$i++;}if(mysql_num_rows($query)=='0'){
echo "<tr><td colspan='5'><h3><b> DATA TIDAK ADA </b></h3></td>";}
?></table></fieldset>
16. Detail_siswa<?php
include('koneksi.php');include('header.php');
$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM siswa WHERE nisn_siswa ='".($_SESSION['user'])."' "));?>
<fieldset>
<h2> Detail Record Data Siswa </h2><hr>
<table><tr>
<th align="left"><label>NISN</label></th><th>:</th><td><? echo $rowz['nisn_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Nama Siswa</label></th><th>:</th><td><? echo $rowz['nama_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Alamat</label></th><th>:</th><td><? echo $rowz['alamat_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Tangal Lahir</label></th><th>:</th><td><? echo $rowz['tanggal_lahir']; ?></td>
</tr><tr>
<th align="left"><label>Kompetensi Keahlian</label></th><th>:</th><td><? echo $rowz['kompetensi_keahlian']; ?></td>
</tr><tr>
<th align="left"><label>Kelas Siswa</label></th><th>:</th><td><? echo $rowz['kelas_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Nama Ayah</label></th><th>:</th><td><? echo $rowz['nama_ayah']; ?></td>
</tr><tr>
<th align="left"><label>Pekerjaan Ayah</label></th><th>:</th><td><? echo $rowz['pekerjaan_ayah']; ?></td>
</tr><tr>
<th align="left"><label>Nama Ibu</label></th><th>:</th>
<td><? echo $rowz['nama_ibu']; ?></td></tr><tr>
<th align="left"><label>Pekerjaan Ibu</label></th><th>:</th><td><? echo $rowz['pekerjaan_ibu']; ?></td>
</tr><tr>
<th align="left"><label>Alamat Orangtua</label></th><th>:</th><td><? echo $rowz['alamat_orangtua']; ?></td>
</tr><tr>
<th align="left"><label>Telepon Orangtua</label></th><th>:</th><td><? echo $rowz['telepon_orangtua']; ?></td>
</tr></table>
</fieldset><?
include('menu.php');include('footer.php');
?>
17. Detail_nilai<?php
include('koneksi.php');include('header.php');
$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM nilai WHERE nisn_siswa ='".($_SESSION['user'])."' "));
$rsis = mysql_fetch_array(mysql_query(" SELECT * FROM siswa WHERE nisn_siswa ='".($_SESSION['user'])."' "));?>
<fieldset><h2> Detail Record Data Nilai Siswa </h2><hr>
<table><tr>
<th align="left"><label>NISN</label></th><th>:</th><td><? echo $rsis['nisn_siswa']; ?></td>
</tr><tr>
<th align="left"><label>Nama Siswa</label></th><th>:</th>
<td><? echo $rsis['nama_siswa']; ?></td></tr><tr>
<th align="left"><label>Kempetensi Keahlian</label></th><th>:</th><td><? echo $rsis['kompetensi_keahlian']; ?></td>
</tr><tr>
<td colspan="3"><fieldset>
<legend>Nilai Ujian Nasional</legend><table width="100%">
<?$qnil =
mysql_query(" SELECT * FROM nilai WHERE nisn_siswa = '".($rowz['nisn_siswa'])."' ORDER BYbidang_studi ASC ");
while($rnil =mysql_fetch_array($qnil)){
?><tr>
<th align="left"><label><?echo $rnil['bidang_studi']; ?></label></th>
<th>:</th><td>
<? echo$rnil['nilai_angka']; ?>
</td><td>
<? echo$rnil['nilai_huruf']; ?>
</td></tr><? } ?>
</table></fieldset>
</td></tr>
</table></fieldset>
<?include('menu.php');include('footer.php');
?>
18. Detail_guru<?php
include('koneksi.php');include('header.php');
$rowz = mysql_fetch_array(mysql_query(" SELECT * FROM guru WHERE nip_guru ='".($_SESSION['user'])."' "));?>
<fieldset><h2> Detail Record Data Guru </h2><hr><fieldset><legend>Detail Data <? echo $rowz['nama_guru']; ?></legend>
<table><tr>
<th align="left"><label>NIP</label></th><th>:</th><td><? echo $rowz['nip_guru']; ?></td>
</tr><tr>
<th align="left"><label>Nama</label></th><th>:</th><td><? echo $rowz['nama_guru']; ?></td>
</tr><tr>
<th align="left"><label>Kompetensi Keahlian</label></th><th>:</th><td><? echo $rowz['kompetensi_keahlian']; ?></td>
</tr><tr>
<td colspan="3"><fieldset>
<legend>Bidang Studi Guru</legend><table>
<?$no = 1;$qnil = mysql_query(" SELECT * FROM
bidang_studi_guru WHERE kode_bidang = '".($rowz['nip_guru'])."' ORDER BY nama_bidang ASC ");while($rnil = mysql_fetch_array($qnil)){
?><tr>
<th align="left"><label>Bidang Studi <? echo $no;?></label></th>
<th>:</th><td><? echo $rnil['nama_bidang']; ?></td><td>|</td>
<th align="left"><label>Kelas</label></th><th>:</th><td><? echo $rnil['kelas_bidang']; ?></td>
</tr><? $no++; } ?>
</table></fieldset><td>
</tr><tr>
<th align="left"><label>Alamat</label></th><th>:</th><td><? echo $rowz['alamat_guru']; ?></td>
</tr><tr>
<th align="left"><label>Telepon</label></th><th>:</th><td><? echo $rowz['telphon']; ?></td>
</tr></table>
</fieldset></fieldset>
<?include('menu.php');include('footer.php');
?>
Untuk pemanis tampilan tinggal memasang Cascade Style Sheet script type text css !
19. Style/****************** CSS DOCUMENT ******************/
.menu button {width: 200px;
}
.menu li {list-style-image: url("gambar/arrow-normal.gif" );
}
.menu li:hover {list-style-image: url("gambar/arrow3.gif" );
}
.tool button {width: 80px;
}
.left {float: left;
}
.right {float: right;
}
/************************ Capter Design Aplication ************************/
Design dengan tampilan berikutHome sebelum Login
Login
Home sesudah login dengan hak aksess Admin
Data siswa dengan hak aksess Admin
Data Penilaian dengan hak aksess Admin
Data Guru dengan hak aksess Admin
Data User dangan hak aksess Admin
Home sesudah Login dengan hak aksess Guru
Data siswa denga hak akess Guru
Data penilaian dengan hak aksess Guru
Data Guru dengan hak aksess Guru
Home sesudah Login dengan hak aksess Siswa
Data siswa dengan hak aksess siswa
Data nilai dengan hak aksess siswa
/************************** Copy right Smk daarul abaroor 2015 **************************//*** SELAMAT MENGERJAKAN ***/