Join Class Reference

Inheritance diagram for Join:

Collaboration diagram for Join:

Public Member Functions
	__construct ($table_base, $type, $table_join,\lib360\db\condition\ICondition $condition)
	addTable ($type, $table_join,\lib360\db\condition\ICondition $condition)

Data Fields
	$table_base
	$table_join
	$type
	$condition
const	JOIN_TYPE_LEFT_OUTER = 1
const	JOIN_TYPE_INNER = 2
const	JOIN_TYPE_JOIN = 3
const	JOIN_TYPE_RIGHT_OUTER = 4
const	JOIN_TYPE_FULL = 5

---

Detailed Description

Database join class. This class describes an database table join between 2 or more database tables.

---

Constructor & Destructor Documentation

__construct	(		$table_base,
			$type,
			$table_join,
		\lib360\db\condition\ICondition	$condition
	)

Constructor.

Parameters:

string	$table_base	string base table name
integer	$type	join type, one of defined class join type constants should be used
string	$table_join	joined table name
\lib360\db\condition\ICondition	$condition	database condition object

Implements IJoin.

---

Member Function Documentation

addTable	(		$type,
			$table_join,
		\lib360\db\condition\ICondition	$condition
	)

Adds a table to the join.

Parameters:

integer	$type	join type, one of defined class join type constants should be used
string	$table_join	joined table name
\lib360\db\condition\ICondition	$condition	database condition object

Implements IJoin.

---

Field Documentation

$condition

Array of database conditions. Property used to store database conditions or condition groups used for joined tables.

$table_base

Base table name. Property used to store name of the base table for the join.

$table_join

Array of joined table names. Property used to store names of joined tables.

$type

Array of join types. Property used to store types of joins associated with joined tables.

const JOIN_TYPE_FULL = 5

Constant for full join

const JOIN_TYPE_INNER = 2

Constant for inner join

const JOIN_TYPE_JOIN = 3

Constant for default join

const JOIN_TYPE_LEFT_OUTER = 1

Constant for left outer join

const JOIN_TYPE_RIGHT_OUTER = 4

Constant for right outer join

---

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

• lib360/db/join/Join.php