English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية
La fonction mysqli_get_warnings() retourne les erreurs générées par la dernière requête exécutée.
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.
mysqli_get_warnings($con)
Numéro | Paramètres et description |
---|---|
1 | con (obligatoire) C'est un objet représentant la connexion au serveur MySQL. |
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.
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) );
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 )
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 )
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
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 )