Subversion-Projekte lars-tiefland.ci

Revision

Revision 2049 | Zur aktuellen Revision | Details | 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 
 *
9 
 * Copyright (c) 2014 - 2016, British Columbia Institute of Technology
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/)
32 
 * @copyright	Copyright (c) 2014 - 2016, British Columbia Institute of Technology (http://bcit.ca/)
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 
 * MSSQL 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_mssql_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 = mssql_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 mssql_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 
		mssql_field_seek($this->result_id, 0);
90 
		while ($field = mssql_fetch_field($this->result_id))
91 
		{
92 
			$field_names[] = $field->name;
93 
		}
94 
 
95 
		return $field_names;
96 
	}
97 
 
98 
	// --------------------------------------------------------------------
99 
 
100 
	/**
101 
	 * Field data
102 
	 *
103 
	 * Generates an array of objects containing field meta-data
104 
	 *
105 
	 * @return	array
106 
	 */
107 
	public function field_data()
108 
	{
109 
		$retval = array();
110 
		for ($i = 0, $c = $this->num_fields(); $i < $c; $i++)
111 
		{
112 
			$field = mssql_fetch_field($this->result_id, $i);
113 
 
114 
			$retval[$i]		= new stdClass();
115 
			$retval[$i]->name	= $field->name;
116 
			$retval[$i]->type	= $field->type;
117 
			$retval[$i]->max_length	= $field->max_length;
118 
		}
119 
 
120 
		return $retval;
121 
	}
122 
 
123 
	// --------------------------------------------------------------------
124 
 
125 
	/**
126 
	 * Free the result
127 
	 *
128 
	 * @return	void
129 
	 */
130 
	public function free_result()
131 
	{
132 
		if (is_resource($this->result_id))
133 
		{
134 
			mssql_free_result($this->result_id);
135 
			$this->result_id = FALSE;
136 
		}
137 
	}
138 
 
139 
	// --------------------------------------------------------------------
140 
 
141 
	/**
142 
	 * Data Seek
143 
	 *
144 
	 * Moves the internal pointer to the desired offset. We call
145 
	 * this internally before fetching results to make sure the
146 
	 * result set starts at zero.
147 
	 *
148 
	 * @param	int	$n
149 
	 * @return	bool
150 
	 */
151 
	public function data_seek($n = 0)
152 
	{
153 
		return mssql_data_seek($this->result_id, $n);
154 
	}
155 
 
156 
	// --------------------------------------------------------------------
157 
 
158 
	/**
159 
	 * Result - associative array
160 
	 *
161 
	 * Returns the result set as an array
162 
	 *
163 
	 * @return	array
164 
	 */
165 
	protected function _fetch_assoc()
166 
	{
167 
		return mssql_fetch_assoc($this->result_id);
168 
	}
169 
 
170 
	// --------------------------------------------------------------------
171 
 
172 
	/**
173 
	 * Result - object
174 
	 *
175 
	 * Returns the result set as an object
176 
	 *
177 
	 * @param	string	$class_name
178 
	 * @return	object
179 
	 */
180 
	protected function _fetch_object($class_name = 'stdClass')
181 
	{
182 
		$row = mssql_fetch_object($this->result_id);
183 
 
184 
		if ($class_name === 'stdClass' OR ! $row)
185 
		{
186 
			return $row;
187 
		}
188 
 
189 
		$class_name = new $class_name();
190 
		foreach ($row as $key => $value)
191 
		{
192 
			$class_name->$key = $value;
193 
		}
194 
 
195 
		return $class_name;
196 
	}
197 
 
198 
}