File manager - Edit - /home/missmand/public_html/actualite/managerActualite.php
Back
<?php include '../lib/app/init.php'; use Lib\Tool; use Lib\Search; /** * Variables de recherche */ if(isset($_POST['addRecherche'])){ Search::postRecherche('actualites'); } extract(Search::getRecherche('actualites',array('categorie','recherche'))); /* Pagination */ extract(Tool::initPaginate(9)); ?> <!doctype html> <html lang="fr"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width; initial-scale=1;"> <title>Actualités</title> <link rel="icon" type="image/png" href="<?= BASEFRONT ?>img/layout/favicon.png"> <link href="<?= BASEFRONT ?>css/app.css" rel="stylesheet" type="text/css"> </head> <body class="managerActualites"> <main class="main"> <?php include'../include/header.php'; ?> <div class="contenuTop"> <div class="inner"> <div class="contentTopRecherche"> <form action="#" method="post"> <div class="form-group first"> <label>Catégorie</label> <select name="categorie" class="form-elem"> <option value="">Choisir une catégorie</option> <?php $sql = $bdd->query("SELECT * FROM actualite_categorie ORDER BY categorieNom ASC "); while($data = $sql->fetchObject()){ $selected = ($data->categorieId == $categorie) ? 'selected' : ''; echo'<option value="'.$data->categorieId.'" '.$selected.'>'.$data->categorieNom.'</option>'; } ?> </select> </div> <div class="form-group last"> <label>Rechercher</label> <input type="text" name="recherche" class="form-elem" value="<?= $recherche ?>" placeholder="Recherche"> </div> <div class="clear"></div> <div class="form-bouton"> <button class="form-submit" tpye="submlit" name="addRecherche">Valider</button> </div> </form> </div> </div> </div> <?php $sql = $bdd->query("SELECT * FROM actualite INNER JOIN actualite_categorie ON actualiteCategorie = categorieId WHERE actualiteEtat = 1 AND actualiteAvant = 1 LIMIT 1 "); if($sql->rowCount() != 0){ $data = $sql->fetchObject(); echo'<section class="section section8">'; echo'<div class="inner">'; echo'<div class="actualiteAvant navFull" data-url="'.BASEFRONT.'actualite/'.$data->actualiteSlug.'/'.$data->actualiteId.'">'; echo'<div class="actualiteAvantImage">'; echo'<p class="actualiteAvantCategorie label orange">'.$data->categorieNom.'</p>'; if(!is_null($data->actualiteImage)){ echo'<img src="'.BASEFRONT.'img/actualite/miniature/'.$data->actualiteImage.'">'; }else{ echo'<img src="'.BASEFRONT.'img/actualite/miniature/alt.jpg">'; } echo'<div class="actualiteAvantGradient"></div>'; echo'<div class="actualiteAvantDate">'; echo '<p><span>'.date('d').'</span>'.strftime("%b",strtotime($data->actualiteCreated)).'</p>'; echo'</div>'; echo'</div>'; echo'<div class="actualiteAvantContenu">'; echo'<h2 class="actualiteAvantTitre">'.$data->actualiteTitre.'</h2>'; echo'<p class="actualiteAvantResume">'.$data->actualiteResume.'</p>'; echo'</div>'; echo'<div class="clear"></div>'; echo'</div>'; echo'</div>'; echo'</section>'; } ?> <section class="section section9"> <div class="inner"> <div class="section9Actualites"> <?php $requete = "SELECT * FROM actualite INNER JOIN actualite_categorie ON actualiteCategorie = categorieId WHERE actualiteEtat = 1 AND actualiteAvant = 0 "; if(!empty($categorie)) $requete .= "AND actualiteCategorie = $categorie "; if(!empty($recherche)) $requete .= " AND actualiteTitre LIKE '%$recherche%' OR actualiteContenu LIKE '%$recherche%' "; $requete .= "ORDER BY actualiteId DESC LIMIT $debut, $nbPage "; $sql = $bdd->query($requete); while($data = $sql->fetchObject()){ echo'<div class="actualiteListe navFull" data-url="'.BASEFRONT.'actualite/'.$data->actualiteSlug.'/'.$data->actualiteId.'">'; echo'<p class="actualiteListeCategorie label orange">'.$data->categorieNom.'</p>'; echo'<div class="actualiteListeImage">'; if(!is_null($data->actualiteImage)){ echo'<img src="'.BASEFRONT.'img/actualite/miniature/'.$data->actualiteImage.'">'; }else{ echo'<img src="'.BASEFRONT.'img/actualite/miniature/alt.jpg">'; } echo'<div class="actualiteListeGradient"></div>'; echo'<div class="actualiteListeDate">'; echo '<p><span>'.date('d').'</span>'.strftime("%b",strtotime($data->actualiteCreated)).'</p>'; echo'</div>'; echo'</div>'; echo'<div class="actualiteListeContenu">'; echo'<h3 class="actualiteListeTitre">'.Tool::tronquer($data->actualiteTitre,60).'</h3>'; echo'<p class="actualiteListeResume">'.Tool::tronquer($data->actualiteResume,90).'</p>'; echo '<a href="'.BASEFRONT.'actualite/'.$data->actualiteSlug.'/'.$data->actualiteId.'" class="actualiteListePlus">Lire la suite</a>'; echo'</div>'; echo'</div>'; } ?> <div class="clear"></div> </div> <div class="pagination section9Pagination"> <?php $requetePage = "SELECT count(actualiteId) as total FROM actualite WHERE actualiteEtat = 1 AND actualiteAvant = 0 "; if(!empty($categorie)) $requete .= "AND actualiteCategorie = $categorie "; if(!empty($recherche)) $requete .= " AND actualiteTitre LIKE '%$recherche%' OR actualiteContenu LIKE '%$recherche%' "; Tool::addPaginate($requetePage,BASEFRONT.'actualites',$nbPage,$page, true); ?> </div> </div> </section> <?php include'../include/footer.php'; ?> </main> <script type="text/javascript" src="<?= BASEFRONT ?>js/jquery/jquery.js"></script> <script type="text/javascript" src="<?= BASEFRONT ?>js/height.js"></script> <script type="text/javascript" src="<?= BASEFRONT ?>js/app.js"></script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings