Properties

$_globals

$_globals : array

Type

array

$engine

$engine : 

Type

$params

$params : 

Type

$_engine_name

$_engine_name : 

Type

$_allow_engines

$_allow_engines : 

Type

$_key

$_key : 

Type

$count

$count : 

Type

$limit

$limit : 

Type

$page

$page : 

Type

$error

$error : 

Type

Methods

__construct()

__construct(  $engineName = "mysql") 

Parameters

$engineName

error()

error() 

init()

init(  $params) 

Parameters

$params

setCount()

setCount(  $count) 

is count

Parameters

$count

setPage()

setPage(  $page) 

page number

Parameters

$page

setLimit()

setLimit(  $limit) 

page size

Parameters

$limit

select()

select(string|array|object  $table, string|array|object  $condition = "", string|array|object  $item = "", string|array|object  $groupby = "", string|array|object  $orderby = "", string|array|object  $leftjoin = "") : \SlightPHP\DbData

select data from db

Parameters

string|array|object $table
string|array|object $condition
string|array|object $item
string|array|object $groupby
string|array|object $orderby
string|array|object $leftjoin

Returns

\SlightPHP\DbData

object || Boolean false

selectOne()

selectOne(  $table,   $condition = "",   $item = "",   $groupby = "",   $orderby = "",   $leftjoin = "") 

select one from select result

Parameters

$table
$condition
$item
$groupby
$orderby
$leftjoin

update()

update(string|array|object  $table, string|array|object  $condition, string|array|object  $item) : integer|boolean

update data

Parameters

string|array|object $table
string|array|object $condition
string|array|object $item

Returns

integer|boolean

delete()

delete(string|array|object  $table, string|array|object  $condition) : integer|boolean

delete

Parameters

string|array|object $table
string|array|object $condition

Returns

integer|boolean

insert()

insert(string|array|object  $table, string|array|object  $item = "", boolean  $isreplace = false, boolean  $isdelayed = false, string|array|object  $update = array(),   $ignore = false) : integer|boolean

insert

Parameters

string|array|object $table
string|array|object $item
boolean $isreplace
boolean $isdelayed
string|array|object $update
$ignore

Returns

integer|boolean —

int(lastInsertId or affectedRows)

execute()

execute(string  $sql) : boolean|integer|array

Parameters

string $sql

Returns

boolean|integer|array

__setEngine()

__setEngine(  $engineName) 

Parameters

$engineName

_reInit()

_reInit() 

construct

__query()

__query(string  $sql,   $retry = false) : Array

query

Parameters

string $sql
$retry

Returns

Array —

$result || Boolean false

__quote()

__quote(  $condition,   $split = "AND") 

Parameters

$condition
$split

__addsqlslashes()

__addsqlslashes(  $k) 

Parameters

$k

__array2string()

__array2string(  $mixed,   $alais = false) 

Parameters

$mixed
$alais