# 函數原型
~~~
public function having($mixCond /* args */);
~~~
having 和 where 用法一致，只是沒有 where exists 這種寫法。
# 字段 （表達式） 值
~~~
# SELECT `test`.`tid` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`tid` HAVING `test`.`tid` > 5
database::table ( 'test', 'tid as id,tname as value' )
->groupBy('tid')
->having('tid','>',5)
->getAll ();
~~~
# 以數組直接傳入
~~~
# SELECT `test`.`name` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`name` HAVING `test`.`name` LIKE '技術'
database::table ( 'test', 'name as id,tname as value' )
->groupBy('name')
->having(['name','like', '技術'] )
->getAll ();
~~~
# OrHaving 語法
~~~
# SELECT `test`.`name` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`name` HAVING `test`.`name` LIKE '技術' OR `test`.`tname` LIKE '技術'
database::table ( 'test', 'name as id,tname as value' )
->groupBy('name')
->having(['name','like', '技術'] )
->orHaving(['tname','like', '技術'])
->getAll ();
~~~
# havingBetween 語法
~~~
# SELECT `test`.`name` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`name` HAVING `test`.`id` BETWEEN 1 AND 10 AND `test`.`id` BETWEEN 1 AND 100
database::table ( 'test', 'name as id,tname as value' )
->groupBy('name')
->having('id','between', [1,10])
->havingBetween('id', [1, 100])
->getAll ();
~~~
# havingBetween 二維數組語法支持
后面的語法均支持這樣的寫法，后面不再繼續示例了。
~~~
# SELECT `test`.`name` AS `id`,`test`.`tname` AS `value` FROM `test` GROUP BY `test`.`name` HAVING `test`.`name` BETWEEN 1 AND 100 AND `test`.`tname` BETWEEN 5 AND 22
database::table ( 'test', 'name as id,tname as value' )
->groupBy('name')
->havingBetween( [ ['name', [1, 100]], ['tname', [5, 22]] ])
->getAll ();
~~~
# havingNotBetween 語法
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`name` HAVING `test`.`id` NOT BETWEEN 1 AND 10 AND `test`.`id` NOT BETWEEN 1 AND 100
database::table ( 'test')
->groupBy('name')
->having('id','not between', [1,10])
->havingNotBetween('id', [1, 100])
->getAll ();
~~~
# havingIn 語法
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`name` HAVING `test`.`id` IN (2,50) AND `test`.`num` IN (2,50)
database::table ( 'test')
->groupBy('name')
->having('id','in', [2,50])
->havingIn('num', [2,50])
->getAll ();
~~~
# havingNotIn 語法
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`name` HAVING `test`.`id` NOT IN (2,50) AND `test`.`num` NOT IN (2,50)
database::table ( 'test')
->groupBy('name')
->having('id','not in', [2,50])
->havingNotIn('num', [2,50])
->getAll ();
~~~
# havingNull 語法
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`name` HAVING `test`.`id` IS NULL AND `test`.`num` IS NULL
database::table ( 'test')
->groupBy('name')
->having('id','null')
->havingNull('num')
->getAll ();
~~~
# havingNotNull 語法
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`name` HAVING `test`.`id` IS NOT NULL AND `test`.`num` IS NOT NULL
database::table ( 'test')
->groupBy('name')
->having('id','not null')
->havingNotNull('num')
->getAll ();
~~~
# 分組查詢
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`id` HAVING `test`.`id` = 5 OR (`test`.`votes` > 100 AND `test`.`title` <> 'Admin')
database::table ( 'test' )
->groupBy('id')
->having ( 'id', 5 )
->orHaving ( function ($objSelect) {
$objSelect->having ( 'votes', '>', 100 )->having ( 'title', '<>', 'Admin' );
} )
->getAll ();
# SELECT `test`.* FROM `test` GROUP BY `test`.`id` HAVING `test`.`id` = 5 OR `test`.`name` = '小牛' AND (`test`.`votes` > 100 OR `test`.`title` <> 'Admin')
database::table ( 'test' )
->groupBy('id')
->having ( 'id', 5 )
->orHaving ( 'name', '小牛' )
->having ( function ($objSelect) {
$objSelect->having ( 'votes', '>', 100 )->orHaving ( 'title', '<>', 'Admin' );
} )
->getAll ();
~~~
# 條件表達式支持
條件表達式由“{}”包起來表示支持條件表達式，“[]”表示支持字段格式化。
~~~
# SELECT `test`.`post`,`test`.`value`,concat("tt_",`test`.`id`) FROM `test` GROUP BY `test`.`id` HAVING concat("hello_",`test`.`posts`) = `test`.`id`
database::table ( 'test', 'post,value,{concat("tt_",[id])}' )
->groupBy('id')
->having ( '{concat("hello_",[posts])}', '=', '{[id]}' )
->getAll ();
~~~
# 字段作為鍵值
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`id` HAVING `test`.`id` = '故事' AND `test`.`name` IN (1,2,3) AND `test`.`weidao` BETWEEN '40' AND '100' AND `test`.`value` IS NULL AND `test`.`remark` IS NOT NULL AND `test`.`goods` = '東亞商品' AND `test`.`hello` = 'world'
database::table ( 'test' )
->groupBy('id')
->having ( [
'id' => [ '=','故事' ],
'name' => ['in',[1,2,3]],
'weidao' => ['between','40,100'],
'value' => 'null',
'remark' => ['not null'],
'goods' => '東亞商品',
'hello' => ['world']
] )->getAll ();
~~~
# string__ 支持（支持字段）
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`id` HAVING `test`.`name` = 11 and `post`.`value` = 22 and concat("tt_",`test`.`id`)
database::table ( 'test')
->groupBy('id')
->having (
['string__' => '{[name] = 11 and [post.value] = 22 and concat("tt_",[id])}']
)
->getAll ();
~~~
# subor__ 和 suband__ 支持
~~~
# SELECT `test`.* FROM `test` GROUP BY `test`.`id` HAVING `test`.`hello` = 'world' OR (`test`.`id` LIKE '你好')
database::table ( 'test')
->groupBy('id')
->having (
[
'hello' => 'world',
'subor__' => ['id','like','你好']
]
)
->getAll ();
# SELECT `test`.* FROM `test` GROUP BY `test`.`id` HAVING `test`.`hello` = '111' OR (`test`.`id` LIKE '你好' AND `test`.`value` = 'helloworld') AND (`test`.`id` LIKE '你好' OR `test`.`value` = 'helloworld' OR (`test`.`child_one` > '123' AND `test`.`child_two` LIKE '123'))
database::table ( 'test')
->groupBy('id')
->having (
[
'hello' => '111',
'subor__' => [
['id','like','你好'],
['value','=','helloworld']
],
'suband__' => [
'logic__' => 'or',
['id','like','你好'],
['value','=','helloworld'],
'subor__' => [
['child_one','>','123'],
['child_two','like','123'],
]
]
]
)
->getAll ();
~~~
- 關于 QueryPHP
- 獲取 QueryPHP
- 環境要求
- 許可協議 Free
- 執行流程 MVC
- 命名規范 $sName
- 目錄結構 DIR
- 單一入口 index.php
- 響應客戶端請求 URL
- 命名空間與自動載入 Autoload
- 路由
- 路由導入
- 批量導入
- 參數正則
- 分組定義
- 路由綁定
- 路由域名
- 分層控制器
- 默認和初始化APP
- 默認控制器和方法
- url 模式
- url 生成
- url 偽靜態
- url 重寫
- url 重定向
- 控制器綁定
- 方法器分層
- 控制器 __init
- 控制器方法交互
- 模板引擎語法
- C變量輸出 $sName
- C變量支持函數和方法 $sName|trim
- C快捷輸出 ~
- C標簽簡化 Css & Javascript
- C默認值 eq 三元運算符
- C變量運算符 +-
- 變量遞增遞減 ++--
- C循環數據 list
- N變量賦值 assign
- N循環數據 list
- N循環數據高級版 lists
- C循環數據 while
- N循環數據 while
- C循環數據 for
- N循環數據 for
- C條件判斷 if
- N條件判斷 if
- 標簽嵌套無限層級
- N循環流程 break & continue
- N使用 PHP 代碼
- N包含子模板 include
- J模板引擎 intro
- J條件判斷 if
- J循環數據 each
- J變量 & 表達式
- J變量支持函數和方法 hello|test
- J默認值 eq 三元運算符
- J框架前端組件 jquery.queryphp.js
- J前端 CSS 規范
- J前端 JS 規范
- 保護標簽自身 tagself
- 數據庫
- 數據庫配置
- 執行原生 sql 語句
- 數據庫事務
- 數據庫構造器 prefix
- 數據庫構造器 table
- 數據庫構造器 forceIndex
- 數據庫構造器 where
- 數據庫構造器 bind
- 數據庫構造器 join
- 數據庫構造器 union
- 數據庫構造器 orderBy
- 數據庫構造器 groupBy
- 數據庫構造器 having
- 數據庫構造器 distinct
- 數據庫構造器 aggregate
- 數據庫構造器 limit
- 數據庫構造器 forUpdate
- 數據庫構造器 columns
- 數據庫構造器 reset
- 數據庫集合查詢
- 數據庫查詢數據 get
- 數據庫查詢多條數據 getAll
- 數據庫查詢單條數據 getOne
- 數據庫查詢聚合查詢 aggregate
- 數據庫寫入數據 insert
- 數據庫寫入數據 insertAll
- 配置
- 配置格式
- 慣性配置
- 配置文件
- 讀取配置
- 設置配置
- 刪除配置
- 日志
- 日志配置參數
- 日志路徑
- 日志過濾器
- 日志處理器
- 緩存
- 緩存配置參數
- 緩存路徑
- 緩存指定時間
- COOKIE
- COOKIE 配置參數
- 開發調試
- 頁面 trace