[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3   *  $Id: SQLitePreparedStatement.php,v 1.7 2004/03/20 04:16:50 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/PreparedStatement.php';
  23  require_once 'creole/common/PreparedStatementCommon.php';
  24  
  25  /**
  26   * MySQL subclass for prepared statements.
  27   * 
  28   * @author    Hans Lellelid <hans@xmpl.org>
  29   * @version   $Revision: 1.7 $
  30   * @package   creole.drivers.sqlite
  31   */
  32  class SQLitePreparedStatement extends PreparedStatementCommon implements PreparedStatement {
  33      
  34      /**
  35       * Quotes string using native sqlite_escape_string() function.
  36       * @see ResultSetCommon::escape()
  37       */
  38      protected function escape($str)
  39      {
  40          return sqlite_escape_string($str);
  41      }
  42      
  43      /**
  44       * Applies sqlite_udf_encode_binary() to ensure that binary contents will be handled correctly by sqlite.
  45       * @see PreparedStatement::setBlob()
  46       * @see ResultSet::getBlob()
  47       */
  48      function setBlob($paramIndex, $blob) 
  49      {    
  50          if ($blob === null) {
  51              $this->setNull($paramIndex);
  52          } else {
  53              // they took magic __toString() out of PHP5.0.0; this sucks
  54              if (is_object($blob)) {
  55                  $blob = $blob->__toString();
  56              }
  57              $this->boundInVars[$paramIndex] = "'" . sqlite_udf_encode_binary( $blob ) . "'";
  58          }
  59      }
  60      
  61  }