TableSelect::bind »

« TableInsert::values

TableSelect class

(PECL mysql-xdevapi >= 8.0.11)

Introduction

A statement for record retrieval operations on a Table.

Class synopsis

class mysql_xdevapi\TableSelect implements mysql_xdevapi\Executable {

/* Methods */

public bind(array $placeholder_values): mysql_xdevapi\TableSelect

public execute(): mysql_xdevapi\RowResult

public groupBy(mixed $sort_expr): mysql_xdevapi\TableSelect

public having(string $sort_expr): mysql_xdevapi\TableSelect

public limit(int $rows): mysql_xdevapi\TableSelect

public lockExclusive(int $lock_waiting_option = ?): mysql_xdevapi\TableSelect

public lockShared(int $lock_waiting_option = ?): mysql_xdevapi\TableSelect

public offset(int $position): mysql_xdevapi\TableSelect

public orderby(mixed $sort_expr, mixed ...$sort_exprs): mysql_xdevapi\TableSelect

public where(string $where_expr): mysql_xdevapi\TableSelect

}

Table of Contents

TableSelect::bind — Bind select query parameters
TableSelect::__construct — TableSelect constructor
TableSelect::execute — Execute select statement
TableSelect::groupBy — Set select grouping criteria
TableSelect::having — Set select having condition
TableSelect::limit — Limit selected rows
TableSelect::lockExclusive — Execute EXCLUSIVE LOCK
TableSelect::lockShared — Execute SHARED LOCK
TableSelect::offset — Set limit offset
TableSelect::orderby — Set select sort criteria
TableSelect::where — Set select search condition

Improve This Page

Learn How To Improve This Page • Submit a Pull Request • Report a Bug

User Contributed Notes

There are no user contributed notes for this page.