• 查询数据.select
    • 函数原型
    • 原生 sql 查询
    • 直接查询 get
    • 回调处理
    • 参数为 Leevel\Database\Select

    查询数据.select

    函数原型

    1. public function select($mixData = null, $arrBind = [], $bFlag = false);

    原生 sql 查询

    1. /*
    2. Array
    3. (
    4.     [0] => select *from test where id = ?
    5.     [1] => Array
    6.         (
    7.             [0] => 1
    8.         )
    10. )
    11. */
    12. Db::table('test')->
    14. select('select *from test where id = ?', [1]);

    直接查询 get

    1. /*
    2. Array
    3. (
    4.     [0] => SELECT `test`.* FROM `test` 
    5.     [1] => Array
    6.         (
    7.         )
    9.     [2] => 
    10.     [3] => 5
    11.     [4] => 
    12.     [5] => Array
    13.         (
    14.         )
    15. )
    16. */
    17. Db::table('test')->
    19. select();

    回调处理

    1. /*
    2. Array
    3. (
    4.     [0] => SELECT `test`.* FROM `test` WHERE `test`.`id` = 1 
    5.     [1] => Array
    6.         (
    7.         )
    9.     [2] => 
    10.     [3] => 5
    11.     [4] => 
    12.     [5] => Array
    13.         (
    14.         )
    15. )
    16. */
    17. datas::table('test')->
    19. select(function($select) {
    20.     $select->where('id', 1);
    21. });

    参数为 Leevel\Database\Select

    1. /*
    2. Array
    3. (
    4.     [0] => SELECT `test`.* FROM `test` WHERE `test`.`id` = 5 
    5.     [1] => Array
    6.         (
    7.         )
    9.     [2] => 
    10.     [3] => 5
    11.     [4] => 
    12.     [5] => Array
    13.         (
    14.         )
    15. )
    16. */
    17. $select = Db::table('test')->
    19. where('id', 5);
    21. Db::select($select);