video/system/database/drivers/sqlsrv/sqlsrv_result.php

   1 <?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
   2 /**
   3  * CodeIgniter
   4  *
   5  * An open source application development framework for PHP 5.1.6 or newer
   6  *
   7  * @package             CodeIgniter
   8  * @author              ExpressionEngine Dev Team
   9  * @copyright   Copyright (c) 2008 - 2011, EllisLab, Inc.
  10  * @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  * SQLSRV 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  */
  27 class CI_DB_sqlsrv_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 @sqlsrv_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 @sqlsrv_num_fields($this->result_id);
  51         }
  52
  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 list_fields()
  64         {
  65                 $field_names = array();
  66                 foreach(sqlsrv_field_metadata($this->result_id) as $offset => $field)
  67                 {
  68                         $field_names[] = $field['Name'];
  69                 }
  70
  71                 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                 foreach(sqlsrv_field_metadata($this->result_id) as $offset => $field)
  88                 {
  89                         $F                              = new stdClass();
  90                         $F->name                = $field['Name'];
  91                         $F->type                = $field['Type'];
  92                         $F->max_length  = $field['Size'];
  93                         $F->primary_key = 0;
  94                         $F->default             = '';
  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                         sqlsrv_free_stmt($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                 // Not implemented
 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 sqlsrv_fetch_array($this->result_id, SQLSRV_FETCH_ASSOC);
 148         }
 149
 150         // --------------------------------------------------------------------
 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 sqlsrv_fetch_object($this->result_id);
 163         }
 164
 165 }
 166
 167
 168 /* End of file mssql_result.php */
 169 /* Location: ./system/database/drivers/mssql/mssql_result.php */