mysqli_result.php 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240
  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 - 2017, 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 - 2017, 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. * MySQLi Result Class
  41. *
  42. * This class extends the parent result class: CI_DB_result
  43. *
  44. * @package CodeIgniter
  45. * @subpackage Drivers
  46. * @category Database
  47. * @author EllisLab Dev Team
  48. * @link https://codeigniter.com/user_guide/database/
  49. */
  50. class CI_DB_mysqli_result extends CI_DB_result {
  51. /**
  52. * Number of rows in the result set
  53. *
  54. * @return int
  55. */
  56. public function num_rows()
  57. {
  58. return is_int($this->num_rows)
  59. ? $this->num_rows
  60. : $this->num_rows = $this->result_id->num_rows;
  61. }
  62. // --------------------------------------------------------------------
  63. /**
  64. * Number of fields in the result set
  65. *
  66. * @return int
  67. */
  68. public function num_fields()
  69. {
  70. return $this->result_id->field_count;
  71. }
  72. // --------------------------------------------------------------------
  73. /**
  74. * Fetch Field Names
  75. *
  76. * Generates an array of column names
  77. *
  78. * @return array
  79. */
  80. public function list_fields()
  81. {
  82. $field_names = array();
  83. $this->result_id->field_seek(0);
  84. while ($field = $this->result_id->fetch_field())
  85. {
  86. $field_names[] = $field->name;
  87. }
  88. return $field_names;
  89. }
  90. // --------------------------------------------------------------------
  91. /**
  92. * Field data
  93. *
  94. * Generates an array of objects containing field meta-data
  95. *
  96. * @return array
  97. */
  98. public function field_data()
  99. {
  100. $retval = array();
  101. $field_data = $this->result_id->fetch_fields();
  102. for ($i = 0, $c = count($field_data); $i < $c; $i++)
  103. {
  104. $retval[$i] = new stdClass();
  105. $retval[$i]->name = $field_data[$i]->name;
  106. $retval[$i]->type = static::_get_field_type($field_data[$i]->type);
  107. $retval[$i]->max_length = $field_data[$i]->max_length;
  108. $retval[$i]->primary_key = (int) ($field_data[$i]->flags & MYSQLI_PRI_KEY_FLAG);
  109. $retval[$i]->default = $field_data[$i]->def;
  110. }
  111. return $retval;
  112. }
  113. // --------------------------------------------------------------------
  114. /**
  115. * Get field type
  116. *
  117. * Extracts field type info from the bitflags returned by
  118. * mysqli_result::fetch_fields()
  119. *
  120. * @used-by CI_DB_mysqli_result::field_data()
  121. * @param int $flags
  122. * @return string
  123. */
  124. private static function _get_field_type($flags)
  125. {
  126. static $map;
  127. isset($map) OR $map = array(
  128. MYSQLI_TYPE_DECIMAL => 'decimal',
  129. MYSQLI_TYPE_BIT => 'bit',
  130. MYSQLI_TYPE_TINY => 'tinyint',
  131. MYSQLI_TYPE_SHORT => 'smallint',
  132. MYSQLI_TYPE_INT24 => 'mediumint',
  133. MYSQLI_TYPE_LONG => 'int',
  134. MYSQLI_TYPE_LONGLONG => 'bigint',
  135. MYSQLI_TYPE_FLOAT => 'float',
  136. MYSQLI_TYPE_DOUBLE => 'double',
  137. MYSQLI_TYPE_TIMESTAMP => 'timestamp',
  138. MYSQLI_TYPE_DATE => 'date',
  139. MYSQLI_TYPE_TIME => 'time',
  140. MYSQLI_TYPE_DATETIME => 'datetime',
  141. MYSQLI_TYPE_YEAR => 'year',
  142. MYSQLI_TYPE_NEWDATE => 'date',
  143. MYSQLI_TYPE_INTERVAL => 'interval',
  144. MYSQLI_TYPE_ENUM => 'enum',
  145. MYSQLI_TYPE_SET => 'set',
  146. MYSQLI_TYPE_TINY_BLOB => 'tinyblob',
  147. MYSQLI_TYPE_MEDIUM_BLOB => 'mediumblob',
  148. MYSQLI_TYPE_BLOB => 'blob',
  149. MYSQLI_TYPE_LONG_BLOB => 'longblob',
  150. MYSQLI_TYPE_STRING => 'char',
  151. MYSQLI_TYPE_VAR_STRING => 'varchar',
  152. MYSQLI_TYPE_GEOMETRY => 'geometry'
  153. );
  154. foreach ($map as $flag => $name)
  155. {
  156. if ($flags & $flag)
  157. {
  158. return $name;
  159. }
  160. }
  161. return $flags;
  162. }
  163. // --------------------------------------------------------------------
  164. /**
  165. * Free the result
  166. *
  167. * @return void
  168. */
  169. public function free_result()
  170. {
  171. if (is_object($this->result_id))
  172. {
  173. $this->result_id->free();
  174. $this->result_id = FALSE;
  175. }
  176. }
  177. // --------------------------------------------------------------------
  178. /**
  179. * Data Seek
  180. *
  181. * Moves the internal pointer to the desired offset. We call
  182. * this internally before fetching results to make sure the
  183. * result set starts at zero.
  184. *
  185. * @param int $n
  186. * @return bool
  187. */
  188. public function data_seek($n = 0)
  189. {
  190. return $this->result_id->data_seek($n);
  191. }
  192. // --------------------------------------------------------------------
  193. /**
  194. * Result - associative array
  195. *
  196. * Returns the result set as an array
  197. *
  198. * @return array
  199. */
  200. protected function _fetch_assoc()
  201. {
  202. return $this->result_id->fetch_assoc();
  203. }
  204. // --------------------------------------------------------------------
  205. /**
  206. * Result - object
  207. *
  208. * Returns the result set as an object
  209. *
  210. * @param string $class_name
  211. * @return object
  212. */
  213. protected function _fetch_object($class_name = 'stdClass')
  214. {
  215. return $this->result_id->fetch_object($class_name);
  216. }
  217. }