query("DELETE FROM `centers` WHERE id = '$id'");
echo '';
}
// Activate center
if (isset($_GET['btn']) && $_GET['btn'] == 'active' && isset($_GET['id'])) {
$id = mysqli_real_escape_string($con, $_GET['id']);
$con->query("UPDATE `centers` SET `status` = '1' WHERE `centers`.`id` = '$id'");
echo '';
}
// Deactivate center
if (isset($_GET['btn']) && $_GET['btn'] == 'deactive' && isset($_GET['id'])) {
$id = mysqli_real_escape_string($con, $_GET['id']);
$con->query("UPDATE `centers` SET `status` = '0' WHERE `centers`.`id` = '$id'");
echo '';
}
// Date filters
$startDate = isset($_GET['start_date']) ? mysqli_real_escape_string($con, $_GET['start_date']) : '';
$endDate = isset($_GET['end_date']) ? mysqli_real_escape_string($con, $_GET['end_date']) : '';
$dateFilter = "";
if (!empty($startDate) && !empty($endDate)) {
$dateFilter = "AND DATE(timestamp) BETWEEN '$startDate' AND '$endDate'";
}
$query = "SELECT * FROM centers WHERE 1 " . $dateFilter . " ORDER BY id DESC";
$get = $con->query($query);
?>
All Franchise Centers
| Date |
Institute ID |
Institute Name |
Address |
State |
District |
Head |
Photo |
Mobile |
Status |
Actions |
num_rows):
while ($g = $get->fetch_assoc()):
$s = $con->query("SELECT * FROM states where id = '" . $g['state_id'] . "'")->fetch_assoc();
$c = $con->query("SELECT * FROM city where id = '" . $g['city_id'] . "'")->fetch_assoc();
?>
|
|
|
|
|
|
|
|
|
Active
Inactive
|
|
|
No centers found
|