-
Notifications
You must be signed in to change notification settings - Fork 0
/
acceptLoad.php
78 lines (66 loc) · 2.64 KB
/
acceptLoad.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
<!doctype html>
<html>
<head>
<title>Success</title>
</head>
<body>
<?php
session_start();
$state = "IT";//in transit
$CDL = $_SESSION["CDL"];//CDL
$dateFufilled = "N/A";//not applicable
/* $destination = $_SESSION["destination"];
$dateListed = $_SESSION["dateListed"];
$weight = $_SESSION["weight"];
$origin = $_SESSION["origin"];
$rate=$_SESSION["rate"];
$clientID=$_SESSION['clientID'];//for integration with login page
$miles=$_SESSION['miles'];
$ratePerMile=($rate/$miles); */
$listingID=$_SESSION['listingID'];
echo "<a href='displayListings.php'>Back to Load Board</a>";
//$clientName=$_SESSION['clientName']; for integration with login page
//$clientName="Pedros inconspicuous shipping crates"; //placeholder until login integration
require_once("db.php");
$sql = "update listing set state = '$state', CDL = '$CDL' where listingID=$listingID";
/*"insert into listing
( origin, destination, dateListed, weight, rate, state, CDL, dateFufilled, clientID, miles, ratePerMile, clientName)
values ('$origin', '$destination', '$dateListed', '$weight', '$rate','$state', '$CDL', '$dateFufilled', '$clientID', '$miles', '$ratePerMile', '$clientName')";
*/
$result=$mydb->query($sql);
if ($result==1) {
$sql2 = "select * from listing where listingID=$listingID";
$result=$mydb->query($sql2);
while($row = mysqli_fetch_array($result)){
echo "<p>You have accepted this Listing! And that's tea, sis!:</p></br>";
echo "<table>
<tr>
<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>
</tr>
<tr>
<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>
</tr>
</table>";
}
}
else
{
echo "an error occured, please try again and ensure that the data is valid.";
}
?>
</body>
</html>