Elgg\Database\Select Class Reference

Query builder for fetching data from the database. More...

Inheritance diagram for Elgg\Database\Select:

Static Public Member Functions
static	fromTable (string $table, string $alias=null)
	Returns a QueryBuilder for selecting data from a given table. More...

Additional Inherited Members
Public Member Functions inherited from Elgg\Database\QueryBuilder
	__construct (protected readonly Connection $backup_connection)
	Initializes a new QueryBuilder. More...
	getConnection ()
	Returns the connection. More...
	subquery (string $table, string $alias=null)
	Creates a new SelectQueryBuilder for join/where sub queries using the DB connection of the primary QueryBuilder. More...
	addClause (Clause $clause, string $alias=null)
	Apply clause to this instance. More...
	prefix (string $table)
	Prefixes the table name with installation DB prefix. More...
	getTableName ()
	Returns the name of the primary table. More...
	getTableAlias ()
	Returns the alias of the primary table. More...
	param ($value, string $type=ELGG_VALUE_STRING, string $key=null)
	Sets a new parameter assigning it a unique parameter key/name if none provided Returns the name of the new parameter. More...
	execute (bool $track_query=true)
	from (string $table,?string $alias=null)
	{} More...
	insert (string $table)
	{} More...
	update (string $table)
	{} More...
	delete (string $table)
	{} More...
	join (string $fromAlias, string $join, string $alias,?string $condition=null)
	{} More...
	innerJoin (string $fromAlias, string $join, string $alias,?string $condition=null)
	{} More...
	leftJoin (string $fromAlias, string $join, string $alias,?string $condition=null)
	{} More...
	rightJoin (string $fromAlias, string $join, string $alias,?string $condition=null)
	{} More...
	orderBy (string $sort,?string $order=null)
	{} More...
	addOrderBy (string $sort,?string $order=null)
	{} More...
	merge ($parts=null, $boolean= 'AND')
	Merges multiple composite expressions with a boolean. More...
	compare (string $x, string $comparison, $y=null, string $type=null, bool $case_sensitive=null)
	Build value comparison clause. More...
	between (string $x, $lower=null, $upper=null, string $type=null)
	Build a between clause. More...
	getNextJoinAlias ()
	Get an index of the next available join alias. More...
	joinEntitiesTable (string $from_alias= '', string $from_column= 'guid',?string $join_type= 'inner', string $joined_alias=null)
	Join entity table from alias and return joined table alias. More...
	joinMetadataTable (string $from_alias= '', string $from_column= 'guid', $name=null,?string $join_type= 'inner', string $joined_alias=null)
	Join metadata table from alias and return joined table alias. More...
	joinAnnotationTable (string $from_alias= '', string $from_column= 'guid', $name=null,?string $join_type= 'inner', string $joined_alias=null)
	Join annotations table from alias and return joined table alias. More...
	joinRelationshipTable (string $from_alias= '', string $from_column= 'guid', $name=null, bool $inverse=false,?string $join_type= 'inner', string $joined_alias=null)
	Join relationship table from alias and return joined table alias. More...
Public Attributes inherited from Elgg\Database\QueryBuilder
const	CALCULATIONS
Protected Attributes inherited from Elgg\Database\QueryBuilder
array	$joins = []
int	$join_index = 0
string	$table_name = null
string	$table_alias = null

Detailed Description

Query builder for fetching data from the database.

Definition at line 8 of file Select.php.

Member Function Documentation

static Elgg\Database\Select::fromTable ( string  $table, string  $alias = null  )

static

Returns a QueryBuilder for selecting data from a given table.

Parameters

string	$table	table name
string | null	$alias	table alias

Returns

static

Definition at line 18 of file Select.php.

---

The documentation for this class was generated from the following file:

• engine/classes/Elgg/Database/Select.php