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  = "RADIO PULAAKU ADUNAARU";
$id_news = "";
$image = "img/logo-radio-footer.png";
$description = "Une Radio au service des communautés";

$requettetitre = $db->query("SELECT * FROM news WHERE url_news = '$categories' ");
foreach ($requettetitre as $key => $title) {
  $titre = $title["titre"];
  $id_news = $title["id_news"];
  $image =   "news/".$title["image"]; // Adjust the path accordingly  
  $description  = $title["description"]; 
}

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);

?> 
<style>
    img{
        width:100%;
    }
</style>
    
<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);
        $IDcategories = $title["id_categories"];
      ?>

<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>
                <figcaption style="text-align:center; margin-top:10px;"><?php echo $articles["legend"]; ?></figcaption>
              </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 class="post-meta-comments"> <i class="fa fa-eye"></i><a href="#"><?php echo nombrevuesnews($id_news); ?> Vues</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/users/photo-2.jpg" alt="foto" class="img-responsive"></div>
              <div class="author-post_content">
                <h5 class="author-post_title">Auteur:<span class="author-post_name"> Abdoulaye BOMBOUYA</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="#"><?php echo $articles["titre_categories"]; ?></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="#"><?php echo nombrecommentairesnews($id_news); ?> Commentaires</a> </div>
                </div>
                <div class="author-post_info"> Je suis journaliste indépendant promoteur de Radio Pulaaku Adunaaru,un media en ligne basé à parakou au Bénin. J'aime lire, voyager et écouter de la musique.</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">
              <?php
                // Article précédent
                $prevArticle  = $db->query("SELECT id_news, url_news FROM news WHERE id_news < $id_news ORDER BY id_news ASC LIMIT 1");
                 foreach($prevArticle  as $prev ){  ?> 
                <a href="<?= $prev['url_news'] ?>"><i class="fa fa-chevron-left"></i> Précédent</a>
                <?php } 
                // Article suivant
                 $nextArticle = $db->query("SELECT id_news, url_news FROM news WHERE id_news > $id_news ORDER BY id_news ASC LIMIT 1");
                 foreach($nextArticle as $next ){  ?>
                <a href="<?= $next['url_news'] ?>">Suivant<i class="fa fa-chevron-right"></i></a>
             <?php } ?> 
                
                
              </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 comment_news.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 Etoiles</option>
                        <option value="4">4 Etoiles</option>
                        <option value="3">3 Etoiles</option>
                        <option value="2">2 Etoiles</option>
                        <option value="1">1 Etoile</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 categories.id_categories != 72 AND categories.id_categories != 71 LIMIT 0,7 ");
                  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"> 
              <?php
                $requette_pub = $db->query("SELECT * FROM publicite_sponsorise ");
                foreach ($requette_pub as $pub) {
                    $date = date("Y-m-d");
                    if($pub["date_debut"] <= $date AND $pub["date_fin"] >= $date){
              ?>
                
                <div class="sidebar-schedule-slide">
                  <div class="sidebar-schedule-slider-layer full"> <a href="publiciter-sponsorisee.php?post=<?php echo $pub["id_publicite_sponsorise"]; ?>">
                      <div class="content">
                        <h3 class="hour-tag"> </h3>
                        <h4 class="sidebar-show-title bg-1"><?php echo $pub["nom_entreprise"]; ?></h4>
                        <p><?php echo $pub["titre"]; ?></p>
                      </div>
                      <img src="img/publiciter/<?php echo $pub["pub_image"]; ?>" alt="<?php echo $pub["titre"]; ?>">
                    </a> </div>
                </div>
                
                <?php
               }
              ?>
              </div>
            </div>

<div class="sidebar-add-place">
              <a href="podcasts/" target="_blank"><img src="img/cta-banner-2.png" 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 ");
                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 ORDER BY id_comment_news DESC 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="#"><?php echo nombrecommentairesnews($id_news); ?> 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 categories.id_categories = $IDcategories ");
            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"> <i class="fa fa-comment-o"></i><?php echo nombrecommentairesnews($id_news); ?> Commentaires</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>
   
</div>

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