bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh

📂 Public Path & index.php Editable Test
/home/u130793164/domains/pulaaku.bj/public_html → Writable ✅
   └─ index.php → Not Found ⚠️
/home/u130793164/domains/pulaaku.bj/public_html/img/news → Writable ✅
   └─ index.php → Not Found ⚠️

<?php

require_once("includes/connexion.php");

// Vérifie si une URL a été fournie via une requête GET
if (isset($_SERVER['REQUEST_URI'])) {
 
  $url = $_SERVER['REQUEST_URI'];

$parsed_url = parse_url($url);

$path = isset($parsed_url['path']) ? $parsed_url['path'] : '';

// Utilise basename pour obtenir le nom du fichier
  $categories = basename($path);
} else {
  header("location:error.php");
}

$titre  = "";
$id_news = 0;

$requettetitre = $db->query("SELECT * FROM news WHERE url_news = '$categories' ");
foreach ($requettetitre as $key => $title) {
  $titre = $title["titre"];
  $id_news = $title["id_news"];
}
 
require_once("includes/fonctions.php");
require_once("includes/traitement-email.php");
require_once("includes/traitement-commentaire-blog.php");
require_once("includes/header.php");

//Insertion de nombre de vue de l'article
//nombre_vue_insert_news($id_news);
?> 
    
<div id="main-section">
  
  <div class="container"> </div>
  
  
  <section class="module">
    <div class="container">
      
      <?php
      if ($success_comment) { ?>
        <div class="alert alert-success"> <?php echo $success_comment; ?> </div>
      <?php
      }
      if ($error_comment) { ?>
        <div class="alert alert-danger"> <?php echo $error_comment;  ?> </div>
      <?php
      }
      $nombre = 0;
      $requette_news_ = $db->query("SELECT * FROM news ");
      foreach ($requette_news_ as $key => $news_) {
        $nombre += 1;
      }

if ($nombre) {
      ?>
        
        <div class="outer">
          <div class="breaking-ribbon">
            <h5>Dernières nouvelles</h5>
          </div>
          
          <div class="newsticker">
            <ul>
              <?php
              $requettederniereNews = $db->query("SELECT * FROM categories, news WHERE news.id_categories = categories.id_categories ORDER BY id_news DESC LIMIT 0, 4");
              foreach ($requettederniereNews as $key => $derniereNews) {
              ?>
                <li>
                  <h4><span class="category"><?php echo $derniereNews["titre_categories"]; ?>:</span><a href="<?php echo $derniereNews["url_news"]; ?>"> <?php echo $derniereNews["titre"]; ?></a></h4>
                </li>
              <?php
              }
              ?>
            </ul>
            <div class="navi">
              <button class="up"><i class="fa fa-caret-left"></i></button>
              <button class="down"><i class="fa fa-caret-right"></i></button>
            </div>
          </div>
          
        </div>
        
      <?php
      }

$requetteArticles = $db->query("SELECT * FROM categories, news WHERE news.id_categories = categories.id_categories AND id_news = $id_news ");
      foreach ($requetteArticles as $key => $articles) {
        $date_sql = $articles["date_ajout_news"];
        $time = strtotime($date_sql);
      ?>

<div class="row no-gutter">
          
          <div class="col-md-8">
            
            <div class="post post-full clearfix">
              <div class="entry-media"> <a href="#">
                  <?php
                  if (!empty($articles["image"])) { ?>
                    <img class="img-responsive" src="img/news/<?php echo $articles["image"]; ?>" alt="<?php echo $articles["titre"]; ?>">
                  <?php } else { ?>
                    <img class="img-responsive" src="img/news.png" alt="<?php echo $articles["titre"]; ?>">
                  <?php
                  }
                  ?>
                </a>
              </div>
              <div class="entry-main">
                <div class="entry-title">
                  <h4 class="entry-title"><a href="#"><?php echo $articles["titre"]; ?></a></h4>
                </div>

<div class="post-meta-elements">
                  <div class="post-meta-author"> <i class="fa fa-user"></i><a href="#">Par Radio ADUNAARU </a> </div>
                  <div class="post-meta-date"> <i class="fa fa-calendar"></i> Il a <?php echo humanTiming($time); ?></div>
                  <div class="post-meta-comments"> <i class="fa fa-comment-o"></i><a href="#"><?php echo nombrecommentairesnews($id_news); ?> Commentaires</a> </div>
                </div>
                
                <div class="entry-content">
                  <p><?php echo $articles["description"]; ?> </p>
                </div>
              </div>
            </div>
            
            
            <div class="author-post clearfix">
              <div class="author-post_img"><img src="img/author.jpg" alt="foto" class="img-responsive"></div>
              <div class="author-post_content">
                <h5 class="author-post_title">Auteur:<span class="author-post_name"> Hugh Jackson</span></h5>
                <div class="post-meta-elements">
                  <div class="post-meta-author"> <i class="fa fa-user"></i><a href="#">Admin</a> </div>
                  <div class="post-meta-cat"> <i class="fa fa-tags"></i><a href="#">News</a>, <a href="#">Politics</a> </div>
                  <div class="post-meta-date"> <i class="fa fa-clock-o"></i> Il a <?php echo humanTiming($time); ?></div>
                  <div class="post-meta-comments"> <i class="fa fa-comment-o"></i><a href="#">Commentaires</a> </div>
                </div>
                <div class="author-post_info">Tempor incididunt labore et dolore magna aliqua enimad min veniam saquis nostru exercitation ullamco laboris onsequat lorem ipsum dolor tasit amet consect elit sed eiusmod incididunt labore et dolore magna aliquipsum.</div>
                <ul class="social-links list-inline">
                  <li><a href="#" class="social-link facebook"><i class="fa fa-facebook"></i></a></li>
                  <li><a href="#" class="social-link youtube"><i class="fa fa-youtube-play"></i></a></li>
                  <li><a href="#" class="social-link twitter"><i class="fa fa-twitter"></i></a></li>
                  <li><a href="#" class="social-link linkedin"><i class="fa fa-linkedin"></i></a></li>
                </ul>
              </div>
              <div class="pager">
                <a href="#"><i class="fa fa-chevron-left"></i>Précedent</a>
                <a href="#">Suivant<i class="fa fa-chevron-right"></i></a>
              </div>
            </div>
            
            
            <div class="comment-section">
              
              <div class="comment-title title-style01">
                <h4><?php echo nombrecommentairesnews($id_news); ?> Commentaires</h4>
              </div>
              
              <ul class="comments-list">
                <?php
                $requette_comment = $db->query("SELECT * FROM users, comment_news WHERE users.id_users = comment_news.id_users AND id_news = $id_news ORDER BY id_comment_news DESC");
                foreach ($requette_comment as $comment) {

$date_sql_ = $comment["date_ajout_comment_news"];
                  $time_comment = strtotime($date_sql_);
                ?>
                  <li>
                    <div class="comment clearfix">
                      <div class="avatar">
                        <?php
                        if (!empty($comment["image"])) { ?>
                          <img src="img/users/<?php echo $comment["image"]; ?>" class="mr-3" alt="<?php echo $comment["image"]; ?>" class="img-responsive">
                        <?php } else { ?>
                          <img src="img/users/avatar.png" class="mr-3" alt="<?php echo $comment["image"]; ?>" class="img-responsive">
                        <?php
                        }
                        ?>
                      </div>
                      <div class="comment-content">
                        <div class="comment-title">
                          <h5 class="comment-author"><?php echo $comment["nom"] . " " . $comment["prenom"]; ?></h5>
                          <div class="comment-date"><i class="fa fa-calendar"></i><span class="day"> <?php echo humanTiming($time_comment); ?></span></div>
                        </div>
                        <p><?php echo $comment["comment"]; ?></p>
                      </div>
                    </div>
                  </li>
                  <?php
                  $id_comment = $comment["id_comment_news"];
                  $requette_comment_reponse = $db->query("SELECT * FROM users, comment_news, reponse_comment_news WHERE reponse_comment_news.id_comment_news = comment_news.id_comment_news AND reponse_comment_news.id_users = users.id_users AND comment_news.id_comment_news = $id_comment ORDER BY id_reponse_comment_news DESC");
                  foreach ($requette_comment_reponse as $comment_reponse) {

$date_sql_ = $comment_reponse["date_ajout_reponse_comment_news"];
                    $time_comment_reponse = strtotime($date_sql_);
                  ?>
                    <li>
                      <ul class="children">
                        <li>
                          <div class="comment clearfix">
                            <div class="avatar">
                              <?php
                              if (!empty($comment["image"])) { ?>
                                <img src="img/users/<?php echo $comment["image"]; ?>" class="mr-3" alt="<?php echo $comment["image"]; ?>" class="img-responsive">
                              <?php } else { ?>
                                <img src="img/users/avatar.png" class="mr-3" alt="<?php echo $comment["image"]; ?>" class="img-responsive">
                              <?php
                              }
                              ?>
                            </div>
                            <div class="comment-content">
                              <div class="comment-title">
                                <h5 class="comment-author"><?php echo $comment_reponse["nom"] . " " . $comment_reponse["prenom"]; ?></h5>
                                <div class="comment-date"><i class="fa fa-calendar"></i><span class="day"> <?php echo humanTiming($time_comment_reponse); ?></span></div>
                              </div>
                              <p><?php echo $comment_reponse["comment_reponse"]; ?></p>
                            </div>
                          </div>
                        </li>
                      </ul>
                    </li>
                <?php
                  }
                }
                ?>
              </ul>
            </div>

<div class="form-reply-section">
              <div class="comment-title title-style01">
                <h4>Laisser une réponse</h4>
              </div>
              <form class="form-reply ui-form" action="" method="post">
                <?php
                if (isset($_SESSION["usersID"]) and !empty($_SESSION["usersID"])) {

<?php
                } else { ?>
                  <div class="row no-gutter">
                    <div class="col-md-6">
                      <div class="form-group">
                        <input placeholder="Votre nom" name="nom" class="form-control" type="text" title="Nom  " />
                      </div>
                    </div>
                    <div class="col-md-6">
                      <div class="form-group">
                        <input placeholder="Votre Prénoms" name="prenom" class="form-control" type="text" title="Prénoms " />
                      </div>
                    </div>
                  </div>
                  <div class="row no-gutter">
                    <div class="col-md-12">
                      <input placeholder="Adresse email" name="email" class="form-control" type="email" title="Email" />
                    </div>
                  </div>
                <?php
                }

?>
                <div class="row no-gutter">
                  <div class="col-md-12">
                    <div class="form-group">
                      <label for="">Donner une note</label>
                      <select name="etoile" id="" class="form-control">
                        <option value="5">5</option>
                        <option value="4">4</option>
                        <option value="3">3</option>
                        <option value="2">2</option>
                        <option value="1">1</option>
                      </select>
                    </div>
                  </div>
                </div>
                <div class="row no-gutter">
                  <div class="col-md-12">
                    <input placeholder="Votre nom" name="id_news" value="<?php echo $id_news; ?>" class="form-control" type="hidden" title="Nom  " />
                    <textarea rows="5" placeholder="Commentaire" name="comment" class="form-control" title="Commentaire"></textarea>
                  </div>
                </div>
                <div class="row no-gutter">
                  <div class="col-md-12">
                    <button type="submit" name="commentaire" class="btn btn-primary btn-black">Envoyez</button>
                  </div>
                </div>
              </form>
            </div>

</div>
          
          
          <div class="col-md-4">
            
            
            <div class="block-title-2">
              <h3> Posts Récents</h3>
            </div>
            
            <div class="sidebar-newsfeed">
              
              <div class="newsfeed-1">
                <ul>
                  <?php
                  $requetteArticlesRecents = $db->query("SELECT * FROM categories, news WHERE news.id_categories = categories.id_categories AND id_news = $id_news ");
                  foreach ($requetteArticlesRecents as $key => $articlesREcents) {
                  ?>
                    <li>
                      <div class="item">
                        <div class="item-image"><a class="img-link" href="#">
                            <?php
                            if (!empty($articlesREcents["image"])) { ?>
                              <img class="img-responsive img-full" src="img/news/<?php echo $articlesREcents["image"]; ?>" alt="<?php echo $articlesREcents["image"]; ?>">
                            <?php } else { ?>
                              <img class="img-responsive img-full" src="img/news.png" alt="<?php echo $articlesREcents["titre"]; ?>">
                            <?php
                            }
                            ?>

</a>
                        </div>
                        <div class="item-content">
                          <h4 class="ellipsis"><a href="<?php echo $articlesREcents["url_news"]; ?>"><?php echo $articlesREcents["titre"]; ?></a></h4>
                          <p class="ellipsis"><a href="<?php echo $articlesREcents["url_news"]; ?>"><?php echo my_meta_description($articlesREcents["description"], $n = 5); ?></a></p>
                        </div>
                      </div>
                    </li>
                  <?php } ?>
                </ul>
              </div>
              
            </div>
            
            
            <div class="sidebar-schedule">
              
              <div class="block-title-2">
                <h3><strong>Publicités</strong> Sponsorisées</h3>
              </div>
              
              <div id="sidebar-schedule-slider" class="owl-carousel">
                
                <div class="sidebar-schedule-slide">
                  <div class="sidebar-schedule-slider-layer full"> <a href="news.html">
                      <div class="content">
                        <h3 class="hour-tag">18:00</h3>
                        <h4 class="sidebar-show-title bg-1">Around the World</h4>
                        <p>New global rules on firms' tax disclosure urged by economists</p>
                      </div>
                      <img src="img/sidebar-schedule_slider-image01.jpg" alt="">
                    </a> </div>
                </div>
                
                
                <div class="sidebar-schedule-slide">
                  <div class="sidebar-schedule-slider-layer full"> <a href="news.html">
                      <div class="content">
                        <h3 class="hour-tag">18:45</h3>
                        <h4 class="sidebar-show-title bg-1">Sport Headlines</h4>
                        <p>All the latest sports news from around the world.</p>
                      </div>
                      <img src="img/sidebar-schedule_slider-image02.jpg" alt="">
                    </a> </div>
                </div>
                
                
                <div class="sidebar-schedule-slide">
                  <div class="sidebar-schedule-slider-layer full"> <a href="news.html">
                      <div class="content">
                        <h3 class="hour-tag">22:00</h3>
                        <h4 class="sidebar-show-title bg-1">Happening Now</h4>
                        <p>Kerry Thomas will take you to news when and where it happens.</p>
                      </div>
                      <img src="img/sidebar-schedule_slider-image03.jpg" alt="">
                    </a> </div>
                </div>
                
              </div>
            </div>

<div class="sidebar-add-place">
              <a href="#" target="_blank"><img src="img/banner_400x270.jpg" alt=""></a>
            </div>
            
            
            
            <div class="block-title-1 center">
              <h3>Catégories</h3>
            </div>
            
            <div class="sidebar-categories">
              <ul class="list list-mark-1">
                <?php
                $requette_categorie = $db->query("SELECT * FROM categories LIMIT 0, 6");
                foreach ($requette_categorie as $cate) {
                ?>
                  <li><a href="<?php echo $cate["url_cat"]; ?>"><?php echo $cate["titre_categories"] ?></a> <span><?php echo  nombre_categories($cate["id_categories"]); ?></span> </li>
                <?php
                }
                ?>
              </ul>
            </div>

<div class="block-title-3">
              <h3>Dernières critiques</h3>
            </div>
            
            <ul class="sidebar-reviews">
              <?php
              $requette_commentaire = $db->query("SELECT * FROM comment_news WHERE id_news = $id_news LIMIT 0, 5");
              foreach ($requette_commentaire as $critique) {
                $date_sql = $critique["date_ajout_comment_news"];
                $comment_news_time = strtotime($date_sql);
              ?>
                <li>
                  <div class="reviews-content">
                    <h3><a href="#"><?php echo $critique["comment"]; ?></a></h3>
                    <div class="post-meta-elements">
                      <div class="post-meta-cat"> <i class="fa fa-tags"></i><a href="#">News</a>, </div>
                      <div class="post-meta-date"> <i class="fa fa-clock-o"></i> Il a <?php echo humanTiming($comment_news_time); ?> </div>
                      <div class="post-meta-comments"> <i class="fa fa-comment-o"></i><a href="#">Comments</a> </div>
                    </div>
                  </div>
                  <ul class="ranking-star">
                    <?php
                    if ($critique["etoile"] == 1) {
                    ?>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                    <?php }
                    if ($critique["etoile"] == 2) {
                    ?>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                    <?php }
                    if ($critique["etoile"] == 3) {
                    ?>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                    <?php }
                    if ($critique["etoile"] == 4) {
                    ?>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star-o"></i></li>
                    <?php }
                    if ($critique["etoile"] == 5) {
                    ?>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                      <li><i class="fa fa-star"></i></li>
                    <?php } ?>
                  </ul>
                </li>
              <?php } ?>

</ul>

<div id='calendar'></div>
            
            
            <div id="sidebar-newsletter">
              
              <div class="title-style01">
                <h3><strong>Newsletter</strong></h3>
              </div>
              
              
              <div class="sidebar-newsletter-form">
                <form class="form-horizontal" action="" method="POST">
                  <div class="input-group">
                    <input title="Newsletter" class="form-control" name="email" type="email" id="address" placeholder="Entrez votre adresse email" data-validate="validate(required, email)" required>
                    <span class="input-group-btn">
                      <button type="submit" name="newsletter" class="btn btn-success">S'abonner</button>
                    </span>
                  </div>
                </form>
                <span id="result" class="alertMsg"></span>
              </div>
              
            </div>
            
            
            <div id="sidebar-social-icons">
              <ul class="sidebar-social-icons">
                <li> <a href="#" class="facebook"><i class="fa fa-facebook"></i></a> </li>
                <li> <a href="#" class="youtube"><i class="fa fa-youtube"></i></a> </li>
                <li> <a href="#" class="twitter"><i class="fa fa-twitter"></i></a> </li>
                <li> <a href="#" class="linkedin"><i class="fa fa-linkedin"></i></a> </li>
              </ul>
            </div>
            
          </div>
          
        </div>
      <?php
      }
      ?>
    </div>
    
  </section>
  
  
  <section class="module highlight">
    <div class="container">
      <div class="row no-gutter">
        
        <div class="col-md-12">
          <div class="module-title">
            <h3 class="title"><span class="bg-1">Actualités 24h/24</span></h3>
            <h3 class="subtitle">Articles populaires</h3>
          </div>
          
          <div class="article">
            <?php
            $requetteArticlesRecentsp = $db->query("SELECT * FROM categories, news WHERE news.id_categories = categories.id_categories AND id_news = $id_news ");
            foreach ($requetteArticlesRecentsp as $key => $articlesREcentsp) {

$date_sql = $articlesREcentsp["date_ajout_news"];
              $timederniere = strtotime($date_sql);
            ?>
              <div class="entry-block">
                <div class="entry-image"><a class="img-link" href="<?php echo $articlesREcentsp["url_news"]; ?>">
                    <?php
                    if (!empty($articlesREcentsp["image"])) { ?>
                      <img class="img-responsive img-full" src="img/news/<?php echo $articlesREcentsp["image"]; ?>" alt="<?php echo $articlesREcentsp["titre"]; ?>">
                    <?php } else { ?>
                      <img class="img-responsive img-full" src="img/news.png" alt="<?php echo $articlesREcentsp["titre"]; ?>">
                    <?php
                    }
                    ?>
                  </a></div>
                <div class="entry-content">
                  <div class="title-left title-style04 underline04">
                    <h3><a href="<?php echo $articlesREcentsp["url_news"]; ?>"><strong><?php echo $articlesREcentsp["titre"]; ?></strong></a></h3>
                    <i class="fa fa-clock-o"></i> Il a <?php echo humanTiming($timederniere); ?> <span class="hour"></span>
                  </div>
                  <p><a href="<?php echo $articlesREcentsp["url_news"]; ?>" target="_blank" class="external-link"><?php echo my_meta_description($articlesREcentsp["description"], 10); ?>...</a></p>
                  <div> <a class="btn btn-info" href="<?php echo $articlesREcentsp["url_news"]; ?>"> Lire plus </a> </div>
                </div>
              </div>
            <?php } ?>
          </div>
          
        </div>
        
      </div>
    </div>
  </section>
  
  
  <section class="module">
    <div class="container">
      
      
      <h3 class="carousel-title">Télécharger nos PODCASTS </h3>
      
      
      <div id="small-gallery-slider" class="owl-carousel">
        <?php
        $requette_news_derniere = $db->query("SELECT * FROM categories, news WHERE news.id_categories = categories.id_categories AND   categories.id_categories = 72  ORDER BY  RAND() ");
        foreach ($requette_news_derniere as $news_derniere) {
          $date_sql = $news_derniere["date_ajout_news"];
          $timederniere = strtotime($date_sql);
        ?>
          
          <div class="small-gallery"> <img class="img-responsive" src="img/news/<?php echo $news_derniere["image"]; ?>" alt="">
            <div class="post-content"> <a href="<?php echo $news["url_news"]; ?>"><?php echo $news_derniere["titre"]; ?></a>
              <p><a href="<?php echo $news_derniere["url_news"]; ?>"><?php echo  my_meta_description($news_derniere["description"], $n = 5); ?>...</a></p>
              <i class="fa fa-clock-o"></i><span class="day"> Il a <?php echo humanTiming($timederniere); ?></span>
            </div>
          </div>
        <?php } ?>

</div>
      
      
      
      <div class="bottom-add-place"> <a href="" target="_blank"><img src="img/banner_1248x100.jpg" alt=""></a> </div>
      
    </div>
    
  </section>
  
</div>

<?php

require_once("includes/footer.php");
?>