connect_error) {
die("DB Connection failed");
}
/* GET VIEW FILTER */
$view = $_GET['view'] ?? 'active';
/* COUNTS */
$total = $conn->query("SELECT COUNT(*) c FROM institutions WHERE deleted_at IS NULL")->fetch_assoc()['c'];
$active = $conn->query("SELECT COUNT(*) c FROM institutions WHERE status='active' AND deleted_at IS NULL")->fetch_assoc()['c'];
$inactive = $conn->query("SELECT COUNT(*) c FROM institutions WHERE status='inactive' AND deleted_at IS NULL")->fetch_assoc()['c'];
$deleted = $conn->query("SELECT COUNT(*) c FROM institutions WHERE deleted_at IS NOT NULL")->fetch_assoc()['c'];
/* FILTER QUERY */
if($view == 'active'){
$result = $conn->query("SELECT * FROM institutions WHERE status='active' AND deleted_at IS NULL");
}
elseif($view == 'inactive'){
$result = $conn->query("SELECT * FROM institutions WHERE status='inactive' AND deleted_at IS NULL");
}
elseif($view == 'deleted'){
$result = $conn->query("SELECT * FROM institutions WHERE deleted_at IS NOT NULL");
}
else{
$result = $conn->query("SELECT * FROM institutions WHERE deleted_at IS NULL");
}
?>
Founder Dashboard | RS Learning Lab
Founder Dashboard
| Name |
Contact |
Phone |
Email |
Status |
Action |
fetch_assoc()): ?>
|
|
|
|
|
Deleted
|
—
|
close(); ?>