Folks,
Can you clear some confusions for me ?
Thanks!
On these following 2, which one’s error lines are incorrect and why ?
1
““
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
$conn = mysqli_connect(“localhost”,”root”,””,”buzz”); //mysqli_connect(“server”,”user”,”password”,”db”);
$input_1 = ‘mogambo’; //username.
$input_2 = ‘[email protected]’; //email.
$input_3 = ‘0’; //id.
$sql = “UPDATE users SET username=?,email=? WHERE id=?”;
if(!$stmt = mysqli_prepare($conn,$sql))
{
echo ‘Mysqli Stmt Error: ‘ .mysqli_stmt_error();
echo ‘<br>’;
echo ‘Mysqli Stmt Error No: ‘ .mysqli_stmt_errno();
}
2
““
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
$conn = mysqli_connect(“localhost”,”root”,””,”buzz”); //mysqli_connect(“server”,”user”,”password”,”db”);
$input_1 = ‘mogambo’; //username.
$input_2 = ‘[email protected]’; //email.
$input_3 = ‘0’; //id.
$sql = “UPDATE users SET username=?,email=? WHERE id=?”;
if(!$stmt = mysqli_prepare($conn,$sql))
{
echo ‘Mysqli Error: ‘ .mysqli_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_errno();
}
Can you spot the difference between the 2 error codes ?