blob: 0140ec64766c8d2b7fe53e5fd1d5a71b8750e0cf [file] [log] [blame]
Derek Allard2067d1a2008-11-13 22:59:24 +00001<?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
Derek Jones7f3719f2010-01-05 13:35:37 +00009 * @copyright Copyright (c) 2008 - 2010, EllisLab, Inc.
Derek Allard2067d1a2008-11-13 22:59:24 +000010 * @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 * MySQL 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_mysql_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 @mysql_num_rows($this->result_id);
38 }
Barry Mienydd671972010-10-04 16:33:58 +020039
Derek Allard2067d1a2008-11-13 22:59:24 +000040 // --------------------------------------------------------------------
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 @mysql_num_fields($this->result_id);
51 }
Barry Mienydd671972010-10-04 16:33:58 +020052
Derek Allard2067d1a2008-11-13 22:59:24 +000053 // --------------------------------------------------------------------
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 while ($field = mysql_fetch_field($this->result_id))
67 {
68 $field_names[] = $field->name;
69 }
Barry Mienydd671972010-10-04 16:33:58 +020070
Derek Allard2067d1a2008-11-13 22:59:24 +000071 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 while ($field = mysql_fetch_field($this->result_id))
Barry Mienydd671972010-10-04 16:33:58 +020088 {
Derek Allard2067d1a2008-11-13 22:59:24 +000089 $F = new stdClass();
Barry Mienydd671972010-10-04 16:33:58 +020090 $F->name = $field->name;
91 $F->type = $field->type;
Derek Allard2067d1a2008-11-13 22:59:24 +000092 $F->default = $field->def;
93 $F->max_length = $field->max_length;
94 $F->primary_key = $field->primary_key;
Barry Mienydd671972010-10-04 16:33:58 +020095
Derek Allard2067d1a2008-11-13 22:59:24 +000096 $retval[] = $F;
97 }
Barry Mienydd671972010-10-04 16:33:58 +020098
Derek Allard2067d1a2008-11-13 22:59:24 +000099 return $retval;
100 }
Barry Mienydd671972010-10-04 16:33:58 +0200101
Derek Allard2067d1a2008-11-13 22:59:24 +0000102 // --------------------------------------------------------------------
103
104 /**
105 * Free the result
106 *
107 * @return null
Barry Mienydd671972010-10-04 16:33:58 +0200108 */
Derek Allard2067d1a2008-11-13 22:59:24 +0000109 function free_result()
110 {
111 if (is_resource($this->result_id))
112 {
113 mysql_free_result($this->result_id);
114 $this->result_id = FALSE;
115 }
116 }
117
118 // --------------------------------------------------------------------
119
120 /**
121 * Data Seek
122 *
123 * Moves the internal pointer to the desired offset. We call
124 * this internally before fetching results to make sure the
125 * result set starts at zero
126 *
127 * @access private
128 * @return array
129 */
130 function _data_seek($n = 0)
131 {
132 return mysql_data_seek($this->result_id, $n);
133 }
134
135 // --------------------------------------------------------------------
136
137 /**
138 * Result - associative array
139 *
140 * Returns the result set as an array
141 *
142 * @access private
143 * @return array
144 */
145 function _fetch_assoc()
146 {
147 return mysql_fetch_assoc($this->result_id);
148 }
Barry Mienydd671972010-10-04 16:33:58 +0200149
Derek Allard2067d1a2008-11-13 22:59:24 +0000150 // --------------------------------------------------------------------
151
152 /**
153 * Result - object
154 *
155 * Returns the result set as an object
156 *
157 * @access private
158 * @return object
159 */
160 function _fetch_object()
161 {
162 return mysql_fetch_object($this->result_id);
163 }
Barry Mienydd671972010-10-04 16:33:58 +0200164
Derek Allard2067d1a2008-11-13 22:59:24 +0000165}
166
167
168/* End of file mysql_result.php */
Derek Jonesa3ffbbb2008-05-11 18:18:29 +0000169/* Location: ./system/database/drivers/mysql/mysql_result.php */