Elgg\Application\Database Class Reference

Public Member Functions
	__construct (ElggDb $db)
	Constructor. More...
	getData (QueryBuilder $query, $callback= '')
	Retrieve rows from the database. More...
	getDataRow (QueryBuilder $query, $callback= '')
	Retrieve a single row from the database. More...
	insertData (QueryBuilder $query)
	Insert a row into the database. More...
	updateData (QueryBuilder $query, bool $getNumRows=false)
	Update the database. More...
	deleteData (QueryBuilder $query)
	Delete data from the database. More...
	getConnection ($type)
	Gets (if required, also creates) a DB connection. More...
	registerDelayedQuery (QueryBuilder $query, $callback=null)
	Queue a query for execution upon shutdown. More...
	__get ($name)
	Handle magic property reads. More...
	__set ($name, $value)
	Handle magic property writes. More...

Detailed Description

Definition at line 16 of file Database.php.

Constructor & Destructor Documentation

Elgg\Application\Database::__construct

(

ElggDb

$db

)

Constructor.

Parameters

ElggDb

$db

The Elgg database

Definition at line 30 of file Database.php.

Member Function Documentation

Elgg\Application\Database::__get

(

$name

)

Handle magic property reads.

Parameters

string

$name

Property name

Returns

mixed

Definition at line 144 of file Database.php.

Elgg\Application\Database::__set	(		$name,
			$value
	)

Handle magic property writes.

Parameters

string	$name	Property name
mixed	$value	Value

Returns

void

Definition at line 155 of file Database.php.

Elgg\Application\Database::deleteData

(

QueryBuilder

$query

)

Delete data from the database.

Note

Altering the DB invalidates all queries in query cache.

Parameters

QueryBuilder

$query

The SQL query to run

Returns

int The number of affected rows

Definition at line 106 of file Database.php.

Elgg\Application\Database::getConnection

(

$type

)

Gets (if required, also creates) a DB connection.

Parameters

string

$type

The type of link we want: "read", "write" or "readwrite".

Returns

Connection

Definition at line 118 of file Database.php.

Elgg\Application\Database::getData	(	QueryBuilder	$query,
			$callback = ''
	)

Retrieve rows from the database.

Queries are executed with Elgg\Database::executeQuery()andresultsareretrievedwith@link\PDO::fetchObject().Ifacallbackfunction$callbackisdefined,eachrowwillbepassedasasingleargumentto$callback.Ifnocallbackfunctionisdefined,theentireresultsetisreturnedasanarray.@paramQueryBuilder$queryThequerybeingpassed.@paramcallable$callbackOptionally,thenameofafunctiontocallbacktooneachrow@returnarrayAnarrayofdatabaseresultobjectsorcallbackfunctionresults.Ifthequeryreturnednothing,anemptyarray.

Definition at line 49 of file Database.php.

Elgg\Application\Database::getDataRow	(	QueryBuilder	$query,
			$callback = ''
	)

Retrieve a single row from the database.

Similar to Elgg\Database::getData()butreturnsonlythefirstrowmatched.Ifacallbackfunction$callbackisspecified,therowwillbepassedastheonlyargumentto$callback.@paramQueryBuilder$queryThequerytoexecute.@paramcallable$callbackAcallbackfunctiontoapplytotherow@returnmixedAsingledatabaseresultobjectortheresultofthecallbackfunction.

Definition at line 65 of file Database.php.

Elgg\Application\Database::insertData

(

QueryBuilder

$query

)

Insert a row into the database.

Note

Altering the DB invalidates all queries in the query cache.

Parameters

QueryBuilder

$query

The query to execute

Returns

int|false The database id of the inserted row if a AUTO_INCREMENT field is defined, 0 if not, and false on failure.

Definition at line 79 of file Database.php.

Elgg\Application\Database::registerDelayedQuery	(	QueryBuilder	$query,
			$callback = null
	)

Queue a query for execution upon shutdown.

You can specify a callback if you care about the result. This function will always be passed a .

Parameters

QueryBuilder	$query	The query to execute
callable	$callback	A callback function to pass the results array to

Returns

void

Definition at line 134 of file Database.php.

Elgg\Application\Database::updateData	(	QueryBuilder	$query,
		bool	$getNumRows = false
	)

Update the database.

Note

Altering the DB invalidates all queries in the query cache.

Parameters

QueryBuilder	$query	The query to run.
bool	$getNumRows	Return the number of rows affected (default: false).

Returns

bool|int

Definition at line 93 of file Database.php.

---

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

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