-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.php
72 lines (65 loc) · 2.43 KB
/
index.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
71
72
<?php $title = 'Dashboard';?>
<?php include 'includes/headlink.php';?>
<body>
<?php include 'includes/sidebar.php';?>
<?php include 'includes/navbar.php';?>
<div class="">
<div class="main_section">
<h4 class="text-center pt-lg-5 font-weight-bold text-danger">Welcome to Library Management System </h4>
<br>
<br>
<br>
<br>
<div class="row">
<div class="col-3">
<div class="dashbox bg-primary border shadow">
<span class="dashboxtext text-center d-block font-weight-bold">Books</span>
<span class="qty text-right d-block p-2 font-weight-bold">
<?php $books = "SELECT * from books where active_status=1";
$fetch = $conn->query($books);
$row = $fetch->num_rows;
echo "$row";
?>
</span>
</div>
</div>
<div class="col-3">
<div class="dashbox bg-success border shadow">
<span class="dashboxtext text-center d-block">Student</span>
<span class="qty text-right d-block p-2">
<?php $student = "SELECT * from student where active_status=1";
$fetch = $conn->query($student);
$row = $fetch->num_rows;
echo "$row";
?></span>
</div>
</div>
<div class="col-3">
<div class="dashbox bg-primary border shadow">
<span class="dashboxtext text-center d-block">Issued</span>
<span class="qty text-right d-block p-2">
<?php $borrow = "SELECT * from borrow where status=1";
$fetch = $conn->query($borrow);
$row = $fetch->num_rows;
echo "$row";
?></span>
</span>
</div>
</div>
<div class="col-3">
<div class="dashbox bg-success border shadow">
<span class="dashboxtext text-center d-block">Pending</span>
<span class="qty text-right d-block p-2">
<?php $pending = "SELECT * from borrow where status=1";
$fetch = $conn->query($pending);
$row = $fetch->num_rows;
echo "$row";
?></span></span>
</div>
</div>
</div>
</div>
</div>
<?php include 'includes/footer_link.php';?>
</body>
<html>