English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية

Tutoriel PHP de base

Tutoriel PHP avancé

PHP & MySQL

Manuel de référence PHP

Utilisation et exemple de la fonction PHP mysqli_get_warnings()

    PHP MySQLi Reference Manual

La fonction mysqli_get_warnings() retourne les erreurs générées par la dernière requête exécutée.

Définition et utilisation

Si votre dernière appel de fonction MySQLi exécute une requête MySQL et génère des erreurs.mysqli_get_warnings()La fonction retourne sous forme de tableau les erreurs générées par la dernière requête exécutée.

Syntaxe

mysqli_get_warnings($con)

Paramètre

NuméroParamètres et description
1

con (obligatoire)

C'est un objet représentant la connexion au serveur MySQL.

Valeur de retour

La fonction PHP mysqli_get_warnings() retourne un tableau contenant les avertissements générés pendant l'exécution de la dernière requête.

Version PHP

Cette fonction a été introduite dans la version PHP5introduit et peut être utilisé dans toutes les versions supérieures.

Supposons que nous ayons créé une table nommée Emp, comme suit :

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

Online example

L'exemple suivant montremysqli_get_warnings()Utilisation de la fonction (style procédural)-

<?php
   //Establishing connection
   $con = mysqli_connect("localhost", "root", "password", "mydb");
   //Inserting record into employee table
   $sql = "INSERT IGNORE into emp values(1, 'Sanjay', NULL, DATE('1981-12-05', 2566)
   mysqli_query($con, $sql);
   //Avertissements
   $warnings = mysqli_get_warnings($con);
   print("Avertissement(s): "."
");
   print_r($warnings);
   $sql = "INSERT IGNORE into emp values (15, 'Swetha', 'Yellapragada', DATE('1990-11-25', 9986), (15, NULL, 'Prayaga', DATE('1990-11-25', 9986)
   mysqli_query($con, $sql);
   //Avertissements
   $warnings = mysqli_get_warnings($con);
   print("\n"."Warning(s): ");
   print_r($warnings);
   //关闭连接
   mysqli_close($con);
?>

Output 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
)

Online example

Here is the functionmysqli_get_warnings()Another example-

<?php
   //Establishing connection
   $con = mysqli_connect("localhost", "root", "password", "mydb");
   //Deleting unknown table
   mysqli_query($con, "drop table if exists WrongTable");
   print("\n"."Warning(s): "."\n");
   print_r(mysqli_get_warnings($con));
   //关闭连接
   mysqli_close($con);
?>

Output result

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

Online example

You can also use the mysqli_warning classnext()Functions retrieve warnings one by one as shown below:

<?php
   //Establishing connection
   $con = new mysqli("localhost", "root", "password", "mydb");
   //Inserting record into employee table
   $con -> 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());
   }
   //关闭连接
   $con -> close();
?>

Output result

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

Online example

Return the error produced by the last executed query

<?php
   $servername = "localhost";
   $username = "root";
   $password = "password";
   $dbname = "mydb";
   $conn = new mysqli($servername, $username, $password, $dbname);
   if (!$conn->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);
   
?>

Output 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
)

PHP MySQLi Reference Manual