411 lines
8.8 KiB
PHP
411 lines
8.8 KiB
PHP
|
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
|
||
|
|
/**
|
||
|
|
* CodeIgniter
|
||
|
|
*
|
||
|
|
* An open source application development framework for PHP 5.1.6 or newer
|
||
|
|
*
|
||
|
|
* @package CodeIgniter
|
||
|
|
* @author ExpressionEngine Dev Team
|
||
|
|
* @copyright Copyright (c) 2008 - 2011, 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 $custom_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
|
||
|
|
*/
|
||
|
|
public function result($type = 'object')
|
||
|
|
{
|
||
|
|
if ($type == 'array') return $this->result_array();
|
||
|
|
else if ($type == 'object') return $this->result_object();
|
||
|
|
else return $this->custom_result_object($type);
|
||
|
|
}
|
||
|
|
|
||
|
|
// --------------------------------------------------------------------
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Custom query result.
|
||
|
|
*
|
||
|
|
* @param class_name A string that represents the type of object you want back
|
||
|
|
* @return array of objects
|
||
|
|
*/
|
||
|
|
public function custom_result_object($class_name)
|
||
|
|
{
|
||
|
|
if (array_key_exists($class_name, $this->custom_result_object))
|
||
|
|
{
|
||
|
|
return $this->custom_result_object[$class_name];
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($this->result_id === FALSE OR $this->num_rows() == 0)
|
||
|
|
{
|
||
|
|
return array();
|
||
|
|
}
|
||
|
|
|
||
|
|
// add the data to the object
|
||
|
|
$this->_data_seek(0);
|
||
|
|
$result_object = array();
|
||
|
|
|
||
|
|
while ($row = $this->_fetch_object())
|
||
|
|
{
|
||
|
|
$object = new $class_name();
|
||
|
|
|
||
|
|
foreach ($row as $key => $value)
|
||
|
|
{
|
||
|
|
$object->$key = $value;
|
||
|
|
}
|
||
|
|
|
||
|
|
$result_object[] = $object;
|
||
|
|
}
|
||
|
|
|
||
|
|
// return the array
|
||
|
|
return $this->custom_result_object[$class_name] = $result_object;
|
||
|
|
}
|
||
|
|
|
||
|
|
// --------------------------------------------------------------------
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Query result. "object" version.
|
||
|
|
*
|
||
|
|
* @access public
|
||
|
|
* @return object
|
||
|
|
*/
|
||
|
|
public 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
|
||
|
|
*/
|
||
|
|
public 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
|
||
|
|
*/
|
||
|
|
public 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;
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($type == 'object') return $this->row_object($n);
|
||
|
|
else if ($type == 'array') return $this->row_array($n);
|
||
|
|
else return $this->custom_row_object($n, $type);
|
||
|
|
}
|
||
|
|
|
||
|
|
// --------------------------------------------------------------------
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Assigns an item into a particular column slot
|
||
|
|
*
|
||
|
|
* @access public
|
||
|
|
* @return object
|
||
|
|
*/
|
||
|
|
public 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 - custom object version
|
||
|
|
*
|
||
|
|
* @access public
|
||
|
|
* @return object
|
||
|
|
*/
|
||
|
|
public function custom_row_object($n, $type)
|
||
|
|
{
|
||
|
|
$result = $this->custom_result_object($type);
|
||
|
|
|
||
|
|
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 - object version
|
||
|
|
*
|
||
|
|
* @access public
|
||
|
|
* @return object
|
||
|
|
*/
|
||
|
|
public 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
|
||
|
|
*/
|
||
|
|
public 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
|
||
|
|
*/
|
||
|
|
public 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
|
||
|
|
*/
|
||
|
|
public 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
|
||
|
|
*/
|
||
|
|
public 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
|
||
|
|
*/
|
||
|
|
public 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.
|
||
|
|
*/
|
||
|
|
public function num_rows() { return $this->num_rows; }
|
||
|
|
public function num_fields() { return 0; }
|
||
|
|
public function list_fields() { return array(); }
|
||
|
|
public function field_data() { return array(); }
|
||
|
|
public function free_result() { return TRUE; }
|
||
|
|
protected function _data_seek() { return TRUE; }
|
||
|
|
protected function _fetch_assoc() { return array(); }
|
||
|
|
protected function _fetch_object() { return array(); }
|
||
|
|
|
||
|
|
}
|
||
|
|
// END DB_result class
|
||
|
|
|
||
|
|
/* End of file DB_result.php */
|
||
|
|
/* Location: ./system/database/DB_result.php */
|