如何显示找到的搜索结果数 - How to display number of search results found

How to display number of search results found

本文关键字：搜索结果何显示显示 | 更新日期: 2023-09-27

这是我的代码。搜索时如何输出数字结果谢谢

if(isset($_GET['search'])) {
$search_value= $_GET['searchbox'];

//$sql="SELECT idemp,sn FROM employee 
/    /WHERE idemp like '%$search_value%' OR
//sn like '%$search_value%'";
$sql = "SELECT * from application where (leave_id like '%$search_value%' OR id_no like                 '%$search_value%' OR type_of_leave like '%$search_value%' OR date_of_filing like '%$search_value%')";
       $result = $conn->query($sql);
       if ($result->num_rows > 0) {
         echo "Search results for '$search_value'";
       print "<br><br>";
       while ($row = $result->fetch_array()) {
.....
      close();
};

您可以通过以下方式显示总结果：

echo mysqli_num_rows($result);

或

echo $result->num_rows;