db.inc.php 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. <?php
  2. /**
  3. * @package Dolphin Core
  4. * @copyright Copyright (c) BoonEx Pty Limited - http://www.boonex.com/
  5. * @license CC-BY - http://creativecommons.org/licenses/by/3.0/
  6. */
  7. defined('BX_DOL') or die('hack attempt');
  8. bx_import('BxDolDb');
  9. function db_list_tables( $error_checking = true ) {
  10. BxDolDb::getInstance()->setErrorChecking ($error_checking);
  11. return BxDolDb::getInstance()->listTables();
  12. }
  13. function db_get_encoding ( $error_checking = true ) {
  14. BxDolDb::getInstance()->setErrorChecking ($error_checking);
  15. return BxDolDb::getInstance()->getEncoding();
  16. }
  17. function db_res( $query, $error_checking = true ) {
  18. BxDolDb::getInstance()->setErrorChecking ($error_checking);
  19. return BxDolDb::getInstance()->res($query);
  20. }
  21. function db_last_id() {
  22. return BxDolDb::getInstance()->lastId();
  23. }
  24. function db_affected_rows() {
  25. return BxDolDb::getInstance()->getAffectedRows();
  26. }
  27. function db_res_assoc_arr( $query, $error_checking = true ) {
  28. BxDolDb::getInstance()->setErrorChecking ($error_checking);
  29. return BxDolDb::getInstance()->getAll($query);
  30. }
  31. function db_arr( $query, $error_checking = true ) {
  32. BxDolDb::getInstance()->setErrorChecking ($error_checking);
  33. return BxDolDb::getInstance()->getRow($query, MYSQL_BOTH);
  34. }
  35. function db_assoc_arr( $query, $error_checking = true ) {
  36. BxDolDb::getInstance()->setErrorChecking ($error_checking);
  37. return BxDolDb::getInstance()->getRow($query);
  38. }
  39. function db_value( $query, $error_checking = true, $index = 0 ) {
  40. BxDolDb::getInstance()->setErrorChecking ($error_checking);
  41. return BxDolDb::getInstance()->getOne($query, $index);
  42. }
  43. function fill_array( $res ) {
  44. return BxDolDb::getInstance()->fillArray($res, MYSQL_BOTH);
  45. }
  46. function fill_assoc_array( $res ) {
  47. return BxDolDb::getInstance()->fillArray($res, MYSQL_ASSOC);
  48. }
  49. function isParam( $param_name, $use_cache = true ) {
  50. return BxDolDb::getInstance()->isParam($param_name, $use_cache);
  51. }
  52. function addParam($sName, $sValue, $iKateg, $sDesc, $sType) {
  53. return BxDolDb::getInstance()->addParam($sName, $sValue, $iKateg, $sDesc, $sType);
  54. }
  55. function getParam( $param_name, $use_cache = true ) {
  56. return BxDolDb::getInstance()->getParam($param_name, $use_cache);
  57. }
  58. function getParamDesc( $param_name ) {
  59. return BxDolDb::getInstance()->getOne ("SELECT `desc` FROM `sys_options` WHERE `Name` = '$param_name'");
  60. }
  61. function setParam( $param_name, $param_val ) {
  62. return BxDolDb::getInstance()->setParam($param_name, $param_val);
  63. }