ibase.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109
  1. <?php
  2. // +----------------------------------------------------------------------+
  3. // | PHP versions 4 and 5 |
  4. // +----------------------------------------------------------------------+
  5. // | Copyright (c) 1998-2006 Manuel Lemos, Tomas V.V.Cox, |
  6. // | Stig. S. Bakken, Lukas Smith, Lorenzo Alberton |
  7. // | All rights reserved. |
  8. // +----------------------------------------------------------------------+
  9. // | MDB2 is a merge of PEAR DB and Metabases that provides a unified DB |
  10. // | API as well as database abstraction for PHP applications. |
  11. // | This LICENSE is in the BSD license style. |
  12. // | |
  13. // | Redistribution and use in source and binary forms, with or without |
  14. // | modification, are permitted provided that the following conditions |
  15. // | are met: |
  16. // | |
  17. // | Redistributions of source code must retain the above copyright |
  18. // | notice, this list of conditions and the following disclaimer. |
  19. // | |
  20. // | Redistributions in binary form must reproduce the above copyright |
  21. // | notice, this list of conditions and the following disclaimer in the |
  22. // | documentation and/or other materials provided with the distribution. |
  23. // | |
  24. // | Neither the name of Manuel Lemos, Tomas V.V.Cox, Stig. S. Bakken, |
  25. // | Lukas Smith nor the names of his contributors may be used to endorse |
  26. // | or promote products derived from this software without specific prior|
  27. // | written permission. |
  28. // | |
  29. // | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
  30. // | "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
  31. // | LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS |
  32. // | FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE |
  33. // | REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, |
  34. // | INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |
  35. // | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS|
  36. // | OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED |
  37. // | AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT |
  38. // | LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY|
  39. // | WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
  40. // | POSSIBILITY OF SUCH DAMAGE. |
  41. // +----------------------------------------------------------------------+
  42. // | Author: Lorenzo Alberton <l.alberton@quipo.it> |
  43. // +----------------------------------------------------------------------+
  44. //
  45. // $Id$
  46. require_once 'MDB2/Driver/Function/Common.php';
  47. /**
  48. * MDB2 FireBird/InterBase driver for the function modules
  49. *
  50. * @package MDB2
  51. * @category Database
  52. * @author Lukas Smith <smith@pooteeweet.org>
  53. */
  54. class MDB2_Driver_Function_ibase extends MDB2_Driver_Function_Common
  55. {
  56. // {{{ functionTable()
  57. /**
  58. * return string for internal table used when calling only a function
  59. *
  60. * @return string for internal table used when calling only a function
  61. * @access public
  62. */
  63. function functionTable()
  64. {
  65. return ' FROM RDB$DATABASE';
  66. }
  67. // }}}
  68. // {{{ length()
  69. /**
  70. * return string to call a function to get a replacement inside an SQL statement.
  71. *
  72. * @return string to call a function to get a replace
  73. * @access public
  74. */
  75. function length($expression)
  76. {
  77. return "STRLEN($expression)";
  78. }
  79. // }}}
  80. // {{{ replace()
  81. /**
  82. * return string to call a function to get a replacement inside an SQL statement.
  83. *
  84. * @return string to call a function to get a replace
  85. * @access public
  86. */
  87. function replace($str, $from_str, $to_str)
  88. {
  89. $db = $this->getDBInstance();
  90. if (MDB2::isError($db)) {
  91. return $db;
  92. }
  93. $error = $db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
  94. 'method not implemented', __FUNCTION__);
  95. return $error;
  96. }
  97. // }}}
  98. }
  99. ?>