grthtrhthjhtyjytjytkergtrhtrjytjerhrfh<?php
require_once __DIR__ . '/config.php';
require_once __DIR__ . '/includes/db.php';

$db = Database::getConnection();

echo "--- UPDATING MR. RANO MAL DESIGNATION ---\n";
$db->exec("UPDATE faculty SET designation = 'Senior Librarian (BPS-18)' WHERE id = 'fac-22' OR name LIKE '%Rano Mal%'");

$fac = $db->query("SELECT id, name, designation, bps_grade, qualification FROM faculty WHERE id = 'fac-22' OR name LIKE '%Rano Mal%'")->fetch(PDO::FETCH_ASSOC);

echo "ID: {$fac['id']} | Name: {$fac['name']} | Designation: {$fac['designation']} | Quali