如果未找到任何记录，则返回默认值

Question

I have this PHP code that selects one simple value:

$name = $mysqli->query('SELECT name FROM users WHERE id = ' . $id . ' LIMIT 1')->fetch_object()->name;

Now if the result is 0, it throws an error.

I want instead to return a default value like "No name" if there are no results.

Any suggestions?

Answer 1

Don't fetch the name directly, instead check, if there is data in it first. Something like this should work:

$result = $mysqli->query('SELECT name FROM users WHERE id = ' . $id . ' LIMIT 1')->fetch_object();

$name = (!$result) ? 'No name' : $result->name;

Additional, as @RiggsFolly mentioned, it is suggested to use prepared statements, to reduce SQL possibilities:

$stmt = $mysqli->prepare("SELECT name FROM users WHERE id = ? LIMIT 1");
$stmt->bind_param('i',$id);
$stmt->execute();
$result = $stmt->get_result()->fetch_object();