Home  >  Article  >  Backend Development  >  How to obtain php mysqli error information

How to obtain php mysqli error information

藏色散人
藏色散人Original
2022-01-26 09:18:503018browse

In PHP, you can use the mysqli_error() function to return the last error description of the recently called function. The syntax is "mysqli_error(connection);". The parameter connection specifies the MySQL connection to be used.

How to obtain php mysqli error information

The operating environment of this article: Windows 7 system, PHP version 7.1, DELL G3 computer

How to obtain the php mysqli error message?

mysqli_error() function returns the last error description of the most recently called function.

Syntax

mysqli_error(connection);

Parameters

connection required. Specifies the MySQL connection to use.

Return value: Returns a string with an error description. Returns "" if no error occurred.

Example

Return the last error description of the recently called function:

<?php 
// 假定数据库用户名:root,密码:123456,数据库:RUNOOB 
$con=mysqli_connect("localhost","root","123456","RUNOOB"); 
if (mysqli_connect_errno($con)) 
{ 
    echo "连接 MySQL 失败: " . mysqli_connect_error(); 
} 
// 执行查询,检查错误
if (!mysqli_query($con,"INSERT INTO websites (name) VALUES (&#39;菜鸟教程&#39;)"))
{
    echo("错误描述: " . mysqli_error($con));
}
mysqli_close($con);
?>

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to obtain php mysqli error information. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn