# SqlStatementResult class

(PECL mysql-xdevapi >= 8.0.11)

## Introduction

## Class synopsis

class mysql_xdevapi\SqlStatementResult implements mysql_xdevapi\BaseResult, Traversable {
/* Methods */
public fetchAll(): array
public fetchOne(): array
public getAffectedItemsCount(): int
public getColumnsCount(): int
public getColumnNames(): array
public getColumns(): Array
public getGeneratedIds(): array
public getLastInsertId(): String
public getWarnings(): array
public getWarningCounts(): int
public hasData(): bool
public nextResult(): mysql_xdevapi\Result
}

## Table of Contents

- SqlStatementResult::__construct — Description constructor
- SqlStatementResult::fetchAll — Get all rows from result
- SqlStatementResult::fetchOne — Get single row
- SqlStatementResult::getAffectedItemsCount — Get affected row count
- SqlStatementResult::getColumnsCount — Get column count
- SqlStatementResult::getColumnNames — Get column names
- SqlStatementResult::getColumns — Get columns
- SqlStatementResult::getGeneratedIds — Get generated ids
- SqlStatementResult::getLastInsertId — Get last insert id
- SqlStatementResult::getWarnings — Get warnings from last operation
- SqlStatementResult::getWarningsCount — Get warning count from last operation
- SqlStatementResult::hasData — Check if result has data
- SqlStatementResult::nextResult — Get next result

`↑` and `↓` to navigate • `Enter` to select • `Esc` to close • `/` to open