PHP find out student record using functions

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?

´return 0;´ and then use a if sentence to determine the record? or, return "No record found"; — Epodax
– Epodax, Commented Nov 10, 2015 at 12:10

jmattheis · Accepted Answer · 2015-11-10 12:12:21Z

2

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";
}

answered Nov 10, 2015 at 12:12

jmattheis

11.2k12 gold badges52 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

maxhb · Accepted Answer · 2015-11-10 12:25:03Z

2

I would not change your function. It returns an array (may be empty) in any case wich is quite consistent.

Instead look at the number of array items returned:

$record = findStudentRecord();
//[HERE]
if(count($record) == 0) {
  echo "No record found";
} else {
  // what ever
}

answered Nov 10, 2015 at 12:25

maxhb

8,8939 gold badges35 silver badges56 bronze badges

Collectives™ on Stack Overflow

PHP find out student record using functions

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related