PHPTS:一键免费搭建 Nginx + PHP + MySQL 运行环境

DocResult::getWarningsCount

(No version information available, might only be in Git)

DocResult::getWarningsCountGet warning count from last operation

说明

public mysql_xdevapi\DocResult::getWarningsCount ( void ) : integer

Returns the number of warnings raised by the last operation. Specifically, these warnings are raised by the MySQL server.

参数

此函数没有参数。

返回值

The number of warnings from the last operation.

范例

Example #1 mysql_xdevapi\DocResult::getWarningsCount() example

<?php
$session 
mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$session->sql("DROP DATABASE IF EXISTS addressbook")->execute();
$session->sql("CREATE DATABASE addressbook")->execute();

$schema $session->getSchema("addressbook");
$create $schema->createCollection("people");

$create->add('{"name": "Alfred", "age": 18, "job": "Butler"}')->execute();
$create->add('{"name": "Reginald", "age": 42, "job": "Butler"}')->execute();

// ...

$collection $schema->getCollection("people");

// Yields a DocResult object
$result $collection
  
->find('job like :job and age > :age')
  ->
bind(['job' => 'Butler''age' => 16])
  ->
sort('age desc')
  ->
execute();

if (!
$result->getWarningsCount()) {
    echo 
"There was an error:\n";
    
print_r($result->getWarnings());
    exit;
}

var_dump($result->fetchOne());
?>

以上例程的输出类似于:

array(4) {
  ["_id"]=>
  string(28) "00005b6b53610000000000000135"
  ["age"]=>
  int(42)
  ["job"]=>
  string(6) "Butler"
  ["name"]=>
  string(8) "Reginald"
}