File manager

File manager - Edit - /home/missmand/public_html/projet/managerProjet.php

Back
<?php include '../lib/app/init.php'; use Lib\Tool; use Lib\Search; /** * Variables de recherche / if(isset($_POST['addRecherche'])){ Search::postRecherche('projets'); } extract(Search::getRecherche('projets',array('ordre','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>Projets</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> <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>Ordre</label> <select name="ordre" class="form-elem"> <option value="alpha_asc" <?= ($ordre == 'alpha_asc') ? 'selected' : '' ?> >Alphabétique croissant</option> <option value="alpha_desc" <?= ($ordre == 'alpha_desc') ? 'selected' : '' ?> >Alphabétique décroissant</option> <option value="created_asc" <?= ($ordre == 'created_asc') ? 'selected' : '' ?> >Date de création croissante</option> <option value="created_desc" <?= ($ordre == 'created_desc') ? 'selected' : '' ?> >Date de création décroissante</option> </select> </div> <div class="form-group last"> <label>Rechercher</label> <input type="text" name="recherche" class="form-elem" placeholder="Recherche" value="<?= $recherche ?>"> </div> <div class="clear"></div> <div class="form-bouton"> <button class="form-submit orange" tpye="submlit" name="addRecherche">Valider</button> </div> </form> </div> </div> </div> <?php $sql = $bdd->query("SELECT FROM projet WHERE projetEtat = 1 AND projetAvant = 1 LIMIT 1 "); if($sql->rowCount() != 0){ $data = $sql->fetchObject(); echo'<section class="section section6">'; echo'<div class="inner">'; echo'<div class="projetAvant navFull" data-url="'.BASEFRONT.'projet/'.$data->projetSlug.'/'.$data->projetId.'">'; echo'<div class="projetAvantLogo">'; if(!is_null($data->projetLogo)){ echo'<img src="'.BASEFRONT.'img/projet/logo/'.$data->projetLogo.'">'; }else{ echo'<img src="'.BASEFRONT.'img/projet/logo/alt.jpg">'; } echo'<div class="projetAvantDate">'; echo'<p>Création<br><span>'.strftime("%d %b %Y",strtotime($data->projetCreated)).'</span></p>'; echo'</div>'; echo'</div>'; echo'<div class="projetAvantContenu">'; echo'<h2 class="projetAvantNom">'.$data->projetNom.'</h2>'; echo'<p class="projetAvantResume">'.$data->projetResume.'</p>'; if(!is_null($data->projetTag)) { echo '<div class="projetAvantTag">'; $sql2 = $bdd->query("SELECT * FROM tag WHERE tagId IN($data->projetTag)"); while($data2 = $sql2->fetchObject()){ echo'<span class="label vert">'.$data2->tagNom.'</span>'; } echo '</div>'; } echo'</div>'; echo'<div class="clear"></div>'; echo'</div>'; echo'</div>'; echo'</section>'; } ?> <section class="section section7"> <div class="inner"> <div class="section7Projets"> <?php $requete = "SELECT * FROM projet WHERE projetEtat = 1 AND projetAvant = 0 "; if(!empty($recherche)) $requete .= " AND projetNom LIKE '%$recherche%' OR projetDescription LIKE '%$recherche%' OR projetDirigeant LIKE '%$recherche%' OR projetActivite LIKE '%$recherche%' OR projetObjectif LIKE '%$recherche%' OR projetComplementaire LIKE '%$recherche%' "; if(!empty($ordre)){ if($ordre == 'alpha_asc') $requete .= " ORDER BY projetNom ASC "; else if ($ordre == 'alpha_desc') $requete .= " ORDER BY projetNom DESC "; else if(($ordre == 'created_asc')) $requete .= " ORDER BY projetCreated ASC "; else if(($ordre == 'created_desc')) $requete .= " ORDER BY projetCreated DESC "; }else $requete .= " ORDER BY projetId DESC "; $requete .= "LIMIT $debut, $nbPage "; $sql = $bdd->query($requete); while($data = $sql->fetchObject()){ echo'<div class="projetListe navFull" data-url="'.BASEFRONT.'projet/'.$data->projetSlug.'/'.$data->projetId.'">'; echo'<p class="projetListeDate">'.strftime("%d %b %Y",strtotime($data->projetCreated)).'</p>'; echo'<div class="projetListeLogo">'; if(!is_null($data->projetLogo)){ echo'<img src="'.BASEFRONT.'img/projet/logo/'.$data->projetLogo.'">'; }else{ echo'<img src="'.BASEFRONT.'img/projet/logo/alt.jpg">'; } echo'</div>'; echo'<div class="projetListeContenu">'; echo'<h3 class="projetListeNom">'.Tool::tronquer($data->projetNom,60).'</h3>'; echo'<p class="projetListeResume">'.Tool::tronquer($data->projetResume,90).'</p>'; if(!is_null($data->projetTag)) { echo '<div class="projetListeTag">'; $sql2 = $bdd->query("SELECT * FROM tag WHERE tagId IN($data->projetTag)"); while($data2 = $sql2->fetchObject()){ echo'<span class="label vert">'.$data2->tagNom.'</span>'; } echo '</div>'; } echo '<a href="'.BASEFRONT.'projet/'.$data->projetSlug.'/'.$data->projetId.'" class="projetListePlus">Voir le détail du projet</a>'; echo'</div>'; echo'</div>'; } ?> <div class="clear"></div> </div> <div class="section7Citation"> <p>« Ces éléments sont fournis par l'équipe projet et relèvent</p> <p>de leur responsabilité »</p> </div> <div class="pagination section7Pagination"> <?php $requetePage = "SELECT count(projetId) as total FROM projet WHERE projetEtat = 1 AND projetAvant = 0 "; if(!empty($recherche)) $requete .= " AND projetNom LIKE '%$recherche%' OR projetDescription LIKE '%$recherche%' OR projetDirigeant LIKE '%$recherche%' OR projetActivite LIKE '%$recherche%' OR projetObjectif LIKE '%$recherche%' OR projetComplementaire LIKE '%$recherche%' "; Tool::addPaginate($requetePage,BASEFRONT.'projets',$nbPage,$page, true); ?> </div> <div class="section7Startup"> <a href="#"><img src="<?= BASEFRONT ?>img/layout/btnStartup.svg"></a> </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