PHP使用函数查找学生记录

Question

• Table: student
  

• student.php

  <?php
  function findStudentRecord()
  {
        //Db connection
  
        $q1 = "select * from student where gender = 'F'";
        $r1 = mysqli_query($dbc, $q1);
        $total_records = mysqli_num_rows($r1);
  
        $record = array();
        if($total_records > 0)
        {
            while($row1 = mysqli_fetch_array($r1, MYSQLI_ASSOC))
            {
                $record[] = $row1;
            }
        }
        else
        {
            //[HERE]
        }
  
        return $record;
  }
  
  $record = findStudentRecord();
  //[HERE]
  ?>
  

• I want to find female student record but there is no record from my database. How do I return 0 value from function and display "No record found" on my web page in [HERE] section?

Answer 1

if($total_records > 0)

add no else block so it will return an empty array now you can do something like this

$records = findStudentRecord();
if(count($records) === 0) {
    echo "No record found";
}