Query Class Reference

Inheritance diagram for Query:

Public Member Functions
	__construct ($queryID=NULL, $action=NULL, $columns=NULL, $tables=NULL, $conditions=NULL, $groups=NULL, $orderby=NULL, $limit=NULL, $priority=NULL)
	show ()
	setQueryId ($queryID)
	setAction ($action)
	setPriority ($priority)
	setColumnList ($columnList)
	setColumns ($columns)
	setTables ($tables)
	setSubquery ($subquery)
	setConditions ($conditions)
	setGroups ($groups)
	setOrder ($order)
	getOrder ()
	setLimit ($limit=NULL)
	select ($columns=NULL)
	from ($tables)
	where ($conditions)
	groupBy ($groups)
	orderBy ($order)
	limit ($limit)
	getAction ()
	getPriority ()
	usesClickCount ()
	getClickCountColumns ()
	getSelectString ($with_values=TRUE)
	getUpdateString ($with_values=TRUE)
	getInsertString ($with_values=TRUE)
	getTables ()
	getFromString ($with_values=TRUE)
	getWhereString ($with_values=TRUE, $with_optimization=TRUE)
	getGroupByString ()
	getOrderByString ()
	getLimit ()
	getLimitString ()
	getFirstTableName ()
	getArguments ()
Public Member Functions inherited from BaseObject
	__construct ($error=0, $message= 'success')
	setError ($error=0)
	getError ()
	setHttpStatusCode ($code= '200')
	getHttpStatusCode ()
	setMessage ($message= 'success', $type=NULL)
	getMessage ()
	add ($key, $val)
	adds ($object)
	get ($key)
	gets ()
	getVariables ()
	getObjectVars ()
	toBool ()
	toBoolean ()

Public Attributes
	$queryID
	$action
	$priority
	$columns
	$tables
	$conditions
	$groups
	$orderby
	$limit
	$arguments = NULL
	$columnList = NULL
	$_orderByString
Public Attributes inherited from BaseObject
	$error = 0
	$message = 'success'
	$variables = array()
	$httpStatusCode = NULL

Detailed Description

Definition at line 9 of file Query.class.php.

Constructor & Destructor Documentation

Query::__construct	(		$queryID = NULL,
			$action = NULL,
			$columns = NULL,
			$tables = NULL,
			$conditions = NULL,
			$groups = NULL,
			$orderby = NULL,
			$limit = NULL,
			$priority = NULL
	)

constructor

Parameters

string	$queryID
string	$action
string | array	$columns
string | array	$tables
string | array	$conditions
string | array	$groups
string | array	$orderby
int	$limit
string	$priority

Returns

void

Definition at line 97 of file Query.class.php.

Member Function Documentation

Query::from

(

$tables

)

from set

Parameters

string | array

$tables

Returns

Query return Query instance

Definition at line 281 of file Query.class.php.

Query::getAction

(

)

Definition at line 333 of file Query.class.php.

Query::getArguments

(

)

Return argument list

Returns

array

Definition at line 607 of file Query.class.php.

Query::getClickCountColumns

(

)

Definition at line 354 of file Query.class.php.

Query::getFirstTableName

(

)

Definition at line 598 of file Query.class.php.

Query::getFromString

(

$with_values = TRUE

)

from table_a from table_a inner join table_b on x=y from (select * from table a) as x from (select * from table t) as x inner join table y on y.x

Parameters

boolean

$with_values

Returns

string

Definition at line 459 of file Query.class.php.

Query::getGroupByString

(

)

Return groupby sql

Returns

string

Definition at line 542 of file Query.class.php.

Query::getInsertString

(

$with_values = TRUE

)

Return insert sql

Parameters

boolean

$with_values

Returns

string

Definition at line 415 of file Query.class.php.

Query::getLimit

(

)

Definition at line 578 of file Query.class.php.

Query::getLimitString

(

)

Return limit sql

Returns

string

Definition at line 587 of file Query.class.php.

Query::getOrder

(

)

Definition at line 249 of file Query.class.php.

Query::getOrderByString

(

)

Return orderby sql

Returns

string

Definition at line 559 of file Query.class.php.

Query::getPriority

(

)

Definition at line 338 of file Query.class.php.

Query::getSelectString

(

$with_values = TRUE

)

Return select sql

Parameters

boolean

$with_values

Returns

string

Definition at line 372 of file Query.class.php.

Query::getTables

(

)

Definition at line 446 of file Query.class.php.

Query::getUpdateString

(

$with_values = TRUE

)

Return update sql

Parameters

boolean

$with_values

Returns

string

Definition at line 396 of file Query.class.php.

Query::getWhereString	(		$with_values = TRUE,
			$with_optimization = TRUE
	)

Return where sql

Parameters

boolean	$with_values
boolean	$with_optimization

Returns

string

Definition at line 494 of file Query.class.php.

Query::groupBy

(

$groups

)

groupBy set

Parameters

string | array

$groups

Returns

Query return Query instance

Definition at line 303 of file Query.class.php.

Query::limit

(

$limit

)

limit set

Parameters

int

$limit

Returns

Query return Query instance

Definition at line 325 of file Query.class.php.

Query::orderBy

(

$order

)

orderBy set

Parameters

string | array

$order

Returns

Query return Query instance

Definition at line 314 of file Query.class.php.

Query::select

(

$columns = NULL

)

seleect set

Parameters

string | array

$columns

Returns

Query return Query instance

Definition at line 269 of file Query.class.php.

Query::setAction

(

$action

)

Definition at line 134 of file Query.class.php.

Query::setColumnList

(

$columnList

)

Definition at line 144 of file Query.class.php.

Query::setColumns

(

$columns

)

Definition at line 162 of file Query.class.php.

Query::setConditions

(

$conditions

)

Definition at line 200 of file Query.class.php.

Query::setGroups

(

$groups

)

Definition at line 221 of file Query.class.php.

Query::setLimit

(

$limit = NULL

)

Definition at line 254 of file Query.class.php.

Query::setOrder

(

$order

)

Definition at line 235 of file Query.class.php.

Query::setPriority

(

$priority

)

Definition at line 139 of file Query.class.php.

Query::setQueryId

(

$queryID

)

Definition at line 129 of file Query.class.php.

Query::setSubquery

(

$subquery

)

Definition at line 195 of file Query.class.php.

Query::setTables

(

$tables

)

Definition at line 178 of file Query.class.php.

Query::show

(

)

Definition at line 124 of file Query.class.php.

Query::usesClickCount

(

)

Check if current query uses the click count attribute For CUBRID, this statement uses the click count feature. For the other databases, using this attribute causes a query to produce both a select and an update

Definition at line 349 of file Query.class.php.

Query::where

(

$conditions

)

where set

Parameters

string | array

$conditions

Returns

Query return Query instance

Definition at line 292 of file Query.class.php.

Member Data Documentation

Query::$_orderByString

Definition at line 82 of file Query.class.php.

Query::$action

Definition at line 22 of file Query.class.php.

Query::$arguments = NULL

Definition at line 70 of file Query.class.php.

Query::$columnList = NULL

Definition at line 76 of file Query.class.php.

Query::$columns

Definition at line 34 of file Query.class.php.

Query::$conditions

Definition at line 46 of file Query.class.php.

Query::$groups

Definition at line 52 of file Query.class.php.

Query::$limit

Definition at line 64 of file Query.class.php.

Query::$orderby

Definition at line 58 of file Query.class.php.

Query::$priority

Definition at line 28 of file Query.class.php.

Query::$queryID

Definition at line 16 of file Query.class.php.

Query::$tables

Definition at line 40 of file Query.class.php.

---

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

• classes/db/queryparts/Query.class.php