123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198 |
- <?php
- /**
- * CodeIgniter
- *
- * An open source application development framework for PHP
- *
- * This content is released under the MIT License (MIT)
- *
- * Copyright (c) 2014 - 2019, British Columbia Institute of Technology
- *
- * Permission is hereby granted, free of charge, to any person obtaining a copy
- * of this software and associated documentation files (the "Software"), to deal
- * in the Software without restriction, including without limitation the rights
- * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
- * copies of the Software, and to permit persons to whom the Software is
- * furnished to do so, subject to the following conditions:
- *
- * The above copyright notice and this permission notice shall be included in
- * all copies or substantial portions of the Software.
- *
- * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
- * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
- * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
- * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
- * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
- * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
- * THE SOFTWARE.
- *
- * @package CodeIgniter
- * @author EllisLab Dev Team
- * @copyright Copyright (c) 2008 - 2014, EllisLab, Inc. (https://ellislab.com/)
- * @copyright Copyright (c) 2014 - 2019, British Columbia Institute of Technology (https://bcit.ca/)
- * @license https://opensource.org/licenses/MIT MIT License
- * @link https://codeigniter.com
- * @since Version 2.1.0
- * @filesource
- */
- defined('BASEPATH') OR exit('No direct script access allowed');
- /**
- * PDO Result Class
- *
- * This class extends the parent result class: CI_DB_result
- *
- * @package CodeIgniter
- * @subpackage Drivers
- * @category Database
- * @author EllisLab Dev Team
- * @link https://codeigniter.com/user_guide/database/
- */
- class CI_DB_pdo_result extends CI_DB_result {
- /**
- * Number of rows in the result set
- *
- * @return int
- */
- public function num_rows()
- {
- if (is_int($this->num_rows))
- {
- return $this->num_rows;
- }
- elseif (count($this->result_array) > 0)
- {
- return $this->num_rows = count($this->result_array);
- }
- elseif (count($this->result_object) > 0)
- {
- return $this->num_rows = count($this->result_object);
- }
- elseif (($num_rows = $this->result_id->rowCount()) > 0)
- {
- return $this->num_rows = $num_rows;
- }
- return $this->num_rows = count($this->result_array());
- }
- // --------------------------------------------------------------------
- /**
- * Number of fields in the result set
- *
- * @return int
- */
- public function num_fields()
- {
- return $this->result_id->columnCount();
- }
- // --------------------------------------------------------------------
- /**
- * Fetch Field Names
- *
- * Generates an array of column names
- *
- * @return bool
- */
- public function list_fields()
- {
- $field_names = array();
- for ($i = 0, $c = $this->num_fields(); $i < $c; $i++)
- {
- // Might trigger an E_WARNING due to not all subdrivers
- // supporting getColumnMeta()
- $field_names[$i] = @$this->result_id->getColumnMeta($i);
- $field_names[$i] = $field_names[$i]['name'];
- }
- return $field_names;
- }
- // --------------------------------------------------------------------
- /**
- * Field data
- *
- * Generates an array of objects containing field meta-data
- *
- * @return array
- */
- public function field_data()
- {
- try
- {
- $retval = array();
- for ($i = 0, $c = $this->num_fields(); $i < $c; $i++)
- {
- $field = $this->result_id->getColumnMeta($i);
- $retval[$i] = new stdClass();
- $retval[$i]->name = $field['name'];
- $retval[$i]->type = isset($field['native_type']) ? $field['native_type'] : null;
- $retval[$i]->max_length = ($field['len'] > 0) ? $field['len'] : NULL;
- $retval[$i]->primary_key = (int) ( ! empty($field['flags']) && in_array('primary_key', $field['flags'], TRUE));
- }
- return $retval;
- }
- catch (Exception $e)
- {
- if ($this->db->db_debug)
- {
- return $this->db->display_error('db_unsupported_feature');
- }
- return FALSE;
- }
- }
- // --------------------------------------------------------------------
- /**
- * Free the result
- *
- * @return void
- */
- public function free_result()
- {
- if (is_object($this->result_id))
- {
- $this->result_id = FALSE;
- }
- }
- // --------------------------------------------------------------------
- /**
- * Result - associative array
- *
- * Returns the result set as an array
- *
- * @return array
- */
- protected function _fetch_assoc()
- {
- return $this->result_id->fetch(PDO::FETCH_ASSOC);
- }
- // --------------------------------------------------------------------
- /**
- * Result - object
- *
- * Returns the result set as an object
- *
- * @param string $class_name
- * @return object
- */
- protected function _fetch_object($class_name = 'stdClass')
- {
- return $this->result_id->fetchObject($class_name);
- }
- }
|