free-siakad-sekolah-php/lap_guru.php at master · suendri/free-siakad-sekolah-php · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<?php
/*
 * Sistem Informasi Sekolah
 * Perbaikan Ulang pada v2.0
 *
 * Program ini adalah program Donasi http://phpbego.wordpress.com
 * Anda hanya saya minta sedikit donasi untuk program ini, tidak lebih.
 * Jika anda menghargai program saya, silakan anda hubungi saya
 *
 * SMS : 085263616901
 * Email : phpbego@yahoo.co.id, phpbego@gmail.com
 *
*/

$maxRows_rec_tampil_guru = 10;
$pageNum_rec_tampil_guru = 0;
if (isset($_GET['pageNum_rec_tampil_guru'])) {
  $pageNum_rec_tampil_guru = $_GET['pageNum_rec_tampil_guru'];
}
$startRow_rec_tampil_guru = $pageNum_rec_tampil_guru * $maxRows_rec_tampil_guru;

mysql_select_db($database_koneksi, $koneksi);
$query_rec_tampil_guru = "SELECT * FROM guru ORDER BY u_nama ASC";
$query_limit_rec_tampil_guru = sprintf("%s LIMIT %d, %d", $query_rec_tampil_guru, $startRow_rec_tampil_guru, $maxRows_rec_tampil_guru);
$rec_tampil_guru = mysql_query($query_limit_rec_tampil_guru, $koneksi) or die(mysql_error());
$row_rec_tampil_guru = mysql_fetch_assoc($rec_tampil_guru);

if (isset($_GET['totalRows_rec_tampil_guru'])) {
  $totalRows_rec_tampil_guru = $_GET['totalRows_rec_tampil_guru'];
} else {
  $all_rec_tampil_guru = mysql_query($query_rec_tampil_guru);
  $totalRows_rec_tampil_guru = mysql_num_rows($all_rec_tampil_guru);
}
$totalPages_rec_tampil_guru = ceil($totalRows_rec_tampil_guru/$maxRows_rec_tampil_guru)-1;
?>

<div class="judul">
<h3><span class="glyphicon glyphicon-list-alt"></span> Daftar Guru</h3>
</div>
<p><img src="Asset/images/print-icon.png" /> <a href="print.php?print=print_guru.php" target="_blank">Print Laporan</a></p>
<table class="table table-bordered">
  <tr>
    <th>#</th>
    <th>NIP</th>
    <th>Nama</th>
    <th>Tempat Lahir</th>
    <th>Tgl Lahir</th>
    <th>Jenis Kelamin</th>
    <th>Alamat</th>
    <th>Agama</th>
    <th>Status</th>
    <th>Nonaktif</th>
  </tr>
  <?php $no=0; do { $no++;?>
    <tr>
      <td><?php echo $no; ?></td>
      <td><?php echo $row_rec_tampil_guru['g_nip']; ?></td>
      <td><?php echo $row_rec_tampil_guru['u_nama']; ?></td>
      <td><?php echo $row_rec_tampil_guru['g_tmp_lhr']; ?></td>
      <td><?php echo $row_rec_tampil_guru['g_tgl_lhr']; ?></td>
      <td><?php echo $row_rec_tampil_guru['g_jk']; ?></td>
      <td><?php echo $row_rec_tampil_guru['g_alamat']; ?></td>
      <td><?php echo $row_rec_tampil_guru['g_agama']; ?></td>
      <td><?php echo $row_rec_tampil_guru['g_status']; ?></td>
      <td><img src="Asset/images/<?php echo $row_rec_tampil_guru['nonaktif']; ?>.gif" border="0" /></td>
    </tr>
    <?php } while ($row_rec_tampil_guru = mysql_fetch_assoc($rec_tampil_guru)); ?>
</table>
<p>&nbsp;</p>