Refresh des tweet (BDD require)

<?php
    $racine_site = "../";
    $load_tweet = false;
    $user = "quenti7794";
    $count = 80;
    $date_format = 'd M Y H:i:s';
    $url = "https://api.twitter.com/1/statuses/user_timeline.xml?include_entities=true&include_rts=true&screen_name=".$user."&amp;count=".$count;

    include("".$racine_site."include/fonction.php");

    // Incrémentation du fichier
    $incFile = fopen('compteur.txt', 'r+');

    $timeSpan = fgets($incFile);
    $timeSpan += 1;

    fseek($incFile, 0);
    fputs($incFile, "  ");

    if ($timeSpan >= 30) {
        $timeSpan = 0;
        $load_tweet = true;
    }

    fseek($incFile, 0);
    fputs($incFile, $timeSpan);
    fclose($incFile);

    if ($load_tweet)
    {
        // On charge les derniers tweets
        $oXML = simplexml_load_file( $url );

        foreach ( $oXML->status as $oStatus )
        {
            $date_time = date_create($oStatus->created_at);
            $date_insert = date_format($date_time, 'Y-m-d H:i:s');

            $oUser = $oStatus->user;
            $pseudo = utf8_decode($oUser->screen_name);

            $tweet = utf8_decode($oStatus->text);

            $req = $bdd->prepare("SELECT t_Pseudo, t_Date, t_Message FROM tweet WHERE t_Pseudo = :pseudo AND t_Date = :temps AND t_Message = :tweet");
            $req->bindValue(':pseudo', $pseudo, PDO::PARAM_STR);
            $req->bindValue(':temps', $date_insert, PDO::PARAM_STR);
            $req->bindValue(':tweet', $tweet, PDO::PARAM_STR);
            $req->execute();

            $data = $req->fetchAll();
            $req->closeCursor();

            if (count($data) == 0)
            {
                $req = $bdd->prepare("INSERT INTO tweet VALUES ('', :pseudo, :temps, :tweet, 0)");
                $req->execute(array( 'pseudo' => $pseudo,
                                'temps' => $date_insert,
                                'tweet' => $tweet));
            }
        }
    }

    $load_tweet = false;

    // On prend le dernier tweet (ou ReTweet) non lu sauf si on à tous lu
    $req = $bdd->prepare("SELECT t_ID, t_Pseudo, t_Date, t_Message FROM tweet WHERE t_Read = 0 ORDER BY t_Date ASC LIMIT :offset, :limit");
    $req->bindValue(':offset', 0, PDO::PARAM_INT);
    $req->bindValue(':limit', 1, PDO::PARAM_INT);
    $req->execute();

    $data = $req->fetchAll();
    $req->closeCursor();

    if (count($data) == 0)
    {
        $load_tweet = true;
        // S'il sont tous lu on prend le premier
        $req = $bdd->prepare("SELECT t_ID, t_Pseudo, t_Date, t_Message FROM tweet ORDER BY t_Date DESC LIMIT :offset, :limit");
        $req->bindValue(':offset', 0, PDO::PARAM_INT);
        $req->bindValue(':limit', 1, PDO::PARAM_INT);
        $req->execute();

        $data = $req->fetchAll();
        $req->closeCursor();
    }

    // On affiche les informations
    $donnee = $data[0];
    $date_time = date_create($donnee["t_Date"]);

    if ($load_tweet == false)
    {
        // On update la ligne du tweet qui est lu
        $req = $bdd->prepare("UPDATE tweet SET t_Read = 1 WHERE t_ID = :id_tweet");
        $req->bindValue(':id_tweet', $donnee["t_ID"], PDO::PARAM_INT);
        $req->execute();
    }

    echo date_format($date_time, $date_format)." \n";
    echo $donnee["t_Pseudo"]." \n";
    echo $donnee["t_Message"]." \n";
?>