AsyncMysqlQueryResult

The result of a successfully executed MySQL query

Not only does this class provide timing information about retrieving the successful result, it provides the actual result information (e.g., result rows).

You get an AsyncMysqlQueryResult through calls to AsyncMysqlConnection::query(), AsyncMysqlConection::queryf() and AsyncMysqlConnection::multiQuery()

Guides

• Introduction
• Extensions

Interface Synopsis

final class AsyncMysqlQueryResult extends AsyncMysqlResult {...}

Public Methods

• ->clientStats(): AsyncMysqlClientStats
  Returns the MySQL client statistics at the moment the successful query ended

• ->dictRowsTyped(): vec<dict<string, mixed, arraykey>>

• ->elapsedMicros(): int
  The total time for the successful query to occur, in microseconds

• ->endTime(): float
  The end time when the successful query began, in seconds since epoch

• ->lastInsertId(): int
  The last ID inserted, if one existed, for the query that produced the current result

• ->mapRows(): Vector<Map<?string>>
  Returns the actual rows returned by the successful query, each row including the name and value for each column

• ->mapRowsTyped(): Vector<Map<string, mixed>>
  Returns the actual rows returned by the successful query, each row including the name and typed-value for each column

• ->noIndexUsed(): bool
  Returns whether or not any of the queries executed did not use an index during execution

• ->numRows(): int
  The number of rows in the current result

• ->numRowsAffected(): int
  The number of database rows affected in the current result

• ->recvGtid(): string
  The GTID of database returned for the current commit

• ->responseAttributes(): Map<string>
  The response attributes returned for the current query

• ->rowBlocks(): Vector<AsyncMysqlRowBlock>
  Returns a Vector representing all row blocks returned by the successful query

• ->startTime(): float
  The start time when the successful query began, in seconds since epoch

• ->vectorRows(): Vector<KeyedContainer<int, ?string>>
  Returns the actual rows returned by the successful query, each row including the values for each column

• ->vectorRowsTyped(): Vector<KeyedContainer<int, mixed>>
  Returns the actual rows returned by the successful query, each row including the typed values for each column

Public Methods (AsyncMysqlResult)

• ->getSslCertCn(): string
  Returns Common Name attribute of the TLS certificate presented by MySQL server
• ->getSslCertExtensions(): Vector<string>
  Returns values from the selected cert extensions of the TLS certificate presented by MySQL server
• ->getSslCertSan(): Vector<string>
  Returns Server Alternative Names attribute of the TLS certificate presented by MySQL server
• ->isSslCertValidationEnforced(): bool
  Returns a boolean value indicating if server cert validation was enforced for this connection
• ->sslSessionReused(): bool
  Returns whether or not the current connection reused the SSL session from another SSL connection