Contact me
Pls I need your help, am new in programming and I need you help(guide) sir, contact on [email protected].. Thanks
<?php $conn = new mysqli('localhost', 'root', '', 'db_search'); if(!$conn){ } ?>
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1" /> </head> <body> <nav class="navbar navbar-default"> <div class="container-fluid"> <a class="navbar-brand" href="https://sourcecodester.com">Sourcecodester</a> </div> </nav> <div class="col-md-3"></div> <div class="col-md-6 well"> <h3 class="text-primary">PHP - Simple Search Using Ajax/MySQLi</h3> <hr style="border-top:1px dotted #ccc;"/> <form method="POST"> <div class="form-inline"> <input type="text" id="search_data" class="form-control" placeholder="Search here..."/> <button type="button" id="search" class="btn btn-primary"><span class="glyphicon glyphicon-search"></span> Search</button> <button type="button" id="refresh" class="btn btn-success"><span class="glyphicon glyphicon-refresh"></span></button> </div> </form> <br /><br /> <table class="table table-bordered"> <thead class="alert-success"> <tr> <th>Firstname</th> <th>Lastname</th> <th>Address</th> <th>Gender</th> <th>Age</th> </tr> </thead> <tbody class="alert-warning" id="data"></tbody> </table> </div> </body> <script src="js/jquery-3.2.1.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ DisplayData(); $('#search').on('click', function(){ if($('#search_data').val() == ""){ alert("Please enter something first!"); }else{ var search = $('#search_data').val(); var loader = $('<tr ><td colspan = "5"><center>Searching....</center></td></tr>'); loader.appendTo('#data'); setTimeout(function(){ loader.remove(); $.ajax({ url: 'search.php', type: 'POST', data: { search: search }, success: function(data){ $('#data').html(data); } }); }, 3000); } }); $('#refresh').on('click', function(){ DisplayData(); }); function DisplayData(){ $.ajax({ url: 'data.php', type: 'POST', data: { res: 1 }, success: function(data){ $('#data').html(data); } }); } }); </script> </html>
<?php require_once 'conn.php'; $query = $conn->query("SELECT * FROM `member` ORDER BY `lastname` ASC"); while($fetch = $query->fetch_array()){ echo " <tr> <td>".$fetch['firstname']."</td> <td>".$fetch['lastname']."</td> <td>".$fetch['address']."</td> <td>".$fetch['gender']."</td> <td>".$fetch['age']."</td> </tr> "; } } ?>
<?php require_once 'conn.php'; $search = $_POST['search']; $query = $conn->query("SELECT * FROM `member` WHERE (`lastname` LIKE '%".$search."%') OR (`address` LIKE '%".$search."%') ORDER BY `lastname` ASC"); $rows = $query->num_rows; if($rows > 0){ while($fetch = $query->fetch_array()){ echo " <tr> <td>".$fetch['firstname']."</td> <td>".$fetch['lastname']."</td> <td>".$fetch['address']."</td> <td>".$fetch['gender']."</td> <td>".$fetch['age']."</td> </tr> "; } }else{ echo " <tr> <td colspan='5'><center>No Search Found!</center></td> </tr> "; } } ?>
$(document).ready(function(){ DisplayData(); $('#search').on('click', function(){ if($('#search_data').val() == ""){ alert("Please enter something first!"); }else{ var search = $('#search_data').val(); var loader = $('<tr ><td colspan = "5"><center>Searching....</center></td></tr>'); $('#data').empty(); loader.appendTo('#data'); setTimeout(function(){ loader.remove(); $.ajax({ url: 'search.php', type: 'POST', data: { search: search }, success: function(data){ $('#data').html(data); } }); }, 3000); } }); $('#refresh').on('click', function(){ DisplayData(); }); function DisplayData(){ $.ajax({ url: 'data.php', type: 'POST', data: { res: 1 }, success: function(data){ $('#data').html(data); } }); } });