PHP mysqli_get_warnings() Function

---

---

Definition and Usage

If your last MySQLi function call executes MySQL query and if it generates any errors. The mysqli_get_warnings() function returns the errors generated by the last executed query, in the form of an array.

Syntax

mysqli_get_warnings($con)

Parameters

Return Values

PHP mysqli_get_warnings() function returns an array that contains the warnings generated during the execution of last query.

PHP Version

This function was first introduced in PHP Version 5 and works works in all the later versions.

Assume we have created a table named Emp as follows −

CREATE TABLE EMP(
   ID TINYINT,
   First_Name VARCHAR(50) Not NULL, 
   Last_Name VARCHAR(10) Not NULL, 
   Date_Of_Birth date, 
   Salary Int(255)
);

Example

Following example demonstrates the usage of the mysqli_get_warnings() function (in procedural style) −

This will produce following result −

Warning(s):
mysqli_warning Object
(
    [message] => Column 'Last_Name' cannot be null
    [sqlstate] => HY000
    [errno] => 1048
)

Warning(s): mysqli_warning Object
(
    [message] => Data truncated for column 'Last_Name' at row 1
    [sqlstate] => HY000
    [errno] => 1265
)

Example

Following is another example of the function mysqli_get_warnings() −

This will produce following result −

Warning(s):
mysqli_warning Object
(
    [message] => Unknown table 'mydb.wrongtable'
    [sqlstate] => HY000
    [errno] => 1051
)

Example

You can also retrieve warnings one by one using the next() function of the mysqli_warning class as follows $minus;

 query("INSERT IGNORE into emp values(105, NULL, 'Yellapragada', DATE('1981-12-05'), 2566)");

   if($con->warning_count){
      $w = mysqli_get_warnings($con);
      do {
         echo "Warning: $w->errno: $w->message\n";
      } while ($w->next());
   }

   //Closing the connection
   $con -> close();
?>

This will produce following result −

Warning: 1048: Column 'First_Name' cannot be null
Warning: 1265: Data truncated for column 'Last_Name' at row 1

Example

real_connect($servername, $username, $password, $dbname)) {
      die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());
   }
   print("Database connected" ."\n");
   mysqli_query($conn, "CREATE TABLE sample (ID INT, Name VARCHAR(20))");
   $query = "INSERT IGNORE INTO sample (id,name) VALUES(
      1,'Rajesh Ramayan Kootrapally')";

   mysqli_query($conn, $query);
   $count = mysqli_warning_count($conn);
   print("No.Of warnings in the query:".$count."\n");

   if ($count) {
      $warnings = mysqli_get_warnings($conn);
	  print_r($warnings);
   }
   mysqli_close($conn);
   
?>

This will produce following result −

Database connected
No.Of warnings in the query:1
mysqli_warning Object
(
    [message] => Data truncated for column 'Name' at row 1
    [sqlstate] => HY000
    [errno] => 1265
)