spoof
 All Data Structures Namespaces Files Functions Variables Pages
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_basestring base table name
integer$typejoin type, one of defined class join type constants should be used
string$table_joinjoined table name
\lib360\db\condition\ICondition$conditiondatabase condition object

Implements IJoin.


Member Function Documentation

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

Adds a table to the join.

Parameters:
integer$typejoin type, one of defined class join type constants should be used
string$table_joinjoined table name
\lib360\db\condition\ICondition$conditiondatabase 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: