PHP Class SQLGlobal

Afficher le fichier Open project: zblogcn/zblogphp Class Usage Examples

Protected Properties

Свойство	Type	Description
$columns
$data
$groupBy
$having
$index
$join
$method
$option
$orderBy
$table
$where

Méthodes publiques

Méthode	Description
__call ( $callName, $argu )
__construct ( object &$db = null )
__get ( $getName )
__set ( $name, $value )
_sqlPush ( $sql )	If we use $this->$getName directly, PHP will throw [Indirect modification of overloaded property] So we have to wrap it.
column ( $columns )	Set column for query
data ( )	Set data for INSERT & UPDATE
exist ( $table )
groupBy ( $groupBy )	GroupBy
having ( $having )	Set having
limit ( )	Set limit & offset
option ( $option )	Set SQL query option
orderBy ( )	Order by
query ( $sql = null )
reset ( )	Re-initialize this class
where ( )	Set where query

Méthodes protégées

Méthode	Description
buildBeforeWhere ( )
buildColumn ( )
buildCreate ( )
buildDelete ( )
buildDrop ( )
buildGroupBy ( )
buildHaving ( )
buildIndex ( )
buildInsert ( )
buildJoin ( )
buildLimit ( )
buildOrderBy ( )
buildOthers ( )
buildPagebar ( )
buildSelect ( )
buildTable ( )
buildUpdate ( )
buildWhere ( $originalWhere = null, $whereKeyword = null )
columnLoaderArray ( $columns )

Private Methods

Méthode	Description
sql ( )
validateParamater ( $param )

Method Details

__call() public méthode

public __call ( $callName, $argu )

__construct() public méthode

public __construct ( object &$db = null )
$db	object

__get() public méthode

public __get ( $getName )

__set() public méthode

public __set ( $name, $value )

_sqlPush() public méthode

It maybe a bug of PHP.

See also: http://stackoverflow.com/questions/10454779/php-indirect-modification-of-overloaded-property

public _sqlPush ( $sql )

buildBeforeWhere() protected méthode

protected buildBeforeWhere ( )

buildColumn() protected méthode

protected buildColumn ( )

buildCreate() protected méthode

protected buildCreate ( )

buildDelete() protected méthode

protected buildDelete ( )

buildDrop() protected méthode

protected buildDrop ( )

buildGroupBy() protected méthode

protected buildGroupBy ( )

buildHaving() protected méthode

protected buildHaving ( )

buildIndex() protected méthode

protected buildIndex ( )

buildInsert() protected méthode

protected buildInsert ( )

buildJoin() protected méthode

protected buildJoin ( )

buildLimit() protected méthode

protected buildLimit ( )

buildOrderBy() protected méthode

protected buildOrderBy ( )

buildOthers() protected méthode

protected buildOthers ( )

buildPagebar() protected méthode

protected buildPagebar ( )

buildSelect() protected méthode

protected buildSelect ( )

buildTable() protected méthode

protected buildTable ( )

buildUpdate() protected méthode

protected buildUpdate ( )

buildWhere() protected méthode

protected buildWhere ( $originalWhere = null, $whereKeyword = null )

column() public méthode

Set column for query

public column ( $columns )

columnLoaderArray() protected méthode

protected columnLoaderArray ( $columns )

data() public méthode

Set data for INSERT & UPDATE

public data ( )

exist() public méthode

public exist ( $table )

groupBy() public méthode

GroupBy

public groupBy ( $groupBy )

having() public méthode

Set having

public having ( $having )

limit() public méthode

Set limit & offset

public limit ( )

option() public méthode

Set SQL query option

public option ( $option )

orderBy() public méthode

Order by

public orderBy ( )

query() public méthode

public query ( $sql = null )

reset() public méthode

Re-initialize this class

public reset ( )

where() public méthode

Set where query

public where ( )

Property Details

$columns protected_oe property

protected $columns

$data protected_oe property

protected $data

$groupBy protected_oe property

protected $groupBy

$having protected_oe property

protected $having

$index protected_oe property

protected $index

$join protected_oe property

protected $join

$method protected_oe property

protected $method

$option protected_oe property

protected $option

$orderBy protected_oe property

protected $orderBy

$table protected_oe property

protected $table

$where protected_oe property

protected $where