soo_txp_select Class Reference

Class for SELECT queries. More...

List of all members.

Public Member Functions
	__construct ($table, $key=null, $select=null)
	Constructor.
	select ($list= '*')
	Add items to the SELECT array.
	distinct ()
	Add the DISTINCT keyword to the query.
	row ()
	Return a single record, or empty array if no matching records.
	rows ()
	Return all records, or empty array if no matching records.
	sql ()
	Return the query as a string.
Protected Member Functions
	init_query ()
Protected Attributes
	$select = array()
	SQL SELECT expressions.
	$distinct = false
	Whether to add DISTINCT.

---

Detailed Description

Class for SELECT queries.

Definition at line 344 of file soo_txp_obj.php.

---

Constructor & Destructor Documentation

soo_txp_select::__construct	(	$	table,
		$	key = null,
		$	select = null
	)

Constructor.

Parameters:

	table	Table name
	select	item(s) to select
	key	Optional key for selecting a single record

Definition at line 357 of file soo_txp_obj.php.

---

Member Function Documentation

soo_txp_select::distinct

(

)

Add the DISTINCT keyword to the query.

Returns:

$this to allow method chaining

Definition at line 376 of file soo_txp_obj.php.

soo_txp_select::row

(

)

Return a single record, or empty array if no matching records.

Returns:

array

Reimplemented in soo_txp_left_join.

Definition at line 391 of file soo_txp_obj.php.

soo_txp_select::rows

(

)

Return all records, or empty array if no matching records.

Returns:

array

Reimplemented in soo_txp_left_join.

Definition at line 401 of file soo_txp_obj.php.

soo_txp_select::select

(

$

list = '*'

)

Add items to the SELECT array.

Parameters:

list

comma-separated list, or array, of items to select

Reimplemented in soo_txp_left_join.

Definition at line 366 of file soo_txp_obj.php.

soo_txp_select::sql

(

)

Return the query as a string.

Returns:

string

Reimplemented in soo_txp_left_join.

Definition at line 411 of file soo_txp_obj.php.

---

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

• soo_txp_obj.php