Gitee
\
app
controller
core
common
lib

\core\libMedoo

数据库类

Summary

Methods
Properties
Constants
__construct()
query()
exec()
quote()
select()
insert()
update()
delete()
replace()
get()
has()
count()
max()
min()
avg()
sum()
action()
id()
debug()
error()
last()
log()
info()
No public properties found
No constants found
generate()
tableQuote()
mapKey()
columnQuote()
columnPush()
arrayQuote()
innerConjunct()
fnQuote()
dataImplode()
whereClause()
selectContext()
columnMap()
dataMap()
$database_type
$prefix
$statement
$option
$logs
$logging
$debug_mode
$guid
N/A
No private methods found
No private properties found
N/A

Properties

$database_type

$database_type :

Type

$prefix

$prefix :

Type

$statement

$statement :

Type

$option

$option :

Type

$logs

$logs :

Type

$logging

$logging :

Type

$debug_mode

$debug_mode :

Type

$guid

$guid :

Type

Methods

__construct()

__construct(string  $options = null) : void|boolean

medoo类construct,连接数据库

Parameters

string $options

Throws

\Exception

Returns

void|boolean

query()

query(string  $query, array  $map = array()) : \core\lib\Ambigous

执行一条sql结果语句

Parameters

string $query
array $map

Returns

\core\lib\Ambigous —

<boolean, PDOStatement>

exec()

exec(string  $query, array  $map = array()) : boolean|\core\lib\PDOStatement

执行一条sql结果语句

Parameters

string $query
array $map

Returns

boolean|\core\lib\PDOStatement

quote()

quote(  $string)

Parameters

$string

select()

select(  $table,   $join,   $columns = null,   $where = null)

Parameters

$table
$join
$columns
$where

insert()

insert(  $table,   $datas)

Parameters

$table
$datas

update()

update(  $table,   $data,   $where = null)

Parameters

$table
$data
$where

delete()

delete(  $table,   $where)

Parameters

$table
$where

replace()

replace(  $table,   $columns,   $where = null)

Parameters

$table
$columns
$where

get()

get(  $table,   $join = null,   $columns = null,   $where = null)

Parameters

$table
$join
$columns
$where

has()

has(  $table,   $join,   $where = null)

Parameters

$table
$join
$where

count()

count(  $table,   $join = null,   $column = null,   $where = null)

Parameters

$table
$join
$column
$where

max()

max(  $table,   $join,   $column = null,   $where = null)

Parameters

$table
$join
$column
$where

min()

min(  $table,   $join,   $column = null,   $where = null)

Parameters

$table
$join
$column
$where

avg()

avg(  $table,   $join,   $column = null,   $where = null)

Parameters

$table
$join
$column
$where

sum()

sum(  $table,   $join,   $column = null,   $where = null)

Parameters

$table
$join
$column
$where

action()

action(  $actions)

Parameters

$actions

id()

id()

debug()

debug()

error()

error()

last()

last()

log()

log()

info()

info()

generate()

generate(  $query,   $map)

Parameters

$query
$map

tableQuote()

tableQuote(  $table)

Parameters

$table

mapKey()

mapKey()

columnQuote()

columnQuote(  $string)

Parameters

$string

columnPush()

columnPush(  $columns)

Parameters

$columns

arrayQuote()

arrayQuote(  $array)

Parameters

$array

innerConjunct()

innerConjunct(  $data,   $map,   $conjunctor,   $outer_conjunctor)

Parameters

$data
$map
$conjunctor
$outer_conjunctor

fnQuote()

fnQuote(  $column,   $string)

Parameters

$column
$string

dataImplode()

dataImplode(  $data,   $map,   $conjunctor)

Parameters

$data
$map
$conjunctor

whereClause()

whereClause(  $where,   $map)

Parameters

$where
$map

selectContext()

selectContext(  $table,   $map,   $join,   $columns = null,   $where = null,   $column_fn = null)

Parameters

$table
$map
$join
$columns
$where
$column_fn

columnMap()

columnMap(  $columns,   $stack)

Parameters

$columns
$stack

dataMap()

dataMap(  $data,   $columns,   $column_map,   $stack)

Parameters

$data
$columns
$column_map
$stack