Affichage des topics sur mon forum

BunnyGaming Le 25 février 2019 à 16:42

Bonjour ,

actuellement entrain de suivre le tuto a PrimFX concernant la création d'un forum , je suis actuellement bloqué car je n'arrive pas a afficher mes topics comment faire ?

Merci

Balatharas Le 25 février 2019 à 18:13

Salut pour qu'on t'aide il faut que tu nous montres le code qui ne fonctionne pas comme tu veux. On est pas devins 😀

BunnyGaming Le 25 février 2019 à 18:15 (Édité le 25 février 2019 à 18:59)

Forum_topics.php

<?php
require('include/php/config.php');
require('include/php/functions_forum.php');
require('include/php/functions.php');
$id_souscategorie = 0;
if(isset($_GET['categorie']) AND !empty($_GET['categorie'])) {

    $get_categorie = htmlspecialchars($_GET['categorie']);

    $categories = array();
    $req_categories = $bdd->query('SELECT * FROM f_categories');
    while($c = $req_categories->fetch()) {
        array_push($categories, array($c['id'],url_custom_encode($c['nom'])));
    }

    foreach($categories as $cat) {
        if(in_array($get_categorie, $cat)) {
            $id_categorie = intval($cat[0]);
        }
    }

    if(@$id_categorie) {

        if(isset($_GET['souscategorie']) AND !empty($_GET['souscategorie'])) {

            $get_souscategorie = htmlspecialchars($_GET['souscategorie']);

            $souscategories = array();
            $req_souscategories = $bdd->prepare('SELECT * FROM f_souscategories WHERE id_categorie = ?');
            $req_souscategories->execute(array($id_categorie));
            while($c = $req_souscategories->fetch()) {
                array_push($souscategories, array($c['id'],url_custom_encode($c['nom'])));
            }

            foreach($souscategories as $cat) {
                if(in_array($get_souscategorie, $cat)) {
                    $id_souscategorie = intval($cat[0]);
                }
            }
        }
        $req = "SELECT *, f_topics.id as topic_id FROM f_topics
                LEFT JOIN f_topics_categories ON f_topics.id=f_topics_categories.id
                LEFT JOIN f_categories ON f_topics_categories.id_categorie=f_categories.id
                LEFT JOIN f_souscategories ON f_topics_categories.id_souscategorie=f_souscategories.id
                LEFT JOIN membres ON f_topics.id_createur=membres.id
                WHERE f_categories.id=?";
        if($id_souscategorie) {
            $req .= " AND f_souscategories.id = ?";
            $exec_array = array($id_categorie,$id_souscategorie);
        } else {
            $exec_array = array($id_categorie);
        }

        $req .= " ORDER BY f_topics.id DESC";
          
        $topics = $bdd->prepare($req);
        $topics->execute($exec_array);
    } else {
        die('Erreur: Catégorie introuvable...');
    }

} else {
    die('Erreur: Aucune catégorie sélectionnée...');
}

require('views/forum_topics.view.php');
?>

forum.view.php<!doctype html>
<html lang="fr">
<head>
  <title>FORUM</title>
  <meta charset="utf-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <link rel="stylesheet" href="include/css/forum.css">
  <link href='https://fonts.googleapis.com/css?family=Roboto:400,500,300,700,400italic' rel='stylesheet' type='text/css'>
  <!--[if lt IE 9]>
    <link rel="stylesheet" type="text/css" href="include/css/ie.css">
    <script src="https://html5shim.googlecode.com/svn/trunk/html5.js"></script>
    <script src="js/PIE_IE678.js"></script>
    <script src="https://css3-mediaqueries-js.googlecode.com/svn/trunk/css3-mediaqueries.js"></script>
    <![endif]-->
</head>
<body class="kp-blog page-1-sidebar">
<?php include_once('include/php/header.php'); ?>
<div id="content" class="container clearfix">
    <div id="main-content">
        <div class="pull-left full-width">
            <!-- <div class="list-posts clearfix" style="padding-bottom:0">
                <div class="kp-breadcrumb">
                    <ol class="breadcrumb">
                      <li><span>Vous êtes ici:</span><a href="">Forum</a></li>
                    </ol>
                </div>
            </div> -->
            <table class="forum">
                <tr class="header">
                    <th class="main">Sujet</th>
                    <th class="sub-info">Auteur</th>
                    <th class="sub-info hide-640">Réponses</th>
                    <th class="sub-info messages hide-640">Vues</th>
                    <th class="sub-info">Dernière rép.</th>
                </tr>
                <?php while($t = $topics->fetch()) { ?>
                <tr>
                    <td class="main">
                        <h4><a href=""><a href="./topic.php?titre=<?= url_custom_encode($t['sujet']) ?>&id=<?= $t['topic_id'] ?>""><?= $t['sujet'] ?></a></a></h4>
                    </td>
                    <td class="sub-info"><p><?= $t['pseudo'] ?></p><p>le <?= $t['date_heure_creation'] ?></p></td>
                    <td class="sub-info hide-640"><p><?= reponse_nbr_topic($t['id']) ?></p></td>
                    <td class="sub-info hide-640"><p></p></td>
                    <td class="sub-info"><p><?= derniere_reponse_topic($t['id']) ?></p></td>
                </tr>
                <?php } ?>
            </table>
            <a class="btn ntopic" href="./nouveau_topic.php?categorie=<?= $id_categorie ?>"><span class="icon-quill"></span> Créer un nouveau topic</a>
        </div>
    </div>
</div>
    <?php //include('includes/aside.php'); ?>
<?php //include('includes/footer.php'); ?>

</body>
</html>

Échange

Articles / Vidéos

Ressources