array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'uk', ), 'this' => array ( 0 => 'pdo-mysql.getwarningcount.php', 1 => 'Pdo\\Mysql::getWarningCount', 2 => 'Returns the number of warnings from the last executed query', ), 'up' => array ( 0 => 'class.pdo-mysql.php', 1 => 'Pdo\\Mysql', ), 'prev' => array ( 0 => 'class.pdo-mysql.php', 1 => 'Pdo\\Mysql', ), 'next' => array ( 0 => 'ref.pdo-sqlsrv.php', 1 => 'MS SQL Server PDO Driver', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/pdo_mysql/pdo/mysql/getwarningcount.xml', ), 'history' => array ( ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); contributors($setup); ?>

Pdo\Mysql::getWarningCount

(PHP 8 >= 8.4.0)

Pdo\Mysql::getWarningCount — Returns the number of warnings from the last executed query

Опис

public Pdo\Mysql::getWarningCount(): int

Returns the number of warnings from the last executed query.

Зауваження: For retrieving warning messages the following SQL command can be used: SHOW WARNINGS [limit row_count].

Параметри

У цієї функції немає параметрів.

Значення, що повертаються

Returns an int representing the number of warnings generated by the last query.

Приклади

Приклад #1 Pdo\Mysql::getWarningCount() example

<?php

$conn = PDO::connect("mysql:host=localhost;dbname=test;charset=utf8mb4", 'user', 'password');

$conn->query('SELECT 42/0');
if ($conn->getWarningCount() > 0) {
$result = $conn->query("SHOW WARNINGS");
$row = $result->fetch();
printf("%s (%d): %s\n", $row[0], $row[1], $row[2]);
}

?>

Поданий вище приклад виведе:

Warning (1365): Division by 0