<?php if (!isset($_GET['act'])) { ?> <div class="col-lg-12"> <h1 class="page-header">Data Sanksi <?php echo tbl_tambah('Input Sanksi', '?hal=sanksi&act=ubah'); ?> </h1> </div> <table class="table table-hover table-bordered" id="tbl"> <thead> <tr> <th class="col-lg-1 text-center">No</th> <th>Jenis Sanksi</th> <th class="col-lg-2 text-center">Poin</th> <th class="col-lg-2 text-center">Status</th> <th class="col-lg-1 text-center">#</th> </tr> </thead> <tbody> <?php $i = 1; $db = new Database(); $db->connect(); $db->select('sanksi', '*', null, null, 'minimal asc'); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions $res = $db->getResult(); foreach ($res as $d) { ?> <tr>
<?php if (!isset($_GET['act'])) { ?> <div class="col-lg-12"> <h1 class="page-header">Data Tata Tertib <?php echo tbl_tambah('Input Tata Tertib', '?hal=tatatertib&act=ubah'); ?> </h1> </div> <table class="table table-hover table-bordered" id="tbl"> <thead> <tr> <th class="col-lg-1 text-center">Poin</th> <th class="col-lg-1 text-center">Kode</th> <th>Nama Tata Tertib</th> <th class="col-lg-2 text-center">Jenis</th> <th class="col-lg-2 text-center">Status</th> <th class="col-lg-1 text-center">#</th> </tr> </thead> <tbody> <?php $i = 1; $db = new Database(); $db->connect(); $db->select('tata_tertib', '*', null, null, "poin asc"); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions $res = $db->getResult(); foreach ($res as $d) { ?>
<?php if (!isset($_GET['act'])) { ?> <div class="col-lg-12"> <h1 class="page-header">Siswa <?php echo tbl_tambah('Input Data Siswa', '?hal=siswa&act=ubah'); ?> </h1> </div> <table class="table table-hover table-bordered" id="tbl"> <thead> <tr> <th class="col-lg-1 text-center">No</th> <th class="col-lg-2 text-center">NIS</th> <th>Nama Siswa</th> <th class="col-lg-3 text-center">Jurusan</th> <th class="col-lg-2 text-center">Kelas</th> <th class="col-lg-1 text-center">#</th> </tr> </thead> <tbody> <?php $i = 1; $db = new Database(); $db->connect(); $db->select('siswa'); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions $res = $db->getResult(); foreach ($res as $d) { ?>
<?php if (!isset($_GET['act'])) { ?> <div class="col-lg-12"> <h1 class="page-header">Data Kelas <?php echo tbl_tambah('Input Kelas', '?hal=kelas&act=ubah'); ?> </h1> </div> <table class="table table-hover table-bordered" id="tbl"> <thead> <tr> <th class="col-lg-1 text-center">No</th> <th class="col-lg-2 text-center">Nama Kelas</th> <th>Wali Kelas</th> <th class="col-lg-2 text-center">Status</th> <th class="col-lg-1 text-center">#</th> </tr> </thead> <tbody> <?php $i = 1; $db = new Database(); $db->connect(); $db->select('kelas'); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions $res = $db->getResult(); foreach ($res as $d) { ?> <tr>
<?php if (!isset($_GET['act'])) { ?> <div class="col-lg-12"> <h1 class="page-header">Master Data Pengguna <?php echo tbl_tambah('Input Data Pengguna', '?hal=pengguna&act=ubah'); ?> </h1> </div> <table class="table table-hover table-bordered" id="tbl"> <thead> <tr> <th class="col-lg-1 text-center">No</th> <th class="col-lg-2 text-center">Username</th> <th>Nama Guru</th> <th class="col-lg-3 text-center">Jurusan</th> <th class="col-lg-2 text-center">Level</th> <th class="col-lg-1 text-center">#</th> </tr> </thead> <tbody> <?php $i = 1; $db = new Database(); $db->connect(); $db->select('users', '*', null, null, 'id asc'); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions $res = $db->getResult(); foreach ($res as $d) { ?>
<?php if (!isset($_GET['act'])) { ?> <div class="col-lg-12"> <h1 class="page-header">Data Jurusan <?php echo tbl_tambah('Input Jurusan', '?hal=jurusan&act=ubah'); ?> </h1> </div> <table class="table table-hover table-bordered" id="tbl"> <thead> <tr> <th class="col-lg-1 text-center">No</th> <th class="col-lg-1 text-center">Kode</th> <th>Nama Jurusan</th> <th class="col-lg-2 text-center">Jumlah Siswa</th> <th class="col-lg-2 text-center">Status</th> <th class="col-lg-1 text-center">#</th> </tr> </thead> <tbody> <?php $i = 1; $db = new Database(); $db->connect(); $db->select('jurusan'); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions $res = $db->getResult(); foreach ($res as $d) { ?>
<?php if (!isset($_GET['act'])) { ?> <div class="col-lg-12"> <h1 class="page-header">Data Tahun Pelajaran <?php echo tbl_tambah('Input Tapel', '?hal=tapel&act=ubah'); ?> </h1> </div> <table class="table table-hover table-bordered" id="tbl"> <thead> <tr> <th class="col-lg-1 text-center">No</th> <th>Tahun Pelajaran</th> <th class="col-lg-2 text-center">Status</th> <th class="col-lg-1 text-center">#</th> </tr> </thead> <tbody> <?php $i = 1; $db = new Database(); $db->connect(); $db->select('tapel'); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions $res = $db->getResult(); foreach ($res as $d) { ?> <tr> <td class="text-center"><?php
<?php if (!isset($_GET['act'])) { ?> <div class="col-lg-12"> <h1 class="page-header">Data Pelanggaran <?php echo tbl_tambah('Input Pelanggaran', '?hal=pelanggaran&act=ubah'); ?> </h1> </div> <table class="table table-hover table-bordered" id="tbl"> <thead> <tr> <th class="col-lg-1 text-center">No</th> <th>Nama Siswa</th> <th class="col-lg-2 text-center">Jumlah Pelanggaran</th> <th class="col-lg-1 text-center">Poin</th> <th class="col-lg-2 text-center">Waktu</th> <!--<th class="col-lg-1 text-center">#</th>--> </tr> </thead> <tbody> <?php $i = 1; $db = new Database(); $db->connect(); //$db->select('pelanggaran','*',null,null,'tanggal desc'); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions $db->sql("select * from pelanggaran group by idsiswa order by tanggal desc"); $res = $db->getResult(); foreach ($res as $d) { ?>