Modul Penggunaan Aplikasi : Program Aplikasi Ujian Akhir ......Modul Penggunaan Aplikasi : Program...
Transcript of Modul Penggunaan Aplikasi : Program Aplikasi Ujian Akhir ......Modul Penggunaan Aplikasi : Program...
Modul Penggunaan Aplikasi :
Program Aplikasi Ujian Akhir Semester Berbasis Computer Base Test (CBT) Di SMK
Samudera Buana Langkap Lancar
1. Login.php
Langkah pertama untuk mengakses aplikasi ini, buka halaman login.php dan masukan
username “ admin” dan password “admin” atau nama pengguna yang sudah di daftarkan
sebagai admin dan akan diarahkan ke alamat admin.php.
Gambar 1 login.php
2. Admin.php
ini adalah tampilan utama dari menu admin yang dapat mengolah beberapa menu yang
sudah disediakan.
Gambar 2 admin.php
3. Pengelola.php
Menu pertama pada tampilan admin yaitu manajemen pengelola ujian, dimana admin bisa
menambahkan atau mengahapus pengguna sebagai admin dan sebagai guru.
Gambar 3 pengelola.php
4. Pengelola.php
Isi form yang tersedia untuk menambahkan pengelola ujian kemudian klik simpan.
Gambar 4 tambahpengelola.php
5. Manajemen siswa
Pada menu manajemen siswa, admin bisa menambah, menghapus, mengedit dan mencetak
siswa yang di daftarkan untuk login ke apliasi ini.
Gambar 5 manajemen siswa
6. Tambah data siswa
isi form yang tersedia untuk menambahkan data siswa, kemudian klik simpan.
Gambar 6 tambah data siswa
7. Menu Manajemen Kelas
Pada menu ini admin dapat menambahkan, mengedit, menghapus kelas yang akan di
daftarkan pada aplikasi ujian.
Gambar 7 Tambah data siswa
8. Menu Manajemen Mata Pelajaran
Pada menu ini admin dapat menambahkan, mengedit, menghapus mata pelajaran yang akan
di ujikan. Isi form tambah mata pelajaran kemudian klik simpan.
Gambar 8 Mata Pelajaran
9. Menu Manajemen soal
Pada menu ini admin dapat menambahkan, mengedit, menghapus, dan mencetak soal yang
akan di ujikan.
Gambar 9 Manajemen Soal
10. Menu Manajemen Hasil
Pada menu manajemen hasil admin dapat melihat hasil ujian siswa dan dapat menghapus
hasil ujian apabila data sudah tidak diperlukan lagi.
Gambar 10 Manajemen hasil
11. Menu Manajemen Ujian
Pada menu ini admin dapat mengaktifkan mata pelajaran yang akan di ujikan supaya tampil
di halaman siswa sesuai dg jadwal ujian. Apabila statusnya “tidak aktif” maka tidak ada
tes yang akan dilaksanakan.
Gambar 11 Manajemen Ujian
12. Menu Profil
Pada menu profil, admin dapat mengubah data personal pengguna sesuai dengan identitas
yang berlaku. Isi form yang tersedia kemudian klik simpan.
Gambar 12 Profil Admin
13. Halaman Guru
Gambar 12 Profil Guru
Untuk masuk ke halaman guru silahkan akses URL “login.php” kemudian masukan
username dan password yang sudah di daftarkan oleh admin dan berlevel “guru”.
14. Menu Manajemen Soal
Pada menu ini, guru hanya dapat mengedit dan menghapus soal yang sudah di input oleh
admin. Jadi apabila ada penambahan soal bisa langsung menghubungi admin. Soal yang
dapat dibuat hanya PG, Listerning, dan soal bergambar.
Gambar 14 Manajemen soal
15. Menu Manajemen Tambah Soal
Gambar 15 Manajemen Tambah Soal
16. Menu Edit Soal
Pada menu ini guru dapat mengubah soal yang sudah dibuat.
Gambar 16 edit soal
17. Menu Manajemen Pengaturan Ujian
Pada menu ini silahkan guru menginputkan jadwal ujian yang akan dilaksanakan.
Kemudian klik simpan.
Gambar 17
18. Edit Pengaturan Ujian
Pada menu ini guru dapat mengedit jadwal dan butir soal yang akan di ujiankan.
Gambar 18 Edit Pengaturan Ujian
19. Menu Profil
Silakan isi form profil guru sesuai dengan identitas masing-masing.
Gambar 19 Menu Profil
20. Login Halaman Siswa
Untuk mengakses halaman siswa masukan URL “ index.php” kemudian masukan
username dan password siswa yang sudah di daftarkan oleh admin pada halaman admin.
21. Menu Mulai Ujian
Tampilan pertama pada menu siswa yaitu mata pelajaran yang sedang aktif untuk di ujikan
kepada siswa. Untuk memulai ujian pada maple yang sedang aktif, Klik status “aktif”
secara otomatis siswa akan diarahkan ke halaman pengerjaan ujian.
Gambar 21 Halaman Mulai Ujian
22. Halaman Lembar Pengerjaan Soal siswa
Pada lembar pengerjaan soal siswa, hitamkan bulatan yang ada disamping abjad untuk
memilih jawaban yang menurut siswa benar. Kemudian klik simpan di soal terakhir untuk
menyelesaikan lembar soal yang sedang di kerjakan.
Gambar 22 Lembar Pengerjaan Soal
23. Halaman Hasil Ujian
Setelah di klik simpan pada soal terakhir akan muncul hasil ujian yang sudah di kerjakan.
Jadi siswa langsung mengetahui jumlah benar soal yang dikerjakan.
Gambar 23 Halaman Hasil Ujian
24. Menu Profil Siswa
Siswa dapat mengedit data pribadi siswa apabila ada pembaharuan data. Isi form kemudian
klik simpan.
Gambar 24 Edit Profil Siswa
25. Menu Nilai Ujian
Untuk melihat nilai ujian yang sudah dikerjakan oleh siswa, klik menu “ Nilai ujian”.
Gambar 25 Nilai Ujian
26. Untuk keluar dari halaman admin, guru dan siswa klik menu “Logout” secara
otomatis akan dialihkan ke halaman login.php
CODING
Coding halaman login :
<?php session_start();?>
<?php
$hostname_koneksi = "localhost";
$database_koneksi = "uascbt";
$username_koneksi = "root";
$password_koneksi = "password";
$koneksi = mysql_pconnect($hostname_koneksi, $username_koneksi, $password_koneksi) or
trigger_error(mysql_error(),E_USER_ERROR);
?>
<!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div class="menu">
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat Datang Di Halaman Login Admin Ujian Akhir Semester Berbasis CBT </h2>
<ul id="tabsmenu" class="tabsmenu"><li class="active">
</li>
</ul>
<ul class="tabsmenu"><li class="active"><a href="#tab1">Masukan Username dan Password
</a></li>
<li></li>
</ul>
<div id="tab1" class="tabcontent">
<form name="form1" method="POST" onsubmit=" return cek()"action="proseslog.php">
<div class="form">
<div class="form_row">
<label>Username </label>
<input type="text" class="form_input" name="nama" />
</div>
<div class="form_row">
<label>Password </label>
<input type="password" class="form_input" name="pass" />
</div>
<div class="form_row">
<input name="Login" type="submit" class="form_submit" value="Login" />
</div>
<div class="clear"></div>
</div>
</form>
</div>
</div>
</div>
<h2> </h2>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
</div>
</body>
<script>
function cek() {
var cek0 =document.forms['form1']['nama'].value &&
document.forms['form1']['nama'].value ;
var cek = document.forms['form1']['nama'].value;
var cek1 = document.forms['form1']['pass'].value;
if(cek0==null || cek0=="")
{
alert("silahkan masukan username dan password !!!");
return false;
}
if(cek==null || cek=="")
{
alert("silahkan masukan username terlebih dahulu!!!");
return false;
}
if(cek1==null || cek1=="")
{
alert("silahkan masukan password terlebih dahulu!!!");
return false;
}
}
</script>
</html>
Coding halaman admin
<?php require_once('../Connections/kon.php');
error_reporting(0);
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
mysql_select_db($database_kon, $kon);
$nama=$_GET['nama'];
$query_pengguna2 = "SELECT * FROM pengguna where username='$nama'";
$pengguna2 = mysql_query($query_pengguna2, $kon) or die(mysql_error());
$row_pengguna2 = mysql_fetch_assoc($pengguna2);
$totalRows_pengguna2 = mysql_num_rows($pengguna2);
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat Datang Di Halaman Admin Ujian Akhir Semester Berbasis CBT </h2>
<ul id="tabsmenu" class="tabsmenu">
</ul>
<div id="tab1" class="tabcontent">Silahkan isi data dengan teliti
</div>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Menu </h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil</a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center"> SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($pengggna);
mysql_free_result($pengguna2);
?>
Coding halaman data siswa admin
<?php require_once('../Connections/kon.php');
error_reporting (0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
mysql_select_db($database_kon, $kon);
$query_siswa = "SELECT * FROM peserta";
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_datasiswa = 15;
$pageNum_datasiswa = 0;
if (isset($_GET['pageNum_datasiswa'])) {
$pageNum_datasiswa = $_GET['pageNum_datasiswa'];
}
$startRow_datasiswa = $pageNum_datasiswa * $maxRows_datasiswa;
mysql_select_db($database_kon, $kon);
$query_datasiswa = "SELECT peserta.no_peserta , peserta.nama , peserta.tgl_lahir ,
kelas.id_kelas FROM uascbt.kelas INNER JOIN uascbt.peserta ON (kelas.id_kelas =
peserta.id_kelas) ";
$query_limit_datasiswa = sprintf("%s LIMIT %d, %d", $query_datasiswa, $startRow_datasiswa,
$maxRows_datasiswa);
$datasiswa = mysql_query($query_limit_datasiswa, $kon) or die(mysql_error());
$row_datasiswa = mysql_fetch_assoc($datasiswa);
if (isset($_GET['totalRows_datasiswa'])) {
$totalRows_datasiswa = $_GET['totalRows_datasiswa'];
} else {
$all_datasiswa = mysql_query($query_datasiswa);
$totalRows_datasiswa = mysql_num_rows($all_datasiswa);
}
$totalPages_datasiswa = ceil($totalRows_datasiswa/$maxRows_datasiswa)-1;
mysql_select_db($database_kon, $kon);
$query_kelas = "SELECT * FROM kelas";
$kelas = mysql_query($query_kelas, $kon) or die(mysql_error());
$row_kelas = mysql_fetch_assoc($kelas);
$totalRows_kelas = mysql_num_rows($kelas);
mysql_select_db($database_kon, $kon);
$query_siswabaru = "SELECT * FROM peserta";
$siswabaru = mysql_query($query_siswabaru, $kon) or die(mysql_error());
$row_siswabaru = mysql_fetch_assoc($siswabaru);
$totalRows_siswabaru = mysql_num_rows($siswabaru);
$queryString_datasiswa = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_datasiswa") == false &&
stristr($param, "totalRows_datasiswa") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_datasiswa = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_datasiswa = sprintf("&totalRows_datasiswa=%d%s", $totalRows_datasiswa,
$queryString_datasiswa);
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="../guru/style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="../guru/js/jquery.min.js"></script>
<script src="../guru/js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Halaman Admin </h2>
<ul id="tabsmenu" class="tabsmenu">
<li class="active"><a href="#tab1">Data Siswa </a></li>
<li><a href="#tab2">Tambah Data Siswa </a></li>
</ul>
<div id="tab1" class="tabcontent">
<form id="form2" name="form2" method="post" action="hasilcari.php">
<label>
<div align="right">
<input name="nama" type="text" />
<input name="Submit" type="submit" class="green" value="cari" />
<br />
<br />
</div>
</label>
</form>
<table id="rounded-corner">
<thead>
<tr>
<th width="5%"></th>
<th width="21%">No Peserta </th>
<th width="31%">Nama</th>
<th width="18%">Tanggal Lahir </th>
<th width="11%">Kelas</th>
<th width="7%">Edit</th>
<th width="7%">Delete</th>
</tr>
</thead>
<tfoot>
<tr>
<td height="75" colspan="10"><div align="right">
<form id="form4" name="form4" method="post" action="cetakpeserta.php">
<label>
<div align="left">
<input name="Submit3" type="submit" class="green" value="cetak data peserta" />
</div>
</label>
</form>
Records <?php echo ($startRow_datasiswa + 1) ?> to <?php echo
min($startRow_datasiswa + $maxRows_datasiswa, $totalRows_datasiswa) ?> of <?php echo
$totalRows_datasiswa ?></div>
<div align="right">
<table border="0" width="39%" align="right">
<tr>
<td width="23%" height="45" align="center"><?php if ($pageNum_datasiswa > 0)
{ // Show if not first page ?>
<a href="<?php printf("%s?pageNum_datasiswa=%d%s", $currentPage, 0,
$queryString_datasiswa); ?>">First</a>
<?php } // Show if not first page ?> </td>
<td width="31%" align="center"><?php if ($pageNum_datasiswa > 0) { // Show if
not first page ?>
<a href="<?php printf("%s?pageNum_datasiswa=%d%s", $currentPage, max(0,
$pageNum_datasiswa - 1), $queryString_datasiswa); ?>">Previous</a>
<?php } // Show if not first page ?> </td>
<td width="23%" align="center"><?php if ($pageNum_datasiswa <
$totalPages_datasiswa) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_datasiswa=%d%s", $currentPage,
min($totalPages_datasiswa, $pageNum_datasiswa + 1), $queryString_datasiswa); ?>">Next</a>
<?php } // Show if not last page ?> </td>
<td width="23%" align="center"><?php if ($pageNum_datasiswa <
$totalPages_datasiswa) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_datasiswa=%d%s", $currentPage,
$totalPages_datasiswa, $queryString_datasiswa); ?>">Last</a>
<?php } // Show if not last page ?> </td>
</tr>
</table>
</div></td>
</tr>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td><input type="checkbox" name="Input" /></td>
<td><a href="detailsiswa.php?no_peserta=<?php echo $row_siswabaru['no_peserta'];
?>"><?php echo $row_siswabaru['no_peserta']; ?></a></td>
<td><?php echo $row_siswabaru['nama']; ?></td>
<td><?php echo $row_siswabaru['tgl_lahir']; ?></td>
<td><?php echo $row_siswabaru['id_kelas']; ?></td>
<td><a href="editpeserta.php?no_peserta=<?php echo $row_siswabaru['no_peserta'];
?>"><img src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapuspeserta.php?no_peserta=<?php echo $row_siswabaru['no_peserta'];
?>" onclick="return confirm('anda yakin ingin menghapus item ini?')"><img
src="images/trash.gif" alt="" title="" border="0" /></a></td>
</tr>
<?php } while ($row_siswabaru = mysql_fetch_assoc($siswabaru)); ?>
</tbody>
</table>
<h3> </h3>
<p></p>
</div>
<div id="tab2" class="tabcontent">
<h3>Tambah Data</h3>
<p>
<script type="text/javascript">
// validasi form (hanya file .xls yang diijinkan)
function validateForm()
{
function hasExtension(inputID, exts) {
var fileName = document.getElementById(inputID).value;
return (new RegExp('(' + exts.join('|').replace(/\./g, '\\.') + ')$')).test(fileName);
}
if(!hasExtension('filesiswa', ['.xls'])){
alert("Hanya file XLS (Excel 2003) yang diijinkan.");
return false;
}
}
</script>
<?php
$sql=mysql_query("select * from peserta order by no_peserta DESC LIMIT 0,1");
$data=mysql_fetch_array($sql);
$kodeawal=substr($data['no_peserta'],3,4)+1;
if($kodeawal<10){
$kode='SIS000'.$kodeawal;
}elseif($kodeawal > 9 && $kodeawal <=99){
$kode='SIS00'.$kodeawal;
}else{
$kode='SIS00'.$kodeawal;
}
?>
</p>
<form id="form2" name="form3" method="post" enctype="multipart/form-
data" action="simpanpeserta.php" onSubmit="return cek();">
<div class="form">
<div class="form_row">
<label>No Peserta </label>
<input type="text" class="form_input" name="id" value="<?php echo $kode;?>" />
</div>
<div class="form_row">
<label>Username </label>
<input type="text" class="form_input" name="nama_akun" />
</div>
<p> </p>
<div class="form_row">
<label>Password </label>
<input type="password" class="form_input" name="kata_sandi" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Nama Lengkap </label>
<input type="text" class="form_input" name="nama_lengkap" />
</div>
<p> </p>
<div class="form_row">
<label>Jenis Kelamin </label>
<select class="form_select" name="jk">
<option>--- Jenis Kelamin---</option>
<option value="perempuan">Perempuan</option>
<option value="laki">laki-laki</option>
</select>
</div>
<p> </p>
<div class="form_row">
<label>Alamat</label>
<input type="text" class="form_input" name="alamat" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Tanggal lahir </label>
<input type="text" id="datepicker" class="form_input" name="tgl_lahir" />
</div>
<p> </p>
<div class="form_row">
<label>Kelas</label>
<select class="form_select" name="kelas">
<?php
do {
?>
<option value="<?php echo $row_kelas['id_kelas']?>"><?php echo
$row_kelas['nama_kelas']?></option>
<?php
} while ($row_kelas = mysql_fetch_assoc($kelas));
$rows = mysql_num_rows($kelas);
if($rows > 0) {
mysql_data_seek($kelas, 0);
$row_kelas = mysql_fetch_assoc($kelas);
}
?>
</select>
</div>
<p> </p>
</div>
<p> </p>
<p> </p>
<div class="form_row">
<input name="submit" type="submit" class="form_submit" value="Simpan" />
</div>
<div class="clear"></div>
</div>
</form>
<p> </p>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard </h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil </a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<li>
<li></li>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<script>
function cek() {
var cek = document.forms['form3']['nama_akun'].value;
var cek1 = document.forms['form3']['kata_sandi'].value;
var cek2 = document.forms['form3']['nama_lengkap'].value;
var cek3 = document.forms['form3']['jk'].value;
var cek4 = document.forms['form3']['alamat'].value;
var cek5 = document.forms['form3']['tgl_lahir'].value;
var cek6 = document.forms['form3']['kelas'].value;
if(cek==null || cek=="")
{
alert("nama akun tidak boleh kosong!!!");
return false;
}
if (cek1==null || cek1=="")
{
alert("kata sandi tidak boleh kosong!!!");
return false;
}
if (cek2==null || cek2=="")
{
alert("nama lengkap tidak boleh kosong!!!");
return false;
}
if (cek3==null || cek3=="")
{
alert("Jenis kelamin tidak boleh kosong!!!");
return false;
}
if (cek4==null || cek4=="")
{
alert("alamat tidak boleh kosong!!!");
return false;
}
if (cek5==null || cek5=="")
{
alert("tanggal lahir tidak boleh kosong!!!");
return false;
}
if (cek6==null || cek6=="")
{
alert("kelas tidak boleh kosong!!!");
return false;
}
}
</script>
<link rel="stylesheet" href="themes/base/jquery.ui.all.css">
<script src="js/jquery-1.7.2.js"></script>
<script src="ui/jquery.ui.core.js"></script>
<script src="ui/jquery.ui.widget.js"></script>
<script src="ui/jquery.ui.datepicker.js"></script>
<script>
$(function() {
$( "#datepicker" ).datepicker({
changeMonth: true,
changeYear: true
});
});
</script>
<?php
mysql_free_result($pengggna);
mysql_free_result($siswa);
mysql_free_result($datasiswa);
mysql_free_result($kelas);
mysql_free_result($siswabaru);
?>
Coding data mata pelajaran admin <?php require_once('../Connections/kon.php');
error_reporting (0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
$maxRows_matpel = 10;
$pageNum_matpel = 0;
if (isset($_GET['pageNum_matpel'])) {
$pageNum_matpel = $_GET['pageNum_matpel'];
}
$startRow_matpel = $pageNum_matpel * $maxRows_matpel;
mysql_select_db($database_kon, $kon);
$query_matpel = "SELECT * FROM mata_pelajaran";
$query_limit_matpel = sprintf("%s LIMIT %d, %d", $query_matpel, $startRow_matpel,
$maxRows_matpel);
$matpel = mysql_query($query_limit_matpel, $kon) or die(mysql_error());
$row_matpel = mysql_fetch_assoc($matpel);
if (isset($_GET['totalRows_matpel'])) {
$totalRows_matpel = $_GET['totalRows_matpel'];
} else {
$all_matpel = mysql_query($query_matpel);
$totalRows_matpel = mysql_num_rows($all_matpel);
}
$totalPages_matpel = ceil($totalRows_matpel/$maxRows_matpel)-1;
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 { font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang dihalaman admin</h2>
<div id="tab1" class="tabcontent">
<h3>Data Mata Pelajaran </h3>
<table id="rounded-corner">
<thead>
<tr>
<th width="10%"></th>
<th width="29%">Kode Mata Pelajaran </th>
<th width="35%">Nama Mata Pelajaran </th>
<th width="18%">Edit</th>
<th width="8%">Delete</th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td><input type="checkbox" name="Input" /></td>
<td><?php echo $row_matpel['kd_matpel']; ?></td>
<td><?php echo $row_matpel['nama_matpel']; ?></td>
<td><a href="editmatpel.php?kd_matpel=<?php echo $row_matpel['kd_matpel'];
?>"><img src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapusmatpel.php?kd_matpel=<?php echo $row_matpel['kd_matpel'];
?>"onclick="return confirm('anda yakin ingin menghapus item ini?')"><img
src="images/trash.gif" alt="" title="" border="0" /></a></td>
</tr>
<?php } while ($row_matpel = mysql_fetch_assoc($matpel)); ?>
</tbody>
</table>
<p class="logintitle style1">Tambah Mata Pelajaran</p>
<form id="form1" name="form1" onsubmit="return cek()"method="post"
action="simpanmatpel.php">
<div class="form">
<div class="form_row">
<label>Kode Mata pelajaran </label>
<input type="text" class="form_input" name="kd_matpel" value="" />
</div>
<div class="form_row">
<label>Nama Mata pelajaran </label>
<input type="text" class="form_input" name="nama_matpel" />
</div>
<div class="form_row">
<input name="submit" type="submit" class="form_submit" value="Simpan" />
</div>
<div class="clear"></div>
</div>
</form>
<p> </p>
</div>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard </h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil </a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<li>
<li></li>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<script>
function cek() {
var cek = document.forms['form1']['nama_matpel'].value;
var cek1 = document.forms['form1']['kd_matpel'].value;
if(cek==null || cek=="")
{
alert("nama mata pelajaran tidak boleh kosong!!!");
return false;
}
if(cek1==null || cek=="")
{
alert("kode tidak boleh kosong!!!");
return false;
}
}
</script>
<?php
mysql_free_result($pengggna);
mysql_free_result($matpel);
?>
Coding Data Soal admin
<?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
$maxRows_soal = 10;
$pageNum_soal = 0;
if (isset($_GET['pageNum_soal'])) {
$pageNum_soal = $_GET['pageNum_soal'];
}
$startRow_soal = $pageNum_soal * $maxRows_soal;
mysql_select_db($database_kon, $kon);
$query_soal = "SELECT * FROM soal";
$query_limit_soal = sprintf("%s LIMIT %d, %d", $query_soal, $startRow_soal,
$maxRows_soal);
$soal = mysql_query($query_limit_soal, $kon) or die(mysql_error());
$row_soal = mysql_fetch_assoc($soal);
if (isset($_GET['totalRows_soal'])) {
$totalRows_soal = $_GET['totalRows_soal'];
} else {
$all_soal = mysql_query($query_soal);
$totalRows_soal = mysql_num_rows($all_soal);
}
$totalPages_soal = ceil($totalRows_soal/$maxRows_soal)-1;
$maxRows_matpel = 10;
$pageNum_matpel = 0;
if (isset($_GET['pageNum_matpel'])) {
$pageNum_matpel = $_GET['pageNum_matpel'];
}
$startRow_matpel = $pageNum_matpel * $maxRows_matpel;
mysql_select_db($database_kon, $kon);
$query_matpel = "SELECT * FROM mata_pelajaran";
$query_limit_matpel = sprintf("%s LIMIT %d, %d", $query_matpel, $startRow_matpel,
$maxRows_matpel);
$matpel = mysql_query($query_limit_matpel, $kon) or die(mysql_error());
$row_matpel = mysql_fetch_assoc($matpel);
if (isset($_GET['totalRows_matpel'])) {
$totalRows_matpel = $_GET['totalRows_matpel'];
} else {
$all_matpel = mysql_query($query_matpel);
$totalRows_matpel = mysql_num_rows($all_matpel);
}
$totalPages_matpel = ceil($totalRows_matpel/$maxRows_matpel)-1;
$queryString_soal = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_soal") == false &&
stristr($param, "totalRows_soal") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_soal = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_soal = sprintf("&totalRows_soal=%d%s", $totalRows_soal, $queryString_soal);
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang di halaman admin</h2>
<ul id="tabsmenu" class="tabsmenu">
<li class="active"><a href="#tab1">Soal Keseluruahan </a></li>
<li><a href="#tab2">Soal Per Mata Pelajaran </a></li>
</ul>
<div id="tab1" class="tabcontent">
<h3>Soal Ujian Akhir Semester </h3>
<p align="right"> <?php echo ($startRow_soal + 1) ?> dari <?php echo
$totalRows_soal ?> </p>
<table width="87%" id="rounded-corner">
<thead>
<tr>
<th width="6%"></th>
<th width="14%">Kode Soal </th>
<th width="42%">Soal Ujian</th>
<th width="9%">Kunci Jawaban</th>
<th width="12%">Edit</th>
<th width="17%">Hapus</th>
</tr>
</thead>
<tfoot>
<tr>
<td colspan="11"><table border="0" width="50%" align="right">
<tr>
<td width="54%" align="center"><div align="right">
<?php if ($pageNum_soal > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_soal=%d%s", $currentPage, 0,
$queryString_soal); ?>"> First</a>
<?php } // Show if not first page ?>
</div></td>
<td width="19%" align="center"><div align="right">
<?php if ($pageNum_soal > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_soal=%d%s", $currentPage, max(0,
$pageNum_soal - 1), $queryString_soal); ?>">Previous</a>
<?php } // Show if not first page ?>
</div></td>
<td width="13%" align="center"><div align="right">
<?php if ($pageNum_soal < $totalPages_soal) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_soal=%d%s", $currentPage,
min($totalPages_soal, $pageNum_soal + 1), $queryString_soal); ?>">Next</a>
<?php } // Show if not last page ?>
</div></td>
<td width="14%" align="center"><div align="right">
<?php if ($pageNum_soal < $totalPages_soal) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_soal=%d%s", $currentPage,
$totalPages_soal, $queryString_soal); ?>">Last</a>
<?php } // Show if not last page ?>
</div></td>
</tr>
</table>
<a href="cetaksemuasoal.php" class="button green">Cetak </a>
</p></td>
</tr>
</tfoot>
<?php do { ?>
<tbody>
<tr class="odd">
<td height="41"><input name="checkbox[]" type="checkbox" id="checkbox"
value="<?php echo $row_INDONESIA['kd_soal']; ?>" /></td>
<td><?php echo $row_soal['kd_soal']; ?></td>
<td><?php echo $row_soal['soal']; ?></td>
<td><?php echo $row_soal['kunci']; ?></td>
<td><a href="editsoal.php?kd_soal=<?php echo $row_soal['kd_soal']; ?>"><img
src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapussoal.php?kd_soal=<?php echo $row_soal['kd_soal']; ?>"
onclick="return confirm('anda yakin ingin menghapus item ini?');"><img src="images/trash.gif"
alt="hapus" title="" border="0" /></a></td>
</tr>
<?php } while ($row_soal = mysql_fetch_assoc($soal)); ?>
</tbody>
</table>
<p> </p>
<p></p>
</div>
<div id="tab2" class="tabcontent">
<h3> Soal Per Mata Pelajaran </h3>
<table border="0">
<?php do { ?>
<tr>
<td><img src="images/DEGREE.png" width="99" height="95" /></td>
<td> <div align="left"><a href="soalmatpel.php?kd_matpel=<?php echo
$row_matpel['kd_matpel']; ?>"><?php echo $row_matpel['nama_matpel'];
?></a></div></td></tr>
<?php } while ($row_matpel = mysql_fetch_assoc($matpel)); ?>
</table>
<div align="center"></div>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard </h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil</a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<li>
<li></li>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($pengggna);
mysql_free_result($soal);
mysql_free_result($matpel);
?>
Coding Data Kelas admin <?php require_once('../Connections/kon.php'); ?>
<?php require_once('../Connections/kon.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
$maxRows_kelas = 10;
$pageNum_kelas = 0;
if (isset($_GET['pageNum_kelas'])) {
$pageNum_kelas = $_GET['pageNum_kelas'];
}
$startRow_kelas = $pageNum_kelas * $maxRows_kelas;
mysql_select_db($database_kon, $kon);
$query_kelas = "SELECT * FROM kelas";
$query_limit_kelas = sprintf("%s LIMIT %d, %d", $query_kelas, $startRow_kelas,
$maxRows_kelas);
$kelas = mysql_query($query_limit_kelas, $kon) or die(mysql_error());
$row_kelas = mysql_fetch_assoc($kelas);
if (isset($_GET['totalRows_kelas'])) {
$totalRows_kelas = $_GET['totalRows_kelas'];
} else {
$all_kelas = mysql_query($query_kelas);
$totalRows_kelas = mysql_num_rows($all_kelas);
}
$totalPages_kelas = ceil($totalRows_kelas/$maxRows_kelas)-1;
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang di halaman admin </h2>
<ul id="tabsmenu" class="tabsmenu"><li></li>
</ul>
<div id="tab1" class="tabcontent">
<h3>DATA KELAS</h3>
<table id="rounded-corner">
<thead>
<tr>
<th width="10%"></th>
<th width="29%">Id kelas </th>
<th width="35%">Nama Kelas </th>
<th width="18%">Edit</th>
<th width="8%">Delete</th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td><input type="checkbox" name="Input" /></td>
<td><?php echo $row_kelas['id_kelas']; ?></td>
<td><?php echo $row_kelas['nama_kelas']; ?></td>
<td><a href="editkelas.php?id_kelas=<?php echo $row_kelas['id_kelas']; ?>"><img
src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapuskelas.php?id_kelas=<?php echo $row_kelas['id_kelas'];
?>"onclick="return confirm('anda yakin ingin menghapus item ini?')"><img
src="images/trash.gif" alt="" title="" border="0" /></a></td>
</tr>
<?php } while ($row_kelas = mysql_fetch_assoc($kelas)); ?>
</tbody>
<?php
$sql=mysql_query("select * from kelas order by id_kelas DESC LIMIT 0,1");
$data=mysql_fetch_array($sql);
$kodeawal=substr($data['id_kelas'],3,4)+1;
if($kodeawal<10){
$kode='KLS000'.$kodeawal;
}elseif($kodeawal > 9 && $kodeawal <=99){
$kode='KLS00'.$kodeawal;
}else{
$kode='KLS00'.$kodeawal;
}
?>
</table>
<p class="logintitle style1">TAMBAH KELAS </p>
<form id="form1" name="form1" method="post" action="simpankelas.php"
onsubmit="return cek()">
<div class="form">
<div class="form_row">
<label>Id Kelas </label>
<input type="text" class="form_input" name="id_kelas" value="<?php echo $kode ?>"
/>
</div>
<div class="form_row">
<label>Nama Kelas </label>
<input type="text" class="form_input" name="nama_kelas" />
</div>
<div class="form_row">
<input name="submit" type="submit" class="form_submit" value="Simpan" />
</div>
<div class="clear"></div>
</div>
</form>
<p> </p>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard </h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil</a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<li>
<li></li>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<script>
function cek() {
var cek = document.forms['form1']['nama_kelas'].value;
if(cek==null || cek=="")
{
alert("nama kelas tidak boleh kosong!!!");
return false;
}
}
</script>
<?php
mysql_free_result($kelas);
mysql_free_result($pengggna);
?>
Coding Data Pribadi Admin <?php require_once('../Connections/kon.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../logguru.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">Selamat datang dihalaman admin
<ul id="tabsmenu" class="tabsmenu">
<li class="active"><form id="form1" name="form1" method="post"
action="editdatapribadiadmin.php">
<div id="tab1" class="tabcontent">
<h3>Profil Anda </h3>
<div class="form_row">
<label>Username </label>
<input type="text" disabled="disabled" class="form_input" name="Input4"
value="<?php echo $row_pengggna ['username']; ?>"/>
</div>
<div class="form_row">
<label>Password</label>
<input type="password" disabled="disabled" class="form_input" name="Input42"
value="<?php echo $row_pengggna ['password']; ?>"/>
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Nama Lengkap </label>
<input type="text" disabled="disabled" class="form_input" name="Input43"
value="<?php echo $row_pengggna ['nama_admin']; ?>"/>
</div>
<div class="form_row">
<label>Jenis Kelamin </label>
<input type="text" disabled="disabled" class="form_input"
name="Input44"value="<?php echo $row_pengggna ['jenis_kelamin']; ?>" />
</div>
<div class="form_row">
<label>Alamat</label>
<input type="text" disabled="disabled" class="form_input" name="Input45"
value="<?php echo $row_pengggna ['alamat']; ?>"/>
</div>
<div class="form_row">
<label>Telepon </label>
<input type="text" disabled="disabled" class="form_input" name="Input46"
value="<?php echo $row_pengggna ['telepon']; ?>"/>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div class="form_row">
<input name="submit3" type="submit" class="form_submit" value="Edit" />
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</div>
</form>
</li>
</ul>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil</a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<li>
<li></li>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($pengggna);
?>
Coding Pengelola.php
<?php require_once('../Connections/kon.php');
error_reporting (0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
mysql_select_db($database_kon, $kon);
$query_pengelola = "SELECT * FROM pengguna";
$pengelola = mysql_query($query_pengelola, $kon) or die(mysql_error());
$row_pengelola = mysql_fetch_assoc($pengelola);
$totalRows_pengelola = mysql_num_rows($pengelola);
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang dihalaman admin </h2>
<ul id="tabsmenu" class="tabsmenu">
<li class="active"><a href="#tab1"> Pengelola </a></li>
<li><a href="#tab2">Tambah Pengelola Ujian</a></li>
</ul>
<div id="tab1" class="tabcontent">
<h3>Data Pengelola </h3>
<table id="rounded-corner">
<thead>
<tr>
<th width="5%"></th>
<th width="21%">Id Pengelola</th>
<th width="32%">Nama Pengelola</th>
<th width="11%">Telepon</th>
<th width="10%">Level</th>
<th width="10%">Mengajar</th>
<th width="5%">Edit</th>
<th width="8%">Delete</th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td><input type="checkbox" name="Input" /></td>
<td><?php echo $row_pengelola['id_admin']; ?></td>
<td><?php echo $row_pengelola['nama_admin']; ?></td>
<td><?php echo $row_pengelola['telepon']; ?></td>
<td><?php echo $row_pengelola['level']; ?></td>
<td><?php echo $row_pengelola['mengajar']; ?></td>
<td><a href="editpengelola.php?id_admin=<?php echo $row_pengelola['id_admin'];
?>"><img src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapuspengelola.php?id_admin=<?php echo $row_pengelola['id_admin'];
?>" onclick="return confirm('anda yakin ingin menghapus item ini?')"> <img
src="images/trash.gif" alt="hapus" title="" border="0"/> </a> </td>
</tr>
<?php } while ($row_pengelola = mysql_fetch_assoc($pengelola)); ?>
</tbody>
</table>
<p> </p>
<p></p>
</div>
<div id="tab2" class="tabcontent">
<h3>Tambah Pengelola </h3>
<?php
$sql=mysql_query("select * from pengguna order by id_admin DESC LIMIT 0,1");
$data=mysql_fetch_array($sql);
$kodeawal=substr($data['id_admin'],3,4)+1;
if($kodeawal<10){
$kode='PGN000'.$kodeawal;
}elseif($kodeawal > 9 && $kodeawal <=99){
$kode='PGN00'.$kodeawal;
}else{
$kode='PGN00'.$kodeawal;
}
?>
<form id="form1" name="form1" method="post" enctype="multipart/form-data"
action="simpanpengelola.php" onSubmit="return cekFile()" onSubmit="return cekNumeric()">
<div class="form">
<div class="form_row">
<label>Id Pengelola </label>
<input type="text" class="form_input" name="id" value="<?php echo $kode;?>" />
</div>
<div class="form_row">
<label>Username </label>
<input type="text" class="form_input" name="nama_akun" />
</div>
<p> </p>
<div class="form_row">
<label>Password </label>
<input type="password" class="form_input" name="kata_sandi" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Nama Lengkap </label>
<input type="text" class="form_input" name="nama_lengkap" />
</div>
<p> </p>
<div class="form_row">
<label>Jenis Kelamin </label>
<select class="form_select" name="jk">
<option>--- Jenis Kelamin---</option>
<option value="perempuan">Perempuan</option>
<option value="laki">Laki-Laki</option>
</select>
</div>
<p> </p>
<div class="form_row">
<label>Alamat</label>
<input type="text" class="form_input" name="alamat" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Telepon</label>
<input type="text" class="form_input" name="telepon" />
</div>
<div class="form_row">
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Level</label>
<select class="form_select" name="level">
<option>--level--</option>
<option value="admin">Admin</option>
<option value="guru">Guru</option>
</select>
</div>
<p> </p>
<div class="form_row">
<label>Mengajar </label>
<select class="form_select" name="nama_matpel">
<option value ="">--- Mata Pelajaran---</option>
<option value="BAHASA INDONESIA">BAHASA INDONESIA</option>
<option value="BAHASA INGGRIS">BAHASA INGGRIS</option>
<option value="MATEMATIKA">MATEMATIKA</option>
<option value="SIMULASI DIGITAL">SIMULASI DIGITAL</option>
</select>
</div>
<p> </p>
<div class="form_row">
<input name="submit" type="submit" class="form_submit" value="Simpan" />
</div>
<div class="clear"></div>
</div>
</form>
<p> </p>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard </h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen Kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil </a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<li>
<li></li>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($pengggna);
mysql_free_result($pengelola);
?>
<script>
function cekFile() {
var cek = document.forms['form1']['nama_akun'].value;
var cek1 = document.forms['form1']['kata_sandi'].value;
var cek2 = document.forms['form1']['nama_lengkap'].value;
var cek3 = document.forms['form1']['jk'].value;
var cek4 = document.forms['form1']['alamat'].value;
var cek5 = document.forms['form1']['telepon'].value;
var cek6 = document.forms['form1']['level'].value;
var cek6 = document.forms['form1']['mengajar'].value;
if(cek==null || cek=="")
{
alert("nama akun tidak boleh kosong!!!");
return false;
}
if (cek1==null || cek1=="")
{
alert("kata sandi tidak boleh kosong!!!");
return false;
}
if (cek2==null || cek2=="")
{
alert("nama lengkap tidak boleh kosong!!!");
return false;
}
if (cek3==null || cek3=="")
{
alert("Jenis kelamin tidak boleh kosong!!!");
return false;
}
if (cek4==null || cek4=="")
{
alert("alamat tidak boleh kosong!!!");
return false;
}
if (cek5==null || cek5=="")
{
alert("telepon tidak boleh kosong!!!");
return false;
}
}
</script>
<script>
function cekNumeric()
{
var cek = document.forms['form1']['telepon'].value;
if (!/^[0-9]+$/.test(cek))
{
alert("Field harus memiliki karakter numerik !!!");
cekForm.numeric.focus();
return false;
}
}
</script>
Coding lihatnilai.php
<?php require_once('../Connections/kon.php'); ?>
<?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
$maxRows_kelas = 10;
$pageNum_kelas = 0;
if (isset($_GET['pageNum_kelas'])) {
$pageNum_kelas = $_GET['pageNum_kelas'];
}
$startRow_kelas = $pageNum_kelas * $maxRows_kelas;
mysql_select_db($database_kon, $kon);
$query_kelas = "SELECT * FROM kelas";
$query_limit_kelas = sprintf("%s LIMIT %d, %d", $query_kelas, $startRow_kelas,
$maxRows_kelas);
$kelas = mysql_query($query_limit_kelas, $kon) or die(mysql_error());
$row_kelas = mysql_fetch_assoc($kelas);
if (isset($_GET['totalRows_kelas'])) {
$totalRows_kelas = $_GET['totalRows_kelas'];
} else {
$all_kelas = mysql_query($query_kelas);
$totalRows_kelas = mysql_num_rows($all_kelas);
}
$totalPages_kelas = ceil($totalRows_kelas/$maxRows_kelas)-1;
$maxRows_nilai3 = 10;
$pageNum_nilai3 = 0;
if (isset($_GET['pageNum_nilai3'])) {
$pageNum_nilai3 = $_GET['pageNum_nilai3'];
}
$startRow_nilai3 = $pageNum_nilai3 * $maxRows_nilai3;
mysql_select_db($database_kon, $kon);
$kd_matpel=$_GET['kd_matpel'];
$query_nilai3 = "SELECT peserta.no_peserta , peserta.nama , ujian.skor,
ujian.kd_matpel,ujian.noujian FROM uascbt.peserta INNER JOIN uascbt.ujian ON
(peserta.no_peserta = ujian.no_peserta) where kd_matpel='$kd_matpel'";
$query_limit_nilai3 = sprintf("%s LIMIT %d, %d", $query_nilai3, $startRow_nilai3,
$maxRows_nilai3);
$nilai3 = mysql_query($query_limit_nilai3, $kon) or die(mysql_error());
$row_nilai3 = mysql_fetch_assoc($nilai3);
if (isset($_GET['totalRows_nilai3'])) {
$totalRows_nilai3 = $_GET['totalRows_nilai3'];
} else {
$all_nilai3 = mysql_query($query_nilai3);
$totalRows_nilai3 = mysql_num_rows($all_nilai3);
}
$totalPages_nilai3 = ceil($totalRows_nilai3/$maxRows_nilai3)-1;
$queryString_nilai3 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_nilai3") == false &&
stristr($param, "totalRows_nilai3") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_nilai3 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_nilai3 = sprintf("&totalRows_nilai3=%d%s", $totalRows_nilai3,
$queryString_nilai3);
$maxRows_nilai = 10;
$pageNum_nilai = 0;
if (isset($_GET['pageNum_nilai'])) {
$pageNum_nilai = $_GET['pageNum_nilai'];
}
$startRow_nilai = $pageNum_nilai * $maxRows_nilai;
mysql_select_db($database_kon, $kon);
$kd_matpel=$_GET['kd_matpel'];
$query_nilai = "SELECT peserta.no_peserta , peserta.nama , ujian.skor, ujian.kd_matpel
FROM uascbt.peserta INNER JOIN uascbt.ujian ON (peserta.no_peserta =
ujian.no_peserta)where kd_matpel='$kd_matpel' ";
$query_limit_nilai = sprintf("%s LIMIT %d, %d", $query_nilai, $startRow_nilai,
$maxRows_nilai);
$nilai = mysql_query($query_limit_nilai, $kon) or die(mysql_error());
$row_nilai = mysql_fetch_assoc($nilai);
if (isset($_GET['totalRows_nilai'])) {
$totalRows_nilai = $_GET['totalRows_nilai'];
} else {
$all_nilai = mysql_query($query_nilai);
$totalRows_nilai = mysql_num_rows($all_nilai);
}
$totalPages_nilai = ceil($totalRows_nilai/$maxRows_nilai)-1;
$maxRows_nilai1 = 10;
$pageNum_nilai1 = 0;
if (isset($_GET['pageNum_nilai1'])) {
$pageNum_nilai1 = $_GET['pageNum_nilai1'];
}
$startRow_nilai1 = $pageNum_nilai1 * $maxRows_nilai1;
mysql_select_db($database_kon, $kon);
$kd_matpel=$_GET['kd_matpel'];
$query_nilai1 = "SELECT peserta.no_peserta , peserta.nama , ujian.skor, ujian.kd_matpel
FROM uascbt.peserta INNER JOIN uascbt.ujian ON (peserta.no_peserta =
ujian.no_peserta) where kd_matpel='$kd_matpel'";
$query_limit_nilai1 = sprintf("%s LIMIT %d, %d", $query_nilai1, $startRow_nilai1,
$maxRows_nilai1);
$nilai1 = mysql_query($query_limit_nilai1, $kon) or die(mysql_error());
$row_nilai1 = mysql_fetch_assoc($nilai1);
if (isset($_GET['totalRows_nilai1'])) {
$totalRows_nilai1 = $_GET['totalRows_nilai1'];
} else {
$all_nilai1 = mysql_query($query_nilai1);
$totalRows_nilai1 = mysql_num_rows($all_nilai1);
}
$totalPages_nilai1 = ceil($totalRows_nilai1/$maxRows_nilai1)-1;
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
.style4 {
font-weight: bold;
font-size: 16px;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Halaman Admin </h2>
<ul id="tabsmenu" class="tabsmenu"><li></li>
</ul>
<div id="tab1" class="tabcontent">
<h3 align="center">Nilai Ujian Akhir Semester </h3>
<p align="center" class="style4">Kode Mata pelajaran <?php echo
$row_nilai1['kd_matpel']; ?> </p>
<form id="form2" name="form2" method="post" action="hasilcarinilai.php">
<label>
<div align="right">
<input name="nama" type="text" />
<input name="Submit" type="submit" class="green" value="cari" />
<br />
<br />
</div>
</label>
</form>
<table id="rounded-corner">
<thead>
<tr>
<th width="6%"></th>
<th width="17%">No Peserta </th>
<th width="49%">nama</th>
<th width="16%">skor</th>
<th width="12%">Delete</th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td><input type="checkbox" name="Input" /></td>
<td><?php echo $row_nilai3['no_peserta']; ?></td>
<td><?php echo $row_nilai3['nama']; ?></td>
<td><?php echo $row_nilai3['skor']; ?></td>
<td><a href="hapusnilai.php?noujian=<?php echo $row_nilai3['noujian'];?>"
onclick="return confirm('anda yakin ingin menghapus item ini?')"><img src="images/trash.gif"
alt="" title="" border="0" /> </a></td>
</tr>
<?php } while ($row_nilai3 = mysql_fetch_assoc($nilai3)); ?>
<tr class="odd">
<th height="101" colspan="5"><p align="right"><a
href="hapusnilai.php?noujian=<?php echo $row_nilai['noujian']; ?>" onclick="return
confirm('anda yakin ingin menghapus item ini?')"><?php echo min($startRow_nilai3 +
$maxRows_nilai3, $totalRows_nilai3) ?>dari </a><a href="hapusujian?noujian=<?php echo
$row_nilai['noujian']; ?>" onclick="return confirm('anda yakin ingin menghapus item
ini?')"><?php echo $totalRows_nilai3 ?></a></p>
<table border="0" width="50%" align="right">
<tr>
<td width="52%" align="center"><div align="right">
<?php if ($pageNum_nilai3 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_nilai3=%d%s", $currentPage, 0,
$queryString_nilai3); ?>">First</a>
<?php } // Show if not first page ?>
</div></td>
<td width="19%" align="center"><div align="right">
<?php if ($pageNum_nilai3 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_nilai3=%d%s", $currentPage, max(0,
$pageNum_nilai3 - 1), $queryString_nilai3); ?>">Previous</a>
<?php } // Show if not first page ?>
</div></td>
<td width="13%" align="center"><div align="right">
<?php if ($pageNum_nilai3 < $totalPages_nilai3) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_nilai3=%d%s", $currentPage,
min($totalPages_nilai3, $pageNum_nilai3 + 1), $queryString_nilai3); ?>">Next</a>
<?php } // Show if not last page ?>
</div></td>
<td width="16%" align="center"><div align="right">
<?php if ($pageNum_nilai3 < $totalPages_nilai3) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_nilai3=%d%s", $currentPage,
$totalPages_nilai3, $queryString_nilai3); ?>">Last</a>
<?php } // Show if not last page ?>
</div></td>
</tr>
</table>
</th>
</tr>
</tbody>
<?php
$sql=mysql_query("select * from kelas order by id_kelas DESC LIMIT 0,1");
$data=mysql_fetch_array($sql);
$kodeawal=substr($data['id_kelas'],3,4)+1;
if($kodeawal<10){
$kode='KLS000'.$kodeawal;
}elseif($kodeawal > 9 && $kodeawal <=99){
$kode='KLS00'.$kodeawal;
}else{
$kode='KLS00'.$kodeawal;
}
?>
</table>
<p align="left"><a href="cetaknilai.php?kd=<?php echo $row_nilai['kd_matpel']; ?>"
class="button green"> cetak </a> </p>
<p class="logintitle style1"> </p>
<p> </p>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard </h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil </a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<li>
<li></li>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($kelas);
mysql_free_result($nilai3);
mysql_free_result($nilai);
mysql_free_result($nilai1);
mysql_free_result($pengggna);
mysql_free_result($kelas);
?>
Coding hasilcari.php
<?php require_once('../Connections/kon.php');
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../logincoba.php";
if ($logoutGoTo) {
header("Location: $logout GoTo");
exit;
}
}
?>
<?php
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
mysql_select_db($database_kon, $kon);
$query_siswa = "SELECT * FROM peserta";
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_datasiswa = 15;
$pageNum_datasiswa = 0;
if (isset($_GET['pageNum_datasiswa'])) {
$pageNum_datasiswa = $_GET['pageNum_datasiswa'];
}
$startRow_datasiswa = $pageNum_datasiswa * $maxRows_datasiswa;
mysql_select_db($database_kon, $kon);
$query_datasiswa = "SELECT peserta.no_peserta , peserta.nama , peserta.tgl_lahir ,
kelas.id_kelas FROM uascbt.kelas INNER JOIN uascbt.peserta ON (kelas.id_kelas =
peserta.id_kelas) ";
$query_limit_datasiswa = sprintf("%s LIMIT %d, %d", $query_datasiswa, $startRow_datasiswa,
$maxRows_datasiswa);
$datasiswa = mysql_query($query_limit_datasiswa, $kon) or die(mysql_error());
$row_datasiswa = mysql_fetch_assoc($datasiswa);
if (isset($_GET['totalRows_datasiswa'])) {
$totalRows_datasiswa = $_GET['totalRows_datasiswa'];
} else {
$all_datasiswa = mysql_query($query_datasiswa);
$totalRows_datasiswa = mysql_num_rows($all_datasiswa);
}
$totalPages_datasiswa = ceil($totalRows_datasiswa/$maxRows_datasiswa)-1;
mysql_select_db($database_kon, $kon);
$query_kelas = "SELECT * FROM kelas";
$kelas = mysql_query($query_kelas, $kon) or die(mysql_error());
$row_kelas = mysql_fetch_assoc($kelas);
$totalRows_kelas = mysql_num_rows($kelas);
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="../guru/style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="../guru/js/jquery.min.js"></script>
<script src="../guru/js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang dihalaman admin </h2>
<ul id="tabsmenu" class="tabsmenu">
<li class="active"><a href="#tab1">Data Siswa </a></li>
<li><a href="#tab2">Tambah Data Siswa </a></li>
</ul>
<div id="tab1" class="tabcontent">
<form id="form2" name="form2" method="post" action="hasilcari.php">
<label>
<div align="right">
<input name="nama" type="text" />
<input name="Submit" type="submit" class="green" value="cari" />
<br />
<br />
</div>
</label>
<p><?php
$host = "localhost";
$user = "root";
$pass = "password";
$dbName = "uascbt";
mysql_connect($host, $user, $pass);
mysql_select_db($dbName)
or die ("Connect Failed !! : ".mysql_error());
$nama= $_POST['nama']; //get the nama value from form
$q = "SELECT * from peserta where nama like '%$nama%' "; //query to get the search result
$result = mysql_query($q); //execute the query $q
?> </p>
</form>
<table id="rounded-corner">
<thead>
<tr>
<th width="5%"></th>
<th width="21%">No Peserta </th>
<th width="31%">Nama</th>
<th width="18%">Tanggal Lahir </th>
<th width="11%">Kelas</th>
<th width="7%">Edit</th>
<th width="7%">Delete</th>
</tr>
</thead>
<tfoot>
<?PHP while ($data = mysql_fetch_array($result)) { ?>
<tr>
<td colspan="10"> </td>
</tr>
</tfoot>
<tbody>
<tr class="odd">
<td><input type="checkbox" name="Input" /></td>
<td><a href="detailsiswa.php?no_peserta=<?php echo $data['no_peserta']; ?>"><?php
echo $data['no_peserta']; ?></a></td>
<td><?php echo $data['nama']; ?></td>
<td><?php echo $data['tgl_lahir']; ?></td>
<td><?php echo $data['id_kelas']; ?></td>
<td><a href="editpeserta.php?no_peserta=<?php echo $data['no_peserta']; ?>"><img
src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapuspeserta.php?no_peserta=<?php echo $data['no_peserta']; ?>"
onclick="return confirm('anda yakin ingin menghapus item ini?')"> <img src="images/trash.gif"
alt="" title="" border="0" /></a></td>
</tr>
<?php } ?>
</tbody>
</table>
<h3> </h3>
<p></p>
</div>
<div id="tab2" class="tabcontent">
<h3>Tambah Data</h3>
<table width="613" height="59" border="0" align="center" cellpadding="1" cellspacing="1"
class="toogle_wrap">
<tr>
</tr>
</table>
<p>
<script type="text/javascript">
// validasi form (hanya file .xls yang diijinkan)
function validateForm()
{
function hasExtension(inputID, exts) {
var fileName = document.getElementById(inputID).value;
return (new RegExp('(' + exts.join('|').replace(/\./g, '\\.') + ')$')).test(fileName);
}
}
</script>
<?php
$sql=mysql_query("select * from peserta order by no_peserta DESC LIMIT 0,1");
$data=mysql_fetch_array($sql);
$kodeawal=substr($data['no_peserta'],3,4)+1;
if($kodeawal<10){
$kode='SIS000'.$kodeawal;
}elseif($kodeawal > 9 && $kodeawal <=99){
$kode='SIS00'.$kodeawal;
}else{
$kode='SIS00'.$kodeawal;
}
?>
</p>
<form id="form2" name="form3" method="post" enctype="multipart/form-
data" action="simpanpeserta.php" onSubmit="return cek();">
<div class="form">
<div class="form_row">
<label>No Peserta </label>
<input type="text" class="form_input" name="id" value="<?php echo $kode;?>" />
</div>
<div class="form_row">
<label>Username </label>
<input type="text" class="form_input" name="nama_akun" />
</div>
<p> </p>
<div class="form_row">
<label>Password </label>
<input type="text" class="form_input" name="kata_sandi" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Nama Lengkap </label>
<input type="text" class="form_input" name="nama_lengkap" />
</div>
<p> </p>
<div class="form_row">
<label>Jenis Kelamin </label>
<select class="form_select" name="jk">
<option>--- Jenis Kelamin---</option>
<option value="perempuan">Perempuan</option>
<option value="laki">laki-laki</option>
</select>
</div>
<p> </p>
<div class="form_row">
<label>Alamat</label>
<input type="text" class="form_input" name="alamat" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Tanggal lahir </label>
<input type="text" class="form_input" name="tgl_lahir" />
</div>
<p> </p>
<div class="form_row">
<label>Kelas</label>
<select class="form_select" name="kelas">
<?php
do {
?>
<option value="<?php echo $row_kelas['id_kelas']?>"><?php echo
$row_kelas['nama_kelas']?></option>
<?php
} while ($row_kelas = mysql_fetch_assoc($kelas));
$rows = mysql_num_rows($kelas);
if($rows > 0) {
mysql_data_seek($kelas, 0);
$row_kelas = mysql_fetch_assoc($kelas);
}
?>
</select>
</div>
<p> </p>
<div class="form_row">
</div>
<p> </p>
<p> </p>
<div class="form_row">
<input name="submit" type="submit" class="form_submit" value="Simpan" />
</div>
<div class="clear"></div>
</div>
</form>
<p> </p>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard </h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">Manajemen Siswa </a></li>
<li><a href="datakelas.php">Manajemen kelas </a></li>
<li><a href="datamatpel.php">Manajemen matapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">ManajemenUjian </a></li>
<li><a href="datapribadiadmin.php">Profil </a></li>
<li></li>
</ul>
<h2>Anda Masuk sebagai</h2>
<ul>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Keluar" />
</a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018</div>
</div>
</div>
</body>
</html>
<script>
function cek() {
var cek = document.forms['form3']['nama_akun'].value;
var cek1 = document.forms['form3']['kata_sandi'].value;
var cek2 = document.forms['form3']['nama_lengkap'].value;
var cek3 = document.forms['form3']['jk'].value;
var cek4 = document.forms['form3']['alamat'].value;
var cek5 = document.forms['form3']['tgl_lahir'].value;
var cek6 = document.forms['form3']['kelas'].value;
if(cek==null || cek=="")
{
alert("nama akun tidak boleh kosong!!!");
return false;
}
if (cek1==null || cek1=="")
{
alert("kata sandi tidak boleh kosong!!!");
return false;
}
if (cek2==null || cek2=="")
{
alert("nama lengkap tidak boleh kosong!!!");
return false;
}
if (cek3==null || cek3=="")
{
alert("Jenis kelamin tidak boleh kosong!!!");
return false;
}
if (cek4==null || cek4=="")
{
alert("alamat tidak boleh kosong!!!");
return false;
}
if (cek5==null || cek5=="")
{
alert("tanggal lahir tidak boleh kosong!!!");
return false;
}
if (cek6==null || cek6=="")
{
alert("kelas tidak boleh kosong!!!");
return false;
}
}
</script>
<?php
mysql_free_result($pengggna);
mysql_free_result($siswa);
mysql_free_result($datasiswa);
mysql_free_result($kelas);
?>
Coding soalmatpel.php <?php require_once('../Connections/kon.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$colname_pengggna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengggna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengggna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengggna);
$pengggna = mysql_query($query_pengggna, $kon) or die(mysql_error());
$row_pengggna = mysql_fetch_assoc($pengggna);
$totalRows_pengggna = mysql_num_rows($pengggna);
$maxRows_soal = 10;
$pageNum_soal = 0;
if (isset($_GET['pageNum_soal'])) {
$pageNum_soal = $_GET['pageNum_soal'];
}
$startRow_soal = $pageNum_soal * $maxRows_soal;
mysql_select_db($database_kon, $kon);
$query_soal = "SELECT * FROM soal";
$query_limit_soal = sprintf("%s LIMIT %d, %d", $query_soal, $startRow_soal,
$maxRows_soal);
$soal = mysql_query($query_limit_soal, $kon) or die(mysql_error());
$row_soal = mysql_fetch_assoc($soal);
if (isset($_GET['totalRows_soal'])) {
$totalRows_soal = $_GET['totalRows_soal'];
} else {
$all_soal = mysql_query($query_soal);
$totalRows_soal = mysql_num_rows($all_soal);
}
$totalPages_soal = ceil($totalRows_soal/$maxRows_soal)-1;
$queryString_soal = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_soal") == false &&
stristr($param, "totalRows_soal") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_soal = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_soal = sprintf("&totalRows_soal=%d%s", $totalRows_soal, $queryString_soal);
$maxRows_soalmatpel = 10;
$pageNum_soalmatpel = 0;
if (isset($_GET['pageNum_soalmatpel'])) {
$pageNum_soalmatpel = $_GET['pageNum_soalmatpel'];
}
$startRow_soalmatpel = $pageNum_soalmatpel * $maxRows_soalmatpel;
mysql_select_db($database_kon, $kon);
$kd_matpel=$_GET['kd_matpel'];
$query_soalmatpel = "SELECT * FROM soal where kd_matpel='$kd_matpel'";
$query_limit_soalmatpel = sprintf("%s LIMIT %d, %d", $query_soalmatpel,
$startRow_soalmatpel, $maxRows_soalmatpel);
$soalmatpel = mysql_query($query_limit_soalmatpel, $kon) or die(mysql_error());
$row_soalmatpel = mysql_fetch_assoc($soalmatpel);
if (isset($_GET['totalRows_soalmatpel'])) {
$totalRows_soalmatpel = $_GET['totalRows_soalmatpel'];
} else {
$all_soalmatpel = mysql_query($query_soalmatpel);
$totalRows_soalmatpel = mysql_num_rows($all_soalmatpel);
}
$totalPages_soalmatpel = ceil($totalRows_soalmatpel/$maxRows_soalmatpel)-1;
mysql_select_db($database_kon, $kon);
$kd_matpel=$_GET['kd_matpel'];
$query_soalmatpel = "SELECT * FROM soal where kd_matpel='$kd_matpel'";
$soalmatpel = mysql_query($query_soalmatpel, $kon) or die(mysql_error());
$row_soalmatpel = mysql_fetch_assoc($soalmatpel);
$totalRows_soalmatpel = mysql_num_rows($soalmatpel);
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="../header.jpg" width="974" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Tables section</h2>
<div id="tab1" class="tabcontent">
<div align="right"></div>
<p align="right"> <?php echo min($startRow_soal + $maxRows_soal,
$totalRows_soal) ?> dari <?php echo $totalRows_soal ?> </p>
<table width="87%" id="rounded-corner">
<thead>
<tr>
<th width="6%"></th>
<th width="14%">kode soal </th>
<th width="42%">soal</th>
<th width="9%">jawaban</th>
<th width="12%">Edit</th>
<th width="17%">hapus</th>
</tr>
</thead>
<tfoot>
<tr>
<td height="65" colspan="11"><table border="0" width="50%" align="right">
<tr>
<td width="54%" align="center"><div align="right">
<?php if ($pageNum_soal > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_soal=%d%s", $currentPage, 0,
$queryString_soal); ?>">First</a>
<?php } // Show if not first page ?>
</div></td>
<td width="19%" align="center"><div align="right">
<?php if ($pageNum_soal > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_soal=%d%s", $currentPage, max(0,
$pageNum_soal - 1), $queryString_soal); ?>">Previous</a>
<?php } // Show if not first page ?>
</div></td>
<td width="13%" align="center"><div align="right">
<?php if ($pageNum_soal < $totalPages_soal) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_soal=%d%s", $currentPage,
min($totalPages_soal, $pageNum_soal + 1), $queryString_soal); ?>">Next</a>
<?php } // Show if not last page ?>
</div></td>
<td width="14%" align="center"><div align="right">
<?php if ($pageNum_soal < $totalPages_soal) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_soal=%d%s", $currentPage,
$totalPages_soal, $queryString_soal); ?>">Last</a>
<?php } // Show if not last page ?>
</div></td>
</tr>
</table>
<a href="cetakpermatpel.php?kd_matpel=<?php echo $row_soalmatpel['kd_matpel'];
?>" class="button green">cetak</a></td>
</tr>
</tfoot>
<?php do { ?>
<tbody>
<tr class="odd">
<td height="41"><input name="checkbox[]" type="checkbox" id="checkbox" value=""
/></td>
<td><?php echo $row_soalmatpel['kd_soal']; ?></td>
<td><span class="clear"><?php echo $row_soalmatpel['soal']; ?> </span></td>
<td><span class="clear"><?php echo $row_soalmatpel['kunci']; ?></span></td>
<td><a href="editsoal.php?kd_soal=<?php echo $row_soalmatpel['kd_soal']; ?>"><img
src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapussoal.php?kd_soal=<?php echo $row_soalmatpel['kd_soal']; ?>"
onclick="return confirm('anda yakin ingin menghapus item ini?');"> <img src="images/trash.gif"
alt="hapus" title="" border="0" /></a></td>
</tr>
<?php } while ($row_soalmatpel = mysql_fetch_assoc($soalmatpel)); ?>
</tbody>
</table>
<p> </p>
<h3> </h3>
<p class="toggle_container"> </p>
</div>
</div>
</div>
<!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="pengelola.php">Manajemen Pengelola Ujian </a></li>
<li><a href="datasiswa.php">ManajemenSiswa </a></li>
<li><a href="datakelas.php">Manajemenkelas </a></li>
<li><a href="datamatpel.php">Manajemenmatapelajaran </a></li>
<li><a href="datasoal.php">Manajemen Soal </a></li>
<li><a href="dataujian.php">Manajemen Ujian </a></li>
<li><a href="datapribadiadmin.php">Profil </a></li>
<li></li>
</ul>
<h2>Anda masuk sebagai</h2>
<ul>
<li>
</li>
<li></li>
<li>
<div align="center"><strong><?php echo $row_pengggna['nama_admin'];
?></strong></div>
</li>
<li>
<div align="center"><a href="<?php echo $logoutAction ?>">
<input name="Submit2" type="submit" class="red" value="Logout" />
</a></div>
</li>
</ul>
</div>
<div class="clear">
<p> </p>
<p> </p>
</div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($pengggna);
mysql_free_result($soal);
mysql_free_result($soalmatpel);
?>
Coding logguru.php
<?php require_once('Connections/kon.php'); ?><?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
session_start();
}
$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
$_SESSION['PrevUrl'] = $_GET['accesscheck'];
}
if (isset($_POST['nama'])) {
$loginUsername=$_POST['nama'];
$password=$_POST['pass'];
$MM_fldUserAuthorization = "";
$MM_redirectLoginSuccess = "guru/guru.php";
$MM_redirectLoginFailed = "gagalguru.php";
$MM_redirecttoReferrer = false;
mysql_select_db($database_kon, $kon);
$LoginRS__query=sprintf("SELECT username, password FROM pengguna WHERE
username='%s' AND password='%s'AND level='guru'",
get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername),
get_magic_quotes_gpc() ? $password : addslashes($password));
$LoginRS = mysql_query($LoginRS__query, $kon) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {
$loginStrGroup = "";
$kode_akses= $LoginRS__query['level'];
//declare two session variables and assign them
$_SESSION['MM_Username'] = $loginUsername;
$_SESSION['MM_UserGroup'] = $loginStrGroup;
if (isset($_SESSION['PrevUrl']) && false) {
$MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
}
header("Location: " . $MM_redirectLoginSuccess );
}
else {
header("Location: ". $MM_redirectLoginFailed );
}
}
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div class="header">
<div class="menu">
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
<div id="right_wrap">
<div id="right_content">
<h2>Selamat Datang Di Halaman Login Guru Ujian Akhir Semester Berbasis CBT </h2>
<ul class="tabsmenu"><li class="active"><a href="#tab1">Masukan Username dan Password
</a></li>
</ul>
<div id="tab1" class="tabcontent">
<form name="login" method="POST" action="<?php echo $loginFormAction; ?>">
<div class="form">
<div class="form_row">
<label>Username </label>
<input type="text" class="form_input" name="nama" />
</div>
<div class="form_row">
<label>Password </label>
<input type="password" class="form_input" name="pass" />
</div>
<div class="form_row">
<input name="Login" type="submit" class="form_submit" value="Login" />
</div>
<div class="clear"></div>
</div>
</form>
</div>
</body>
</html>
Coding datapribadiguru.php <?php require_once('../Connections/kon.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
$maxRows_pengguna = 10;
$pageNum_pengguna = 0;
if (isset($_GET['pageNum_pengguna'])) {
$pageNum_pengguna = $_GET['pageNum_pengguna'];
}
$startRow_pengguna = $pageNum_pengguna * $maxRows_pengguna;
$colname_pengguna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengguna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengguna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengguna);
$query_limit_pengguna = sprintf("%s LIMIT %d, %d", $query_pengguna, $startRow_pengguna,
$maxRows_pengguna);
$pengguna = mysql_query($query_limit_pengguna, $kon) or die(mysql_error());
$row_pengguna = mysql_fetch_assoc($pengguna);
if (isset($_GET['totalRows_pengguna'])) {
$totalRows_pengguna = $_GET['totalRows_pengguna'];
} else {
$all_pengguna = mysql_query($query_pengguna);
$totalRows_pengguna = mysql_num_rows($all_pengguna);
}
$totalPages_pengguna = ceil($totalRows_pengguna/$maxRows_pengguna)-1;
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 14;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p align="center"><img src="images/header.jpg" width="969" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang Di halaman Guru </h2>
<div id="tab2" class="tabcontent">
<form id="form1" name="form1" method="post" action="editdatapribadi.php">
<div id="tab1" class="tabcontent">
<h3>Data Pribadi anda </h3>
<div class="form_row">
<label>Username </label>
<input type="text" disabled="disabled" class="form_input" name="Input4"
value="<?php echo $row_pengguna['username']; ?>"/>
</div>
<div class="form_row">
<label>Password</label>
<input type="password" disabled="disabled" class="form_input" name="Input42"
value="<?php echo $row_pengguna['password']; ?>"/>
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Nama Lengkap </label>
<input type="text" disabled="disabled" class="form_input" name="Input43"
value="<?php echo $row_pengguna['nama_admin']; ?>"/>
</div>
<div class="form_row">
<label>Jenis Kelamin </label>
<input type="text" disabled="disabled" class="form_input"
name="Input44"value="<?php echo $row_pengguna['jenis_kelamin']; ?>" />
</div>
<div class="form_row">
<label>alamat</label>
<input type="text" disabled="disabled" class="form_input" name="Input45"
value="<?php echo $row_pengguna['alamat']; ?>"/>
</div>
<div class="form_row">
<label>Telepon </label>
<input type="text" disabled="disabled" class="form_input" name="Input46"
value="<?php echo $row_pengguna['telepon']; ?>"/>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div class="form_row">
<input name="submit3" type="submit" class="form_submit" value="Edit" />
</div>
<p> </p>
</div>
</form>
<p> </p>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="datasoal.php">Manajemen Data Soal</a></li>
<li><a href="tambahsoal.php">Manajemen Tambah Soal</a></li>
<li><a href="pengaturanujian.php">Manajemen Pengaturan Ujian</a></li>
<li><a href="editdatapribadi.php">Manajemen Edit Data
Pribadi</a></li>
</ul>
<h2>Anda masuk sebagai</h2>
<ul>
<li> </li>
<li>
<table border="1" align="center">
</table>
</li>
<li class="style1" >
<div align="center"><?php echo $_SESSION['MM_Username'] ?></div>
</li>
<li class="style1" ></li>
<li class="style1" >
<div align="center">
<a href="<?php echo $logoutAction ?>"> <input name="submit" type="submit"
class="red" value="Logout" /></a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018
<a href="htpp://csstemplatesmarket.com" target="_blank"></a>
</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($pengguna);
?>
Coding datasoal.php <?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?><?php
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_pengguna = 15;
$pageNum_pengguna = 0;
if (isset($_GET['pageNum_pengguna'])) {
$pageNum_pengguna = $_GET['pageNum_pengguna'];
}
$startRow_pengguna = $pageNum_pengguna * $maxRows_pengguna;
$colname_pengguna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengguna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengguna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengguna);
$query_limit_pengguna = sprintf("%s LIMIT %d, %d", $query_pengguna, $startRow_pengguna,
$maxRows_pengguna);
$pengguna = mysql_query($query_limit_pengguna, $kon) or die(mysql_error());
$row_pengguna = mysql_fetch_assoc($pengguna);
if (isset($_GET['totalRows_pengguna'])) {
$totalRows_pengguna = $_GET['totalRows_pengguna'];
} else {
$all_pengguna = mysql_query($query_pengguna);
$totalRows_pengguna = mysql_num_rows($all_pengguna);
}
$totalPages_pengguna = ceil($totalRows_pengguna/$maxRows_pengguna)-1;
$maxRows_matematika = 15;
$pageNum_matematika = 0;
if (isset($_GET['pageNum_matematika'])) {
$pageNum_matematika = $_GET['pageNum_matematika'];
}
$startRow_matematika = $pageNum_matematika * $maxRows_matematika;
mysql_select_db($database_kon, $kon);
$query_matematika = "SELECT mata_pelajaran.nama_matpel , `soal`.* FROM
uascbt.mata_pelajaran INNER JOIN uascbt.soal ON (mata_pelajaran.kd_matpel =
soal.kd_matpel) WHERE mata_pelajaran.kd_matpel='MTK'";
$query_limit_matematika = sprintf("%s LIMIT %d, %d", $query_matematika,
$startRow_matematika, $maxRows_matematika);
$matematika = mysql_query($query_limit_matematika, $kon) or die(mysql_error());
$row_matematika = mysql_fetch_assoc($matematika);
if (isset($_GET['totalRows_matematika'])) {
$totalRows_matematika = $_GET['totalRows_matematika'];
} else {
$all_matematika = mysql_query($query_matematika);
$totalRows_matematika = mysql_num_rows($all_matematika);
}
$totalPages_matematika = ceil($totalRows_matematika/$maxRows_matematika)-1;
$maxRows_INDONESIA = 15;
$pageNum_INDONESIA = 0;
if (isset($_GET['pageNum_INDONESIA'])) {
$pageNum_INDONESIA = $_GET['pageNum_INDONESIA'];
}
$startRow_INDONESIA = $pageNum_INDONESIA * $maxRows_INDONESIA;
mysql_select_db($database_kon, $kon);
$query_INDONESIA = "SELECT mata_pelajaran.nama_matpel , `soal`.* FROM
uascbt.mata_pelajaran INNER JOIN uascbt.soal ON (mata_pelajaran.kd_matpel =
soal.kd_matpel) WHERE mata_pelajaran.kd_matpel='IND'";
$query_limit_INDONESIA = sprintf("%s LIMIT %d, %d", $query_INDONESIA,
$startRow_INDONESIA, $maxRows_INDONESIA);
$INDONESIA = mysql_query($query_limit_INDONESIA, $kon) or die(mysql_error());
$row_INDONESIA = mysql_fetch_assoc($INDONESIA);
if (isset($_GET['totalRows_INDONESIA'])) {
$totalRows_INDONESIA = $_GET['totalRows_INDONESIA'];
} else {
$all_INDONESIA = mysql_query($query_INDONESIA);
$totalRows_INDONESIA = mysql_num_rows($all_INDONESIA);
}
$totalPages_INDONESIA = ceil($totalRows_INDONESIA/$maxRows_INDONESIA)-1;
$maxRows_Recordset1 = 15;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_kon, $kon);
$query_Recordset1 = "SELECT mata_pelajaran.nama_matpel , `soal`.* FROM
uascbt.mata_pelajaran INNER JOIN uascbt.soal ON (mata_pelajaran.kd_matpel =
soal.kd_matpel) WHERE mata_pelajaran.kd_matpel='IGR'";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1,
$startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $kon) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
mysql_select_db($database_kon, $kon);
$query_SDG = "SELECT mata_pelajaran.nama_matpel , `soal`.* FROM
uascbt.mata_pelajaran INNER JOIN uascbt.soal ON (mata_pelajaran.kd_matpel =
soal.kd_matpel) WHERE mata_pelajaran.kd_matpel='SDG'";
$SDG = mysql_query($query_SDG, $kon) or die(mysql_error());
$row_SDG = mysql_fetch_assoc($SDG);
$totalRows_SDG = mysql_num_rows($SDG);
$queryString_matematika = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_matematika") == false &&
stristr($param, "totalRows_matematika") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_matematika = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_matematika = sprintf("&totalRows_matematika=%d%s", $totalRows_matematika,
$queryString_matematika);
$queryString_INDONESIA = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_INDONESIA") == false &&
stristr($param, "totalRows_INDONESIA") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_INDONESIA = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_INDONESIA = sprintf("&totalRows_INDONESIA=%d%s",
$totalRows_INDONESIA, $queryString_INDONESIA);
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 14;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p align="center"><img src="images/header.jpg" width="971" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang Di halaman Guru </h2>
<div id="div">
<div id="div2">
<ul id="tabsmenu" class="tabsmenu">
<li class="active"><a href="#tab1">BAHASA INDONESIA </a></li>
<li><a href="#tab2">MATEMATIKA</a></li>
<li><a href="#tab3">BAHASA INGGRIS </a></li>
<li><a href="#tab4">SIMULASI DIGITAL</a></li>
</ul>
<div id="tab1" class="tabcontent">
<h3>Bahasa Indonesia </h3>
<table width="87%" id="rounded-corner">
<thead>
<tr>
<th width="8%"></th>
<th width="27%">Kode Soal </th>
<th width="29%">Soal - Soal</th>
<th width="17%">Jawaban</th>
<th width="8%">Edit</th>
<th width="11%">Hapus</th>
</tr>
</thead>
<tfoot>
<tr>
<td colspan="11"><p>
<table border="0" width="30%" align="right">
<tr>
<td width="14%" align="center"><?php if ($pageNum_INDONESIA > 0) { //
Show if not first page ?>
<a href="<?php printf("%s?pageNum_INDONESIA=%d%s", $currentPage, 0,
$queryString_INDONESIA); ?>">First</a>
<?php } // Show if not first page ?> </td>
<td width="18%" align="center"><?php if ($pageNum_INDONESIA > 0) { //
Show if not first page ?>
<a href="<?php printf("%s?pageNum_INDONESIA=%d%s", $currentPage,
max(0, $pageNum_INDONESIA - 1), $queryString_INDONESIA); ?>">Previous</a>
<?php } // Show if not first page ?> </td>
<td width="14%" align="center"><?php if ($pageNum_INDONESIA <
$totalPages_INDONESIA) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_INDONESIA=%d%s", $currentPage,
min($totalPages_INDONESIA, $pageNum_INDONESIA + 1), $queryString_INDONESIA);
?>">Next</a>
<?php } // Show if not last page ?> </td>
<td width="54%" align="center"><?php if ($pageNum_INDONESIA <
$totalPages_INDONESIA) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_INDONESIA=%d%s", $currentPage,
$totalPages_INDONESIA, $queryString_INDONESIA); ?>"> Last</a>
<?php } // Show if not last page ?> </td>
</tr>
</table>
<a href="pdfindonesia.php" class="button green">cetak </a>
</p></td>
</tr>
</tfoot>
<?php do { ?>
<tbody>
<tr class="odd">
<td height="41"><input name="checkbox[]" type="checkbox" id="checkbox"
value="<?php echo $row_INDONESIA['kd_soal']; ?>" /></td>
<td><a href="detailsoal.php?kd_soal=<?php echo $row_INDONESIA['kd_soal'];
?>"><?php echo $row_INDONESIA['kd_soal']; ?></a></td>
<td><?php echo $row_INDONESIA['soal'];?> <?php
if($row_INDONESIA['soalgambar']!="" and $row_INDONESIA['soallistening']=="" ){?><img
src="images/<?php echo $row_INDONESIA['soalgambar']; ?>" width="500" height="250"
/><?php }elseif($row_INDONESIA['soalgambar']=="" and
$row_INDONESIA['soallistening']!="" ){ ?><audio src="audio/<?php echo
$row_INDONESIA['soallistening']; ?>" controls></audio> <?php }else{ echo "-";} ?></td>
<td><?php echo $row_INDONESIA['kunci']; ?></td>
<td><a href="editsoal.php?kd_soal=<?php echo $row_INDONESIA['kd_soal'];
?>"><img src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapussoal.php?kd_soal=<?php echo $row_INDONESIA['kd_soal'];
?>"" onclick="return confirm('anda yakin ingin menghapus item ini?');"><img
src="images/trash.gif" alt="hapus" title="" border="0" /></a></td>
</tr>
<?php } while ($row_INDONESIA = mysql_fetch_assoc($INDONESIA)); ?>
</tbody>
</table>
<p> </p>
</div>
<div id="tab2" class="tabcontent">
<h3>Matematika </h3>
<p> </p>
<table width="91%" id="rounded-corner">
<thead>
<tr>
<th width="29%">Kode Soal</th>
<th width="35%">Soal</th>
<th width="17%">Jawaban</th>
<th width="8%">Edit</th>
<th width="11%">hapus</th>
</tr>
</thead>
<tfoot>
<tr>
<td height="42" colspan="10"> <a href="pdfmtk.php" class="button green">cetak
</a> </td>
</tr>
</tfoot>
<?php do { ?>
<tbody>
<tr class="odd">
<td height="41"><a href="detailsoal.php?kd_soal=<?php echo
$row_matematika['kd_soal']; ?>"><?php echo $row_matematika['kd_soal']; ?></a></td>
<td><?php echo $row_matematika['soal'];?> <?php
if($row_matematika['soalgambar']!="" and $row_matematika['soallistening']=="" ){?><img
src="images/<?php echo $row_matematika['soalgambar']; ?>" width="500" height="250"
/><?php }elseif($row_matematika['soalgambar']=="" and $row_matematika['soallistening']!=""
){ ?><audio src="audio/<?php echo $row_matematika['soallistening']; ?>" controls></audio>
<?php }else{ echo "-";} ?></td>
<td><?php echo $row_matematika['kunci']; ?></td>
<td><a href="editsoal.php?kd_soal=<?php echo $row_matematika['kd_soal'];
?>"><img src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapussoal.php?kd_soal=<?php echo $row_matematika['kd_soal']; ?>""
onclick="return confirm('anda yakin ingin menghapus item ini?');"><img src="images/trash.gif"
alt="hapus" title="" border="0" /></a></td>
</tr>
<?php } while ($row_matematika =
mysql_fetch_assoc($matematika)); ?>
</table>
<p> </p>
</div>
<div id="tab3" class="tabcontent">
<h3>Bahasa inggris </h3>
<table width="91%" id="rounded-corner">
<thead>
<tr>
<th width="8%"></th>
<th width="27%">Kode Soal</th>
<th width="29%">Soal- Soal</th>
<th width="17%">Jawaban</th>
<th width="8%">Edit</th>
<th width="11%">hapus</th>
</tr>
</thead>
<tfoot>
<tr>
<td colspan="11"><p><a href="pdfinggris.php" class="button green">cetak </a></p>
<p><a href="hapussoal.php" class="" ></a></p> </td>
</tr>
</tfoot>
<?php do { ?>
<tbody>
<tr class="odd">
<td height="41"><input type="checkbox" name="del[]" value="<?php echo
$row_Recordset1['kd_soal']; ?>"/></td>
<td><a href="detailsoal.php?kd_soal=<?php echo $row_Recordset1['kd_soal'];
?>"><?php echo $row_Recordset1['kd_soal']; ?></a></td>
<td><?php echo $row_Recordset1['soal'];?> <?php
if($row_Recordset1['soalgambar']!="" and $row_Recordset1['soallistening']=="" ){?><img
src="images/<?php echo $row_Recordset1['soalgambar']; ?>" width="500" height="250"
/><?php }elseif($row_Recordset1['soalgambar']=="" and $row_Recordset1['soallistening']!=""
){ ?><audio src="audio/<?php echo $row_Recordset1['soallistening']; ?>" controls></audio>
<?php }else{ echo "-";} ?></td>
<td><?php echo $row_Recordset1['kunci']; ?></td>
<td><a href="editsoal.php?kd_soal=<?php echo $row_Recordset1 ['kd_soal'];
?>"><img src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapussoal.php?kd_soal=<?php echo $row_Recordset1['kd_soal']; ?>""
onclick="return confirm('anda yakin ingin menghapus item ini?');"><img src="images/trash.gif"
alt="hapus" title="" border="0" /></a></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</tbody>
</table>
<p> </p>
</div>
<div id="tab4" class="tabcontent">
<h3>SIMULASI DIGITAL</h3>
<table width="91%" id="rounded-corner">
<thead>
<tr>
<th width="11%"></th>
<th width="24%">Kode Soal</th>
<th width="31%">Soal - Soal</th>
<th width="10%">Jawaban</th>
<th width="10%">Edit</th>
<th width="14%">hapus</th>
</tr>
</thead>
<tfoot>
<tr>
<td colspan="11"><p> <a href="pdfsdg.php" class="button green">cetak
</a></p></td>
</tr>
</tfoot>
<?php do { ?>
<tbody>
<tr class="odd">
<td height="41"><input type="checkbox" name="Input4" /></td>
<td><a href="detailsoal.php?kd_soal=<?php echo $row_SDG['kd_soal']; ?>"></a><a
href="detailsoal.php?kd_soal=<?php echo $row_SDG['kd_soal']; ?>"><?php echo
$row_SDG['kd_soal']; ?></a></td>
<td><?php echo $row_SDG['soal'];?> <?php if($row_SDG['soalgambar']!="" and
$row_SDG['soallistening']=="" ){?><img src="images/<?php echo $row_SDG['soalgambar'];
?>" width="500" height="250" /><?php }elseif($row_SDG['soalgambar']=="" and
$row_SDG['soallistening']!="" ){ ?><audio src="audio/<?php echo $row_SDG['soallistening'];
?>" controls></audio> <?php }else{ echo "-";} ?></td>
<td><?php echo $row_SDG['kunci']; ?></td>
<td><a href="editsoal.php?kd_soal=<?php echo $row_SDG['kd_soal']; ?>"><img
src="images/edit.png" alt="" title="" border="0" /></a></td>
<td><a href="hapussoal.php?kd_soal=<?php echo $row_SDG['kd_soal']; ?>""
onclick="return confirm('anda yakin ingin menghapus item ini?');"><img src="images/trash.gif"
alt="hapus" title="" border="0" /></a></td>
</tr>
<?php } while ($row_SDG = mysql_fetch_assoc($SDG)); ?>
</tbody>
</table>
<p> </p>
</div>
</div>
</div>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="datasoal.php">Manajemen Soal</a></li>
<li><a href="tambahsoal.php">Manajemen Tambah Soal</a></li>
<li><a href="pengaturanujian.php">Manajemen Pengaturan Ujian</a></li>
<li><a href="editdatapribadi.php">Profil</a></li>
<li></li>
</ul>
<h2>Anda masuk sebagai</h2>
<ul>
<li> </li>
<li>
<table border="1" align="center">
</table>
</li>
<li class="style1" >
<div align="center"><?php echo $_SESSION['MM_Username'] ?></div>
</li>
<li class="style1" ></li>
<li class="style1" >
<div align="center">
<a href="<?php echo $logoutAction ?>"> <input name="submit" type="submit"
class="red" value="Logout" /></a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018
<a href="htpp://csstemplatesmarket.com" target="_blank"></a>
</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($pengguna);
mysql_free_result($matematika);
mysql_free_result($INDONESIA);
mysql_free_result($Recordset1);
mysql_free_result($SDG);
?>
Coding pengaturanujian.php <?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?><?php
$maxRows_pengguna = 10;
$pageNum_pengguna = 0;
if (isset($_GET['pageNum_pengguna'])) {
$pageNum_pengguna = $_GET['pageNum_pengguna'];
}
$startRow_pengguna = $pageNum_pengguna * $maxRows_pengguna;
$colname_pengguna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengguna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengguna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengguna);
$query_limit_pengguna = sprintf("%s LIMIT %d, %d", $query_pengguna, $startRow_pengguna,
$maxRows_pengguna);
$pengguna = mysql_query($query_limit_pengguna, $kon) or die(mysql_error());
$row_pengguna = mysql_fetch_assoc($pengguna);
if (isset($_GET['totalRows_pengguna'])) {
$totalRows_pengguna = $_GET['totalRows_pengguna'];
} else {
$all_pengguna = mysql_query($query_pengguna);
$totalRows_pengguna = mysql_num_rows($all_pengguna);
}
$totalPages_pengguna = ceil($totalRows_pengguna/$maxRows_pengguna)-1;
mysql_select_db($database_kon, $kon);
$query_matpel = "SELECT * FROM mata_pelajaran";
$matpel = mysql_query($query_matpel, $kon) or die(mysql_error());
$row_matpel = mysql_fetch_assoc($matpel);
$totalRows_matpel = mysql_num_rows($matpel);
$maxRows_pgujian = 10;
$pageNum_pgujian = 0;
if (isset($_GET['pageNum_pgujian'])) {
$pageNum_pgujian = $_GET['pageNum_pgujian'];
}
$startRow_pgujian = $pageNum_pgujian * $maxRows_pgujian;
mysql_select_db($database_kon, $kon);
$query_pgujian = "SELECT mata_pelajaran.nama_matpel , pengaturan_ujian.id_pengaturan
,pengaturan_ujian.tanggal_ujian , pengaturan_ujian.waktu_ujian , pengaturan_ujian.waktu
, pengaturan_ujian.jumlah_soal FROM uascbt.mata_pelajaran INNER JOIN
uascbt.pengaturan_ujian ON (mata_pelajaran.kd_matpel = pengaturan_ujian.kd_matpel)";
$query_limit_pgujian = sprintf("%s LIMIT %d, %d", $query_pgujian, $startRow_pgujian,
$maxRows_pgujian);
$pgujian = mysql_query($query_limit_pgujian, $kon) or die(mysql_error());
$row_pgujian = mysql_fetch_assoc($pgujian);
if (isset($_GET['totalRows_pgujian'])) {
$totalRows_pgujian = $_GET['totalRows_pgujian'];
} else {
$all_pgujian = mysql_query($query_pgujian);
$totalRows_pgujian = mysql_num_rows($all_pgujian);
}
$totalPages_pgujian = ceil($totalRows_pgujian/$maxRows_pgujian)-1;
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 14;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p align="center"><img src="images/header.jpg" width="969" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Pengaturan Ujian </h2>
<div id="tab1" class="tabcontent"><form id="form1" onsubmit="return cek()" name="form1"
method="post" action="pengaturan.php">
<div class="form">
<div class="form_row">
<label>Mata Pelajaran </label>
<select name="kd_matpel" class="form_select" id="kd_matpel">
<option value=""></option>
<?php
do {
?>
<option value="<?php echo $row_matpel['kd_matpel']?>"><?php echo
$row_matpel['nama_matpel']?></option>
<?php
} while ($row_matpel = mysql_fetch_assoc($matpel));
$rows = mysql_num_rows($matpel);
if($rows > 0) {
mysql_data_seek($matpel, 0);
$row_matpel = mysql_fetch_assoc($matpel);
}
?>
</select>
</div>
<div class="form_row">
<label>Tanggal ujian </label>
<input type="text" id="datepicker" class="form_input" name="tanggal_ujian"
value="" />
</div>
<p> </p>
<div class="form_row">
<label>Waktu Ujian</label>
<input type="text" class="form_input" name="waktu_ujian" value="" />
</div>
<p> </p>
<div class="form_row">
<label>Durasi Ujian</label>
<input type="text" class="form_input" name="waktu" value="" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Jumlah Soal </label>
<input type="text" class="form_input" name="jumlah_soal" value="" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<input name="submit2" type="submit" class="form_submit" value="Simpan" />
</div>
<p> </p>
</div>
</form>
<div id="div">
<h2>Pengaturan Ujian </h2>
<table id="rounded-corner">
<thead>
<tr>
<th width="21%">Mata Pelajaran </th>
<th width="25%">Tanggal Ujian </th>
<th width="17%">Waktu Ujian </th>
<th width="14%">Durasi Ujian</th>
<th width="15%">Jumlah Soal </th>
<th width="8%">Edit</th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td><?php echo $row_pgujian['nama_matpel']; ?></td>
<td><?php echo $row_pgujian['tanggal_ujian']; ?></td>
<td><?php echo $row_pgujian['waktu_ujian']; ?></td>
<td><?php echo $row_pgujian['waktu']; ?></td>
<td><?php echo $row_pgujian['jumlah_soal']; ?></td>
<td><a href="editpengaturan.php?id_pengaturan=<?php echo
$row_pgujian['id_pengaturan']; ?>"><img src="images/edit.png" alt="" title="" border="0"
/></a></td>
</tr>
<?php } while ($row_pgujian = mysql_fetch_assoc($pgujian));
?>
</tbody>
</table>
<ul id="tabsmenu" class="tabsmenu">
<li class="active"></li>
</ul>
</div>
<h3> </h3>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="datasoal.php">Manajemen Soal</a></li>
<li><a href="tambahsoal.php">Manajemen Tambah Soal</a></li>
<li><a href="pengaturanujian.php">Manajemen Pengaturan Ujian</a></li>
<li><a href="editdatapribadi.php">Profil</a></li>
<li></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<li> </li>
<li>
<tr>
</tr>
</table>
</li>
<li class="style1" >
<div align="center"><?php echo $_SESSION['MM_Username'] ?></div>
</li>
<li class="style1" ></li>
<li class="style1" >
<div align="center">
<a href="<?php echo $logoutAction ?>"> <input name="submit" type="submit"
class="red" value="Logout" /></a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center"> SMK SAMUDERA BUANA LANGKAPLANCAR @2018
<a href="htpp://csstemplatesmarket.com" target="_blank"></a>
</div>
</div>
</div>
</body>
<script>
function cek() {
var cek = document.forms['form1']['kd_matpel'].value;
var cek1 = document.forms['form1']['tanggal_ujian'].value;
var cek2 = document.forms['form1']['waktu'].value;
var cek3 = document.forms['form1']['jumlah_soal'].value;
if(cek==null || cek=="")
{
alert("kode mata pelajaran tidak boleh kosong!!!");
return false;
}
if (cek1==null || cek1=="")
{
alert("tanggal ujian tidak boleh kosong!!!");
return false;
}
if (cek2==null || cek2=="")
{
alert("waktu ujian tidak boleh kosong!!!");
return false;
}
if (cek3==null || cek3=="")
{
alert("Jumlah soal tidak boleh kosong!!!");
return false;
}
}
</script>
<link rel="stylesheet" href="themes/base/jquery.ui.all.css">
<script src="js/jquery-1.7.2.js"></script>
<script src="ui/jquery.ui.core.js"></script>
<script src="ui/jquery.ui.widget.js"></script>
<script src="ui/jquery.ui.datepicker.js"></script>
<script>
$(function() {
$( "#datepicker" ).datepicker({
changeMonth: true,
changeYear: true
});
});
</script>
</html>
<?php
mysql_free_result($pengguna);
mysql_free_result($matpel);
mysql_free_result($pgujian);
?>
Coding editdatapribadi.php <?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?><?php
$maxRows_pengguna = 10;
$pageNum_pengguna = 0;
if (isset($_GET['pageNum_pengguna'])) {
$pageNum_pengguna = $_GET['pageNum_pengguna'];
}
$startRow_pengguna = $pageNum_pengguna * $maxRows_pengguna;
$colname_pengguna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengguna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengguna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengguna);
$query_limit_pengguna = sprintf("%s LIMIT %d, %d", $query_pengguna, $startRow_pengguna,
$maxRows_pengguna);
$pengguna = mysql_query($query_limit_pengguna, $kon) or die(mysql_error());
$row_pengguna = mysql_fetch_assoc($pengguna);
if (isset($_GET['totalRows_pengguna'])) {
$totalRows_pengguna = $_GET['totalRows_pengguna'];
} else {
$all_pengguna = mysql_query($query_pengguna);
$totalRows_pengguna = mysql_num_rows($all_pengguna);
}
$totalPages_pengguna = ceil($totalRows_pengguna/$maxRows_pengguna)-1;
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 14;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p align="center"><img src="images/header.jpg" width="969" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang Di halaman Guru </h2>
<div id="tab1" class="tabcontent">
<form id="form1" name="form1" method="post" enctype="multipart/form-data"
action="updatedataguru.php">
<div id="div" class="tabcontent">
<h3>Data Pribadi anda
<label>
<input type="hidden" name="id_admin" value="<?php echo
$row_pengguna['id_admin']; ?>" />
</label>
</h3>
<div class="form_row">
<label>Username </label>
<input type="text" class="form_input" name="a" value="<?php echo
$row_pengguna['username']; ?>"/>
</div>
<div class="form_row">
<label>Password</label>
<input type="password" class="form_input" name="b" value="<?php echo
$row_pengguna['password']; ?>"/>
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Nama Lengkap </label>
<input type="text" class="form_input" name="c" value="<?php echo
$row_pengguna['nama_admin']; ?>"/>
</div>
<div class="form_row">
<label>Jenis Kelamin </label>
<input type="text" class="form_input" name="d"value="<?php echo
$row_pengguna['jenis_kelamin']; ?>" />
</div>
<div class="form_row">
<label>alamat</label>
<input type="text" class="form_input" name="e" value="<?php echo
$row_pengguna['alamat']; ?>"/>
</div>
<div class="form_row">
<label>Telepon </label>
<input type="text" class="form_input" name="f" value="<?php echo
$row_pengguna['telepon']; ?>"/>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div class="form_row">
</div>
<p> </p>
<p> </p>
<div class="form_row">
<input name="submit3" type="submit" class="form_submit" value="Simpan" />
</div>
<p> </p>
</div>
</form>
<h3> </h3>
</div>
<div id="tab2" class="tabcontent">
<p> </p>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="datasoal.php">Manajemen Soal</a></li>
<li><a href="tambahsoal.php">Manajemen Tambah Soal</a></li>
<li><a href="pengaturanujian.php">Manajemen Pengaturan Ujian</a></li>
<li><a href="editdatapribadi.php">Profil</a></li>
</ul>
<h2>Anda masuk sebagai</h2>
<ul>
<li> </li>
<li>
<table border="1" align="center">
</table>
</li>
<li class="style1" >
<div align="center"><?php echo $_SESSION['MM_Username'] ?></div>
</li>
<li class="style1" ></li>
<li class="style1" >
<div align="center">
<a href="<?php echo $logoutAction ?>"> <input name="submit" type="submit"
class="red" value="Logout" /></a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018
<a href="htpp://csstemplatesmarket.com" target="_blank"></a>
</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($pengguna);
?>
Coding editpengaturan.php <?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?><?php
$maxRows_pengguna = 10;
$pageNum_pengguna = 0;
if (isset($_GET['pageNum_pengguna'])) {
$pageNum_pengguna = $_GET['pageNum_pengguna'];
}
$startRow_pengguna = $pageNum_pengguna * $maxRows_pengguna;
$colname_pengguna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengguna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengguna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengguna);
$query_limit_pengguna = sprintf("%s LIMIT %d, %d", $query_pengguna, $startRow_pengguna,
$maxRows_pengguna);
$pengguna = mysql_query($query_limit_pengguna, $kon) or die(mysql_error());
$row_pengguna = mysql_fetch_assoc($pengguna);
if (isset($_GET['totalRows_pengguna'])) {
$totalRows_pengguna = $_GET['totalRows_pengguna'];
} else {
$all_pengguna = mysql_query($query_pengguna);
$totalRows_pengguna = mysql_num_rows($all_pengguna);
}
$totalPages_pengguna = ceil($totalRows_pengguna/$maxRows_pengguna)-1;
mysql_select_db($database_kon, $kon);
$query_matpel = "SELECT * FROM mata_pelajaran";
$matpel = mysql_query($query_matpel, $kon) or die(mysql_error());
$row_matpel = mysql_fetch_assoc($matpel);
$totalRows_matpel = mysql_num_rows($matpel);
$maxRows_pgujian = 10;
$pageNum_pgujian = 0;
if (isset($_GET['pageNum_pgujian'])) {
$pageNum_pgujian = $_GET['pageNum_pgujian'];
}
$startRow_pgujian = $pageNum_pgujian * $maxRows_pgujian;
mysql_select_db($database_kon, $kon);
$id_pengaturan=$_GET['id_pengaturan'];
$query_pgujian = "SELECT *from pengaturan_ujian where id_pengaturan ='$id_pengaturan' ";
$query_limit_pgujian = sprintf("%s LIMIT %d, %d", $query_pgujian, $startRow_pgujian,
$maxRows_pgujian);
$pgujian = mysql_query($query_limit_pgujian, $kon) or die(mysql_error());
$row_pgujian = mysql_fetch_assoc($pgujian);
if (isset($_GET['totalRows_pgujian'])) {
$totalRows_pgujian = $_GET['totalRows_pgujian'];
} else {
$all_pgujian = mysql_query($query_pgujian);
$totalRows_pgujian = mysql_num_rows($all_pgujian);
}
$totalPages_pgujian = ceil($totalRows_pgujian/$maxRows_pgujian)-1;
?><!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 14;
font-weight: bold;
}
.style2 {font-size: 18px}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p align="center"><img src="images/header.jpg" width="969" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Pengaturan Ujian </h2>
<div id="tab1" class="tabcontent"><form id="form1" name="form1" method="post"
action="updatepengaturan.php">
<div class="form"><span class="header style2"><strong>Edit Pengaturan
Ujian</strong></span>
<div class="form_row">
<p>
<input type="hidden" class="form_input" name="id_pengaturan"
value="<?php echo $row_pgujian['id_pengaturan']?>" />
</p>
<label></label>
</div>
<div class="form_row">
<label>Tanggal ujian </label>
<input type="text" class="form_input" name="tanggal_ujian" id="datepicker"
value="<?php echo $row_pgujian['tanggal_ujian']?>" />
</div>
<div class="form_row">
<label>Waktu Ujian</label>
<input type="text" class="form_input" name="waktu_ujian" value="<?php echo
$row_pgujian['waktu_ujian']?>" />
</div>
<div class="form_row">
<label>Durasi Ujian</label>
<input type="text" class="form_input" name="waktu" value="<?php echo
$row_pgujian['waktu']?>" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Jumlah Soal </label>
<input type="text" class="form_input" name="jumlah_soal" value="<?php echo
$row_pgujian['jumlah_soal']?>" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<input name="submit2" type="submit" class="form_submit" value="Simpan" />
</div>
<p> </p>
</div>
</form>
<h3> </h3>
<p> </p>
<p> </p>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="datasoal.php">Manajemen Soal</a></li>
<li><a href="tambahsoal.php">Manajemen Tambah Soal</a></li>
<li><a href="pengaturanujian.php">Manajemen Pengaturan Ujian</a></li>
<li><a href="editdatapribadi.php">Profil</a></li>
<li></li>
</ul>
<h2>Anda masuk sebagai</h2>
<ul>
<li> </li>
<li>
<table border="1" align="center">
</table>
</li>
<li class="style1" >
<div align="center"><?php echo $_SESSION['MM_Username'] ?></div>
</li>
<li class="style1" ></li>
<li class="style1" >
<div align="center">
<a href="<?php echo $logoutAction ?>"> <input name="submit" type="submit"
class="red" value="Logout" /></a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018
<a href="htpp://csstemplatesmarket.com" target="_blank"></a>
</div>
</div>
</div>
</body>
<link rel="stylesheet" href="themes/base/jquery.ui.all.css">
<script src="js/jquery-1.7.2.js"></script>
<script src="ui/jquery.ui.core.js"></script>
<script src="ui/jquery.ui.widget.js"></script>
<script src="ui/jquery.ui.datepicker.js"></script>
<script>
$(function() {
$( "#datepicker" ).datepicker({
changeMonth: true,
changeYear: true
});
});
</script>
</html>
<?php
mysql_free_result($pengguna);
mysql_free_result($matpel);
mysql_free_result($pgujian);
?>
Coding editsoal.php <?php require_once('../Connections/kon.php'); ?>
<?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?><?php
$maxRows_pengguna = 10;
$pageNum_pengguna = 0;
if (isset($_GET['pageNum_pengguna'])) {
$pageNum_pengguna = $_GET['pageNum_pengguna'];
}
$startRow_pengguna = $pageNum_pengguna * $maxRows_pengguna;
$colname_pengguna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengguna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengguna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengguna);
$query_limit_pengguna = sprintf("%s LIMIT %d, %d", $query_pengguna, $startRow_pengguna,
$maxRows_pengguna);
$pengguna = mysql_query($query_limit_pengguna, $kon) or die(mysql_error());
$row_pengguna = mysql_fetch_assoc($pengguna);
if (isset($_GET['totalRows_pengguna'])) {
$totalRows_pengguna = $_GET['totalRows_pengguna'];
} else {
$all_pengguna = mysql_query($query_pengguna);
$totalRows_pengguna = mysql_num_rows($all_pengguna);
}
$totalPages_pengguna = ceil($totalRows_pengguna/$maxRows_pengguna)-1;
mysql_select_db($database_kon, $kon);
$query_matpel = "SELECT * FROM mata_pelajaran";
$matpel = mysql_query($query_matpel, $kon) or die(mysql_error());
$row_matpel = mysql_fetch_assoc($matpel);
$totalRows_matpel = mysql_num_rows($matpel);
mysql_select_db($database_kon, $kon);
$kd_soal=$_GET['kd_soal'];
$query_soal = "SELECT * FROM soal where kd_soal='$kd_soal'";
$soal = mysql_query($query_soal, $kon) or die(mysql_error());
$row_soal = mysql_fetch_assoc($soal);
$totalRows_soal = mysql_num_rows($soal);
?><!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>Ujian Akhir Semester berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 14;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p align="center"><img src="images/header.jpg" width="969" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang Di halaman Guru </h2>
<ul id="tabsmenu" class="tabsmenu">
<li class="active">
<script src="ckeditor/ckeditor.js"></script>
</li>
</ul>
<div id="tab1" class="tabcontent"><form id="form1" name="form1"
enctype="multipart/form-data" method="post" action="updatesoal.php">
<div class="form">
<div class="form_row">
<label>Mata Pelajaran </label>
<input type="text" class="form_input" name="pil_a2" disabled="disabled" value="<?php
echo $row_soal['kd_matpel']?>" />
</div>
<div class="form_row">
<label>Kode Soal </label>
<input type="hidden" class="form_input" name="kd_soal" value="<?php echo
$row_soal['kd_soal']?>" />
</div>
<div class="form_row">
<label>Soal Ujian</label>
<textarea id="editor1" class="form_textarea" name="soal" rows="5" cols="40" <?php
echo $row_soal['soal']?>></textarea>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div class="form_row">
<label>Soal Gambar </label>
<input type="file" class="form_input" name="soalgambar" value="<?php echo
$row_soal['soalgambar']?>" />
</div>
<p> </p>
<div class="form_row">
<label>Pilihan A </label>
<input type="text" class="form_input" name="pil_a" value="<?php echo
$row_soal['pil_a']?>" />
</div>
<p> </p>
<div class="form_row">
<label>Pilihan B </label>
<input type="text" class="form_input" name="pil_b" value="<?php echo
$row_soal['pil_b']?>" />
</div>
<p> </p>
<div class="form_row">
<label>Pilihan C </label>
<input type="text" class="form_input" name="pil_c" value="<?php echo
$row_soal['pil_c']?>" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Pilihan D </label>
<input type="text" class="form_input" name="pil_d" value="<?php echo
$row_soal['pil_d']?>" />
</div>
<p> </p>
<div class="form_row">
<label>Kunci Jawaban</label>
<select class="form_select" name="kunci" >
<option>-- Pilih Kunci Jawaban--</option>
<option>a</option>
<option>b</option>
<option>c</option>
<option>d</option>
</select>
</div>
<p> </p>
<div class="form_row">
<input name="submit2" type="submit" class="form_submit" value="Simpan" />
</div>
<p> </p>
<p> </p>
<p> </p>
</div>
</form>
<h3> </h3>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="datasoal.php">Manajemen Soal</a></li>
<li><a href="tambahsoal.php">Manajemen Tambah Soal</a></li>
<li><a href="pengaturanujian.php">Manajemen Pengaturan Ujian</a></li>
<li><a href="editdatapribadi.php">Manajemen Profil</a></li>
<li></li>
</ul>
<h2>Anda masuk sebagai</h2>
<ul>
<li> </li>
<li>
<table border="1" align="center">
</table>
</li>
<li class="style1" >
<div align="center"><?php echo $_SESSION['MM_Username'] ?></div>
</li>
<li class="style1" ></li>
<li class="style1" >
<div align="center">
<a href="<?php echo $logoutAction ?>"> <input name="submit" type="submit"
class="red" value="Logout" /></a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018
<a href="htpp://csstemplatesmarket.com" target="_blank"></a>
</div>
</div>
</div>
</body>
<script type="text/javascript">
if ( typeof CKEDITOR == 'undefined' )
{
document.write(
'CKEditor not found');
}
else
{
var editor = CKEDITOR.replace( 'editor1' );
CKFinder.setupCKEditor( editor, '' ) ;
}
</script>
</html>
<?php
mysql_free_result($pengguna);
mysql_free_result($matpel);
mysql_free_result($soal);
?>
Coding tambahsoal.php <?php require_once('../Connections/kon.php'); ?>
<?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../login.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../gagalguru.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?><?php
$maxRows_pengguna = 10;
$pageNum_pengguna = 0;
if (isset($_GET['pageNum_pengguna'])) {
$pageNum_pengguna = $_GET['pageNum_pengguna'];
}
$startRow_pengguna = $pageNum_pengguna * $maxRows_pengguna;
$colname_pengguna = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_pengguna = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_pengguna = sprintf("SELECT * FROM pengguna WHERE username = '%s'",
$colname_pengguna);
$query_limit_pengguna = sprintf("%s LIMIT %d, %d", $query_pengguna, $startRow_pengguna,
$maxRows_pengguna);
$pengguna = mysql_query($query_limit_pengguna, $kon) or die(mysql_error());
$row_pengguna = mysql_fetch_assoc($pengguna);
if (isset($_GET['totalRows_pengguna'])) {
$totalRows_pengguna = $_GET['totalRows_pengguna'];
} else {
$all_pengguna = mysql_query($query_pengguna);
$totalRows_pengguna = mysql_num_rows($all_pengguna);
}
$totalPages_pengguna = ceil($totalRows_pengguna/$maxRows_pengguna)-1;
mysql_select_db($database_kon, $kon);
$query_matpel = "SELECT * FROM mata_pelajaran";
$matpel = mysql_query($query_matpel, $kon) or die(mysql_error());
$row_matpel = mysql_fetch_assoc($matpel);
$totalRows_matpel = mysql_num_rows($matpel);
mysql_select_db($database_kon, $kon);
$kd_soal=$_GET['kd_soal'];
$query_soal = "SELECT * FROM soal where kd_soal='$kd_soal'";
$soal = mysql_query($query_soal, $kon) or die(mysql_error());
$row_soal = mysql_fetch_assoc($soal);
$totalRows_soal = mysql_num_rows($soal);
?><!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>Ujian Akhir Semester berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 14;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p align="center"><img src="images/header.jpg" width="969" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang Di halaman Guru </h2>
<ul id="tabsmenu" class="tabsmenu">
<li class="active">
<script src="ckeditor/ckeditor.js"></script>
</li>
</ul>
<div id="tab1" class="tabcontent"><form id="form1" name="form1"
enctype="multipart/form-data" method="post" action="updatesoal.php">
<div class="form">
<div class="form_row">
<label>Mata Pelajaran </label>
<input type="text" class="form_input" name="pil_a2" disabled="disabled" value="<?php
echo $row_soal['kd_matpel']?>" />
</div>
<div class="form_row">
<label>Kode Soal </label>
<input type="hidden" class="form_input" name="kd_soal" value="<?php echo
$row_soal['kd_soal']?>" />
</div>
<div class="form_row">
<label>Soal Ujian</label>
<textarea id="editor1" class="form_textarea" name="soal" rows="5" cols="40" <?php
echo $row_soal['soal']?>></textarea>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div class="form_row">
<label>Soal Gambar </label>
<input type="file" class="form_input" name="soalgambar" value="<?php echo
$row_soal['soalgambar']?>" />
</div>
<p> </p>
<div class="form_row">
<label>Pilihan A </label>
<input type="text" class="form_input" name="pil_a" value="<?php echo
$row_soal['pil_a']?>" />
</div>
<p> </p>
<div class="form_row">
<label>Pilihan B </label>
<input type="text" class="form_input" name="pil_b" value="<?php echo
$row_soal['pil_b']?>" />
</div>
<p> </p>
<div class="form_row">
<label>Pilihan C </label>
<input type="text" class="form_input" name="pil_c" value="<?php echo
$row_soal['pil_c']?>" />
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Pilihan D </label>
<input type="text" class="form_input" name="pil_d" value="<?php echo
$row_soal['pil_d']?>" />
</div>
<p> </p>
<div class="form_row">
<label>Kunci Jawaban</label>
<select class="form_select" name="kunci" >
<option>-- Pilih Kunci Jawaban--</option>
<option>a</option>
<option>b</option>
<option>c</option>
<option>d</option>
</select>
</div>
<p> </p>
<div class="form_row">
<input name="submit2" type="submit" class="form_submit" value="Simpan" />
</div>
<p> </p>
<p> </p>
<p> </p>
</div>
</form>
<h3> </h3>
</div>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="datasoal.php">Manajemen Soal</a></li>
<li><a href="tambahsoal.php">Manajemen Tambah Soal</a></li>
<li><a href="pengaturanujian.php">Manajemen Pengaturan Ujian</a></li>
<li><a href="editdatapribadi.php">Manajemen Profil</a></li>
<li></li>
</ul>
<h2>Anda masuk sebagai</h2>
<ul>
<li> </li>
<li>
<table border="1" align="center">
</table>
</li>
<li class="style1" >
<div align="center"><?php echo $_SESSION['MM_Username'] ?></div>
</li>
<li class="style1" ></li>
<li class="style1" >
<div align="center">
<a href="<?php echo $logoutAction ?>"> <input name="submit" type="submit"
class="red" value="Logout" /></a></div>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018
<a href="htpp://csstemplatesmarket.com" target="_blank"></a>
</div>
</div>
</div>
</body>
<script type="text/javascript">
if ( typeof CKEDITOR == 'undefined' )
{
document.write(
'CKEditor not found');
}
else
{
var editor = CKEDITOR.replace( 'editor1' );
CKFinder.setupCKEditor( editor, '' ) ;
}
</script>
</html>
<?php
mysql_free_result($pengguna);
mysql_free_result($matpel);
mysql_free_result($soal);
?>
Coding siswa.php <?php require_once('../Connections/kon.php'); ?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../ceklogin.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?><?php
$colname_siswa = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_siswa = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_siswa = sprintf("SELECT * FROM peserta WHERE ussername = '%s'",
$colname_siswa);
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_jadwal = 10;
$pageNum_jadwal = 0;
if (isset($_GET['pageNum_jadwal'])) {
$pageNum_jadwal = $_GET['pageNum_jadwal'];
}
$startRow_jadwal = $pageNum_jadwal * $maxRows_jadwal;
mysql_select_db($database_kon, $kon);
$query_jadwal = "SELECT mata_pelajaran.nama_matpel , pengaturan_ujian.tanggal_ujian
,pengaturan_ujian.waktu, pengaturan_ujian.waktu_ujian FROM uascbt.mata_pelajaran
INNER JOIN uascbt.pengaturan_ujian ON (mata_pelajaran.kd_matpel =
pengaturan_ujian.kd_matpel)";
$query_limit_jadwal = sprintf("%s LIMIT %d, %d", $query_jadwal, $startRow_jadwal,
$maxRows_jadwal);
$jadwal = mysql_query($query_limit_jadwal, $kon) or die(mysql_error());
$row_jadwal = mysql_fetch_assoc($jadwal);
if (isset($_GET['totalRows_jadwal'])) {
$totalRows_jadwal = $_GET['totalRows_jadwal'];
} else {
$all_jadwal = mysql_query($query_jadwal);
$totalRows_jadwal = mysql_num_rows($all_jadwal);
}
$totalPages_jadwal = ceil($totalRows_jadwal/$maxRows_jadwal)-1;
?>
<!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p> <img src="images/header.jpg" width="980" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang di halaman peserta ujian</h2>
<p align="center" class="style1">JADWAL UJIAN AKHIR SEMESTER SMK SAMUDERA
BUANA LANGKAPLANCAR </p>
<ul id="tabsmenu" class="tabsmenu">
<li class="active">
<table id="rounded-corner">
<thead>
<tr>
<th width="24%"><div align="left">Mata pelajaran </div></th>
<th width="24%"><div align="left">Tanggal</div></th>
<th width="21%"><div align="left">Jam Mulai </div></th>
<th width="31%"><div align="left">Lama Pengerjaan </div></th>
</tr>
</thead>
<tfoot>
<tr>
<td colspan="7"> </td>
</tr>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td><?php echo $row_jadwal['nama_matpel']; ?></td>
<td><?php echo $row_jadwal['tanggal_ujian']; ?></td>
<td><?php echo $row_jadwal['waktu_ujian']; ?></td>
<td><?php echo $row_jadwal['waktu']; ?> menit</td>
</tr>
<?php } while ($row_jadwal = mysql_fetch_assoc($jadwal)); ?>
</tbody>
</table>
</li>
</ul>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2><a href="siswa.php">Dashboard</a></h2>
<ul>
<li><a href="mulaiujian.php">Mulai Ujian</a></li>
<li><a href="datanilaisiswa.php?id=<?php echo $row_siswa['no_peserta']; ?>">Nilai
Ujian </a></li>
<li><a href="datapribadisiswa.php">Profil </a></li>
<li><a href="#"></a></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<div align="center"><strong><?php echo $row_siswa['nama']; ?></strong></div>
</li>
<li>
<form action="" method="post" name="form1" class="red" id="form1">
<label></label>
<a href="logout.php"><div align="center">Logout </div></a>
</form>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($siswa);
mysql_free_result($jadwal);
?>
Coding ujian.php <?php require_once('../Connections/kon.php'); ?>
<?php require_once('../Connections/kon.php');
error_reporting(0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../ceklogin.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$colname_siswa = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_siswa = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_siswa = sprintf("SELECT * FROM peserta WHERE ussername = '%s'",
$colname_siswa);
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_jadwal = 10;
$pageNum_jadwal = 0;
if (isset($_GET['pageNum_jadwal'])) {
$pageNum_jadwal = $_GET['pageNum_jadwal'];
}
$startRow_jadwal = $pageNum_jadwal * $maxRows_jadwal;
mysql_select_db($database_kon, $kon);
$query_jadwal = "SELECT mata_pelajaran.nama_matpel , pengaturan_ujian.tanggal_ujian ,
pengaturan_ujian.waktu_ujian FROM uascbt.mata_pelajaran INNER JOIN
uascbt.pengaturan_ujian ON (mata_pelajaran.kd_matpel = pengaturan_ujian.kd_matpel)";
$query_limit_jadwal = sprintf("%s LIMIT %d, %d", $query_jadwal, $startRow_jadwal,
$maxRows_jadwal);
$jadwal = mysql_query($query_limit_jadwal, $kon) or die(mysql_error());
$row_jadwal = mysql_fetch_assoc($jadwal);
if (isset($_GET['totalRows_jadwal'])) {
$totalRows_jadwal = $_GET['totalRows_jadwal'];
} else {
$all_jadwal = mysql_query($query_jadwal);
$totalRows_jadwal = mysql_num_rows($all_jadwal);
}
$totalPages_jadwal = ceil($totalRows_jadwal/$maxRows_jadwal)-1;
$maxRows_soal = 1;
$pageNum_soal = 0;
if (isset($_GET['pageNum_soal'])) {
$pageNum_soal = $_GET['pageNum_soal'];
}
$startRow_soal = $pageNum_soal * $maxRows_soal;
mysql_select_db($database_kon, $kon);
$query_soal = "SELECT *FROM soal ORDER BY RAND() ";
$query_limit_soal = sprintf("%s LIMIT %d, %d", $query_soal, $startRow_soal,
$maxRows_soal);
$soal = mysql_query($query_limit_soal, $kon) or die(mysql_error());
$row_soal = mysql_fetch_assoc($soal);
if (isset($_GET['totalRows_soal'])) {
$totalRows_soal = $_GET['totalRows_soal'];
} else {
$all_soal = mysql_query($query_soal);
$totalRows_soal = mysql_num_rows($all_soal);
}
$totalPages_soal = ceil($totalRows_soal/$maxRows_soal)-1;
mysql_select_db($database_kon, $kon);
$query_setting = "SELECT * FROM pengaturan_ujian";
$setting = mysql_query($query_setting, $kon) or die(mysql_error());
$row_setting = mysql_fetch_assoc($setting);
$totalRows_setting = mysql_num_rows($setting);
$queryString_soal = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_soal") == false &&
stristr($param, "totalRows_soal") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_soal = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_soal = sprintf("&totalRows_soal=%d%s", $totalRows_soal, $queryString_soal);
?>
<!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">
<?php
$server = "localhost"; //sesuaikan dengan nama server
$username = "root"; //sesuaikan dengan username server, username default adalah root
$password = "password"; //sesuaikan dengan password server, apabila tidak ada dikosongi
saja
$database = "uascbt"; //sesuaikan dengan nama database yang sudah dibuat
// Koneksi dan memilih database di server
mysql_connect($server,$username,$password) or die("Koneksi gagal");
mysql_select_db($database) or die("database tidak ada");
$kd=$_GET['kd'];
$sql = mysql_query("SELECT * FROM pengaturan_ujian where kd_matpel='$kd'");
/* Apabila data di database kosong, maka waktu awal di set 0 jam, 10 menit dan 0 detik */
if(mysql_num_rows($sql) == 0){
$jam = 0;
$menit = 10;
}else{
$data = mysql_fetch_array($sql);
if($data['waktu'] < 60){
/* Apabila waktu yang diiputkan kurang dari 60 menit, maka waktu dijadikan menit dan
0 jam */
$menit = $data['waktu'];
$jam = 0;
}else{
/* Apabila waktu yang diiputkan lebih dari 60 menit, maka waktu/60 dan sisa bagi
dijadikan menit serta hasil bagi dijadikan jam */
$menit = $data['waktu']%60;
$jam = substr(($data['waktu']/60),0,1); //substr berfungsi untuk mengambil string, 0
dimulai dari string ke-0 dan 1 jumlah string yang akan diambil
}
}
?>
<head>
<!-- Kita membutuhkan jquery, disini saya menggunakan langsung dari jquery.com, jquery ini
bisa didownload dan ditaruh dilocal -->
<script src="http://code.jquery.com/jquery-1.10.2.min.js" type="text/javascript"></script>
<!-- Script Timer -->
<script type="text/javascript">
$(document).ready(function() {
/** Membuat Waktu Mulai Hitung Mundur Dengan
* var detik = 0,
* var menit = 1,
* var jam = 1
*/
var detik = 0;
var menit = <?php echo $menit; ?>;
var jam = <?php echo $jam; ?>;
var hari = 2;
/**
* Membuat function hitung() sebagai Penghitungan Waktu
*/
function hitung() {
/** setTimout(hitung, 1000) digunakan untuk
* mengulang atau merefresh halaman selama 1000 (1 detik)
*/
setTimeout(hitung,1000);
/** Jika waktu kurang dari 10 menit maka Timer akan berubah menjadi warna merah
*/
if(menit < 10 && jam == 0){
var peringatan = 'style="color:red"';
};
/** Menampilkan Waktu Timer pada Tag #Timer di HTML yang tersedia */
$('#timer').html(
'<h1 align="center"'+peringatan+'>Sisa waktu anda <br />' + jam + ' jam : ' + menit
+ ' menit : ' + detik + ' detik</h1><hr>'
);
/** Melakukan Hitung Mundur dengan Mengurangi variabel detik - 1 */
detik --;
/** Jika var detik < 0
* var detik akan dikembalikan ke 59
* Menit akan Berkurang 1
*/
if(detik < 0) {
detik = 59;
menit --;
/** Jika menit < 0
* Maka menit akan dikembali ke 59
* Jam akan Berkurang 1
*/
if(menit < 0) {
menit = 59;
jam --;
/** Jika var jam < 0
* clearInterval() Memberhentikan Interval dan submit secara otomatis
*/
if(jam < 0) {
clearInterval();
/** Variable yang digunakan untuk submit secara otomatis di Form */
var frmSoal = document.getElementById("frmSoal");
alert('Waktu Anda telah habis segeralah menekan tombol simpan');
frmSoal.submit();
document.location='siswa.php'
}
}
}
}
/** Menjalankan Function Hitung Waktu Mundur */
hitung();
});
// ]]>
</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div id="panelwrap">
<div class="header"><img src="images/header.jpg" width="980" height="100" />
<div class="menu">
<p></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang di halaman peserta ujian</h2>
<form id="" name="frmsoal" method="post" enctype="multipart/form-data" action="">
<table border="0">
<?php
$no=0;?>
</table>
<table id="rounded-corner">
<tfoot>
</tfoot>
<tbody>
<tr class="odd">
<td>No peserta </td>
<td width="82%"><?php echo $row_siswa['no_peserta']; ?> </td>
</tr>
<?php
$sql=mysql_query("select * from ujian order by noujian DESC LIMIT 0,1");
$data=mysql_fetch_array($sql);
$kodeawal=substr($data['noujian'],3,4)+1;
if($kodeawal<10){
$kode='UJN000'.$kodeawal;
}elseif($kodeawal > 9 && $kodeawal <=99){
$kode='UJN00'.$kodeawal;
}else{
$kode='UJN00'.$kodeawal;
}
?>
<tr class="odd">
<td width="18%">No ujian </td>
<td><?PHP echo $kode;?>
</td>
</tr>
</tbody>
</table>
<p><?php include ("ujian3.php")?> </p>
<p>
<label></label>
<label></label>
<label></label>
</p>
</form>
<p> </p>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="#">Mulai Ujian</a></li>
<li><a href="#">Nilai Ujian </a></li>
<li><a href="#">Profil </a></li>
<div id='timer'></div>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<div align="center"><strong><?php echo $row_siswa['nama']; ?></strong></div>
</li>
<li>
<form action="" method="post" name="form1" class="red" id="form1">
<label></label>
<a href="logout.php"><div align="center">Logout </div></a>
</form>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($siswa);
mysql_free_result($jadwal);
mysql_free_result($soal);
mysql_free_result($setting);
?>
Coding datanilaisiswa.php <?php require_once('../Connections/kon.php');
error_reporting (0)
?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../ceklogin.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$colname_siswa = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_siswa = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_siswa = sprintf("SELECT * FROM peserta WHERE ussername = '%s'",
$colname_siswa);
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_jadwal = 10;
$pageNum_jadwal = 0;
if (isset($_GET['pageNum_jadwal'])) {
$pageNum_jadwal = $_GET['pageNum_jadwal'];
}
$startRow_jadwal = $pageNum_jadwal * $maxRows_jadwal;
mysql_select_db($database_kon, $kon);
$query_jadwal = "SELECT mata_pelajaran.nama_matpel , pengaturan_ujian.tanggal_ujian
,pengaturan_ujian.waktu, pengaturan_ujian.waktu_ujian FROM uascbt.mata_pelajaran
INNER JOIN uascbt.pengaturan_ujian ON (mata_pelajaran.kd_matpel =
pengaturan_ujian.kd_matpel)";
$query_limit_jadwal = sprintf("%s LIMIT %d, %d", $query_jadwal, $startRow_jadwal,
$maxRows_jadwal);
$jadwal = mysql_query($query_limit_jadwal, $kon) or die(mysql_error());
$row_jadwal = mysql_fetch_assoc($jadwal);
if (isset($_GET['totalRows_jadwal'])) {
$totalRows_jadwal = $_GET['totalRows_jadwal'];
} else {
$all_jadwal = mysql_query($query_jadwal);
$totalRows_jadwal = mysql_num_rows($all_jadwal);
}
$totalPages_jadwal = ceil($totalRows_jadwal/$maxRows_jadwal)-1;
mysql_select_db($database_kon, $kon);
$rata=$_GET['id'];
$query_rata = "SELECT AVG(skor) AS rata FROM uascbt.ujian where
no_peserta='$rata';";
$rata = mysql_query($query_rata, $kon) or die(mysql_error());
$row_rata = mysql_fetch_assoc($rata);
$totalRows_rata = mysql_num_rows($rata);
mysql_select_db($database_kon, $kon);
$isi=$_GET['id'];
$query_jumlah = "SELECT SUM(skor)AS jumlah FROM uascbt.ujian WHERE
no_peserta='$isi' ;";
$jumlah = mysql_query($query_jumlah, $kon) or die(mysql_error());
$row_jumlah = mysql_fetch_assoc($jumlah);
$totalRows_jumlah = mysql_num_rows($jumlah);
$maxRows_NILAI = 10;
$pageNum_NILAI = 0;
if (isset($_GET['pageNum_NILAI'])) {
$pageNum_NILAI = $_GET['pageNum_NILAI'];
}
$startRow_NILAI = $pageNum_NILAI * $maxRows_NILAI;
mysql_select_db($database_kon, $kon);
$id=$_GET['id'];
$query_NILAI = "SELECT mata_pelajaran.nama_matpel , ujian.* FROM uascbt.ujian
INNER JOIN uascbt.mata_pelajaran ON (ujian.kd_matpel= mata_pelajaran.kd_matpel)
where ujian.no_peserta='$id'";
$query_limit_NILAI = sprintf("%s LIMIT %d, %d", $query_NILAI, $startRow_NILAI,
$maxRows_NILAI);
$NILAI = mysql_query($query_limit_NILAI, $kon) or die(mysql_error());
$row_NILAI = mysql_fetch_assoc($NILAI);
if (isset($_GET['totalRows_NILAI'])) {
$totalRows_NILAI = $_GET['totalRows_NILAI'];
} else {
$all_NILAI = mysql_query($query_NILAI);
$totalRows_NILAI = mysql_num_rows($all_NILAI);
}
$totalPages_NILAI = ceil($totalRows_NILAI/$maxRows_NILAI)-1;
?>
<!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>Ujian Akhir Semester berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="980" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang di halaman peserta ujian </h2>
<p align="center" class="style1">REKAP NILAI UAS </p>
<ul id="tabsmenu" class="tabsmenu">
<li class="active">
<table width="61%" id="rounded-corner">
<thead>
<tr>
<th width="50%"><div align="left">Mata pelajaran </div></th>
<th width="50%"><div align="left">Nilai</div></th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td><?php echo $row_NILAI['nama_matpel']; ?></td>
<td><?php echo $row_NILAI['skor']; ?></td>
</tr>
<?php } while ($row_NILAI = mysql_fetch_assoc($NILAI)); ?>
<tr class="odd">
<td bgcolor="#8080FF" class="toogle_wrap">Jumlah nilai </td>
<td bgcolor="#8080FF" class="toogle_wrap"><?php echo $row_jumlah['jumlah'];
?></td>
</tr>
<tr class="odd">
<td bgcolor="#8080FF" class="toogle_wrap">Rata-rata</td>
<td bgcolor="#8080FF" class="toogle_wrap"><?php echo
number_format($row_rata['rata'],2); ?> </td>
</tr>
</tbody>
</table>
</li>
</ul>
<p> </p>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="mulaiujian.php">Mulai Ujian</a></li>
<li><a href="datanilaisiswa.php?id=<?php echo $row_siswa['no_peserta']; ?>">Nilai
Ujian </a></li>
<li><a href="datapribadisiswa.php">Profil</a></li>
<li><a href="#"></a></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<div align="center"><strong><?php echo $row_siswa['nama']; ?></strong></div>
</li>
<li>
<form action="" method="post" name="form1" class="red" id="form1">
<label></label>
<a href="logout.php"><div align="center">Logout </div></a>
</form>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018</div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($siswa);
mysql_free_result($jadwal);
mysql_free_result($rata);
mysql_free_result($jumlah);
mysql_free_result($NILAI);
?>
Coding datapribadisiswa.php <?php require_once('../Connections/kon.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../ceklogin.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$colname_siswa = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_siswa = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_siswa = sprintf("SELECT * FROM peserta WHERE ussername = '%s'",
$colname_siswa);
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_jadwal = 10;
$pageNum_jadwal = 0;
if (isset($_GET['pageNum_jadwal'])) {
$pageNum_jadwal = $_GET['pageNum_jadwal'];
}
$startRow_jadwal = $pageNum_jadwal * $maxRows_jadwal;
mysql_select_db($database_kon, $kon);
$query_jadwal = "SELECT mata_pelajaran.nama_matpel , pengaturan_ujian.tanggal_ujian
,pengaturan_ujian.waktu, pengaturan_ujian.waktu_ujian FROM uascbt.mata_pelajaran
INNER JOIN uascbt.pengaturan_ujian ON (mata_pelajaran.kd_matpel =
pengaturan_ujian.kd_matpel)";
$query_limit_jadwal = sprintf("%s LIMIT %d, %d", $query_jadwal, $startRow_jadwal,
$maxRows_jadwal);
$jadwal = mysql_query($query_limit_jadwal, $kon) or die(mysql_error());
$row_jadwal = mysql_fetch_assoc($jadwal);
if (isset($_GET['totalRows_jadwal'])) {
$totalRows_jadwal = $_GET['totalRows_jadwal'];
} else {
$all_jadwal = mysql_query($query_jadwal);
$totalRows_jadwal = mysql_num_rows($all_jadwal);
}
$totalPages_jadwal = ceil($totalRows_jadwal/$maxRows_jadwal)-1;
?>
<!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>Ujian Akhir Semester berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="980" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang di halaman peserta ujian</h2>
<ul id="tabsmenu" class="tabsmenu">
<li class="active">
<form id="form1" name="form1" method="post" action="editdatapribadisiswa.php">
<div id="tab1" class="tabcontent">
<h3>Data Pribadi anda </h3>
<div class="form_row">
<label>Username </label>
<input type="text" disabled="disabled" class="form_input" name="username"
value="<?php echo $row_siswa['ussername']; ?>"/>
</div>
<div class="form_row">
<label>Password</label>
<input type="password" disabled="disabled" class="form_input" name="password"
value="<?php echo $row_siswa['password']; ?>"/>
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Nama Lengkap </label>
<input type="text" disabled="disabled" class="form_input" name="nama"
value="<?php echo $row_siswa['nama']; ?>"/>
</div>
<div class="form_row">
<label>Jenis Kelamin </label>
<input type="text" disabled="disabled" class="form_input" name="jk"value="<?php
echo $row_siswa['jk']; ?>" />
</div>
<div class="form_row">
<label>Alamat</label>
<input type="text" disabled="disabled" class="form_input" name="alamat"
value="<?php echo $row_siswa['alamat']; ?>"/>
</div>
<div class="form_row">
<label>Tanggal Lahir </label>
<input type="text" disabled="disabled" class="form_input" name="tgl" value="<?php
echo $row_siswa['tgl_lahir']; ?>"/>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div class="form_row">
</div>
<p> </p>
<div class="form_row">
<input name="submit3" type="submit" class="form_submit" value="Edit" />
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</div>
</form>
</li>
</ul>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="mulaiujian.php">Mulai Ujian</a></li>
<li><a href="datanilaisiswa.php">Nilai Ujian </a></li>
<li><a href="datapribadisiswa.php">Profil </a></li>
<li><a href="#"></a></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<div align="center"><strong><?php echo $row_siswa['nama']; ?></strong></div>
</li>
<li>
<form action="" method="post" name="form1" class="red" id="form1">
<label></label>
<a href="logout.php"><div align="center">Logout </div></a>
</form>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($siswa);
mysql_free_result($jadwal);
?>
Coding editdatapribadi.siswa <?php require_once('../Connections/kon.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../ceklogin.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$colname_siswa = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_siswa = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_siswa = sprintf("SELECT * FROM peserta WHERE ussername = '%s'",
$colname_siswa);
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_jadwal = 10;
$pageNum_jadwal = 0;
if (isset($_GET['pageNum_jadwal'])) {
$pageNum_jadwal = $_GET['pageNum_jadwal'];
}
$startRow_jadwal = $pageNum_jadwal * $maxRows_jadwal;
mysql_select_db($database_kon, $kon);
$query_jadwal = "SELECT mata_pelajaran.nama_matpel , pengaturan_ujian.tanggal_ujian
,pengaturan_ujian.waktu, pengaturan_ujian.waktu_ujian FROM uascbt.mata_pelajaran
INNER JOIN uascbt.pengaturan_ujian ON (mata_pelajaran.kd_matpel =
pengaturan_ujian.kd_matpel)";
$query_limit_jadwal = sprintf("%s LIMIT %d, %d", $query_jadwal, $startRow_jadwal,
$maxRows_jadwal);
$jadwal = mysql_query($query_limit_jadwal, $kon) or die(mysql_error());
$row_jadwal = mysql_fetch_assoc($jadwal);
if (isset($_GET['totalRows_jadwal'])) {
$totalRows_jadwal = $_GET['totalRows_jadwal'];
} else {
$all_jadwal = mysql_query($query_jadwal);
$totalRows_jadwal = mysql_num_rows($all_jadwal);
}
$totalPages_jadwal = ceil($totalRows_jadwal/$maxRows_jadwal)-1;
?>
<!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>Ujian Akhir Semester berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="980" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat Datang Di Halaman siswa </h2>
<ul id="tabsmenu" class="tabsmenu">
<li class="active">
<form id="form1" name="form1" method="post" enctype="multipart/form-data"
action="updatedata.php">
<div id="tab1" class="tabcontent">
<h3>Profil Anda
<label>
<input type="hidden" name="id" value="<?php echo $row_siswa['no_peserta']; ?>" />
</label>
</h3>
<div class="form_row">
<label>Username </label>
<input type="text" class="form_input" name="username" value="<?php echo
$row_siswa['ussername']; ?>"/>
</div>
<div class="form_row">
<label>Password</label>
<input type="password" class="form_input" name="password" value="<?php echo
$row_siswa['password']; ?>"/>
</div>
<p> </p>
<p> </p>
<div class="form_row">
<label>Nama Lengkap </label>
<input type="text" class="form_input" name="nama" value="<?php echo
$row_siswa['nama']; ?>"/>
</div>
<div class="form_row">
<label>Jenis Kelamin </label>
<input type="text" class="form_input" name="jk"value="<?php echo
$row_siswa['jk']; ?>" />
</div>
<div class="form_row">
<label>Alamat</label>
<input type="text" class="form_input" name="alamat" value="<?php echo
$row_siswa['alamat']; ?>"/>
</div>
<div class="form_row">
<label>Tanggal Lahir </label>
<input type="text" class="form_input" name="tgl" value="<?php echo
$row_siswa['tgl_lahir']; ?>"/>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div class="form_row">
</div>
<p> </p>
<div class="form_row">
<input name="submit3" type="submit" class="form_submit" value="Simpan" />
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</div>
</form>
</li>
</ul>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="mulaiujian.php">Mulai Ujian</a></li>
<li><a href="datanilaisiswa.php">Nilai Ujian </a></li>
<li><a href="datapribadisiswa.php">Profil</a></li>
<li><a href="#"></a></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<div align="center"><strong><?php echo $row_siswa['nama']; ?></strong></div>
</li>
<li>
<form action="" method="post" name="form1" class="red" id="form1">
<label></label>
<a href="logout.php"><div align="center">Logout </div></a>
</form>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($siswa);
mysql_free_result($jadwal);
?>
Coding mulaiujian.php <?php require_once('../Connections/kon.php'); ?>
<?php require_once('../Connections/kon.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their
username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID
established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../ceklogin.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers,
$_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" .
urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
$colname_siswa = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_siswa = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_siswa = sprintf("SELECT * FROM peserta WHERE ussername = '%s'",
$colname_siswa);
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_jadwal = 10;
$pageNum_jadwal = 0;
if (isset($_GET['pageNum_jadwal'])) {
$pageNum_jadwal = $_GET['pageNum_jadwal'];
}
$startRow_jadwal = $pageNum_jadwal * $maxRows_jadwal;
mysql_select_db($database_kon, $kon);
$query_jadwal = "SELECT mata_pelajaran.nama_matpel , pengaturan_ujian.tanggal_ujian
,pengaturan_ujian.waktu, pengaturan_ujian.waktu_ujian FROM uascbt.mata_pelajaran
INNER JOIN uascbt.pengaturan_ujian ON (mata_pelajaran.kd_matpel =
pengaturan_ujian.kd_matpel)";
$query_limit_jadwal = sprintf("%s LIMIT %d, %d", $query_jadwal, $startRow_jadwal,
$maxRows_jadwal);
$jadwal = mysql_query($query_limit_jadwal, $kon) or die(mysql_error());
$row_jadwal = mysql_fetch_assoc($jadwal);
if (isset($_GET['totalRows_jadwal'])) {
$totalRows_jadwal = $_GET['totalRows_jadwal'];
} else {
$all_jadwal = mysql_query($query_jadwal);
$totalRows_jadwal = mysql_num_rows($all_jadwal);
}
$totalPages_jadwal = ceil($totalRows_jadwal/$maxRows_jadwal)-1;
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_kon, $kon);
$query_Recordset1 = "SELECT * FROM mata_pelajaran where status='aktif'";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1,
$startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $kon) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
mysql_select_db($database_kon, $kon);
$query_Recordset2 = "SELECT * FROM mata_pelajaran";
$Recordset2 = mysql_query($query_Recordset2, $kon) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
<!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>Ujian Akhir Semester Berbasis CBT</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
<style type="text/css">
<!--
.style2 {font-size: 16px}
-->
</style>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="980" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Selamat datang di halaman peserta ujian</h2>
<p> </p>
<form id="form3" name="form3" method="post" action="ujian.php">
<table width="61%" id="rounded-corner">
<thead>
<tr>
<th width="50%"><div align="center">Mata pelajaran </div></th>
<th width="50%"><div align="center">Status</div></th>
</tr>
</thead>
<tfoot>
</tfoot>
<tbody>
<?php do { ?>
<tr class="odd">
<td height="40"><?php echo $row_Recordset1['nama_matpel']; ?> </td>
<td><div align="center" id="openbt"><a href="ujian.php?kd=<?php echo
$row_Recordset1['kd_matpel']; ?>" class="green"><?php echo $row_Recordset1['status'];
?></a></div></td>
</tr>
</tbody>
<?php } while ($row_Recordset1 =
mysql_fetch_assoc($Recordset1)); ?>
</table>
</form>
<p> </p>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Dashboard</h2>
<ul>
<li><a href="mulaiujian.php">Mulai Ujian</a></li>
<li><a href="datanilaisiswa.php?id=<?php echo $row_siswa['no_peserta']; ?>">Nilai
Ujian</a></li>
<li><a href="datapribadisiswa.php">Profil </a></li>
<li><a href="#"></a></li>
</ul>
<h2>Anda Masuk Sebagai</h2>
<ul>
<div align="center"><strong><?php echo $row_siswa['nama']; ?></strong></div>
</li>
<li>
<form action="" method="post" name="form1" class="red" id="form1">
<label></label>
<a href="logout.php"><div align="center">Logout </div></a>
</form>
</li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($siswa);
mysql_free_result($jadwal);
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>
Coding rekapujian.php <?php require_once('../Connections/kon.php'); ?>
<?php require_once('../Connections/kon.php'); ?><?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../cobaloginsiswa.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$colname_siswa = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_siswa = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] :
addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kon, $kon);
$query_siswa = sprintf("SELECT * FROM peserta WHERE ussername = '%s'",
$colname_siswa);
$siswa = mysql_query($query_siswa, $kon) or die(mysql_error());
$row_siswa = mysql_fetch_assoc($siswa);
$totalRows_siswa = mysql_num_rows($siswa);
$maxRows_jadwal = 10;
$pageNum_jadwal = 0;
if (isset($_GET['pageNum_jadwal'])) {
$pageNum_jadwal = $_GET['pageNum_jadwal'];
}
$startRow_jadwal = $pageNum_jadwal * $maxRows_jadwal;
mysql_select_db($database_kon, $kon);
$query_jadwal = "SELECT mata_pelajaran.nama_matpel , pengaturan_ujian.tanggal_ujian ,
pengaturan_ujian.waktu_ujian FROM latihanujianonline.mata_pelajaran INNER JOIN
latihanujianonline.pengaturan_ujian ON (mata_pelajaran.kd_matpel =
pengaturan_ujian.kd_matpel)";
$query_limit_jadwal = sprintf("%s LIMIT %d, %d", $query_jadwal, $startRow_jadwal,
$maxRows_jadwal);
$jadwal = mysql_query($query_limit_jadwal, $kon) or die(mysql_error());
$row_jadwal = mysql_fetch_assoc($jadwal);
if (isset($_GET['totalRows_jadwal'])) {
$totalRows_jadwal = $_GET['totalRows_jadwal'];
} else {
$all_jadwal = mysql_query($query_jadwal);
$totalRows_jadwal = mysql_num_rows($all_jadwal);
}
$totalPages_jadwal = ceil($totalRows_jadwal/$maxRows_jadwal)-1;
$maxRows_soal = 1;
$pageNum_soal = 0;
if (isset($_GET['pageNum_soal'])) {
$pageNum_soal = $_GET['pageNum_soal'];
}
$startRow_soal = $pageNum_soal * $maxRows_soal;
mysql_select_db($database_kon, $kon);
$query_soal = "SELECT *FROM soal ORDER BY RAND() ";
$query_limit_soal = sprintf("%s LIMIT %d, %d", $query_soal, $startRow_soal,
$maxRows_soal);
$soal = mysql_query($query_limit_soal, $kon) or die(mysql_error());
$row_soal = mysql_fetch_assoc($soal);
if (isset($_GET['totalRows_soal'])) {
$totalRows_soal = $_GET['totalRows_soal'];
} else {
$all_soal = mysql_query($query_soal);
$totalRows_soal = mysql_num_rows($all_soal);
}
$totalPages_soal = ceil($totalRows_soal/$maxRows_soal)-1;
mysql_select_db($database_kon, $kon);
$query_setting = "SELECT detail_ujian.no , soal.soal , detail_ujian.jawab FROM
latihanujianonline.soal INNER JOIN latihanujianonline.detail_ujian ON (soal.kd_soal =
detail_ujian.kd_soal);";
$setting = mysql_query($query_setting, $kon) or die(mysql_error());
$row_setting = mysql_fetch_assoc($setting);
$totalRows_setting = mysql_num_rows($setting);
$maxRows_detailujian1 = 10;
$pageNum_detailujian1 = 0;
if (isset($_GET['pageNum_detailujian1'])) {
$pageNum_detailujian1 = $_GET['pageNum_detailujian1'];
}
$startRow_detailujian1 = $pageNum_detailujian1 * $maxRows_detailujian1;
mysql_select_db($database_kon, $kon);
$noujian=$_REQUEST['noujian'];
$query_detailujian1 = "SELECT detail_ujian.no ,detail_ujian.noujian , soal.soal ,
detail_ujian.jawab FROM latihanujianonline.soal INNER JOIN latihanujianonline.detail_ujian
ON (soal.kd_soal = detail_ujian.kd_soal) ";
$query_limit_detailujian1 = sprintf("%s LIMIT %d, %d", $query_detailujian1,
$startRow_detailujian1, $maxRows_detailujian1);
$detailujian1 = mysql_query($query_limit_detailujian1, $kon) or die(mysql_error());
$row_detailujian1 = mysql_fetch_assoc($detailujian1);
if (isset($_GET['totalRows_detailujian1'])) {
$totalRows_detailujian1 = $_GET['totalRows_detailujian1'];
} else {
$all_detailujian1 = mysql_query($query_detailujian1);
$totalRows_detailujian1 = mysql_num_rows($all_detailujian1);
}
$totalPages_detailujian1 = ceil($totalRows_detailujian1/$maxRows_detailujian1)-1;
$maxRows_detail = 10;
$pageNum_detail = 0;
if (isset($_GET['pageNum_detail'])) {
$pageNum_detail = $_GET['pageNum_detail'];
}
$startRow_detail = $pageNum_detail * $maxRows_detail;
mysql_select_db($database_kon, $kon);
$noujian=$_GET['noujian'];
$query_detail = "SELECT * FROM detail_ujian where noujian='$noujian'";
$query_limit_detail = sprintf("%s LIMIT %d, %d", $query_detail, $startRow_detail,
$maxRows_detail);
$detail = mysql_query($query_limit_detail, $kon) or die(mysql_error());
$row_detail = mysql_fetch_assoc($detail);
if (isset($_GET['totalRows_detail'])) {
$totalRows_detail = $_GET['totalRows_detail'];
} else {
$all_detail = mysql_query($query_detail);
$totalRows_detail = mysql_num_rows($all_detail);
}
$totalPages_detail = ceil($totalRows_detail/$maxRows_detail)-1;
mysql_select_db($database_kon, $kon);
$noujian=$_GET['noujian'];
$query_detaillujian = "SELECT * FROM detail_ujian where noujian='$noujian'";
$detaillujian = mysql_query($query_detaillujian, $kon) or die(mysql_error());
$row_detaillujian = mysql_fetch_assoc($detaillujian);
$totalRows_detaillujian = mysql_num_rows($detaillujian);
$queryString_soal = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_soal") == false &&
stristr($param, "totalRows_soal") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_soal = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_soal = sprintf("&totalRows_soal=%d%s", $totalRows_soal, $queryString_soal);
?>
<!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>Panelo - Free Admin Template</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<link href='http://fonts.googleapis.com/css?family=Belgrano' rel='stylesheet' type='text/css'>
<!-- jQuery file -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery.tabify.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
var $ = jQuery.noConflict();
$(function() {
$('#tabsmenu').tabify();
$(".toggle_container").hide();
$(".trigger").click(function(){
$(this).toggleClass("active").next().slideToggle("slow");
return false;
});
});
</script>
</head>
<body>
<div id="panelwrap">
<div class="header">
<div class="menu">
<p><img src="images/header.jpg" width="980" height="100" /></p>
<ul>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<div class="center_content">
<div id="right_wrap">
<div id="right_content">
<h2>Halaman siswa</h2>
<form id="form2" name="form2" method="post" enctype="multipart/form-data" action="">
<table border="0">
<?php
$no=0;?>
</table>
<table id="rounded-corner">
<tfoot>
</tfoot>
<tbody>
<tr class="odd">
<td>No peserta </td>
<td width="82%"><?php echo $row_siswa['no_peserta']; ?> </td>
</tr>
<?php
$sql=mysql_query("select * from ujian order by noujian DESC LIMIT 0,1");
$data=mysql_fetch_array($sql);
$kodeawal=substr($data['noujian'],3,4)+1;
if($kodeawal<10){
$kode='UJN000'.$kodeawal;
}elseif($kodeawal > 9 && $kodeawal <=99){
$kode='UJN00'.$kodeawal;
}else{
$kode='UJN00'.$kodeawal;
}
?>
<tr class="odd">
<td width="18%">No ujian </td>
<td><?PHP echo $kode;?>
<label></label></td>
</tr>
</tbody>
</table>
<table width="87%" id="rounded-corner">
<thead>
<tr>
<th width="4%"></th>
<th width="14%">no</th>
<th width="39%">soal</th>
<th width="30%">jawaban</th>
<th width="13%">status</th>
</tr>
</thead>
<tfoot>
<tr>
<td colspan="10"><p> </p>
<table border="0" width="30%" align="right">
<tr>
<td width="14%" align="center"><?php if ($pageNum_INDONESIA > 0) { //
Show if not first page ?>
<a href="<?php printf("%s?pageNum_INDONESIA=%d%s", $currentPage, 0,
$queryString_INDONESIA); ?>">First</a>
<?php } // Show if not first page ?> </td>
<td width="18%" align="center"><?php if ($pageNum_INDONESIA > 0) { //
Show if not first page ?>
<a href="<?php printf("%s?pageNum_INDONESIA=%d%s", $currentPage,
max(0, $pageNum_INDONESIA - 1), $queryString_INDONESIA); ?>">Previous</a>
<?php } // Show if not first page ?> </td>
<td width="14%" align="center"><?php if ($pageNum_INDONESIA <
$totalPages_INDONESIA) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_INDONESIA=%d%s", $currentPage,
min($totalPages_INDONESIA, $pageNum_INDONESIA + 1), $queryString_INDONESIA);
?>">Next</a>
<?php } // Show if not last page ?> </td>
<td width="54%" align="center"><?php if ($pageNum_INDONESIA <
$totalPages_INDONESIA) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_INDONESIA=%d%s", $currentPage,
$totalPages_INDONESIA, $queryString_INDONESIA); ?>"> Last</a>
<?php } // Show if not last page ?> </td>
</tr>
</table>
<a href="pdfindonesia.php" class="button green">cetak </a>
</p></td>
</tr>
</tfoot>
<?php do { ?>
<tbody>
<tr class="odd">
<td height="41"> </td>
<td><?php echo $row_detailujian1['no']; ?></td>
<td><?php echo $row_detailujian1['soal']; ?></td>
<td><div align="center"><?php echo $row_detailujian1['jawab']; ?></div></td>
<td>benar</td>
</tr>
<?php } while ($row_detailujian1 = mysql_fetch_assoc($detailujian1)); ?>
</tbody>
</table>
<p> </p>
<p>
<label></label>
<label></label>
<label></label>
</p>
</form>
<p> </p>
<p> </p>
</div>
</div><!-- end of right content-->
<div class="sidebar" id="sidebar">
<h2>Browse categories</h2>
<ul>
<li>
<div align="center"><img src="../images/<?php echo $row_siswa['foto']; ?>"
width="101" height="115" /></div>
</li>
<li>
<div align="center"><strong><?php echo $row_siswa['nama']; ?></strong></div>
</li>
<li>
<form action="" method="post" name="form1" class="red" id="form1">
<label></label>
<div align="center"><a href="<?php echo $logoutAction ?>" class="red">Log
out</a> </div>
</form>
</li>
</ul>
<h2>Menu</h2>
<ul>
<li><a href="#">Ujian</a></li>
<li><a href="#">Data Nilai </a></li>
<li><a href="#">Edit Data Pribadi </a></li>
</ul>
</div>
<div class="clear"></div>
</div> <!--end of center_content-->
<div class="footer">
<div align="center">SMK SAMUDERA BUANA LANGKAPLANCAR @2018 </div>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($siswa);
mysql_free_result($jadwal);
mysql_free_result($soal);
mysql_free_result($setting);
mysql_free_result($detailujian1);
mysql_free_result($detail);
mysql_free_result($detaillujian);
?>
Coding logout.php
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?php
session_start();
if(session_destroy()) // Menghapus Sessions
{
echo "<script> document.location='../index.php' </script> ";
}S
?>
</body>
</html>