blob: 2eca68ff564a7deae5ac8974c0e86d62851bfccb [file] [log] [blame]
admin7b613c72006-09-24 18:05:17 +00001<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
2/**
3 * Code Igniter
4 *
5 * An open source application development framework for PHP 4.3.2 or newer
6 *
7 * @package CodeIgniter
8 * @author Rick Ellis
9 * @copyright Copyright (c) 2006, pMachine, Inc.
10 * @license http://www.codeignitor.com/user_guide/license.html
11 * @link http://www.codeigniter.com
12 * @since Version 1.0
13 * @filesource
14 */
15
16// ------------------------------------------------------------------------
17
18/**
19 * MySQLi Result Class
20 *
21 * This class extends the parent result class: CI_DB_result
22 *
23 * @category Database
24 * @author Rick Ellis
25 * @link http://www.codeigniter.com/user_guide/database/
26 */
27class CI_DB_mysqli_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 @mysqli_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 @mysqli_num_fields($this->result_id);
51 }
adminab4f61b2006-09-25 22:12:32 +000052
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 field_names()
64 {
65 $field_names = array();
66 while ($field = mysql_fetch_field($this->result_id))
67 {
68 $field_names[] = $field->name;
69 }
70
71 return $field_names;
72 }
73
admin7b613c72006-09-24 18:05:17 +000074 // --------------------------------------------------------------------
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 = mysqli_fetch_field($this->result_id))
88 {
89 $F = new stdClass();
90 $F->name = $field->name;
91 $F->type = $field->type;
92 $F->default = $field->def;
93 $F->max_length = $field->max_length;
94 $F->primary_key = ($field->flags & MYSQLI_PRI_KEY_FLAG) ? 1 : 0;
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 if (is_resource($this->result_id))
112 {
113 mysqli_free_result($this->result_id);
114 $this->result_id = FALSE;
115 }
116 }
117
118 // --------------------------------------------------------------------
119
120 /**
121 * Result - associative array
122 *
123 * Returns the result set as an array
124 *
125 * @access private
126 * @return array
127 */
128 function _fetch_assoc()
129 {
130 return mysqli_fetch_assoc($this->result_id);
131 }
132
133 // --------------------------------------------------------------------
134
135 /**
136 * Result - object
137 *
138 * Returns the result set as an object
139 *
140 * @access private
141 * @return object
142 */
143 function _fetch_object()
144 {
145 return mysqli_fetch_object($this->result_id);
146 }
147
148}
149
150?>