Library-management/ADfine.php at master · jaytorasakar8/Library-management · 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
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
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
	<title>Admin login</title>


	<link rel="stylesheet" type="text/css" href="screen.css" media="screen" />
</head>
<body>

<div id="header">
	<img src="logo.png" name="logo" />

	<p id="layoutdims"><marquee>Welcome to Online Library Management System</marquee></p>
</div>
<div class="colmask threecol">
	<div class="colmid">
		<div class="colleft">
			<div class="col1">
				<!-- Column 1 start -->
				<br><br><br>

<?php
 include 'conn.php';
echo "<table border='1' align='center' cellpadding='5'>
 <th>Issue_id </th>
 <th>Return_id </th>
 <th>Bid</th>
 <th>Mid</th>
 <th>Name</th>
 <th>Issue_date</th>
 <th>Return_date</th>
 <th>diff</th>
 <th>Amount</th>
 <th>Action</th>";

$result=$mysqli->query("SELECT * FROM returnstore where diff>0");

$no=1;

	while ($row=$result->fetch_array())
	{
    $return_id=$row['Return_id'];
	$issue_id=$row['Issue_id'];
	$mid=$row['Mid'];
	$name=$row['Name'];
	$bid=$row['Bid'];
	$bname=$row['Bname'];
	$validreturndate=$row['validreturndate'];
    $returndate=$row['Return_date'];
	$diff=$row['diff'];


echo" <tr>
<td>$issue_id</td>
<td>$return_id</td>
<td>$bid</td>
<td>$mid</td>
<td>$name</td>
<td>$validreturndate</td>
<td>$returndate</td>
<td>$diff</td>
<td>'100'</td>
</tr>"
;
}


?>
<br><br><br><br><br><br>

				<!-- Column 1 end -->
			</div>
			<div class="col2">
				<!-- Column 2 start -->
					<br><br>

					<a href="admin.php" style="font-size:25px; background-color:transparent;text-decoration:none; color:#369; "><b>Home</b></a><br><br>

				<!-- Column 2 end -->
			</div>
			<div class="col3">
				<!-- Column 3 start -->
					<div id="ads">


					</div>
				<!-- Column 3 end -->
			</div>
		</div>
	</div>
</div>
<div id="footer">


</div>

</body>
</html>