<?php

    include('include/session.php');
    $titre = "Accueil";
    $script = '';
    $diapo = '';
    include('include/debut.php');
    include('include/menu.php');

    echo '<p><span style="font-style: italic;">Vous êtes ici</span> : <a href="index.php">Index</a></p>';


    echo '<div id="slider">';
    $req = $bdd->query('SELECT * FROM photos ORDER BY id DESC LIMIT 0, 5');
    while($result_slide = $req->fetch())
    {
        echo '<img src="'.$result_slide['lien'].'" alt="'.$result_slide['titre'].'" />';
    }
    echo "</div>";
    echo '<script src="nivo-slider/jquery.nivo.slider.js"></script>
        <script src="nivo-slider/jquery.nivo.slider.pack.js"></script>';
    echo "<script type=\"text/javascript\">
            $(window).load(function() {
            $('#slider').nivoSlider();
        });
     </script>";

    echo '<div id="liste_last_album">';
    echo '<h3>Liste des derniers albums:</h3><p>';
    $req = $bdd->query('SELECT * FROM albums ORDER BY id DESC LIMIT 0,5');
    while($donnees = $req->fetch())
    {
        echo '<a href="album.php?nom=' . $donnees['nom'] . '">' . $donnees['nom'] . '</a><br />';
    }
    $req->closeCursor();

    echo '</p></div>';

    echo '<div id="description"><h3>Description</h3>';
    $req2 = $bdd->query('SELECT contenu FROM description ORDER BY id DESC LIMIT 0, 1');
    $description = $req2->fetch();
    if($description)
    {
        echo '<p>'. $description['contenu'] . '</p>';
    }
    else
    {
        echo '<p>Il n\'y a aucune description</p>';
    }
    if($_SESSION['lvl'] == 3)
    {
        echo '<a href="modif_description.php">Modifier la description</a>';
    }
    echo '</div>';
    include('include/pied_de_page.php');
?>