SlightPHP framework Documentation
\
SlightPHP

\SDb

Summary

Methods
Properties
Constants
__construct()
error()
init()
setCount()
setPage()
setLimit()
select()
selectOne()
update()
delete()
insert()
execute()
setConfigFile()
getConfig()
useConfig()
setConfig()
__get()
__set()
setTable()
listAll()
reset()
getAll()
get()
del()
set()
setForeignKey()
$_globals
No constants found
No protected methods found
No protected properties found
N/A
__setEngine()
_reInit()
__query()
__quote()
__addsqlslashes()
__array2string()
$engine
$params
$_engine_name
$_allow_engines
$_key
$count
$limit
$page
$error
$_config_file
$foreign_keys
$table_name
$_fields
N/A

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

$_config_file

$_config_file :

Type

$foreign_keys

$foreign_keys :

Type

$table_name

$table_name :

Type

$_fields

$_fields :

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

Type

Methods

__construct()

__construct(string  $table_name = "",   $config = array()) : void

构造方法

Parameters

string $table_name
$config

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

setConfigFile()

setConfigFile(string  $file) : void

set global db config file

Parameters

string $file

getConfig()

getConfig(string  $zone = null, string  $type = "main") : array

Parameters

string $zone
string $type

main|query

Returns

array

useConfig()

useConfig(  $zone,   $type = "main")

Parameters

$zone
$type

setConfig()

setConfig(string  $zone, string  $type = "main") : array

设置数据库配置文件

Parameters

string $zone
string $type

main|query

Returns

array

__get()

__get(  $k)

Parameters

$k

__set()

__set(  $k,   $v)

Parameters

$k
$v

setTable()

setTable(  $table_name)

Parameters

$table_name

listAll()

listAll(  $condition,   $foreign_info = false)

Parameters

$condition
$foreign_info

reset()

reset()

重设所有参数

getAll()

getAll()

得到带外键的信息

get()

get(  $foreign_info = false)

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

Parameters

$foreign_info

del()

del(  $foreign_info = false)

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

Parameters

$foreign_info

set()

set()

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

setForeignKey()

setForeignKey(  $keys = array())

设置外键关联

Parameters

$keys

__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