Subversion-Projekte lars-tiefland.ci

Revision

Revision 2049 | Revision 2254 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
68 lars 1 
<?php
2 
/**
3 
 * CodeIgniter
4 
 *
5 
 * An open source application development framework for PHP
6 
 *
7 
 * This content is released under the MIT License (MIT)
8 
 *
2242 lars 9 
 * Copyright (c) 2014 - 2018, British Columbia Institute of Technology
68 lars 10 
 *
11 
 * Permission is hereby granted, free of charge, to any person obtaining a copy
12 
 * of this software and associated documentation files (the "Software"), to deal
13 
 * in the Software without restriction, including without limitation the rights
14 
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
15 
 * copies of the Software, and to permit persons to whom the Software is
16 
 * furnished to do so, subject to the following conditions:
17 
 *
18 
 * The above copyright notice and this permission notice shall be included in
19 
 * all copies or substantial portions of the Software.
20 
 *
21 
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
22 
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
23 
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
24 
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
25 
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
26 
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
27 
 * THE SOFTWARE.
28 
 *
29 
 * @package	CodeIgniter
30 
 * @author	EllisLab Dev Team
31 
 * @copyright	Copyright (c) 2008 - 2014, EllisLab, Inc. (https://ellislab.com/)
2242 lars 32 
 * @copyright	Copyright (c) 2014 - 2018, British Columbia Institute of Technology (http://bcit.ca/)
68 lars 33 
 * @license	http://opensource.org/licenses/MIT	MIT License
34 
 * @link	https://codeigniter.com
35 
 * @since	Version 1.3.0
36 
 * @filesource
37 
 */
38 
defined('BASEPATH') OR exit('No direct script access allowed');
39 
 
40 
/**
41 
 * Postgres Result Class
42 
 *
43 
 * This class extends the parent result class: CI_DB_result
44 
 *
45 
 * @package		CodeIgniter
46 
 * @subpackage	Drivers
47 
 * @category	Database
48 
 * @author		EllisLab Dev Team
49 
 * @link		https://codeigniter.com/user_guide/database/
50 
 */
51 
class CI_DB_postgre_result extends CI_DB_result {
52 
 
53 
	/**
54 
	 * Number of rows in the result set
55 
	 *
56 
	 * @return	int
57 
	 */
58 
	public function num_rows()
59 
	{
60 
		return is_int($this->num_rows)
61 
			? $this->num_rows
62 
			: $this->num_rows = pg_num_rows($this->result_id);
63 
	}
64 
 
65 
	// --------------------------------------------------------------------
66 
 
67 
	/**
68 
	 * Number of fields in the result set
69 
	 *
70 
	 * @return	int
71 
	 */
72 
	public function num_fields()
73 
	{
74 
		return pg_num_fields($this->result_id);
75 
	}
76 
 
77 
	// --------------------------------------------------------------------
78 
 
79 
	/**
80 
	 * Fetch Field Names
81 
	 *
82 
	 * Generates an array of column names
83 
	 *
84 
	 * @return	array
85 
	 */
86 
	public function list_fields()
87 
	{
88 
		$field_names = array();
89 
		for ($i = 0, $c = $this->num_fields(); $i < $c; $i++)
90 
		{
91 
			$field_names[] = pg_field_name($this->result_id, $i);
92 
		}
93 
 
94 
		return $field_names;
95 
	}
96 
 
97 
	// --------------------------------------------------------------------
98 
 
99 
	/**
100 
	 * Field data
101 
	 *
102 
	 * Generates an array of objects containing field meta-data
103 
	 *
104 
	 * @return	array
105 
	 */
106 
	public function field_data()
107 
	{
108 
		$retval = array();
109 
		for ($i = 0, $c = $this->num_fields(); $i < $c; $i++)
110 
		{
111 
			$retval[$i]			= new stdClass();
112 
			$retval[$i]->name		= pg_field_name($this->result_id, $i);
113 
			$retval[$i]->type		= pg_field_type($this->result_id, $i);
114 
			$retval[$i]->max_length		= pg_field_size($this->result_id, $i);
115 
		}
116 
 
117 
		return $retval;
118 
	}
119 
 
120 
	// --------------------------------------------------------------------
121 
 
122 
	/**
123 
	 * Free the result
124 
	 *
125 
	 * @return	void
126 
	 */
127 
	public function free_result()
128 
	{
129 
		if (is_resource($this->result_id))
130 
		{
131 
			pg_free_result($this->result_id);
132 
			$this->result_id = FALSE;
133 
		}
134 
	}
135 
 
136 
	// --------------------------------------------------------------------
137 
 
138 
	/**
139 
	 * Data Seek
140 
	 *
141 
	 * Moves the internal pointer to the desired offset. We call
142 
	 * this internally before fetching results to make sure the
143 
	 * result set starts at zero.
144 
	 *
145 
	 * @param	int	$n
146 
	 * @return	bool
147 
	 */
148 
	public function data_seek($n = 0)
149 
	{
150 
		return pg_result_seek($this->result_id, $n);
151 
	}
152 
 
153 
	// --------------------------------------------------------------------
154 
 
155 
	/**
156 
	 * Result - associative array
157 
	 *
158 
	 * Returns the result set as an array
159 
	 *
160 
	 * @return	array
161 
	 */
162 
	protected function _fetch_assoc()
163 
	{
164 
		return pg_fetch_assoc($this->result_id);
165 
	}
166 
 
167 
	// --------------------------------------------------------------------
168 
 
169 
	/**
170 
	 * Result - object
171 
	 *
172 
	 * Returns the result set as an object
173 
	 *
174 
	 * @param	string	$class_name
175 
	 * @return	object
176 
	 */
177 
	protected function _fetch_object($class_name = 'stdClass')
178 
	{
179 
		return pg_fetch_object($this->result_id, NULL, $class_name);
180 
	}
181 
 
182 
}