\NotORM_Result

Filtered table representation

Summary

Methods

Properties

Constants

__construct()
__destruct()
__toString()
query()
executeSql()
insert_multi()
insert()
update()
updateCounter()
updateMultiCounters()
insert_update()
insert_id()
delete()
select()
where()
__call()
__invoke()
order()
limit()
page()
group()
lock()
union()
aggregation()
count()
min()
max()
sum()
fetch()
fetchOne()
fetchRow()
fetchAll()
fetchRows()
queryAll()
queryRows()
fetchPairs()
rewind()
current()
key()
next()
valid()
offsetExists()
offsetGet()
offsetSet()
offsetUnset()
jsonSerialize()
getConn()
exec()
beginTransaction()
commit()
rollBack()
alias()
leftJoin()
()
()

$queryTimes
$

No constants found

limitString()
removeExtraDots()
whereString()
topString()
createJoins()
formatValue()
quote()
createLiteral()
mergeLiteralParamaters()
getQuoteChar()
whereOperator()
whereIn()
execute()
access()
single()

$single
$select
$conditions
$where
$parameters
$order
$limit
$offset
$group
$having
$lock
$union
$unionOrder
$unionLimit
$unionOffset
$data
$referencing
$aggregation
$accessed
$access
$keys
$aliasTableName
$leftJoins

N/A

No private methods found

No private properties found

N/A

File: notorm/src/NotORM/Result.php
Package: Default
Class hierarchy: \NotORM_Abstract

\NotORM_Result
Implements

Tags

None found

Properties

$queryTimes

$queryTimes :

Type

$

$ : string

sequence

Type

string

$single

$single :

Type

$select

$select :

Type

$conditions

$conditions :

Type

$where

$where :

Type

$parameters

$parameters :

Type

$order

$order :

Type

$limit

$limit :

Type

$offset

$offset :

Type

$group

$group :

Type

$having

$having :

Type

$lock

$lock :

Type

$union

$union :

Type

$unionOrder

$unionOrder :

Type

$unionLimit

$unionLimit :

Type

$unionOffset

$unionOffset :

Type

$data

$data :

Type

$referencing

$referencing :

Type

$aggregation

$aggregation :

Type

$accessed

$accessed :

Type

$access

$access :

Type

$keys

$keys :

Type

$aliasTableName

$aliasTableName : string

Type

string — 数据库表别名

$leftJoins

$leftJoins : array

Type

array — 关联查询设置，每组格式对应一条LEFT JOIN语句，例如：LEFT JOIN table AS B ON A.id = B.a_id

Methods

__construct()

__construct(string  $table, \NotORM  $notORM, boolean  $single = false)

Create table result

Parameters

string	$table
\NotORM	$notORM
boolean	$single	row

__destruct()

__destruct()

Save data to cache and empty result

__toString()

__toString() : string

Get SQL query

Returns

string

query()

query(  $query,   $parameters) : boolean|\PDOStatement

放开限制 protected -> public @scott 反馈

Parameters

	$query	string
	$parameters	array

Returns

boolean|\PDOStatement

executeSql()

executeSql(  $sql,   $parameters = array()) : integer

执行带结果的原生sql，可用于插入、更新、删除等执行性的语句 @dogstar 20190329

Parameters

	$sql	string
	$parameters	array

Returns

integer —

number of affected rows or false in case of an error

insert_multi()

insert_multi(array  $rows, boolean  $isIgnore = false) : integer

Shortcut for call_user_func_array(array($this, 'insert'), $rows)

Parameters

array	$rows	待批量添加的数据
boolean	$isIgnore	是否在插入时使用IGNORE

Returns

integer —

number of affected rows or false in case of an error

insert()

insert(  $data) : mixed

Insert row in a table

Parameters

$data

Returns

mixed —

inserted NotORM_Row or false in case of an error or number of affected rows for INSERT ... SELECT

update()

update(array  $data) : integer

Update all rows in result set

Parameters

array

$data

Returns

integer —

number of affected rows or false in case of an error

updateCounter()

updateCounter(  $column,   $number = 1)

Parameters

	$column
	$number

updateMultiCounters()

updateMultiCounters(array  $data)

Parameters

array

$data

insert_update()

insert_update(array  $unique, array  $insert, array  $update = array()) : integer

Insert row or update if it already exists

Parameters

array	$unique
array	$insert
array	$update

Returns

integer —

number of affected rows or false in case of an error

insert_id()

insert_id() : string

Get last insert ID

Returns

string —

number

delete()

delete() : boolean|integer

Delete all rows in result set

Throws

\Exception

Returns

boolean|integer —

number of affected rows or false in case of an error

select()

select(string  $columns) : \NotORM_Result

Add select clause, more calls appends to the end

Parameters

string

$columns

for example "column, MD5(column) AS column_md5", empty string to reset previously set columns

Returns

\NotORM_Result —

fluent interface

where()

where(  $condition,   $parameters = array()) : \NotORM_Result

Add where condition, more calls appends with AND

Parameters

	$condition
	$parameters

Returns

\NotORM_Result —

fluent interface

__call()

__call(  $name, array  $args)

Parameters

	$name
array	$args

__invoke()

__invoke(  $where,   $parameters = array()) : \NotORM_Result

Shortcut for where()

Parameters

	$where
	$parameters

Returns

\NotORM_Result —

fluent interface

order()

order(string  $columns) : \NotORM_Result

Add order clause, more calls appends to the end

Parameters

string

$columns

for example "column1, column2 DESC", empty string to reset previous order

Returns

\NotORM_Result —

fluent interface

limit()

limit(  $limit,   $offset = null) : \NotORM_Result

对查询进行limit操作请注意以下两种用法，与NotORM原来的定义有所区别 - limit(数量) - limit(开始位置，数量) Set limit clause, more calls rewrite old values

Parameters

	$limit
	$offset

Returns

\NotORM_Result —

fluent interface

page()

page(integer  $page = 1, integer  $perpage = 100)

分页

Parameters

integer	$page	第几页
integer	$perpage	每页多少条

group()

group(  $columns,   $having = "") : \NotORM_Result

Set group clause, more calls rewrite old values

Parameters

	$columns
	$having

Returns

\NotORM_Result —

fluent interface

lock()

lock(  $exclusive = true) : \NotORM_Result

Set select FOR UPDATE or LOCK IN SHARE MODE

Parameters

$exclusive

Returns

\NotORM_Result —

fluent interface

union()

union(\NotORM_Result  $result,   $all = false) : \NotORM_Result

Parameters

\NotORM_Result	$result
	$all

Returns

\NotORM_Result —

fluent interface

aggregation()

aggregation(string  $function) : string

Execute aggregation function

Parameters

string

$function

Returns

string

count()

count(  $column = "*") : integer

Count number of rows

Parameters

$column

Returns

integer

min()

min(  $column) : integer

Return minimum value from a column

Parameters

$column

Returns

integer

max()

max(  $column) : integer

Return maximum value from a column

Parameters

$column

Returns

integer

sum()

sum(  $column) : integer

Return sum of values in a column

Parameters

$column

Returns

integer

fetch()

fetch(string  $column = '') : mixed

Fetch next row of result

Parameters

string

$column

name to return or an empty string for the whole row

Returns

mixed —

string or null with $column, NotORM_Row without $column, false if there is no row

fetchOne()

fetchOne(string  $column = '') : mixed

fetchRow别名，等效于NotORM_Result::fetchRow()

Parameters

string

$column

Returns

mixed

Tags

author	: dogstar 2015-04-26

fetchRow()

fetchRow(string  $column = '') : mixed

只查询第一行纪录，等效于NotORM_Result::fetchOne()

Parameters

string

$column

Returns

mixed

Tags

author	: dogstar 2015-04-18

fetchAll()

fetchAll()

返回全部的数据，等效于NotORM_Result::fetchRows()

Tags

author	: dogstar 2014-11-01

fetchRows()

fetchRows()

fetchAll别名，等效于NotORM_Result::fetchAll()

Tags

author	: dogstar 2015-04-26

queryAll()

queryAll(string  $sql, array  $parmas = array()) : array

queryRows别名，等效于NotORM_Result::queryRows($sql, $parmas)

Parameters

string	$sql
array	$parmas

Returns

array

Tags

author	: dogstar 2015-04-26

queryRows()

queryRows(string  $sql, array  $parmas = array()) : array

根据SQL查询全部数据，等效于NotORM_Result::queryAll($sql, $parmas)

Parameters

string	$sql
array	$parmas

Returns

array

Tags

author	: dogstar 2014-11-01

fetchPairs()

fetchPairs(string  $key, string  $value = '') : array

Fetch all rows as associative array

Parameters

string	$key
string	$value	column name used for an array value or an empty string for the whole row

Returns

array

rewind()

rewind()

current()

current() : \NotORM_Row

Returns

\NotORM_Row

key()

key() : string

Returns

string —

row ID

next()

next()

valid()

valid()

offsetExists()

offsetExists(mixed  $key) : boolean

Test if row exists

Parameters

mixed

$key

Returns

boolean

offsetGet()

offsetGet(string  $key) : \NotORM_Row

Get specified row

Parameters

string

$key

row ID or array for where conditions

Returns

\NotORM_Row —

or null if there is no such row

offsetSet()

offsetSet(string  $key, \NotORM_Row  $value)

Mimic row

Parameters

string	$key	row ID
\NotORM_Row	$value

offsetUnset()

offsetUnset(string  $key)

Remove row from result set

Parameters

string

$key

row ID

jsonSerialize()

jsonSerialize()

getConn()

getConn() : \PDO

获取当前PDO连接

Returns

\PDO

exec()

exec(string  $query) : integer|false

Execute an SQL statement and return the number of affected rows

Parameters

string

$query

Returns

integer|false

beginTransaction()

beginTransaction() : boolean

开启数据库事务

Returns

boolean

commit()

commit() : boolean

提交数据库事务

Returns

boolean

rollBack()

rollBack() : boolean

回滚数据库事务

Returns

boolean

alias()

alias(  $aliasTableName)

当前表的别名，当进行关联查询时需要提前设置

Parameters

$aliasTableName

当前表的别名

leftJoin()

leftJoin(string  $joinTableName, string  $aliasJoinTableName, string  $onWhere)

关联查询，支持关联多张表

Parameters

string	$joinTableName	需要关联的表名
string	$aliasJoinTableName	关联表名的别名
string	$onWhere	关联ON条件

()

() :

NotORM_Result and (mixed $condition, mixed $parameters = array()) Add AND condition

Returns

()

() :

NotORM_Result or (mixed $condition, mixed $parameters = array()) Add OR condition

Returns

limitString()

limitString(  $limit,   $offset = null)

Parameters

	$limit
	$offset

removeExtraDots()

removeExtraDots(  $expression)

Parameters

$expression

whereString()

whereString()

topString()

topString(  $limit) : string

Parameters

$limit

Returns

string

createJoins()

createJoins(  $val)

Parameters

$val

formatValue()

formatValue(  $val)

Parameters

$val

quote()

quote(  $val)

Parameters

$val

createLiteral()

createLiteral(  $column,   $number)

Parameters

	$column
	$number

mergeLiteralParamaters()

mergeLiteralParamaters(  $parameters,   $literalParamaters)

合并NotORM_Literal的参数，让其支持:name的参数绑定方式

Parameters

	$parameters
	$literalParamaters

getQuoteChar()

getQuoteChar()

获取数据库字段的引号

Tags

author	dogstar 20170617

whereOperator()

whereOperator(  $operator, array  $args)

Parameters

	$operator
array	$args

whereIn()

whereIn(  $condition,   $parameters)

Parameters

	$condition
	$parameters

execute()

execute()

Execute the built query

access()

access(  $key,   $delete = false)

Parameters

	$key
	$delete

single()

single()