Home | Classes | Modules | Annotated | Functions | Files

MySQLResultSet.php

Go to the documentation of this file.

<?php
/*
 *  $Id: MySQLResultSet.php,v 1.2 2004/03/29 18:46:46 micha Exp $
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information please see
 * <http://creole.phpdb.org>.
 */

//
// STATUS:
// - ported:   y
// - exceptions: y
// - compiled: y
// - tested:   n
//

require_once 'creole/common/ResultSetCommon.php';

class MySQLResultSet extends ResultSetCommon
{
  function seek($rownum)
  {
    // MySQL rows start w/ 0, but this works, because we are
    // looking to move the position _before_ the next desired position
    if (!@mysql_data_seek($this->result, $rownum)) {
                return false;
    }
    $this->cursorPos = $rownum;
    return true;
  }


  function next()
  {
    $this->fields = mysql_fetch_array($this->result, $this->fetchmode);

    if (!$this->fields) {
      $errno = mysql_errno($this->conn->getResource());
      if (!$errno) {
        // We've advanced beyond end of recordset.
        $this->afterLast();
        return false;
      }
      else {
        return new SQLException(CREOLE_ERROR, "Error fetching result", mysql_error($this->conn->getResource()));
      }
    }

    if (!$this->ignoreAssocCase) {
        $this->fields = array_change_key_case($this->fields, CASE_LOWER);
    }

    // Advance cursor position
    $this->cursorPos++;
    return true;
  }

  function getRecordCount()
  {
    $rows = @mysql_num_rows($this->result);
    if ($rows === null) {
      return new SQLException(CREOLE_ERROR, "Error fetching num rows", mysql_error($this->conn->getResource()));
    }
    return (int) $rows;
  }

  function close()
  {
    @mysql_free_result($this->result);
    $this->fields = array();
  }

  function getString($column)
  {
    $idx = (is_int($column) ? $column - 1 : $column);
    if (!array_key_exists($idx, $this->fields)) {
      return new SQLException(CREOLE_ERROR_INVALID, "Invalid resultset column: " . $column);
    }
    if ($this->fields[$idx] === null) { return null; }
    return (string) $this->fields[$idx];
  }

  function getTimestamp($column, $format='Y-m-d H:i:s')
  {
    if (is_int($column)) { $column--; } // because Java convention is to start at 1
    if (!array_key_exists($column, $this->fields)) {
      return new SQLException(CREOLE_ERROR_INVALID, "Invalid resultset column: " . (is_int($column) ? $column + 1 : $column));
    }

    if ($this->fields[$column] === null) { return null; }

    $ts = strtotime($this->fields[$column]);
    if ($ts === -1) {
        // otherwise it's an ugly MySQL timestamp!
      // YYYYMMDDHHMMSS
      if (preg_match('/([\d]{4})([\d]{2})([\d]{2})([\d]{2})([\d]{2})([\d]{2})/', $this->fields[$column], $matches)) {
        //        YYYY      MM        DD      HH        MM       SS
        //        $1    $2      $3    $4    $5     $6
          $ts = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
      }
    }
    if ($ts === -1) { // if it's still -1, then there's nothing to be done; use a different method.
      return new SQLException(CREOLE_ERROR_INVALID, "Unable to convert value at column " . (is_int($column) ? $column + 1 : $column) . " to timestamp: " . $this->fields[$column]);
    }
    if ($ts === null) {
      return $ts;
    }
    if (strpos($format, '%') !== false) {
      return strftime($format, $ts);
    } else {
      return date($format, $ts);
    }
  }

}

---

This file is part of the Creole[php4] library.