如何按类别分开搜索结果? MySQL + PHP [英] How separate search results by category? MySQL + PHP

问题描述

我没有得到任何有效的代码.当然，我可能会误用，因为我是一个初学者.一些告诉我使用MySQL子查询，其他告诉我使用PHP foreach实现它. 我想要的是显示按类别组分开的关键字的搜索结果，诸如此类:

I didn't get any code that worked. Of course I could have use then wrongly because I'm a beginner. Some told me to use MySQL subqueries other told me to use PHP foreach achieve it. What I want is to show the search results of a keyword separated by groups of categories, something like that:

针对 Item 的搜索结果，分为2个类别，共有3个迭代:

Search results for Item, 3 itens in 2 categories:

• 项目1003

有人可以向我解释得尽可能简单吗?
谢谢你提前！

Can someone explain me it as simple as possible.
Thanks n advance!

推荐答案

我使用单个请求，该请求返回每个项目的类别名称，并使用PHP进行显示

I use a single request which return name of category for each item and I use PHP to display it

<?php
    $cat;
    while($result = $statement->fetch()) {
        if($result['cat'] !== $cat) {
            $cat = $result['cat'];
            /* display cat */
        }
        /* display items */
    }
?>

这篇关于如何按类别分开搜索结果? MySQL + PHP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！