<?php
require_once('public/connection.php');

// Initialize default variables
$school_name = '';
$school_motto = '';
$school_logo = '';
$school_favicon = '';
$school_stamp = '';

// Query the database
$query = "SELECT * FROM `administratives`";
$run_query = mysqli_query($connection, $query);

if ($run_query && mysqli_num_rows($run_query) > 0) {
    $result = mysqli_fetch_assoc($run_query);
    $school_name = $result['school_name'] ?? '';
    $school_motto = $result['school_motto'] ?? '';
    $school_logo = $result['school_logo'] ?? '';
    $school_favicon = $result['school_favicon'] ?? '';
    $school_stamp = $result['school_stamp'] ?? '';
}
