-
Notifications
You must be signed in to change notification settings - Fork 0
/
adminViewCurrentListings.php
80 lines (74 loc) · 2.52 KB
/
adminViewCurrentListings.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
<?php
session_start();
if (isset($_POST["submit"])) {
if(isset($_POST["listingID"])) $_SESSION['listingID']=$_POST["listingID"];
Header("Location: moderationDetail.php");
}
?>
<html>
<head>
<title>Reynholm Industries</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link rel="stylesheet" href="stylesheet.css" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<img src="reynholm.jpg" height=5% width=5% />
<ul class="nav nav-tabs">
<li><a href="adminLanding.php">Home</a></li>
<li><a href="adminViewListings.php">View Listings</a></li>
<li><a href="moderationNew.php">Moderation</a></li>
<li class="active"><a href="adminViewCurrentListings.php">View Current Listings</a></li>
<li><a href="adminAreYouSure.php">Delete your Account</a></li>
</ul>
</body>
</html>
<?php
require_once("db.php");
//$CDL=$_SESSION['CDL'];
//$clientID=$_SESSION['truckerID'];
$sql = "select * from listing where state='L'";
$result = $mydb->query($sql);
echo
"<div><table>
<tr>
<th> ListingID </th>
<th> Client Name </th>
<th> Origin </th>
<th> Destination </th>
<th> date listed </th>
<th> Weight </th>
<th> rate </th>
<th> Miles </th>
<th> Rate per Mile </th>
<th> Status </th>
<th>Detail View</th>
</tr>";
while($row = mysqli_fetch_array($result)) {
$lid=$row['listingID'];
echo
"<tr>
<td>".$row['listingID']."</td>
<td>".$row['clientName']."</td>
<td>".$row['origin']."</td>
<td>".$row['destination']."</td>
<td>".$row['dateListed']."</td>
<td>".$row['weight']."</td>
<td>$".$row['rate']."</td>
<td>$".$row['miles']."</td>
<td>$".$row['ratePerMile']."</td>";
if ($row['state']=="NA"){echo "<td>Needs Approval</td>";}
elseif($row['state']=="L"){echo "<td>Listed</td>";}
elseif($row['state']=="IT"){echo "<td>In Transit</td>";}
elseif($row['state']=="F"){echo "<td>Fulfilled</td>";}
elseif($row['state']=="C"){echo "<td>Cancelled</td>";}
echo"<td><form method='post'
action='".$_SERVER['PHP_SELF']."'>
<input type='hidden' name='listingID' value=".$lid." />
<input type='submit' name='submit' value='View Detail' />
</form></td>
</tr>";
}
echo "</table></div>";
?>