forked from bastoniyahya/TA-LMS-LSKK-STEI-ITB
-
Notifications
You must be signed in to change notification settings - Fork 1
/
dosen.php
70 lines (66 loc) · 2.01 KB
/
dosen.php
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
70
<?php
include 'template/header.php';
?>
<div class="main">
<div class="main-inner">
<div class="container">
<div class="row">
<div class="span12">
<!-- Menampilkan Jumlah data Mahasiswa -->
<?php
$sql="select * from tb_dosen";
if ($result=mysqli_query($mysqli,$sql))
{
// Return the number of rows in result set
$rowcount1=mysqli_num_rows($result);
// Free result set
mysqli_free_result($result);
}
// Menampilkan Jumlah data Mahasiswa
$sql="select * from tb_dosen where status='nonaktif'";
if ($result=mysqli_query($mysqli,$sql))
{
// Return the number of rows in result set
$rowcount2=mysqli_num_rows($result);
// Free result set
mysqli_free_result($result);
}
?>
<div class="widget-header">
<i class="icon-user"></i>
<h3> Jumlah Dosen <span class="badge badge-success pull-right" style="line-height:18px;"> <?php printf("%d",$rowcount2);?></span><span class="badge badge-warning pull-right" style="line-height:18px;" title="Belum dikonfirmasi"> <?php printf("%d",$rowcount1);?></span></h3>
<!-- textbox untuk pencarian data Mahasiswa -->
<div class="input-prepend pull-right">
<input type="text" class="search-query" id="prependedInput" type="text" name="pencarian" placeholder="Pencarian Dosen..">
</div>
</div>
<!-- tempat untuk menampilkan data mahasiswa -->
<div id="data-dosen"></div>
<!-- /span6 -->
<?php
$sql="select * from tb_mahasiswa";
if ($result=mysqli_query($mysqli,$sql))
{
// Return the number of rows in result set
$rowcount=mysqli_num_rows($result);
// Free result set
mysqli_free_result($result);
}
?>
</div>
</div>
<!-- /widget -->
</div>
</div>
<!-- /span6 -->
</div>
<!-- /row -->
</div>
<!-- /container -->
</div>
<!-- /main-inner -->
</div>
<!-- /main -->
<?php
require_once'template/footer.php';
?>