php - How do I get desired value if no entry is found in the database

Question

I have 2 columns in a table. 'phrase' and 'count'.

if($conn->connect_error){
echo 'Connection Faild: '.$conn->connect_error;
}
else{
    $just_str = 'ghsfghffgh';
    $sql="select * from dbtest where phrase like '%$just_str%'";

    $res=$conn->query($sql);

    while($row=$res->fetch_assoc()){
        $jso = $row["count"];
        
        
        }    

    }
exit(json_encode(array("name"=>$jso)));

I want it to return "Not found" as JSON response if there is no such entry in the database.

Note: $just_str variable is user input.

question from:https://stackoverflow.com/questions/65905949/how-do-i-get-desired-value-if-no-entry-is-found-in-the-database

Answer 1

Since you only get one value, you don't need a loop. So just check whether any row is returned.

$row = $res->fetch_assoc();
if ($row) {
    $jso = $row['count'];
} else {
    $jso = 'Not found';
}