Create the query with WHERE property.id IN (?, ?, ?, ...)
, where you build the list of question marks dynamically from the size of the array of checkbox values.
$where_count = count($_POST['property']);
$questions = '?' . str_repeat(', ?', $where_count-1);
$sql = "SELECT c.name, GROUP_CONCAT(p.ozellik) AS ozellik
FROM cafe AS c
JOIN property_cafe AS pc ON pc.cafe_id = c.id
JOIN property AS p ON pc.property_id = p.id
WHERE p.id IN ($questions)
GROUP BY c.id
HAVING COUNT(*) = ?";
$stmt = $pdo->prepare($sql);
$params = $_POST['property'];
$params[] = $where_count;
$stmt->execute($params);
Passing an array to $stmt->execute()
uses the elements to fill in the ?
placeholders in the SQL.
See How to return rows that have the same column values in MySql for various ways to write a query to find all the cafes that have all the properties. This is the simplest for making this dynamic SQL.
This assumes your checkboxes are written like:
<input type="checkbox" name="property[]" value="1"> Random
<input type="checkbox" name="property[]" value="2"> Fast
<input type="checkbox" name="property[]" value="3"> Red
DEMO