Search Form with One or More (Multiple) Parameters

by

This is easiest to do when using PDO, not mysqli, as your database API.

Build the WHERE clause dynamically. My recommended approach is to push each condition onto an array, and then use implode() to concatenate all the conditions, connecting them with AND or OR as is your preference.

$wheres = array();
$params = array();
if (!empty($_GET['id'])) {
    $wheres[] = 'a.uid = :uid';
    $params[':uid'] = $_GET['id'];
}
if (!empty($_GET['major'])) {
    $wheres[] = 'a.major = :major';
    $params[':major'] = $_GET['major'];
}
if (!empty($_GET['name'])) {
    $wheres[] = 'b.name LIKE :name';
    $params[':name'] = '%'.$_GET['name'].'%';
}
// And so on for all parameters

$sql = "SELECT * 
        FROM user_details AS a
        JOIN user AS b ON a.uid = b.id";
if (!empty($wheres)) {
    $sql .= " WHERE " . implode(' AND ', $wheres);
}
$stmt = $db->prepare($sql);
$stmt->execute($params);

Then display the results as in your original code.

while ($student = $stmt->fetch()) {
    ...
}

More Related Contents:

  1. Php if($var) used to work [closed]
  2. How to search by key=>value in a multidimensional array in PHP
  3. PHP Multidimensional Array Searching (Find key by specific value)
  4. Find a matching or closest value in an array
  5. PHP to search within txt file and echo the whole line
  6. Best way to test for a variable’s existence in PHP; isset() is clearly broken
  7. Search for a key in an array, recursively
  8. What’s the difference between ‘isset()’ and ‘!empty()’ in PHP?
  9. How would I skip optional arguments in a function call?
  10. In where shall I use isset() and !empty()
  11. parameters in MySQLi
  12. Delete multiple rows by selecting checkboxes using PHP
  13. PHP check whether property exists in object or class
  14. PHP – include a php file and also send query parameters
  15. PHP Default Function Parameter values, how to ‘pass default value’ for ‘not last’ parameters?
  16. Check if a specific value exists at a specific key in any subarray of a multidimensional array
  17. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  18. PHP Error : Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` [duplicate]
  19. PHP function with variable as default value for a parameter
  20. What is the PHP shorthand for: print var if var exist
  21. PHP: Check if variable exist but also if has a value equal to something
  22. Clean URLs for search query?
  23. Highlight keywords in a paragraph
  24. Check if value isset and null
  25. PDO: Invalid parameter number: mixed named and positional parameters
  26. Bing search API and Azure
  27. How would I implement a simple site search with php and mySQL?
  28. PHP shorthand for isset()? [duplicate]
  29. How to pass parameters from bash to php script?
  30. Is it possible to capture search term from Google search?

Leave a Comment