Advertisement
Alkhammash

Untitled

Dec 19th, 2014
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.04 KB | None | 0 0
  1. <?php
  2.  
  3. include 'includes/connection.php';
  4.  
  5. $data = '';
  6.  
  7.   if(isset($_POST['search']))
  8.  
  9.   {
  10.       $var = $_POST['search'];
  11.       if($query = mysql_query("SELECT userid,username,firstname,surname,email,password from users where userid LIKE '%$var%' or firstname LIKE '%$var%' or surname LIKE '%$var%' or email LIKE '%$var%' or username LIKE '%$var'"))
  12.       {
  13.           while($d = mysql_fetch_array($query))
  14.           {
  15.               $data = $data . '<div>' . 'ID:&nbsp;'. $d['userid'] . '<br>'. 'Username:&nbsp;'.$d['username']. '<br>'. 'Firstname:&nbsp;' . $d['firstname'] . '<br>' . 'Surname:&nbsp;' . $d['surname'] . '<br>' . 'Email:&nbsp;' . $d['email'] . '</div>';
  16.           }
  17.           echo $data;
  18.       }
  19.   }else {
  20.  
  21. ?>
  22.  
  23. <html>
  24. <head>
  25. <meta charset="utf-8">
  26.     <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  27.     <meta name="viewport" content="width=device-width, initial-scale=1">
  28.  
  29. <script src="//code.jquery.com/jquery-1.10.2.min.js"></script>
  30. <script type="text/javascript">
  31.       $(function(){
  32.           $('.input').keyup(function(){
  33.               var a = $('.input').val();
  34.               $.post('admin-user-search.php',{"search":a},function(data){
  35.                   $('#display').html(data);
  36.               });
  37.           });
  38.       });
  39.  
  40.  
  41. </script>
  42. <title>Admin User search</title>
  43. <link href="CSS/photoshoot-admin.css" rel="stylesheet" type="text/css" />
  44.  
  45. </head>
  46. <body>
  47.  
  48. <div class="group" align="center">
  49.     <div class="left">
  50.     <h1 align="center" style="color:#c00; font-size:45px;">One place to store everything in your life</h1>
  51.    
  52.     <img src="Images/Logo.jpg" />                  
  53.     </div>
  54.     <div class="right">
  55.     <span style="padding-left:900px;"><a href="admin-logout.php">Logout</a></span>
  56. <span style="padding-left:20px;"><a href="admin-user-details.php">Back</a></span>
  57. <div>
  58. <span><h3>Search User Details Table</h3></span>
  59.      <form action="admin-user-search.php" method="post">
  60.      Enter Query:<input type="text" name="search" class="input" />
  61.      </form></div>
  62.      <div id="display" style="margin-top:30px;"></div>
  63.  
  64.     </div>
  65. </div>
  66.  
  67. </body>
  68.  
  69. </html>
  70.  
  71. <?php } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement