-
Notifications
You must be signed in to change notification settings - Fork 0
/
SeeAll_Messages.php
67 lines (55 loc) · 1.74 KB
/
SeeAll_Messages.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
<?php include 'header.php';?>
<?php include 'nav.php';?>
<?php include 'menu.php';?>
<body class="skin-blue" >
<div class="container" >
<aside class="right-side">
<div class="panel-body">
<div class="dataTable_wrapper">
<!-- Table row -->
<div class="row">
<div class="col-xs-12 table-responsive">
<h2 ><i class="glyphicon glyphicon-envelope">SeeAll</i></h2>
<table class="table table-striped table-hover" style="border: 2px solid #DCDCDC;">
<thead colspan="12">
<tr style="background-color:#4682B4; color:white;">
<th>Customer Name</th>
<th>PayDate</th>
<th>Rent Item</th>
<th>Price</th>
</tr>
</thead>
<tbody>
<?php
$db->disconnect();
$db->connect();
//Call Select for New company
$select3=$db->query("CALL spSelectCusPay('".$getComIDUser."')");
$rowselect3=$db->dbCountRows($select3);
if($rowselect3>0){
while($row1=$db->fetch($select3)){
$Customer_RentID = $row1->Customer_RentID;
$FullName = $row1->FullName;
$ItemName = $row1->ItemName;
$RentDate = $row1->RentDate;
$PayDate = $row1->PayDate;
$Price = $row1->Price;
echo '<tr>
<td><a href="Customer_Rent.php?Customer_RentID='.$Customer_RentID .'">'.$FullName.'</a></td>
<td>'.$PayDate.'</td>
<td>'.$ItemName.'</td>
<td>$' .$Price. '</td>
</tr>';
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</aside>
</div>
</body>
<?php include 'footer.php';?>