class SelectSql

Properties

$sql
$select
$where
$order
$group
$arrSql
$arrVal

Methods

__construct($array = '')

No description

getSql($mode = '')

No description

addSearchStr($val)

No description

selectRange($from, $to, $column)

No description

selectTermRange($from_year, $from_month, $from_day, $to_year, $to_month, $to_day, $column)

No description

setItemTerm($arr, $ItemStr)

No description

setItemTermWithNull($arr, $ItemStr)

No description

setItemTermWithNullAndSpace($arr, $ItemStr)

No description

setWhereByOR($arrWhere)

No description

string
getWhere($with_where = false)

WHERE を取得する。

setWhere($where)

No description

setOrder(string $order)

No description

setGroup($group)

No description

clearSql()

No description

setSelect($sql)

No description

Details

at line 43
__construct($array = '')

Parameters

$array

at line 51
getSql($mode = '')

Parameters

$mode

at line 63
addSearchStr($val)

Parameters

$val

at line 75
selectRange($from, $to, $column)

Parameters

$from
$to
$column

at line 103
selectTermRange($from_year, $from_month, $from_day, $to_year, $to_month, $to_day, $column)

Parameters

$from_year
$from_month
$from_day
$to_year
$to_month
$to_day
$column

at line 147
setItemTerm($arr, $ItemStr)

Parameters

$arr
$ItemStr

at line 177
setItemTermWithNull($arr, $ItemStr)

Parameters

$arr
$ItemStr

at line 197
setItemTermWithNullAndSpace($arr, $ItemStr)

Parameters

$arr
$ItemStr

at line 224
setWhereByOR($arrWhere)

Parameters

$arrWhere

at line 250
string getWhere($with_where = false)

WHERE を取得する。

ヘンテコセッター互換仕様。

Parameters

$with_where boolean 必要に応じて WHERE を前置するか

Return Value

string WHERE

at line 261
setWhere($where)

Parameters

$where

at line 275
setOrder(string $order)

Parameters

string $order

at line 280
setGroup($group)

Parameters

$group

at line 285
clearSql()

at line 293
setSelect($sql)

Parameters

$sql