Ejemplo n.º 1
0
if ($i_cn == 0) {
    echo '</br>';
}
echo '<div style="clear:both;"></div>';
?>
      <div id="limiter">Sujets épinglés</div>
        <div id="cat">
          <?php 
$db = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password);
$sql_req = "SELECT * FROM `web_threads` WHERE `forum_id`='" . $_GET['id'] . "' AND `stucked` = '1';";
$req = $db->prepare($sql_req);
$req->execute();
$req->setFetchMode(PDO::FETCH_ASSOC);
if ($req->rowCount() > 0) {
    while ($row = $req->fetch()) {
        $desc = $dev->getThreadForDesc($row['id']);
        echo "<a style='text-decoration:none;' href='./forum_thread.php?id=" . $row['id'] . "'>\n                        <div id='forum'>\n                          <span class=\"icon-bubble\" id='ico'></span>\n                          <span id='title'>" . utf8_encode($row['title']) . "</span></br>\n                          <span id='threads'>" . $desc . "</span>\n                          <div class='clearfix'></div>\n                        </div>\n                      </a>";
    }
} else {
    echo '<div id="forum">
                      <span class="icon-bubble" id="ico"></span>
                      <span id="title">Aucun sujet épinglé</span></br>
                      <span id="threads">Aucun sujet épinglé</span>
                    </div>';
}
?>
      </div>
    </br>
      <div id="limiter">
        Liste des sujets
          <?php