PHP Tutorial - PHP mysqli_error() Function






Definition

The mysqli_error() function returns the last error for the most recent function call.

Syntax

PHP mysqli_error() Function has the following syntax.

mysqli_error(connection);

Parameter

ParameterIs RequiredDescription
connectionRequired.MySQL connection

Return

A string that describes the error. An empty string if no error occurred.

Example

Get the last error for the most recent function call


<?php/*from www. 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("Error description: " . mysqli_error($con));
}

mysqli_close($con);
?>