PHP中MySQL多条件表单查询问题：仅返回全匹配结果

Hey there! Sounds like you're hitting a classic query logic snag where your dual conditions are returning separate results instead of the overlapping set you want. Let's break this down and get it fixed step by step.

The Likely Root Cause #

Your issue almost certainly stems from one of two scenarios:

• You're using OR instead of AND to connect your two conditions (which pulls in rows that match either condition, not both), or
• Your code is executing two separate queries (one for the city, one for plowtruck) and returning both result sets instead of combining them into a single targeted query.

The Fix: Combine Conditions with AND #

To get only rows that meet both criteria, you need to craft a single query that uses AND to link your two conditions. Here's what that looks like in SQL:

SELECT * FROM your_table_name
WHERE city = 'user_input_city'
AND plowtruck = 'user_plowtruck_condition';

This query will only return rows where both the city matches your input and the plowtruck column meets your second requirement—exactly the single result table you're aiming for.

Example Code Adjustment #

If your code was previously running two separate queries (like the pseudo-code below), that's why you're getting two distinct result tables:

# ❌ Old approach: Two separate queries returning two results
city_query = "SELECT * FROM your_table WHERE city = %s"
city_results = cursor.execute(city_query, (user_city,))

plow_query = "SELECT * FROM your_table WHERE plowtruck = %s"
plow_results = cursor.execute(plow_query, (user_plow_input,))

return [city_results, plow_results]  # Returns two separate tables

Update it to run one combined query instead:

# ✅ New approach: Single query returning one combined result
combined_query = "SELECT * FROM your_table WHERE city = %s AND plowtruck = %s"
combined_results = cursor.execute(combined_query, (user_city, user_plow_input))

return combined_results  # Returns one table with rows matching both conditions

Quick Validation Checks #

• Double-check that the plowtruck column exists in your table and that your input matches the data type stored there (e.g., if it's a boolean, don't pass a string like "active" unless that's how the values are stored).
• Confirm there are actually rows in your table that meet both conditions—if there aren't, you'll get an empty result set, which is expected behavior!

内容的提问来源于stack exchange，提问作者codEinstein