Subversion-Projekte lars-tiefland.ci

Revision

Revision 2257 | 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
 *
2414 lars 9
 * Copyright (c) 2014 - 2019, 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/)
2414 lars 32
 * @copyright	Copyright (c) 2014 - 2019, British Columbia Institute of Technology (https://bcit.ca/)
33
 * @license	https://opensource.org/licenses/MIT	MIT License
68 lars 34
 * @link	https://codeigniter.com
35
 * @since	Version 2.1.0
36
 * @filesource
37
 */
38
defined('BASEPATH') OR exit('No direct script access allowed');
39
 
40
/**
41
 * PDO 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_pdo_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
		if (is_int($this->num_rows))
61
		{
62
			return $this->num_rows;
63
		}
64
		elseif (count($this->result_array) > 0)
65
		{
66
			return $this->num_rows = count($this->result_array);
67
		}
68
		elseif (count($this->result_object) > 0)
69
		{
70
			return $this->num_rows = count($this->result_object);
71
		}
72
		elseif (($num_rows = $this->result_id->rowCount()) > 0)
73
		{
74
			return $this->num_rows = $num_rows;
75
		}
76
 
77
		return $this->num_rows = count($this->result_array());
78
	}
79
 
80
	// --------------------------------------------------------------------
81
 
82
	/**
83
	 * Number of fields in the result set
84
	 *
85
	 * @return	int
86
	 */
87
	public function num_fields()
88
	{
89
		return $this->result_id->columnCount();
90
	}
91
 
92
	// --------------------------------------------------------------------
93
 
94
	/**
95
	 * Fetch Field Names
96
	 *
97
	 * Generates an array of column names
98
	 *
99
	 * @return	bool
100
	 */
101
	public function list_fields()
102
	{
103
		$field_names = array();
104
		for ($i = 0, $c = $this->num_fields(); $i < $c; $i++)
105
		{
106
			// Might trigger an E_WARNING due to not all subdrivers
107
			// supporting getColumnMeta()
108
			$field_names[$i] = @$this->result_id->getColumnMeta($i);
109
			$field_names[$i] = $field_names[$i]['name'];
110
		}
111
 
112
		return $field_names;
113
	}
114
 
115
	// --------------------------------------------------------------------
116
 
117
	/**
118
	 * Field data
119
	 *
120
	 * Generates an array of objects containing field meta-data
121
	 *
122
	 * @return	array
123
	 */
124
	public function field_data()
125
	{
126
		try
127
		{
128
			$retval = array();
129
 
130
			for ($i = 0, $c = $this->num_fields(); $i < $c; $i++)
131
			{
132
				$field = $this->result_id->getColumnMeta($i);
133
 
134
				$retval[$i]			= new stdClass();
135
				$retval[$i]->name		= $field['name'];
2414 lars 136
				$retval[$i]->type		= isset($field['native_type']) ? $field['native_type'] : null;
68 lars 137
				$retval[$i]->max_length		= ($field['len'] > 0) ? $field['len'] : NULL;
138
				$retval[$i]->primary_key	= (int) ( ! empty($field['flags']) && in_array('primary_key', $field['flags'], TRUE));
139
			}
140
 
141
			return $retval;
142
		}
143
		catch (Exception $e)
144
		{
145
			if ($this->db->db_debug)
146
			{
147
				return $this->db->display_error('db_unsupported_feature');
148
			}
149
 
150
			return FALSE;
151
		}
152
	}
153
 
154
	// --------------------------------------------------------------------
155
 
156
	/**
157
	 * Free the result
158
	 *
159
	 * @return	void
160
	 */
161
	public function free_result()
162
	{
163
		if (is_object($this->result_id))
164
		{
165
			$this->result_id = FALSE;
166
		}
167
	}
168
 
169
	// --------------------------------------------------------------------
170
 
171
	/**
172
	 * Result - associative array
173
	 *
174
	 * Returns the result set as an array
175
	 *
176
	 * @return	array
177
	 */
178
	protected function _fetch_assoc()
179
	{
180
		return $this->result_id->fetch(PDO::FETCH_ASSOC);
181
	}
182
 
183
	// --------------------------------------------------------------------
184
 
185
	/**
186
	 * Result - object
187
	 *
188
	 * Returns the result set as an object
189
	 *
190
	 * @param	string	$class_name
191
	 * @return	object
192
	 */
193
	protected function _fetch_object($class_name = 'stdClass')
194
	{
195
		return $this->result_id->fetchObject($class_name);
196
	}
197
 
198
}