[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3   *  $Id: MySQLAdapter.php,v 1.1 2004/07/27 23:08:30 hlellelid Exp $
   4   *
   5   * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
   6   * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
   7   * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
   8   * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
   9   * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  10   * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  11   * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
  12   * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
  13   * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  14   * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
  15   * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  16   *
  17   * This software consists of voluntary contributions made by many individuals
  18   * and is licensed under the LGPL. For more information please see
  19   * <http://creole.phpdb.org>.
  20   */
  21  
  22  require_once 'creole/drivers/odbc/ODBCCachedResultSet.php';
  23  require_once 'creole/drivers/odbc/ODBCResultSet.php';
  24  require_once 'creole/drivers/odbc/adapters/ODBCAdapter.php';
  25  
  26  /**
  27   * Implements MySQL driver-specific behavior.
  28   *
  29   * Obviously it would be much more efficient to simply use the Creole
  30   * MySQL driver. This adapter was created for the sole purpose of testing
  31   * the ODBC driver.
  32   *
  33   * @author    Dave Lawson <dlawson@masterytech.com>
  34   * @version   $Revision: 1.1 $
  35   * @package   creole.drivers.odbc
  36   */
  37  class MySQLAdapter extends ODBCAdapter
  38  {
  39      /**
  40       * @see ODBCAdapter::hasLimitOffset()
  41       */
  42      public function hasLimitOffset()
  43      {
  44          return true;
  45      }
  46  
  47      /**
  48       * @see ODBCAdapter::applyLimit()
  49       */
  50      public function applyLimit(&$sql, $offset, $limit)
  51      {
  52          if ( $limit > 0 ) {
  53              $sql .= " LIMIT " . ($offset > 0 ? $offset . ", " : "") . $limit;
  54          } else if ( $offset > 0 ) {
  55              $sql .= " LIMIT " . $offset . ", 18446744073709551615";
  56          }
  57      }
  58  
  59      /**
  60       * @see ODBCAdapter::escape()
  61       */
  62      public function escape($str)
  63      {
  64          return addslashes($str);
  65      }
  66  
  67      /**
  68       * @see ODBCAdapter::createResultSet()
  69       */
  70      public function createResultSet($conn, $odbcresult, $fetchmode)
  71      {
  72  //        return new ODBCCachedResultSet($conn, $odbcresult, $fetchmode, true);
  73          return new ODBCResultSet($conn, $odbcresult, $fetchmode);
  74      }
  75  
  76  }
  77  
  78  ?>