Documentation

Db
in package

Table of Contents

Properties

$_allow_engines  : mixed
$_engine_name  : mixed
$_key  : mixed
$count  : mixed
$engine  : mixed
$error  : mixed
$limit  : mixed
$page  : mixed
$params  : mixed

Methods

__construct()  : mixed
delete()  : int|bool
delete
error()  : mixed
escape()  : mixed
execute()  : bool|int|array<string|int, mixed>
init()  : mixed
insert()  : int|bool
insert
select()  : DbData
select data from db
selectOne()  : mixed
select one from select result
setCount()  : mixed
is count
setLimit()  : mixed
page size
setPage()  : mixed
page number
update()  : int|bool
update data
__addsqlslashes()  : mixed
__array2string()  : mixed
__query()  : array<string|int, mixed>
query
__quote()  : mixed
__setEngine()  : mixed
_reInit()  : mixed
construct
merge_params()  : mixed
merge array

Properties

$_allow_engines

private mixed $_allow_engines = array("mysqli", "pdo_mysql", "pdo_sqlite", "pdo_cubrid", "pdo_dblib", "pdo_firebird", "pdo_ibm", "pdo_informix", "pdo_sqlsrv", "pdo_oci", "pdo_odbc", "pdo_pgsql", "pdo_4d")

$_engine_name

private mixed $_engine_name = "pdo_mysql"

$_key

private mixed $_key

$count

private mixed $count = true

$engine

private mixed $engine

$error

private mixed $error = array('code' => 0, 'msg' => "")

$limit

private mixed $limit = 0

$page

private mixed $page = 1

$params

private mixed $params

Methods

__construct()

public __construct([mixed $engineName = "mysql" ]) : mixed
Parameters
$engineName : mixed = "mysql"

delete()

delete

public delete(string|array<string|int, mixed>|object $table, string|array<string|int, mixed>|object $condition) : int|bool
Parameters
$table : string|array<string|int, mixed>|object
$condition : string|array<string|int, mixed>|object
Return values
int|bool

error()

public error() : mixed

escape()

public escape(mixed $str) : mixed
Parameters
$str : mixed

execute()

public execute(string $sql) : bool|int|array<string|int, mixed>
Parameters
$sql : string
Return values
bool|int|array<string|int, mixed>

init()

public init(mixed $params) : mixed
Parameters
$params : mixed

insert()

insert

public insert(string|array<string|int, mixed>|object $table[, string|array<string|int, mixed>|object $item = "" ][, bool $isreplace = false ][, bool $isdelayed = false ][, string|array<string|int, mixed>|object $update = array() ][, mixed $ignore = false ]) : int|bool
Parameters
$table : string|array<string|int, mixed>|object
$item : string|array<string|int, mixed>|object = ""
$isreplace : bool = false
$isdelayed : bool = false
$update : string|array<string|int, mixed>|object = array()
$ignore : mixed = false
Return values
int|bool —

int(lastInsertId or affectedRows)

select()

select data from db

public select(string|array<string|int, mixed>|object $table[, string|array<string|int, mixed>|object $condition = "" ][, string|array<string|int, mixed>|object $item = "" ][, string|array<string|int, mixed>|object $groupby = "" ][, string|array<string|int, mixed>|object $orderby = "" ][, string|array<string|int, mixed>|object $leftjoin = "" ]) : DbData
Parameters
$table : string|array<string|int, mixed>|object
$condition : string|array<string|int, mixed>|object = ""
$item : string|array<string|int, mixed>|object = ""
$groupby : string|array<string|int, mixed>|object = ""
$orderby : string|array<string|int, mixed>|object = ""
$leftjoin : string|array<string|int, mixed>|object = ""
Return values
DbData —

object || Boolean false

selectOne()

select one from select result

public selectOne(mixed $table[, mixed $condition = "" ][, mixed $item = "" ][, mixed $groupby = "" ][, mixed $orderby = "" ][, mixed $leftjoin = "" ]) : mixed
Parameters
$table : mixed
$condition : mixed = ""
$item : mixed = ""
$groupby : mixed = ""
$orderby : mixed = ""
$leftjoin : mixed = ""

setCount()

is count

public setCount(mixed $count) : mixed
Parameters
$count : mixed

setLimit()

page size

public setLimit(mixed $limit) : mixed
Parameters
$limit : mixed

setPage()

page number

public setPage(mixed $page) : mixed
Parameters
$page : mixed

update()

update data

public update(string|array<string|int, mixed>|object $table, string|array<string|int, mixed>|object $condition, string|array<string|int, mixed>|object $item) : int|bool
Parameters
$table : string|array<string|int, mixed>|object
$condition : string|array<string|int, mixed>|object
$item : string|array<string|int, mixed>|object
Return values
int|bool

__addsqlslashes()

private __addsqlslashes(mixed $k) : mixed
Parameters
$k : mixed

__array2string()

private __array2string(mixed $mixed[, mixed $alais = false ]) : mixed
Parameters
$mixed : mixed
$alais : mixed = false

__query()

query

private __query(string $sql[, mixed $retry = false ][, mixed $params = [] ]) : array<string|int, mixed>
Parameters
$sql : string
$retry : mixed = false
$params : mixed = []
Return values
array<string|int, mixed> —

$result || Boolean false

__quote()

private __quote(mixed $condition[, mixed $split = "AND" ][, mixed &$params = [] ]) : mixed
Parameters
$condition : mixed
$split : mixed = "AND"
$params : mixed = []

__setEngine()

private __setEngine(mixed $engineName) : mixed
Parameters
$engineName : mixed

_reInit()

construct

private _reInit() : mixed

merge_params()

merge array

private merge_params(mixed ...$arr) : mixed
Parameters
$arr : mixed 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results