too long

Question

How can I echo empty array to frontend although the table doesn't have any records?

$result = mysqli_query($conn, "SELECT * FROM person");

while($res = mysqli_fetch_assoc($result)) {

    $row = array(
        'fname' => $res['fname']
    );

    $encoded[] = $row;
}

//$encoded ? echo json_encode($encoded); : echo array();

Answer 1

Initialize an empty array at the beginning of your code:

$encoded = array();
$result = mysqli_query($conn, "SELECT * FROM person");

while ($res = mysqli_fetch_assoc($result)) {
    $encoded[] = array('fname' => $res['fname']);
}

echo json_encode($encoded);

If no results have been found, this will outout [].