V1rus Private

Viewing: get_stats.php

<?php
include 'config.php';

// Get total students
$stmt = $pdo->query("SELECT COUNT(*) as total FROM students");
$totalStudents = $stmt->fetch()['total'];

// Get total certificates
$stmt = $pdo->query("SELECT COUNT(*) as total FROM certificates");
$totalCertificates = $stmt->fetch()['total'];

// Get total exams
$stmt = $pdo->query("SELECT COUNT(*) as total FROM exams");
$totalExams = $stmt->fetch()['total'];

// Calculate success rate
$stmt = $pdo->query("SELECT COUNT(*) as passed FROM exams WHERE status = 'passed'");
$passedExams = $stmt->fetch()['passed'];
$successRate = $totalExams > 0 ? round(($passedExams / $totalExams) * 100) : 0;

echo json_encode([
    'total_students' => $totalStudents,
    'total_certificates' => $totalCertificates,
    'total_exams' => $totalExams,
    'success_rate' => $successRate
]);
?>

User / IP	: 216.73.217.108
Host / Server	: 190.92.174.125 / aerosofthealthcare.com
System	: Linux s3739.bom1.stableserver.net 4.18.0-513.24.1.lve.2.el8.x86_64 #1 SMP Fri May 24 12:42:50 UTC 2024 x86_64