blob: d55188e684336116e7e9254f9017cd5a164a7b76 [file] [log] [blame]
Andrey Andreevc5536aa2012-11-01 17:33:58 +02001<?php
Derek Allard2067d1a2008-11-13 22:59:24 +00002/**
3 * CodeIgniter
4 *
Phil Sturgeon07c1ac82012-03-09 17:03:37 +00005 * An open source application development framework for PHP 5.2.4 or newer
Derek Allard2067d1a2008-11-13 22:59:24 +00006 *
Derek Jonesf4a4bd82011-10-20 12:18:42 -05007 * NOTICE OF LICENSE
Andrey Andreev1ff49e02012-01-27 11:30:41 +02008 *
Derek Jonesf4a4bd82011-10-20 12:18:42 -05009 * Licensed under the Open Software License version 3.0
Andrey Andreev1ff49e02012-01-27 11:30:41 +020010 *
Derek Jonesf4a4bd82011-10-20 12:18:42 -050011 * This source file is subject to the Open Software License (OSL 3.0) that is
12 * bundled with this package in the files license.txt / license.rst. It is
13 * also available through the world wide web at this URL:
14 * http://opensource.org/licenses/OSL-3.0
15 * If you did not receive a copy of the license and are unable to obtain it
16 * through the world wide web, please send an email to
17 * licensing@ellislab.com so we can send you a copy immediately.
18 *
Derek Allard2067d1a2008-11-13 22:59:24 +000019 * @package CodeIgniter
Derek Jonesf4a4bd82011-10-20 12:18:42 -050020 * @author EllisLab Dev Team
Greg Aker0defe5d2012-01-01 18:46:41 -060021 * @copyright Copyright (c) 2008 - 2012, EllisLab, Inc. (http://ellislab.com/)
Derek Jonesf4a4bd82011-10-20 12:18:42 -050022 * @license http://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
Derek Allard2067d1a2008-11-13 22:59:24 +000023 * @link http://codeigniter.com
24 * @since Version 1.0
25 * @filesource
26 */
Andrey Andreevc5536aa2012-11-01 17:33:58 +020027defined('BASEPATH') OR exit('No direct script access allowed');
Derek Allard2067d1a2008-11-13 22:59:24 +000028
Derek Allard2067d1a2008-11-13 22:59:24 +000029/**
30 * MySQLi Result Class
31 *
32 * This class extends the parent result class: CI_DB_result
33 *
34 * @category Database
Derek Jonesf4a4bd82011-10-20 12:18:42 -050035 * @author EllisLab Dev Team
Derek Allard2067d1a2008-11-13 22:59:24 +000036 * @link http://codeigniter.com/user_guide/database/
Andrey Andreevc7db6bb2012-07-05 15:11:20 +030037 * @since 1.3
Derek Allard2067d1a2008-11-13 22:59:24 +000038 */
39class CI_DB_mysqli_result extends CI_DB_result {
Barry Mienydd671972010-10-04 16:33:58 +020040
Derek Allard2067d1a2008-11-13 22:59:24 +000041 /**
42 * Number of rows in the result set
43 *
Andrey Andreev1ff49e02012-01-27 11:30:41 +020044 * @return int
Derek Allard2067d1a2008-11-13 22:59:24 +000045 */
Andrey Andreev1ff49e02012-01-27 11:30:41 +020046 public function num_rows()
Derek Allard2067d1a2008-11-13 22:59:24 +000047 {
Andrey Andreevc7db6bb2012-07-05 15:11:20 +030048 return is_int($this->num_rows)
49 ? $this->num_rows
50 : $this->num_rows = $this->result_id->num_rows;
Derek Allard2067d1a2008-11-13 22:59:24 +000051 }
Barry Mienydd671972010-10-04 16:33:58 +020052
Derek Allard2067d1a2008-11-13 22:59:24 +000053 // --------------------------------------------------------------------
54
55 /**
56 * Number of fields in the result set
57 *
Andrey Andreev1ff49e02012-01-27 11:30:41 +020058 * @return int
Derek Allard2067d1a2008-11-13 22:59:24 +000059 */
Andrey Andreev1ff49e02012-01-27 11:30:41 +020060 public function num_fields()
Derek Allard2067d1a2008-11-13 22:59:24 +000061 {
Andrey Andreev992f1752012-03-19 16:58:43 +020062 return $this->result_id->field_count;
Derek Allard2067d1a2008-11-13 22:59:24 +000063 }
64
65 // --------------------------------------------------------------------
66
67 /**
68 * Fetch Field Names
69 *
70 * Generates an array of column names
71 *
Derek Allard2067d1a2008-11-13 22:59:24 +000072 * @return array
73 */
Andrey Andreev1ff49e02012-01-27 11:30:41 +020074 public function list_fields()
Derek Allard2067d1a2008-11-13 22:59:24 +000075 {
76 $field_names = array();
Andrey Andreev992f1752012-03-19 16:58:43 +020077 while ($field = $this->result_id->fetch_field())
Derek Allard2067d1a2008-11-13 22:59:24 +000078 {
79 $field_names[] = $field->name;
80 }
Barry Mienydd671972010-10-04 16:33:58 +020081
Derek Allard2067d1a2008-11-13 22:59:24 +000082 return $field_names;
83 }
84
85 // --------------------------------------------------------------------
86
87 /**
88 * Field data
89 *
90 * Generates an array of objects containing field meta-data
91 *
Derek Allard2067d1a2008-11-13 22:59:24 +000092 * @return array
93 */
Andrey Andreev1ff49e02012-01-27 11:30:41 +020094 public function field_data()
Derek Allard2067d1a2008-11-13 22:59:24 +000095 {
96 $retval = array();
Andrey Andreev992f1752012-03-19 16:58:43 +020097 $field_data = $this->result_id->fetch_fields();
Andrey Andreeveffd0132012-03-02 12:34:54 +020098 for ($i = 0, $c = count($field_data); $i < $c; $i++)
Barry Mienydd671972010-10-04 16:33:58 +020099 {
Andrey Andreeveffd0132012-03-02 12:34:54 +0200100 $retval[$i] = new stdClass();
101 $retval[$i]->name = $field_data[$i]->name;
102 $retval[$i]->type = $field_data[$i]->type;
103 $retval[$i]->max_length = $field_data[$i]->max_length;
104 $retval[$i]->primary_key = (int) ($field_data[$i]->flags & 2);
Andrey Andreev10ecc842012-11-16 01:06:20 +0200105 $retval[$i]->default = $field_data[$i]->def;
Derek Allard2067d1a2008-11-13 22:59:24 +0000106 }
Barry Mienydd671972010-10-04 16:33:58 +0200107
Derek Allard2067d1a2008-11-13 22:59:24 +0000108 return $retval;
109 }
Andrey Andreev1ff49e02012-01-27 11:30:41 +0200110
Derek Allard2067d1a2008-11-13 22:59:24 +0000111 // --------------------------------------------------------------------
112
113 /**
114 * Free the result
115 *
Andrey Andreev1ff49e02012-01-27 11:30:41 +0200116 * @return void
Barry Mienydd671972010-10-04 16:33:58 +0200117 */
Andrey Andreev1ff49e02012-01-27 11:30:41 +0200118 public function free_result()
Derek Allard2067d1a2008-11-13 22:59:24 +0000119 {
120 if (is_object($this->result_id))
121 {
Andrey Andreev992f1752012-03-19 16:58:43 +0200122 $this->result_id->free();
Derek Allard2067d1a2008-11-13 22:59:24 +0000123 $this->result_id = FALSE;
124 }
125 }
126
127 // --------------------------------------------------------------------
128
129 /**
130 * Data Seek
131 *
Andrey Andreev8f3566f2012-04-12 14:30:05 +0300132 * Moves the internal pointer to the desired offset. We call
Derek Allard2067d1a2008-11-13 22:59:24 +0000133 * this internally before fetching results to make sure the
Andrey Andreev8463b912012-11-02 02:16:28 +0200134 * result set starts at zero.
Derek Allard2067d1a2008-11-13 22:59:24 +0000135 *
Andrey Andreev8463b912012-11-02 02:16:28 +0200136 * @param int $n
Andrey Andreev8f3566f2012-04-12 14:30:05 +0300137 * @return bool
Derek Allard2067d1a2008-11-13 22:59:24 +0000138 */
Andrey Andreev1ff49e02012-01-27 11:30:41 +0200139 protected function _data_seek($n = 0)
Derek Allard2067d1a2008-11-13 22:59:24 +0000140 {
Andrey Andreev992f1752012-03-19 16:58:43 +0200141 return $this->result_id->data_seek($n);
Derek Allard2067d1a2008-11-13 22:59:24 +0000142 }
143
144 // --------------------------------------------------------------------
145
146 /**
147 * Result - associative array
148 *
149 * Returns the result set as an array
150 *
Derek Allard2067d1a2008-11-13 22:59:24 +0000151 * @return array
152 */
Andrey Andreev1ff49e02012-01-27 11:30:41 +0200153 protected function _fetch_assoc()
Derek Allard2067d1a2008-11-13 22:59:24 +0000154 {
Andrey Andreev992f1752012-03-19 16:58:43 +0200155 return $this->result_id->fetch_assoc();
Derek Allard2067d1a2008-11-13 22:59:24 +0000156 }
Barry Mienydd671972010-10-04 16:33:58 +0200157
Derek Allard2067d1a2008-11-13 22:59:24 +0000158 // --------------------------------------------------------------------
159
160 /**
161 * Result - object
162 *
163 * Returns the result set as an object
164 *
Andrey Andreev8463b912012-11-02 02:16:28 +0200165 * @param string $class_name
Derek Allard2067d1a2008-11-13 22:59:24 +0000166 * @return object
167 */
Andrey Andreev9a4f3562012-07-06 11:57:37 +0300168 protected function _fetch_object($class_name = 'stdClass')
Derek Allard2067d1a2008-11-13 22:59:24 +0000169 {
Andrey Andreev9a4f3562012-07-06 11:57:37 +0300170 return $this->result_id->fetch_object($class_name);
Derek Allard2067d1a2008-11-13 22:59:24 +0000171 }
Barry Mienydd671972010-10-04 16:33:58 +0200172
Derek Allard2067d1a2008-11-13 22:59:24 +0000173}
174
Derek Allard2067d1a2008-11-13 22:59:24 +0000175/* End of file mysqli_result.php */
Andrey Andreev67c28712012-03-27 09:20:54 +0300176/* Location: ./system/database/drivers/mysqli/mysqli_result.php */