Advertisement
Guest User

Untitled

a guest
Feb 13th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. <?php
  2.  
  3. if(isset($_POST['search'])){
  4. $valueToSearch = $_POST['valueToSearch'];
  5. $query = "SELECT * FROM `ini` WHERE CONCAT(`id`, `fname`, `lname`, `age`) LIKE '%".$valueToSearch."%'";
  6. $search_result = filterTable($query);
  7. }
  8.  
  9. else {
  10. $query = "SELECT * FROM `ini` ORDER BY id";
  11. $search_result = filterTable($query);
  12. }
  13.  
  14. function filterTable($query){
  15. $connect = mysqli_connect("localhost", "lesfugit_me", "ledzep1970", "lesfugit_test");
  16. $filter_Result = mysqli_query($connect, $query);
  17. return $filter_Result;
  18. }
  19.  
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement