• 查询语言.sql
    • 函数原型
    • 用法如下
  • 例外 getOne 等也支持快捷

    查询语言.sql

    函数原型

    本功能特别适合用于调试 SQL，大家可以这样子用。

    1. public function sql($bFlag = true);

    用法如下

    1. /*
    2. Array
    3. (
    4.     [0] => SELECT `test`.* FROM `test` ORDER BY `test`.`create_at` DESC LIMIT 1 
    5.     [1] => Array
    6.         (
    7.         )
    9.     [2] => 
    10.     [3] => 5
    11.     [4] => 
    12.     [5] => Array
    13.         (
    14.         )
    15. )
    16. */
    17. Db::table('test')->
    19. sql(true)->
    21. latest()->
    23. getOne();
    25. /*
    26. Array
    27. (
    28.     [0] => delete from test where id = ?
    29.     [1] => Array
    30.         (
    31.             [0] => 22
    32.         )
    33. )
    34. */
    35. Db::sql(true)->
    37. delete('delete from test where id = ?', [22]);
    39. // 等效
    40. Db::delete('delete from test where id = ?', [22], true);

    例外 getOne 等也支持快捷

    1. /*
    2. Array
    3. (
    4.     [0] => SELECT `test`.* FROM `test` ORDER BY `test`.`create_at` DESC LIMIT 1 
    5.     [1] => Array
    6.         (
    7.         )
    9.     [2] => 
    10.     [3] => 5
    11.     [4] => 
    12.     [5] => Array
    13.         (
    14.         )
    16. )
    17. */
    18. Db::table('test')->
    20. latest()->
    22. getOne(true);
    24. /*
    25. public function select($strData, $arrBind = [], $bFlag = false);
    26. public function insert($mixData, $arrBind = [], $booReplace = false, $bFlag = false);
    27. public function insertAll($arrData, $arrBind = [], $booReplace = false, $bFlag = false);
    28. public function update($mixData, $arrBind = [], $bFlag = false);
    29. public function updateColumn($strColumn, $mixValue, $arrBind = [], $bFlag = false);
    30. public function updateIncrease($strColumn, $intStep = 1, $arrBind = [], $bFlag = false);
    31. public function updateDecrease($strColumn, $intStep = 1, $arrBind = [], $bFlag = false);
    32. public function delete($mixData = null, $arrBind = [], $bFlag = false);
    33. public function truncate($bFlag = false);
    34. public function statement($strData, $arrBind = [], $bFlag = false);
    35. public function getOne($bFlag = false);
    36. public function getAll($bFlag = false);
    37. public function get($nNum = null, $bFlag = false);
    38. public function value($strField, $bFlag = false);
    39. public function lists($mixFieldValue, $strFieldKey = null, $bFlag = false);
    40. public function getCount($strField = '*', $sAlias = 'row_count', $bFlag = false);
    41. public function getAvg($strField, $sAlias = 'avg_value', $bFlag = false);
    42. public function getMax($strField, $sAlias = 'max_value', $bFlag = false);
    43. public function getMin($strField, $sAlias = 'min_value', $bFlag = false);
    44. public function getSum($strField, $sAlias = 'sum_value', $bFlag = false);
    45. */