/halogy/database/drivers/sqlite/sqlite_result.php

  1<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
  2/**
  3 * CodeIgniter
  4 *
  5 * An open source application development framework for PHP 4.3.2 or newer
  6 *
  7 * @package		CodeIgniter
  8 * @author		ExpressionEngine Dev Team
  9 * @copyright	Copyright (c) 2008 - 2009, EllisLab, Inc.
 10 * @license		http://codeigniter.com/user_guide/license.html
 11 * @link		http://codeigniter.com
 12 * @since		Version 1.0
 13 * @filesource
 14 */
 15
 16// ------------------------------------------------------------------------
 17
 18/**
 19 * SQLite Result Class
 20 *
 21 * This class extends the parent result class: CI_DB_result
 22 *
 23 * @category	Database
 24 * @author		ExpressionEngine Dev Team
 25 * @link		http://codeigniter.com/user_guide/database/
 26 */
 27class CI_DB_sqlite_result extends CI_DB_result {
 28	
 29	/**
 30	 * Number of rows in the result set
 31	 *
 32	 * @access	public
 33	 * @return	integer
 34	 */
 35	function num_rows()
 36	{
 37		return @sqlite_num_rows($this->result_id);
 38	}
 39	
 40	// --------------------------------------------------------------------
 41
 42	/**
 43	 * Number of fields in the result set
 44	 *
 45	 * @access	public
 46	 * @return	integer
 47	 */
 48	function num_fields()
 49	{
 50		return @sqlite_num_fields($this->result_id);
 51	}
 52
 53	// --------------------------------------------------------------------
 54
 55	/**
 56	 * Fetch Field Names
 57	 *
 58	 * Generates an array of column names
 59	 *
 60	 * @access	public
 61	 * @return	array
 62	 */
 63	function list_fields()
 64	{
 65		$field_names = array();
 66		for ($i = 0; $i < $this->num_fields(); $i++)
 67		{
 68			$field_names[] = sqlite_field_name($this->result_id, $i);
 69		}
 70		
 71		return $field_names;
 72	}
 73
 74	// --------------------------------------------------------------------
 75
 76	/**
 77	 * Field data
 78	 *
 79	 * Generates an array of objects containing field meta-data
 80	 *
 81	 * @access	public
 82	 * @return	array
 83	 */
 84	function field_data()
 85	{
 86		$retval = array();
 87		for ($i = 0; $i < $this->num_fields(); $i++)
 88		{
 89			$F 				= new stdClass();
 90			$F->name 		= sqlite_field_name($this->result_id, $i);
 91			$F->type 		= 'varchar';
 92			$F->max_length	= 0;
 93			$F->primary_key = 0;
 94			$F->default		= '';
 95
 96			$retval[] = $F;
 97		}
 98		
 99		return $retval;
100	}
101
102	// --------------------------------------------------------------------
103
104	/**
105	 * Free the result
106	 *
107	 * @return	null
108	 */		
109	function free_result()
110	{
111		// Not implemented in SQLite
112	}
113
114	// --------------------------------------------------------------------
115
116	/**
117	 * Data Seek
118	 *
119	 * Moves the internal pointer to the desired offset.  We call
120	 * this internally before fetching results to make sure the
121	 * result set starts at zero
122	 *
123	 * @access	private
124	 * @return	array
125	 */
126	function _data_seek($n = 0)
127	{
128		return sqlite_seek($this->result_id, $n);
129	}
130
131	// --------------------------------------------------------------------
132
133	/**
134	 * Result - associative array
135	 *
136	 * Returns the result set as an array
137	 *
138	 * @access	private
139	 * @return	array
140	 */
141	function _fetch_assoc()
142	{
143		return sqlite_fetch_array($this->result_id);
144	}
145	
146	// --------------------------------------------------------------------
147
148	/**
149	 * Result - object
150	 *
151	 * Returns the result set as an object
152	 *
153	 * @access	private
154	 * @return	object
155	 */
156	function _fetch_object()
157	{
158		if (function_exists('sqlite_fetch_object'))
159		{
160			return sqlite_fetch_object($this->result_id);
161		}
162		else
163		{
164			$arr = sqlite_fetch_array($this->result_id, SQLITE_ASSOC);
165			if (is_array($arr))
166			{
167				$obj = (object) $arr;
168				return $obj;
169			} else {
170				return NULL;
171			} 
172		}
173	}
174
175}
176
177
178/* End of file sqlite_result.php */
179/* Location: ./system/database/drivers/sqlite/sqlite_result.php */