Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include 'includes/connection.php';
- $data = '';
- if(isset($_POST['search']))
- {
- $var = $_POST['search'];
- 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'"))
- {
- while($d = mysql_fetch_array($query))
- {
- $data = $data . '<div>' . 'ID: '. $d['userid'] . '<br>'. 'Username: '.$d['username']. '<br>'. 'Firstname: ' . $d['firstname'] . '<br>' . 'Surname: ' . $d['surname'] . '<br>' . 'Email: ' . $d['email'] . '</div>';
- }
- echo $data;
- }
- }else {
- ?>
- <html>
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge" />
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <script src="//code.jquery.com/jquery-1.10.2.min.js"></script>
- <script type="text/javascript">
- $(function(){
- $('.input').keyup(function(){
- var a = $('.input').val();
- $.post('admin-user-search.php',{"search":a},function(data){
- $('#display').html(data);
- });
- });
- });
- </script>
- <title>Admin User search</title>
- <link href="CSS/photoshoot-admin.css" rel="stylesheet" type="text/css" />
- </head>
- <body>
- <div class="group" align="center">
- <div class="left">
- <h1 align="center" style="color:#c00; font-size:45px;">One place to store everything in your life</h1>
- <img src="Images/Logo.jpg" />
- </div>
- <div class="right">
- <span style="padding-left:900px;"><a href="admin-logout.php">Logout</a></span>
- <span style="padding-left:20px;"><a href="admin-user-details.php">Back</a></span>
- <div>
- <span><h3>Search User Details Table</h3></span>
- <form action="admin-user-search.php" method="post">
- Enter Query:<input type="text" name="search" class="input" />
- </form></div>
- <div id="display" style="margin-top:30px;"></div>
- </div>
- </div>
- </body>
- </html>
- <?php } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement