<?php
    header('Content-Type: application/json');

    require_once '../DB/db_credentials.php';
    require_once '../DB/db_connection.php';

    $query = "
                SELECT 
                    pk_availableLanguage,
                    languageName
                FROM citeLeParis_availableLanguage
                ORDER BY languageName ASC
            ";

    $result = mysqli_query($dbc, $query);

    if ($result) {
        $languages = [];

        while ($row = mysqli_fetch_assoc($result)) {
            $languages[] = $row;
        }

        http_response_code(200);
        echo json_encode(['languages' => $languages]);
    } else {
        http_response_code(500);
        echo json_encode([
            'error' => 'Unable to retrieve languages.',
            'details' => mysqli_error($dbc)
        ]);
    }
?>