Documentation

Db
in package

Table of Contents

Properties

$allow_engines  : mixed
$count  : mixed
$engine  : mixed
$engine_name  : mixed
$error  : mixed
$limit  : mixed
$page  : mixed
$params  : mixed

Methods

__construct()  : mixed
begin()  : mixed
commit()  : mixed
delete()  : int|bool
delete
error()  : mixed
escape()  : mixed
execute()  : bool
execute sql(multi sql)
init()  : mixed
construct
insert()  : int|bool
insert
query()  : bool|int|array<string|int, mixed>
query sql and return data
rollback()  : mixed
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
buildsql()  : mixed
merge_params()  : mixed
merge array
reInit()  : mixed
setEngine()  : mixed

Properties

$allow_engines

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

$count

private mixed $count = true

$engine

private mixed $engine

$engine_name

private mixed $engine_name = "pdo_mysql"

$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"

begin()

public begin() : mixed

commit()

public commit() : mixed

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()

execute sql(multi sql)

public execute(string $sql) : bool
Parameters
$sql : string
Return values
bool

init()

construct

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

.persistent

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)

query()

query sql and return data

public query(string $sql[, mixed $params = [] ][, mixed $retry = false ]) : bool|int|array<string|int, mixed>
Parameters
$sql : string
$params : mixed = []
$retry : mixed = false
Return values
bool|int|array<string|int, mixed>

rollback()

public rollback() : mixed

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

buildsql()

private buildsql(mixed $mixed[, mixed $split = "" ][, bool $revert = true ][, bool $alias = true ][, mixed $joinflag = "," ][, mixed &$return_params = NULL ]) : mixed
Parameters
$mixed : mixed
$split : mixed = ""
$revert : bool = true

, orderby,conditon is false

$alias : bool = true

, groupby is false

$joinflag : mixed = ","
$return_params : mixed = NULL

merge_params()

merge array

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

reInit()

private reInit() : mixed

setEngine()

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

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results