Properties

$_globals

$_globals : array

Type

array

$engine

$engine : 

Type

$_allow_engines

$_allow_engines : 

Type

$_key

$_key : 

Type

$host

$host : 

Type

$port

$port : 

Type

$user

$user : 

Type

$password

$password : 

Type

$database

$database : 

Type

$charset

$charset : 

Type

$count

$count : 

Type

$limit

$limit : 

Type

$page

$page : 

Type

$error

$error : 

Type

Methods

__construct()

__construct(  $engine = "mysql") 

Parameters

$engine

error()

error() 

init()

init(array  $params = array()) 

construct

Parameters

array $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()) : integer|boolean

insert

Parameters

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

Returns

integer|boolean —

int(lastInsertId or affectedRows)

execute()

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

Parameters

string $sql

Returns

boolean|integer|array

__setEngine()

__setEngine(  $engine) 

Parameters

$engine

__query()

__query(string  $sql) : Array

query

Parameters

string $sql

Returns

Array —

$result || Boolean false

__connect()

__connect(  $forceReconnect = false) 

Parameters

$forceReconnect

__quote()

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

Parameters

$condition
$split

__addsqlslashes()

__addsqlslashes(  $k) 

Parameters

$k

__array2string()

__array2string(  $mixed,   $alais = false) 

Parameters

$mixed
$alais