1. <?php
  2. include('../auth.php');
  3. if($_SESSION["userdata"]["acces"] != 4){
  4. header("Loaction: ../home");
  5. }
  6. ?>
  8. <!DOCTYPE html>
  9. <html>
  10. <head>
  11. <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
  13. <title>Usersuche Test</title>
  15. <script type="text/javascript" src="https://code.jquery.com/jquery-2.2.3.min.js"></script>
  17. </head>
  18. <script type="text/javascript">
  19. $(function(){
  20. $('#search').keyup(function() {
  21. if($(this).val().length > 0) {
  22. $.get("search.php", {search: $(this).val()}, function(data) {
  23. $("#results").html(data);
  24. });
  25. }
  26. });
  27. });
  28. </script>
  29. <body>
  30. <form action="">
  31. <fieldset>
  32. <label for="filter">User: </label>
  33. <input type="text" name="search" id="search" />
  34. </fieldset>
  35. </form>
  36. <?php
  37. require_once('../db.connect.php');
  38. if($_GET['search'])
  39. $sql = mysqli_query($DBCONN, "SELECT * FROM users ORDER BY username ASC;");
  40. else
  41. $sql = mysqli_query($DBCONN, "SELECT * FROM users WHERE username LIKE '%" . $_GET['search'] . "%'
  42. ORDER BY name ASC;");
  43. while($row = mysqli_fetch_object($sql)) {
  44. echo "<br />".$row->name;
  45. }
  46. ?>
  47. <div id="results"></div>
  48. </body>
  49. </html>