</head>
<body>
<h1>Completed Food Drives</h1>
<table border="1">
<tr><th>ID</th><th>Category</th><th>Organization Name & Address</th><th>Contact Phone & E-mail</th><th>Start Date</th><th>End Date</th><th>Total Pounds</th><th>Action</th></tr>
<?php
// Connect to MySQL
$connect = $conn;
if ($connect->connect_error) {
die('Connection error: (' . $connect->connect_errno . '): ' . $connect->connect_error);
}
// get list of pickups with pounds
$sql = "SELECT fooddrive_id, org_name, orgcat_name, org_street, org_city, org_state, org_zip, org_contact, org_phone, org_email, fooddrive_startdate, fooddrive_enddate, SUM(pickup_pounds) FROM view_pickup WHERE pickup_complete=1 GROUP BY fooddrive_id";
$result = $connect->query($sql) or die($connect->error);
// create the table
while ($result2 = $result->fetch_assoc()) {
echo '<tr><td>' . $result2["fooddrive_id"] . '</td><td>' . $result2["orgcat_name"] . '</td><td>' . $result2["org_name"] . '<br>' . $result2["org_street"] . '<br>' . $result2["org_city"] . ', ' . $result2["org_state"] . ' ' . $result2["org_zip"] . '</td><td>' . $result2["org_contact"] . '<br>' . $result2["org_phone"] . '<br>' . '<a href="mailto:' . $result2["org_email"] . '">' . $result2["org_email"] . '</a></td><td>' . dateDefault($result2["fooddrive_startdate"]) . '</td><td>' . dateDefault($result2["fooddrive_enddate"]) . '</td><td>' . $result2["SUM(pickup_pounds)"] . '</td><td>';
echo '<form><input type="hidden" name="fdid" value="' . $result2['fooddrive_id'] . '">' . '<button type="submit" formmethod="post" formaction="fooddrivesingle.php">View Food Drive</button><br></form>';
echo '</td></tr>';
}
?>
</table>
</body>
</html>
$result7 = $connect->query($sql4) or die($connect->error);
$result8 = $result7->fetch_array(MYSQLI_NUM);
// count completed pickups
$sql5 = "SELECT COUNT(*) FROM view_pickup WHERE fooddrive_id={$result2['fooddrive_id']} AND pickup_complete=1";
$result9 = $connect->query($sql5) or die($connect->error);
$result10 = $result9->fetch_array(MYSQLI_NUM);
echo '<tr><td>' . $result2["fooddrive_id"] . '</td><td>' . $result2["orgcat_name"] . '</td><td>' . $result2["org_name"] . '<br>' . $result2["org_street"] . '<br>' . $result2["org_city"] . ', ' . $result2["org_state"] . ' ' . $result2["org_zip"] . '</td><td>' . $result2["org_contact"] . '<br>' . $result2["org_phone"] . '<br>' . '<a href="mailto:' . $result2["org_email"] . '">' . $result2["org_email"] . '</a></td><td>';
echo nl2br($result2['org_notes']);
echo '<p>';
echo nl2br($result2['fooddrive_notes']);
// convert dates to US format
/* $startdate = new DateTime($result2["fooddrive_startdate"]);
$enddate = new DateTime($result2["fooddrive_enddate"]);
echo '</td><td>' . $startdate->format('D, M jS, Y') . '</td><td>' . $enddate->format('D, M jS, Y') . '</td>'; */
echo '</td><td>' . dateDefault($result2["fooddrive_startdate"]) . '</td><td>' . dateDefault($result2["fooddrive_enddate"]) . '</td>';
echo '<form><input type="hidden" name="fooddriveorg" value="' . $result2['fooddrive_id'] . '">';
// show number of scheduled dropoffs, number of completed dropoffs
echo '<td>';
if ($result4[0] == 0) {
echo '<span class="unscheduled">';
}
echo 'Scheduled: ' . $result4[0] . '<br>Completed: ' . $result8[0] . '<br>';
echo '<button type="submit" formmethod="post" formaction="dropoffadd.php">Schedule Dropoff</button>';
if ($result4[0] == 0) {
echo '</span>';
}
echo '</td>';
// show number of scheduled pickups, number of completed pickups
echo '<td>';
if ($result6[0] == 0) {