douao3063
2019-04-26 22:57
浏览 28
已采纳

php pdo属性数组

---property---
id | ozellik
1  | "random"
2  | "fast"
3  | "red"
-----------

----property_cafe--------
id | cafe_id | property_id
1  | 1       |  1   
2  | 1       |  2
3  | 1       |  3
-----------------------

---cafe---
id | name
1  | lorem
-----------------

property.id = property_cafe.property_id
cafe.id = property_cafe.cafe_id 

Checkbox select 1,2,3. I want to see the feature of cafes with the feature of 1,2,3 id.

I can create a separate query, but I have unlimited feature table close to 100, I could not find a solution.

图片转代码服务由CSDN问答提供 功能建议

  --- property --- 
id |  ozellik 
1 |  “随机”
2 |  “快”
3 |  “red”
 ----------- 
 
 ---- property_cafe -------- 
id |  cafe_id |  property_id 
1 |  1 |  1 
2 |  1 |  2 
3 |  1 |  3 
 ----------------------- 
 
 --- cafe --- 
id | 名称
1 |  lorem 
 ----------------- 
 
property.id = property_cafe.property_id 
cafe.id = property_cafe.cafe_id 
   
  
 

复选框选择1,2,3。 我希望看到具有1,2,3 id特征的咖啡馆的功能。

我可以创建一个单独的查询,但我有无限的功能表接近100,我不能 找到解决方案。

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dragon7713 2019-04-26 23:17
    已采纳

    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

    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题