将msqli预处理语句的输出作为PHP中的变量获取

Question

I am beginning using prepared statements:

($stmt = $db->prepare('SELECT email FROM users WHERE token=?'))
|| fail('MySQL prepare', $db->error);
$stmt->bind_param('s', $token)
|| fail('MySQL bind_param', $db->error);
$stmt->execute()
|| fail('MySQL execute', $db->error);
$stmt->close();

The statement returns an email address, and I was wondering if it is possible to convert the desired email address into a string for further use in PHP? Which is the best way to do this?

Thanks.

Answer 1

$stmt->bind_result($email);
$stmt->fetch();
echo $email;