How can PHP arrays be effectively used to simplify conditional statements for search queries?

When dealing with search queries, conditional statements can become complex and difficult to manage. By using PHP arrays to store search parameters and their corresponding values, we can simplify the conditional statements and make the code more readable and maintainable. 

// Define an array to store search parameters and their values
$searchParams = [
    'keyword' => 'example',
    'category' => 'books',
    'price' => 50,
];

// Loop through the array and construct the search query
$searchQuery = "SELECT * FROM products WHERE 1=1";
foreach ($searchParams as $param => $value) {
    $searchQuery .= " AND $param = '$value'";
}

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

Keywords

PHP arrays conditional statements search queries simplification optimization

Related Questions