• 홈
• System
• Database
• query

PHP 클래스 System\Database\query

파일 보기 프로젝트 열기: anchorcms/anchor-cms

공개 프로퍼티들

프로퍼티	타입	설명
$bind	array	Array values to bind to the query
$columns	array	Array of columns to build the select
$connection	object	Database connector object
$fetch_class	string	The class name of the object to create when fetching from the database
$groupby	array	Columns to group by
$join	array	Array of table joins to build
$limit	integer	Number of rows to limit
$offset	integer	Number of rows to offset
$sortby	array	Columns to sort by
$table	string	The current database table
$where	array	Array of where clauses to build

공개 메소드들

메소드	설명
__construct ( $table, $connection = null )	Create a new database query instance
apply ( $class ) : object	Set the class name for fetch queries, return self for chaining
column ( $columns = [], $column_number ) : string	Fetch a single column from the query
count ( ) : string	Run a count function on database query
delete ( ) : integer	Delete a row in the database
fetch ( $columns = null ) : object	Fetch a single row from the query
get ( $columns = null ) : object	Fetch a result set from the query
group ( $column ) : object	Add a group by column to the query
insert ( $row ) : object	Insert a row into the database
insert_get_id ( $row ) : integer	Insert a row into the database and return the inserted ID
join ( $table, $left, $operator, $right, $type = 'INNER' ) : object	Add a table join to the query
left_join ( $table, $left, $operator, $right ) : object	Add a left table join to the query
or_where ( $column, $operator, $value ) : object	Add a where clause to the query starting with OR
skip ( $num ) : object	Set a row offset on the query
sort ( $column, $mode = 'ASC' ) : object	Add a sort by column to the query
table ( $table, $connection = null ) : object	Create a new database query instance for chaining
take ( $num ) : object	Set a row limit on the query
update ( $row ) : integer	Update row in the database
where ( $column, $operator, $value ) : object	Add a where clause to the query
where_in ( $column, $values ) : object	Add a where clause to the query starting with IN

메소드 상세

프로퍼티 상세