grthtrhthjhtyjytjytkergtrhtrjytjerhrfh<?php
require_once __DIR__ . '/includes/db.php';
$db = get_db();
$stmt = $db->query("SELECT id, principal_no, name, qualification, notes, joining_date, departure_date, tenure_period FROM former_principals ORDER BY CAST(principal_no AS INTEGER) ASC");
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo "Total Principals: " . count($rows) . "\n\n";
foreach ($rows as $r) {
    echo "No. " . sprintf("%02d", $r['principal_no']) . " | " . str_pad($r['name'], 34) . " | Qual: " . str_pad($r['qualification'] ?? 'NULL', 28) . " | Not