Documentation

SDb extends Db
in package

SlightPHP

Properties

$_config_file : mixed
$_fields : mixed: 字段属性结构 $user->id=1; $user->name="XX"; $user->nickname="nickname"; $user->profile->address="my address"; $user->profile->comment="comment";
$allow_engines : mixed
$count : mixed
$engine : mixed
$engine_name : mixed
$error : mixed
$foreign_keys : mixed
$limit : mixed
$page : mixed
$params : mixed
$table_name : mixed

Methods

__construct() : void: 构造方法
__get() : mixed
__set() : mixed
begin() : mixed
commit() : mixed
del() : mixed: 删除信息,可以连带外键一起删除
delete() : int|bool: delete
error() : mixed
escape() : mixed
execute() : bool: execute sql(multi sql)
get() : mixed: 得到信息，返回数组，可以用对像获取本身
getAll() : mixed: 得到带外键的信息
getConfig() : array<string|int, mixed>
init() : mixed: construct
insert() : int|bool: insert
listAll() : mixed
query() : bool|int|array<string|int, mixed>: query sql and return data
reset() : mixed: 重设所有参数
rollback() : mixed
select() : DbData: select data from db
selectOne() : mixed: select one from select result
set() : mixed: 保存信息,支持外键属性保存当外键属性保存时，特别注意: 你必须初始化外键的值，否则可能无效，如: $test->user_profile = new stdclass; $test->user_profile->field_name = "field_value";
setConfig() : array<string|int, mixed>: 设置数据库配置文件
setConfigFile() : void: set global db config file
setCount() : mixed: is count
setForeignKey() : mixed: 设置外键关联
setLimit() : mixed: page size
setPage() : mixed: page number
setTable() : mixed
update() : int|bool: update data
useConfig() : mixed
buildsql() : mixed
merge_params() : mixed: merge array
reInit() : mixed
setEngine() : mixed

$_config_file


    private
    static    mixed
    $_config_file

$_fields

字段属性结构 $user->id=1; $user->name="XX"; $user->nickname="nickname"; $user->profile->address="my address"; $user->profile->comment="comment";


    private
        mixed
    $_fields

$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' => "")

$foreign_keys


    private
        mixed
    $foreign_keys
     = array()

$limit


    private
        mixed
    $limit
     = 0

$page


    private
        mixed
    $page
     = 1

$params


    private
        mixed
    $params

$table_name


    private
        mixed
    $table_name
     = ""

__construct()

构造方法


    public
                    __construct([string $table_name = "" ][, mixed $config = array() ]) : void

Parameters

$table_name : string = ""
$config : mixed = array()

__get()


    public
                    __get(mixed $k) : mixed

Parameters

$k : mixed

__set()


    public
                    __set(mixed $k, mixed $v) : mixed

Parameters

$k : mixed
$v : mixed

begin()


    public
                    begin() : mixed

commit()


    public
                    commit() : mixed

del()

删除信息,可以连带外键一起删除


    public
                    del([mixed $foreign_info = false ]) : mixed

Parameters

$foreign_info : mixed = false

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

get()

得到信息，返回数组，可以用对像获取本身


    public
                    get([mixed $foreign_info = false ]) : mixed

Parameters

$foreign_info : mixed = false

getAll()

得到带外键的信息


    public
                    getAll() : mixed

getConfig()


    public
            static        getConfig([string $zone = null ][, string $type = "main" ]) : array<string|int, mixed>

Parameters

$zone : string = null
$type : string = "main": main|query

Return values

array<string|int, mixed>

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)

listAll()


    public
                    listAll(mixed $condition[, mixed $foreign_info = false ]) : mixed

Parameters

$condition : mixed
$foreign_info : mixed = false

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>

reset()

重设所有参数


    public
                    reset() : 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 = ""

set()

保存信息,支持外键属性保存当外键属性保存时，特别注意: 你必须初始化外键的值，否则可能无效，如: $test->user_profile = new stdclass; $test->user_profile->field_name = "field_value";


    public
                    set() : mixed

setConfig()

设置数据库配置文件


    public
                    setConfig(string $zone[, string $type = "main" ]) : array<string|int, mixed>

Parameters

$zone : string
$type : string = "main": main|query

Return values

array<string|int, mixed>

setConfigFile()

set global db config file


    public
            static        setConfigFile(string $file) : void

Parameters

$file : string

setCount()

is count


    public
                    setCount(mixed $count) : mixed

Parameters

$count : mixed

setForeignKey()

设置外键关联


    public
                    setForeignKey([mixed $keys = array() ]) : mixed

Parameters

$keys : mixed = array()

setLimit()

page size


    public
                    setLimit(mixed $limit) : mixed

Parameters

$limit : mixed

setPage()

page number


    public
                    setPage(mixed $page) : mixed

Parameters

$page : mixed

setTable()


    public
                    setTable(mixed $table_name) : mixed

Parameters

$table_name : 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

useConfig()


    public
                    useConfig(mixed $zone[, mixed $type = "main" ]) : mixed

use setConfig

Parameters

$zone : mixed
$type : mixed = "main"

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

SDb extends Db in package SlightPHP

Table of Contents

Properties

Methods

Properties

$_config_file

$_fields

$allow_engines

$count

$engine

$engine_name

$error

$foreign_keys

$limit

$page

$params

$table_name

Methods

__construct()

Parameters

__get()

Parameters

__set()

Parameters

begin()

commit()

del()

Parameters

delete()

Parameters

Return values

error()

escape()

Parameters

execute()

Parameters

Return values

get()

Parameters

getAll()

getConfig()

Parameters

Return values

init()

Parameters

insert()

Parameters

Return values

listAll()

Parameters

query()

Parameters

Return values

reset()

rollback()

select()

Parameters

Return values

selectOne()

Parameters

set()

setConfig()

Parameters

Return values

setConfigFile()

Parameters

setCount()

Parameters

setForeignKey()

Parameters

setLimit()

Parameters

setPage()

Parameters

setTable()

Parameters

update()

Parameters

Return values

useConfig()

SDb extends Db
in package

SlightPHP