How can a checkbox be used in PHP to refine search results in a MySQL database?

To refine search results in a MySQL database using checkboxes in PHP, you can create a form with checkboxes representing different search criteria. When the form is submitted, you can construct a SQL query based on the selected checkboxes to filter the search results accordingly. This allows users to easily narrow down their search results based on their preferences. 

<?php
// Assuming you have a form with checkboxes for refining search results
// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check if form is submitted
if(isset($_POST['submit'])){
    // Initialize an empty array to store selected checkboxes
    $selectedCheckboxes = array();

    // Loop through each checkbox value and add to the array if checked
    foreach($_POST['checkbox'] as $checkbox){
        $selectedCheckboxes[] = $checkbox;
    }

    // Construct SQL query based on selected checkboxes
    $query = "SELECT * FROM table_name WHERE column_name IN ('" . implode("','", $selectedCheckboxes) . "')";

    // Execute the query
    $result = mysqli_query($connection, $query);

    // Display search results
    while($row = mysqli_fetch_assoc($result)){
        // Display search results here
    }

    // Close database connection
    mysqli_close($connection);
}
?>

<!-- Example HTML form with checkboxes -->
<form method="post" action="">
    <input type="checkbox" name="checkbox[]" value="checkbox_value1"> Checkbox 1
    <input type="checkbox" name="checkbox[]" value="checkbox_value2"> Checkbox 2
    <input type="checkbox" name="checkbox[]" value="checkbox_value3"> Checkbox 3
    <input type="submit" name="submit" value="Search">
</form>

Keywords

checkbox PHP MySQL search results refine

Related Questions