File manager - Edit - /home/missmand/public_html/learning/admin/forum/managerMandarine.php
Back
<?php include '../lib/init.php'; Tool::verif_connect(); Auth::roleAccesAuth(array()); /* limitation de l'accès par rôle */ /* Recherche */ if(isset($_POST['addRecherche'])){ Recherche::postRecherche('mandarine'); } extract(Recherche::getRecherche('mandarine',array('recherche'))); /* Pagination variables */ $page = 1; $debut = 0; if (isset($_GET['page'])) { $page = $_GET['page']; $debut = $page-1; $debut *=50; } ?> <!doctype html> <html lang="fr"> <head> <meta charset="utf-8"> <title><?php echo TITLE ?></title> <link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,800italic,400,300,600,700' rel='stylesheet' type='text/css'/> <link href="<?php echo BASEADMIN ?>css/init.css" rel="stylesheet" type="text/css" /> <link href="<?php echo BASEADMIN ?>css/template.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="main"> <!-- En tête --> <?php include '../include/header.php'; ?> <!-- Menu latéral --> <?php include '../include/menu.php'; ?> <div id="conteneur"> <div id="titre"> <h1>Gestion Miss Mandarine</h1> <span id="flecheTitre"></span> </div> <div class="inner"> <div id="recherche"> <form action="#" method="post"> <input type="text" name="recherche" class="medium" placeholder="Recherche" value="<?php echo $recherche ?>" /> <input type="submit" value="" name="addRecherche" id="btnRecherche"/> </form> <div class="clear"></div> </div> <table class="table"> <tr> <th width="80%" class="left">Utilisateur</th> <th width="10%">Message(s)</th> <th width="10%">Lu</th> </tr> <?php /* Liste des messages */ $messages = implode(',',Forum::mandarineMessage($bdd)); if(empty($messages)) $messages = 0; /* Affichage des messages */ $requete = "SELECT utilisateurId, utilisateurNom, utilisateurPrenom, mandarineContenu, mandarineCreated FROM forum_mandarine INNER JOIN utilisateur ON utilisateurId = mandarineUtilisateur WHERE mandarineId IN ($messages) "; if(!empty($recherche)) $requete .= " AND mandarineContenu LIKE '%$recherche%' "; $requete .= "ORDER BY mandarineId DESC LIMIT $debut, 50 "; $sql = $bdd->query($requete); if($sql->rowCount() == 0){ echo'<tr>'; echo'<td colspan="3">Aucun message</td>'; echo'</tr>'; } while($data = $sql->fetchObject()){ $utilisateur = $data->utilisateurId; echo '<tr>'; echo '<td class="left">'; echo '<p class="created">Ajouté le : '.date("d/m/Y",$data->mandarineCreated).'</p>'; echo '<p><strong>'.$data->utilisateurPrenom.' '.$data->utilisateurNom.'</strong></p>'; echo '<p>'.Tool::tronquer($data->mandarineContenu,150).'</p>'; echo '</td>'; echo'<td><a href="'.BASEADMIN.'forum/managerMandarineMessage.php?utilisateur='.$data->utilisateurId.'" class="btn bleu">Afficher</a></td>'; echo'<td>'.Forum::mandarineLu($bdd, $utilisateur).'</td>'; echo'</tr>'; } ?> </table> <div id="navigation"> <?php $requete = "SELECT COUNT(mandarineId) AS total FROM forum_mandarine INNER JOIN utilisateur ON utilisateurId = mandarineUtilisateur WHERE mandarineId IN ($messages) "; if(!empty($recherche)) $requete .= " AND mandarineContenu LIKE '%$recherche%' "; Tool::pagination($requete,'forum/managerMandarine',50,$page,$bdd); ?> </div> </div> </div> </div> <script type="text/javascript" src="<?php echo BASEADMIN ?>js/jquery.js"></script> <script type="text/javascript" src="<?php echo BASEADMIN ?>js/jquery-ui.js"></script> <script type="text/javascript" src="<?php echo BASEADMIN ?>js/script.js"></script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings