-
Notifications
You must be signed in to change notification settings - Fork 0
/
topborrowers.php
48 lines (40 loc) · 1.12 KB
/
topborrowers.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
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body style="background-color:lightblue">
<p> </p>
<p> </p>
<div align="center"><br>
<?php
$host="localhost";
$user="root";
$pass="";
$conn=mysql_connect($host,$user,$pass);
$db=mysql_select_db("elib");
$sel="select * from issue where reader_id >=40 ";
$query=mysql_query($sel);
?>
<form name="banchinfo" action="adminlogin.php">
<table bgcolor="blue" border="3">
<tr><td>Issue ID</td><td>Issue Date</td><td>Due Date</td><td>No of books</td><td>Book Id</td><td>Reader Id</td></tr>
<?php
while($row=mysql_fetch_array($query))
{
?>
<tr><td><?php echo $row['issue_id']; ?></td><td><?php echo $row['issue_date']; ?>
<td><?php echo $row['due_date']; ?></td>
<td><?php echo $row['No_of books']; ?></td>
<td><?php echo $row['book_id']; ?></td>
<td><?php echo $row['reader_id']; ?></td></tr>
<?php
}
?>
</table>
</br>
<input type="submit" value="Go Back">
</form>
</body>
</html>