query("SELECT * FROM subscribers");
if (!$result) {
http_response_code(500);
die("Error retrieving subscribers: {$conn->error}");
}
$subscribers = [];
while ($row = $result->fetch_assoc()) {
$subscribers[] = $row;
}
$result = $conn->query("SELECT id, full_name, subject, send_date FROM messages ORDER BY send_date DESC");
if (!$result) {
http_response_code(500);
die("Error retrieving messages: {$conn->error}");
}
$messages = [];
while ($row = $result->fetch_assoc()) {
$messages[] = $row;
}
$result = $conn->query("SELECT * FROM volunteers");
if (!$result) {
http_response_code(500);
die("Error retrieving volunteers: {$conn->error}");
}
$volunteers = [];
while ($row = $result->fetch_assoc()) {
$volunteers[] = $row;
}
$result = $conn->query("SELECT * FROM signs");
if (!$result) {
http_response_code(500);
die("Error retrieving sign requests: {$conn->error}");
}
$signs = [];
while ($row = $result->fetch_assoc()) {
$signs[] = $row;
}
?>
Miles Linden for San Jose City Council
Admin Panel
Subscribers
| Name |
Email |
Phone |
Join Date |
Actions |
|
|
|
|
|
Volunteers
| Name |
Email |
Phone |
Position |
Join Date |
Actions |
|
|
|
|
|
|
Sign Requests
| Address |
Quantity |
Wire stake? |
Fulfilled? |
|
|
|
|
|