<?php
    header('Content-Type: application/json');
    require_once '../DB/db_credentials.php';
    require_once '../DB/db_connection.php';

    $query = "SELECT pk_filmID, title, duration, ageLimit, uploaded, serialNumber, imagePath, releaseYear, overview, issuedDate FROM citeLeParis_film";
    $result = mysqli_query($dbc, $query);

    if (!$result) {
        http_response_code(500);
        echo json_encode(['error' => 'Unable to retrieve films.', 'details' => mysqli_error($dbc)]);
        exit;
    }

    $films = [];

    while ($film = mysqli_fetch_assoc($result)) {
        $filmID = $film['pk_filmID'];

        $langQuery = "SELECT pkfk_availableLanguage FROM citeLeParis_hasLanguage WHERE pkfk_film = $filmID";
        $langResult = mysqli_query($dbc, $langQuery);

        $languages = [];

        if ($langResult) {
            while ($langRow = mysqli_fetch_assoc($langResult)) {
                $languages[] = (int)$langRow['pkfk_availableLanguage'];
            }
        }

        $film['languages'] = $languages;
        $films[] = $film;
    }


    echo json_encode(['movies' => $films]);
?>