Subversion Repositories Applications.papyrus

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2005 Aurelien 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, 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 
 */
27 
class 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 */