Collection::count

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

    Collection::count — Get document count

    说明

    publicmysql_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.

    参数

    此函数没有参数。

    返回值

    The number of documents in the collection.

    示例

    示例 #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());
    ?>

    以上示例会输出：

    int(2)
    To Top