How can a search form be created in PHP to allow users to select specific table fields to search through?

To create a search form in PHP that allows users to select specific table fields to search through, you can use a combination of HTML form elements and PHP code to dynamically generate the SQL query based on the user's selections. The form should include dropdown menus for selecting the table fields and a text input for the search term. In the PHP code, you can retrieve the user's selections using $_POST, construct the SQL query dynamically, and execute the query to fetch the results. 

<form method="post" action="">
    <select name="field">
        <option value="field1">Field 1</option>
        <option value="field2">Field 2</option>
        <option value="field3">Field 3</option>
    </select>
    <input type="text" name="search_term">
    <input type="submit" value="Search">
</form>

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $field = $_POST['field'];
    $search_term = $_POST['search_term'];

    // Construct the SQL query based on user's selections
    $sql = "SELECT * FROM your_table WHERE $field LIKE '%$search_term%'";

    // Execute the query and fetch the results
    // Replace $pdo with your database connection variable
    $stmt = $pdo->query($sql);
    $results = $stmt->fetchAll();

    // Display the results
    foreach ($results as $row) {
        // Output the results as needed
    }
}
?>

Keywords

PHP search form table fields user input SQL query.

Related Questions