Subversion Repositories Applications.papyrus

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

/**

 * CodeIgniter

 *

 * An open source application development framework for PHP 4.3.2 or newer

 *

 * @package		CodeIgniter

 * @author		ExpressionEngine Dev Team

 * @copyright	Copyright (c) 2008, EllisLab, Inc.

 * @license		http://codeigniter.com/user_guide/license.html

 * @link		http://codeigniter.com

 * @since		Version 1.0

 * @filesource

 */

// ------------------------------------------------------------------------

/**

 * Database Result Class

 *

 * This is the platform-independent result class.

 * This class will not be called directly. Rather, the adapter

 * class for the specific database will extend and instantiate it.

 *

 * @category	Database

 * @author		ExpressionEngine Dev Team

 * @link		http://codeigniter.com/user_guide/database/

 */

class CI_DB_result {

	var $conn_id		= NULL;

	var $result_id		= NULL;

	var $result_array	= array();

	var $result_object	= array();

	var $current_row 	= 0;

	var $num_rows		= 0;

	var $row_data		= NULL;

	/**

	 * Query result.  Acts as a wrapper function for the following functions.

	 *

	 * @access	public

	 * @param	string	can be "object" or "array"

	 * @return	mixed	either a result object or array

	 */

	function result($type = 'object')

	{

		return ($type == 'object') ? $this->result_object() : $this->result_array();

	}

	// --------------------------------------------------------------------

	/**

	 * Query result.  "object" version.

	 *

	 * @access	public

	 * @return	object

	 */

	function result_object()

	{

		if (count($this->result_object) > 0)

		{

			return $this->result_object;

		}

		// In the event that query caching is on the result_id variable

		// will return FALSE since there isn't a valid SQL resource so

		// we'll simply return an empty array.

		if ($this->result_id === FALSE OR $this->num_rows() == 0)

		{

			return array();

		}

		$this->_data_seek(0);

		while ($row = $this->_fetch_object())

		{

			$this->result_object[] = $row;

		}

		return $this->result_object;

	}

	// --------------------------------------------------------------------

	/**

	 * Query result.  "array" version.

	 *

	 * @access	public

	 * @return	array

	 */

	function result_array()

	{

		if (count($this->result_array) > 0)

		{

			return $this->result_array;

		}

		// In the event that query caching is on the result_id variable

		// will return FALSE since there isn't a valid SQL resource so

		// we'll simply return an empty array.

		if ($this->result_id === FALSE OR $this->num_rows() == 0)

		{

			return array();

		}

		$this->_data_seek(0);

		while ($row = $this->_fetch_assoc())

		{

			$this->result_array[] = $row;

		}

		return $this->result_array;

	}

	// --------------------------------------------------------------------

	/**

	 * Query result.  Acts as a wrapper function for the following functions.

	 *

	 * @access	public

	 * @param	string

	 * @param	string	can be "object" or "array"

	 * @return	mixed	either a result object or array

	 */

	function row($n = 0, $type = 'object')

	{

		if ( ! is_numeric($n))

		{

			// We cache the row data for subsequent uses

			if ( ! is_array($this->row_data))

			{

				$this->row_data = $this->row_array(0);

			}

			// array_key_exists() instead of isset() to allow for MySQL NULL values

			if (array_key_exists($n, $this->row_data))

			{

				return $this->row_data[$n];

			}

			// reset the $n variable if the result was not achieved

			$n = 0;

		}

		return ($type == 'object') ? $this->row_object($n) : $this->row_array($n);

	}

	// --------------------------------------------------------------------

	/**

	 * Assigns an item into a particular column slot

	 *

	 * @access	public

	 * @return	object

	 */

	function set_row($key, $value = NULL)

	{

		// We cache the row data for subsequent uses

		if ( ! is_array($this->row_data))

		{

			$this->row_data = $this->row_array(0);

		}

		if (is_array($key))

		{

			foreach ($key as $k => $v)

			{

				$this->row_data[$k] = $v;

			}

			return;

		}

		if ($key != '' AND ! is_null($value))

		{

			$this->row_data[$key] = $value;

		}

	}

	// --------------------------------------------------------------------

	/**

	 * Returns a single result row - object version

	 *

	 * @access	public

	 * @return	object

	 */

	function row_object($n = 0)

	{

		$result = $this->result_object();

		if (count($result) == 0)

		{

			return $result;

		}

		if ($n != $this->current_row AND isset($result[$n]))

		{

			$this->current_row = $n;

		}

		return $result[$this->current_row];

	}

	// --------------------------------------------------------------------

	/**

	 * Returns a single result row - array version

	 *

	 * @access	public

	 * @return	array

	 */

	function row_array($n = 0)

	{

		$result = $this->result_array();

		if (count($result) == 0)

		{

			return $result;

		}

		if ($n != $this->current_row AND isset($result[$n]))

		{

			$this->current_row = $n;

		}

		return $result[$this->current_row];

	}

	// --------------------------------------------------------------------

	/**

	 * Returns the "first" row

	 *

	 * @access	public

	 * @return	object

	 */

	function first_row($type = 'object')

	{

		$result = $this->result($type);

		if (count($result) == 0)

		{

			return $result;

		}

		return $result[0];

	}

	// --------------------------------------------------------------------

	/**

	 * Returns the "last" row

	 *

	 * @access	public

	 * @return	object

	 */

	function last_row($type = 'object')

	{

		$result = $this->result($type);

		if (count($result) == 0)

		{

			return $result;

		}

		return $result[count($result) -1];

	}

	// --------------------------------------------------------------------

	/**

	 * Returns the "next" row

	 *

	 * @access	public

	 * @return	object

	 */

	function next_row($type = 'object')

	{

		$result = $this->result($type);

		if (count($result) == 0)

		{

			return $result;

		}

		if (isset($result[$this->current_row + 1]))

		{

			++$this->current_row;

		}

		return $result[$this->current_row];

	}

	// --------------------------------------------------------------------

	/**

	 * Returns the "previous" row

	 *

	 * @access	public

	 * @return	object

	 */

	function previous_row($type = 'object')

	{

		$result = $this->result($type);

		if (count($result) == 0)

		{

			return $result;

		}

		if (isset($result[$this->current_row - 1]))

		{

			--$this->current_row;

		}

		return $result[$this->current_row];

	}

	// --------------------------------------------------------------------

	/**

	 * The following functions are normally overloaded by the identically named

	 * methods in the platform-specific driver -- except when query caching

	 * is used.  When caching is enabled we do not load the other driver.

	 * These functions are primarily here to prevent undefined function errors

	 * when a cached result object is in use.  They are not otherwise fully

	 * operational due to the unavailability of the database resource IDs with

	 * cached results.

	 */

	function num_rows() { return $this->num_rows; }

	function num_fields() { return 0; }

	function list_fields() { return array(); }

	function field_data() { return array(); }

	function free_result() { return TRUE; }

	function _data_seek() { return TRUE; }

	function _fetch_assoc() { return array(); }

	function _fetch_object() { return array(); }

}

// END DB_result class

/* End of file DB_result.php */

/* Location: ./system/database/DB_result.php */