0x1998 - MANAGER
Edit File: aj_listeuser.php
<script> $(document).ready(function(){ $('#tableUSER').dataTable({ searching: true, "columnDefs": [ { "targets": [ 0 ], "visible": false, "searchable": false } ], "order": [[ 0, 'asc' ]], "bStateSave": false, "language": { "search":"Rechercher", "lengthMenu": "Afficher _MENU_ enregistrements par page", "zeroRecords": "Pas de résultat", "info": "page _PAGE_ de _PAGES_", "infoEmpty": "Pas de réponse", "infoFiltered": "(fitré depuis _MAX_ utilisateurs)", "paginate": { "first": "Première", "last": "Dernière", "next": ">", "previous": "<" }, } }); }); </script> <?php include "config/auth-config.php"; include "config/authcheck.php"; include "config/garde.php"; $requete="select nom, name, niveau, email, ".PREF."users.id from ".PREF."users, user_type where ".PREF."users.id=user_type.id and block=0"; $sql=mysqli_query($link,$requete) or die("erreur"); echo " <table class=\"table table-bordered order-column\" id=\"tableUSER\"> <thead><tr>"; for ($i=0;$i<=3;$i++) { echo "<th>".strtoupper(mysqli_field_name($sql,$i))."</th>"; } echo " </thead></tr></tbody>"; while ($corps=mysqli_fetch_array($sql)) { echo " <tr ondblclick=\"load('user','".$corps[4]."')\">"; for ($i=0;$i<=3;$i++) { echo " <td>".$corps[$i]."</span></td>"; } echo " </tr>"; } echo " </tbody></table>"; ?>