Php/docs/class.mysql-xdevapi-tableselect

• PHP Manual
• Mysql_xdevapi
• TableSelect class

(PECL mysql-xdevapi >= 8.0.11)

Introduction

A statement for record retrieval operations on a Table.

Class synopsis

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