php - 使用 PHP 从表中的列中选择名称

Question

我正在尝试从我拥有的表中获取业务类型，在上一页上我使用了此代码

$sql = "SELECT * FROM directorydata WHERE CompanyName LIKE :SearchTerm ORDER BY CompanyName ";

但是，这依赖于搜索词，我只想使用 foreach 循环输出类型列表。有几个业务具有相同的业务类型，我不希望输出两次。

这是我的旧 foreach 循环(如果有帮助的话)，尽管这不会改变任何东西

if ($stmt->rowcount() > 0) {
    foreach($stmt as $row) {
        $ResultsCounter++;
        $htmlResult .=  "<div class='col-md-6 well' style='margin'>" .
                            "<h4>". $row['CompanyName'] . "</h4>" .
                            "<p><strong><a href='/" . $row['UrlAlias'] .".htm'>" . $phoneDirectory->formatPhoneNumber($row['Number1']) ."</a></strong></p>" .
                        "</div>"; 

        if ($ResultsCounter == 8){
            $htmlResult .=  "<div class=''><a class='collapse-btn' href='#'>See more results</a><div class='span4 collapse-group'><div class='collapse'>"; 
        }
    }

    if ($stmt->rowcount() >= 8) $htmlResult .=  "</div></div></div>"; 


} else{
        $htmlResult .= "<h1 class='text-center'>Sorry no search results found please search again</h1>";
}
}

这里有什么帮助吗？

Answer 1

使用按类型分组或不同类型

$sql = "SELECT * FROM directorydata
WHERE CompanyName LIKE :SearchTerm 
GROUP BY type
ORDER BY CompanyName ";

或不同

$sql = "SELECT DISTINCT type FROM directorydata
WHERE CompanyName LIKE :SearchTerm 
ORDER BY CompanyName ";