Sometimes, we want to display errors for my MySQLi query with PHP.
In this article, we’ll look at how to display errors for my MySQLi query with PHP.
How to display errors for my MySQLi query with PHP?
To display errors for my MySQLi query with PHP, we use the mysqli_error
function.
For instance, we write
$sql = "...";
($result = mysqli_query($conn, $sql)) or
trigger_error(
"Query Failed! SQL: $sql - Error: " . mysqli_error($conn),
E_USER_ERROR
);
to call mysqli_query
to make the $sql
query.
We add
or
trigger_error(
"Query Failed! SQL: $sql - Error: " . mysqli_error($conn),
E_USER_ERROR
);
to trigger an error if there’s an error.
And we call mysqli_error
with $conn
to get the error.
Conclusion
To display errors for my MySQLi query with PHP, we use the mysqli_error
function.