<?php
    include_once 'header.php';
    include_once 'menu.php';
    include_once 'lib.php';
    if (isset ($_GET['sigla'])) {
        $siglaCont = $_GET['sigla'];
        try {
            $select_statement = $database->prepare("SELECT * FROM container c, noleggio n, prenotazione p WHERE c.id_tipo=p.tipo_id AND p.prenotazione_id = n.prenotazione_id AND c.sigla=':a'");
            $select_statement->bindValue(':a',$siglaCont);

            $select_statement->execute();
            $info_container = $select_statement->fetch();
        } catch (Exception $exc) {
            echo $exc->getTraceAsString();
            echo $exc->getMessage();
        }
        echo '<div class="info_prenotazione">';

        print_r($info_container);
        echo '</div>';

    }
?>