PHPKonf 2020 Online

Collection::count

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

Collection::countGet document count

Descrierea

public mysql_xdevapi\Collection::count ( ) : int

This functionality is similar to a SELECT COUNT(*) SQL operation against the MySQL server for the current schema and collection. In other words, it counts the number of documents in the collection.

Parametri

Această funcție nu are parametri.

Valorile întoarse

The number of documents in the collection.

Exemple

Example #1 mysql_xdevapi\Collection::count() 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");

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

$result $collection
  
->add(
  
'{"name": "Bernie",
    "jobs": [
      {"title":"Cat Herder","Salary":42000}, 
      {"title":"Father","Salary":0}
    ],
    "hobbies": ["Sports","Making cupcakes"]}'
,
  
'{"name": "Jane",
    "jobs": [
      {"title":"Scientist","Salary":18000}, 
      {"title":"Mother","Salary":0}
    ],
    "hobbies": ["Walking","Making pies"]}'
)
  ->
execute();

var_dump($collection->count());
?>

Exemplul de mai sus va afișa:

int(2)
add a note add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top