selectParams
in
IP-Listen Objekt
Table of Contents
$table | Database table name | string |
---|---|---|
$item | Select item string | string |
$where | Where clause | string |
$join | JOIN clause | string |
$params | Select params | array |
$distinct | SELECT DISTINCT flag | bool |
$returnResult | Return raw result flag | bool |
$fetchAll | Fetch all mode | bool |
$fetchStyle | Fetch style | int |
__construct() | Constructor method, as of FPCM 4.1 the destination table(s) can be set directly | mixed |
getTable() | Returns database name(s) | string|array |
getItem() | Returns items | string |
getWhere() | Returns where clause | string |
getJoin() | Returns join clause | string |
getParams() | Return select params | array |
getDistinct() | return Distinct select mode | bool |
getReturnResult() | Returns mode of result return | bool |
getFetchAll() | Returns fetch mode | bool |
getFetchStyle() | Returns fetch style | int |
setTable() | Set database table name(s) | $this |
setItem() | Set select items | $this |
setWhere() | Set Where clause | $this |
setJoin() | Set JOIN clause | $this |
setParams() | Set select data params for where clause | $this |
setDistinct() | Set distinct select mode | $this |
setReturnResult() | Set return of raw result | $this |
setFetchAll() | Set fetch mode to all or single mode | $this |
setFetchStyle() | Set fetch style | $this |
getQuery() | string |
Properties
$table
Database table name
private
string
$table
= ''
$item
Select item string
private
string
$item
= '*'
$where
Where clause
private
string
$where
= ''
$join
JOIN clause
private
string
$join
= ''
$params
Select params
private
array
$params
= []
$distinct
SELECT DISTINCT flag
private
bool
$distinct
= false
$returnResult
Return raw result flag
private
bool
$returnResult
= false
$fetchAll
Fetch all mode
private
bool
$fetchAll
= false
$fetchStyle
Fetch style
private
int
$fetchStyle
= 5
Methods
__construct()
Constructor method, as of FPCM 4.1 the destination table(s) can be set directly
public
__construct(
[ $table :
string|array
= '' ]
)
: mixed
Parameters
- $table : string|array = ''
(@since 4.1)
Return values
mixedgetTable()
Returns database name(s)
public
getTable(
)
: string|array
Return values
string|arraygetItem()
Returns items
public
getItem(
)
: string
Return values
stringgetWhere()
Returns where clause
public
getWhere(
)
: string
Return values
stringgetJoin()
Returns join clause
public
getJoin(
)
: string
Return values
stringgetParams()
Return select params
public
getParams(
)
: array
Return values
arraygetDistinct()
return Distinct select mode
public
getDistinct(
)
: bool
Return values
boolgetReturnResult()
Returns mode of result return
public
getReturnResult(
)
: bool
Return values
boolgetFetchAll()
Returns fetch mode
public
getFetchAll(
)
: bool
Return values
boolgetFetchStyle()
Returns fetch style
public
getFetchStyle(
)
: int
Tags
Return values
intsetTable()
Set database table name(s)
public
setTable(
$table :
string|array
)
: $this
Parameters
- $table : string|array
Return values
$thissetItem()
Set select items
public
setItem(
$item :
string
)
: $this
Parameters
- $item : string
Return values
$thissetWhere()
Set Where clause
public
setWhere(
$where :
string
)
: $this
Parameters
- $where : string
Return values
$thissetJoin()
Set JOIN clause
public
setJoin(
$join :
string
)
: $this
Parameters
- $join : string
Return values
$thissetParams()
Set select data params for where clause
public
setParams(
$params :
array
)
: $this
Parameters
- $params : array
Return values
$thissetDistinct()
Set distinct select mode
public
setDistinct(
$distinct :
bool
)
: $this
Parameters
- $distinct : bool
Return values
$thissetReturnResult()
Set return of raw result
public
setReturnResult(
$returnResult :
bool
)
: $this
Parameters
- $returnResult : bool
Return values
$thissetFetchAll()
Set fetch mode to all or single mode
public
setFetchAll(
$fetchAll :
bool
)
: $this
Parameters
- $fetchAll : bool
Return values
$thissetFetchStyle()
Set fetch style
public
setFetchStyle(
$fetchStyle :
int
)
: $this
Parameters
- $fetchStyle : int
Tags
Return values
$thisgetQuery()
public
final getQuery(
)
: string