-
Notifications
You must be signed in to change notification settings - Fork 0
/
lost_books.php
124 lines (112 loc) · 5.19 KB
/
lost_books.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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php include ('header.php'); ?>
<div class="page-title">
<div class="title_left">
<h3>
<small>Home /</small> Books
</h3>
</div>
</div>
<div class="clearfix"></div>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<a href="book_print_lost.php" target="_blank" style="background:none;">
<button class="btn btn-danger pull-right"><i class="fa fa-print"></i> Print Book List</button>
</a>
<br />
<br />
<div class="x_title">
<h2><i class="fa fa-book"></i> Book List</h2>
<ul class="nav navbar-right panel_toolbox">
<li>
<a href="add_book.php" style="background:none;">
<button class="btn btn-primary"><i class="fa fa-plus"></i> Add Book</button>
</a>
</li>
</ul>
<div class="clearfix"></div>
<ul class="nav nav-pills">
<li role="presentation"><a href="book.php">All</a></li>
<li role="presentation" class="active"><a href="lost_books.php">Lost Books</a></li>
</ul>
<div class="clearfix"></div>
</div>
<div class="x_content">
<!-- content starts here -->
<div class="table-responsive">
<table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered" id="example">
<thead>
<tr>
<th style="width:100px;">Book Image</th>
<th>Barcode</th>
<th>Title</th>
<th>ISBN</th>
<th>Author/s</th>
<th>Category</th>
<th>Status</th>
<th>Remarks</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$result= mysqli_query($con,"select * from book where status = 'Lost' ") or die (mysql_error());
while ($row= mysqli_fetch_array ($result) ){
$id=$row['book_id'];
?>
<tr>
<td>
<?php if($row['book_image'] != ""): ?>
<img src="upload/<?php echo $row['book_image']; ?>" class="img-thumbnail" width="75px" height="50px">
<?php else: ?>
<img src="images/book_image.jpg" class="img-thumbnail" width="75px" height="50px">
<?php endif; ?>
</td> <!--- either this <td><a target="_blank" href="view_book_barcode.php?code=<?php // echo $row['book_barcode']; ?>"><?php // echo $row['book_barcode']; ?></a></td> -->
<td><a target="_blank" href="print_barcode_individual.php?code=<?php echo $row['book_barcode']; ?>"><?php echo $row['book_barcode']; ?></a></td>
<td style="word-wrap: break-word; width: 10em;"><?php echo $row['book_title']; ?></td>
<td style="word-wrap: break-word; width: 10em;"><?php echo $row['isbn']; ?></td>
<td style="word-wrap: break-word; width: 10em;"><?php echo $row['author']."<br />".$row['author_2']."<br />".$row['author_3']."<br />".$row['author_4']."<br />".$row['author_5']; ?></td>
<td><?php echo $row['category']; ?></td>
<td><?php echo $row['status']; ?></td>
<td><?php echo $row['remarks']; ?></td>
<td>
<a class="btn btn-primary" for="ViewAdmin" href="view_book.php<?php echo '?book_id='.$id; ?>">
<i class="fa fa-search"></i>
</a>
<a class="btn btn-warning" for="ViewAdmin" href="edit_book.php<?php echo '?book_id='.$id; ?>">
<i class="fa fa-edit"></i>
</a>
<!-- <a class="btn btn-danger" for="DeleteAdmin" href="#delete<?php echo $id;?>" data-toggle="modal" data-target="#delete<?php echo $id;?>">
<i class="glyphicon glyphicon-trash icon-white"></i>
</a>
delete modal user -->
<div class="modal fade" id="delete<?php echo $id;?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel"><i class="glyphicon glyphicon-user"></i> User</h4>
</div>
<div class="modal-body">
<div class="alert alert-danger">
Are you sure you want to delete?
</div>
<div class="modal-footer">
<button class="btn btn-inverse" data-dismiss="modal" aria-hidden="true"><i class="glyphicon glyphicon-remove icon-white"></i> No</button>
<a href="delete_user.php<?php echo '?book_id='.$id; ?>" style="margin-bottom:5px;" class="btn btn-primary"><i class="glyphicon glyphicon-ok icon-white"></i> Yes</a>
</div>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<!-- content ends here -->
</div>
</div>
</div>
</div>
<?php include ('footer.php'); ?>