查询语言.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. */