PHP mysqli_errno() Function
In this chapter you will learn:
- Definition for PHP mysqli_errno() Function
- Syntax for PHP mysqli_errno() Function
- Parameter for PHP mysqli_errno() Function
- Return for PHP mysqli_errno() Function
- Example - Get the last error code for the most recent function call
Definition
The mysqli_errno() function returns the last error code for the most recent function call.
Syntax
PHP mysqli_errno() Function has the following syntax.
mysqli_errno(connection);
Parameter
Parameter | Is Required | Description |
---|---|---|
connection | Required. | MySQL connection |
Return
It returns an error code value or Zero if no error occurred.
Example
Get the last error code for the most recent function call.
<?php/*jav a 2s . c om*/
$con=mysqli_connect("localhost","my_user","my_password","my_db");
if (mysqli_connect_errno($con)){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// Perform a query, check for error
if (!mysqli_query($con,"INSERT INTO Persons (FirstName) VALUES ('Jack')")){
echo("Errorcode: " . mysqli_errno($con));
}
mysqli_close($con);
?>
Next chapter...
What you will learn in the next chapter:
- Definition for PHP mysqli_error() Function
- Syntax for PHP mysqli_error() Function
- Parameter for PHP mysqli_error() Function
- Return for PHP mysqli_error() Function
- Example - Get the last error for the most recent function call
Home » PHP Tutorial » PHP MySQLi Functions