pdo.func.php 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
  1. <?php
  2. /**
  3. * [WeEngine System] Copyright (c) 2014 WE7.CC
  4. * WeEngine is NOT a free software, it under the license terms, visited http://www.we7.cc/ for more details.
  5. */
  6. defined('IN_IA') or exit('Access Denied');
  7. function pdo() {
  8. global $_W;
  9. static $db;
  10. if (empty($db)) {
  11. if ($_W['config']['db']['slave_status'] == true && !empty($_W['config']['db']['slave'])) {
  12. load()->classs('slave.db');
  13. $db = new SlaveDb('master');
  14. } else {
  15. load()->classs('db');
  16. if (empty($_W['config']['db']['master'])) {
  17. $_W['config']['db']['master'] = $GLOBALS['_W']['config']['db'];
  18. }
  19. $db = new DB('master');
  20. }
  21. }
  22. return $db;
  23. }
  24. function pdos($table = '') {
  25. return load()->singleton('Query');
  26. }
  27. function pdo_query($sql, $params = array()) {
  28. return pdo()->query($sql, $params);
  29. }
  30. function pdo_fetchcolumn($sql, $params = array(), $column = 0) {
  31. return pdo()->fetchcolumn($sql, $params, $column);
  32. }
  33. function pdo_fetch($sql, $params = array()) {
  34. return pdo()->fetch($sql, $params);
  35. }
  36. function pdo_fetchall($sql, $params = array(), $keyfield = '') {
  37. return pdo()->fetchall($sql, $params, $keyfield);
  38. }
  39. function pdo_get($tablename, $condition = array(), $fields = array()) {
  40. return pdo()->get($tablename, $condition, $fields);
  41. }
  42. function pdo_getall($tablename, $condition = array(), $fields = array(), $keyfield = '', $orderby = array(), $limit = array()) {
  43. return pdo()->getall($tablename, $condition, $fields, $keyfield, $orderby, $limit);
  44. }
  45. function pdo_getslice($tablename, $condition = array(), $limit = array(), &$total = null, $fields = array(), $keyfield = '', $orderby = array()) {
  46. return pdo()->getslice($tablename, $condition, $limit, $total, $fields, $keyfield, $orderby);
  47. }
  48. function pdo_getcolumn($tablename, $condition = array(), $field = '') {
  49. return pdo()->getcolumn($tablename, $condition, $field);
  50. }
  51. function pdo_exists($tablename, $condition = array()) {
  52. return pdo()->exists($tablename, $condition);
  53. }
  54. function pdo_count($tablename, $condition = array(), $cachetime = 15) {
  55. return pdo()->count($tablename, $condition, $cachetime);
  56. }
  57. function pdo_update($table, $data = array(), $params = array(), $glue = 'AND') {
  58. return pdo()->update($table, $data, $params, $glue);
  59. }
  60. function pdo_insert($table, $data = array(), $replace = false) {
  61. return pdo()->insert($table, $data, $replace);
  62. }
  63. function pdo_delete($table, $params = array(), $glue = 'AND') {
  64. return pdo()->delete($table, $params, $glue);
  65. }
  66. function pdo_insertid() {
  67. return pdo()->insertid();
  68. }
  69. function pdo_begin() {
  70. pdo()->begin();
  71. }
  72. function pdo_commit() {
  73. pdo()->commit();
  74. }
  75. function pdo_rollback() {
  76. pdo()->rollBack();
  77. }
  78. function pdo_debug($output = true, $append = array()) {
  79. return pdo()->debug($output, $append);
  80. }
  81. function pdo_run($sql) {
  82. return pdo()->run($sql);
  83. }
  84. function pdo_fieldexists($tablename, $fieldname = '') {
  85. return pdo()->fieldexists($tablename, $fieldname);
  86. }
  87. function pdo_fieldmatch($tablename, $fieldname, $datatype = '', $length = '') {
  88. return pdo()->fieldmatch($tablename, $fieldname, $datatype, $length);
  89. }
  90. function pdo_indexexists($tablename, $indexname = '') {
  91. return pdo()->indexexists($tablename, $indexname);
  92. }
  93. function pdo_fetchallfields($tablename) {
  94. $fields = pdo_fetchall("DESCRIBE {$tablename}", array(), 'Field');
  95. $fields = array_keys($fields);
  96. return $fields;
  97. }
  98. function pdo_tableexists($tablename) {
  99. return pdo()->tableexists($tablename);
  100. }