prepare('SELECT nom AS nom FROM cmw_forum_categorie WHERE id = :id'); $categorie->execute(array( 'id' => $id )); $categoried = $categorie->fetch(); $sousforum = $bddConnection->prepare('SELECT * FROM cmw_forum_sous_forum WHERE id_categorie = :id_categorie'); $sousforum->execute(array( 'id_categorie' => $id )); $sousforumd = $sousforum->fetch(); ?>

Les sous-Catégories de

execute(array( 'id_categorie' => $id )); while($sousforumd = $sousforum->fetch()) { ?>
Nom Description Actions
chat

Les topics de

prepare('SELECT * FROM cmw_forum_post WHERE id_categorie = :id_categorie AND sous_forum IS NULL'); $count_topic2->bindParam(':id_categorie', $id); $count_topic2->execute(); $count_topic_max2 = $count_topic2->rowCount(); $count_topic_PerPage2 = 20; $count_topic_Total2 = $count_topic_max2; $count_topic_nbrOfPages2 = ceil($count_topic_Total2 / $count_topic_PerPage2); if(isset($_GET['page_topic'])) { $page = $_GET['page_topic']; } else { $page = 1; } $count_topic_FirstDisplay2 = ($page - 1) * $count_topic_PerPage2; $topic = $bddConnection->prepare('SELECT * FROM cmw_forum_post WHERE id_categorie = :id_categorie AND sous_forum IS NULL LIMIT '.$count_topic_FirstDisplay2.', '.$count_topic_PerPage2.''); $topic->bindParam(':id_categorie', $id); $topic->execute(); $topicd = $topic->fetch(); if(isset($topicd['id'])) { ?> execute(); while($topicd = $topic->fetch()) { ?>
Nom du topic Description Dernière réponse
is_read($topicd['id'])) { ?>donemessage
prepare('SELECT * FROM cmw_forum_sous_forum WHERE id = :id'); $sousforum->execute(array( 'id' => $id_sous_forum )); $sousforumd = $sousforum->fetch(); $count_topic = $bddConnection->prepare('SELECT * FROM cmw_forum_post WHERE sous_forum LIKE :sous_forum'); $count_topic->bindParam(':sous_forum', $id_sous_forum); $count_topic->execute(); $count_topic_max = $count_topic->rowCount(); $count_topic_PerPage = 20; $count_topic_Total = $count_topic_max; $count_topic_nbrOfPages = ceil($count_topic_Total / $count_topic_PerPage); if(isset($_GET['page_sous_forum'])) { $page_topic = $_GET['page_sous_forum']; } else { $page_topic = 1; } $count_topic_FirstDisplay = ($page_topic - 1) * $count_topic_PerPage; $topic = $bddConnection->prepare('SELECT * FROM cmw_forum_post WHERE sous_forum LIKE :sous_forum LIMIT '.$count_topic_FirstDisplay.', '.$count_topic_PerPage.''); $topic->bindParam(':sous_forum', $id_sous_forum); $topic->execute(); $topicd = $topic->fetch(); $cat = $bddConnection->prepare('SELECT nom FROM cmw_forum_categorie WHERE id = :id'); $cat->execute(array( 'id' => $sousforumd['id_categorie'] )); $catdonnees = $cat->fetch(); ?> closeCursor(); $topic->execute(); while($topicd = $topic->fetch()) { ?>
Nom du topic Description Dernière réponse
is_read($topicd['id'])) { ?>donemessage

Aucun sujet n'a été posté encore :(


prepare('SELECT * FROM cmw_forum_categorie WHERE id = :id'); $categorie2->execute(array( 'id' => $id )); $categorie2d = $categorie2->fetch(); // if(isset($_GET['id_sous_forum'])) // { // $sousforum2 = $bddConnection->prepare('SELECT * FROM cmw_forum_sous_forum WHERE id_categorie = :id'); // $sousforum2->execute(array( // 'id' => $id // )); // $sousforum2d = $sousforum2->fetch(); // } ?>

Poster un topic dans la catégorie