interface/modules/zend_modules/library/Zend/Db/Adapter/Driver/Sqlsrv/Result.php

   1 <?php
   2 /**
   3  * Zend Framework (http://framework.zend.com/)
   4  *
   5  * @link      http://github.com/zendframework/zf2 for the canonical source repository
   6  * @copyright Copyright (c) 2005-2013 Zend Technologies USA Inc. (http://www.zend.com)
   7  * @license   http://framework.zend.com/license/new-bsd New BSD License
   8  */
   9
  10 namespace Zend\Db\Adapter\Driver\Sqlsrv;
  11
  12 use Iterator;
  13 use Zend\Db\Adapter\Driver\ResultInterface;
  14
  15 class Result implements Iterator, ResultInterface
  16 {
  17
  18     /**
  19      * @var resource
  20      */
  21     protected $resource = null;
  22
  23     /**
  24      * @var bool
  25      */
  26     protected $currentData = false;
  27
  28     /**
  29      *
  30      * @var bool
  31      */
  32     protected $currentComplete = false;
  33
  34     /**
  35      *
  36      * @var int
  37      */
  38     protected $position = -1;
  39
  40     /**
  41      * @var mixed
  42      */
  43     protected $generatedValue = null;
  44
  45     /**
  46      * Initialize
  47      *
  48      * @param  resource $resource
  49      * @param  mixed    $generatedValue
  50      * @return Result
  51      */
  52     public function initialize($resource, $generatedValue = null)
  53     {
  54         $this->resource = $resource;
  55         $this->generatedValue = $generatedValue;
  56         return $this;
  57     }
  58
  59     /**
  60      * @return null
  61      */
  62     public function buffer()
  63     {
  64         return null;
  65     }
  66
  67     /**
  68      * @return bool
  69      */
  70     public function isBuffered()
  71     {
  72         return false;
  73     }
  74
  75     /**
  76      * Get resource
  77      *
  78      * @return resource
  79      */
  80     public function getResource()
  81     {
  82         return $this->resource;
  83     }
  84
  85     /**
  86      * Current
  87      *
  88      * @return mixed
  89      */
  90     public function current()
  91     {
  92         if ($this->currentComplete) {
  93             return $this->currentData;
  94         }
  95
  96         $this->load();
  97         return $this->currentData;
  98     }
  99
 100     /**
 101      * Next
 102      *
 103      * @return bool
 104      */
 105     public function next()
 106     {
 107         $this->load();
 108         return true;
 109     }
 110
 111     /**
 112      * Load
 113      *
 114      * @param  int $row
 115      * @return mixed
 116      */
 117     protected function load($row = SQLSRV_SCROLL_NEXT)
 118     {
 119         $this->currentData = sqlsrv_fetch_array($this->resource, SQLSRV_FETCH_ASSOC, $row);
 120         $this->currentComplete = true;
 121         $this->position++;
 122         return $this->currentData;
 123     }
 124
 125     /**
 126      * Key
 127      *
 128      * @return mixed
 129      */
 130     public function key()
 131     {
 132         return $this->position;
 133     }
 134
 135     /**
 136      * Rewind
 137      *
 138      * @return bool
 139      */
 140     public function rewind()
 141     {
 142         $this->position = 0;
 143         $this->load(SQLSRV_SCROLL_FIRST);
 144         return true;
 145     }
 146
 147     /**
 148      * Valid
 149      *
 150      * @return bool
 151      */
 152     public function valid()
 153     {
 154         if ($this->currentComplete && $this->currentData) {
 155             return true;
 156         }
 157
 158         return $this->load();
 159     }
 160
 161     /**
 162      * Count
 163      *
 164      * @return int
 165      */
 166     public function count()
 167     {
 168         return sqlsrv_num_rows($this->resource);
 169     }
 170
 171     /**
 172      * @return bool|int
 173      */
 174     public function getFieldCount()
 175     {
 176         return sqlsrv_num_fields($this->resource);
 177     }
 178
 179     /**
 180      * Is query result
 181      *
 182      * @return bool
 183      */
 184     public function isQueryResult()
 185     {
 186         if (is_bool($this->resource)) {
 187             return false;
 188         }
 189         return (sqlsrv_num_fields($this->resource) > 0);
 190     }
 191
 192     /**
 193      * Get affected rows
 194      *
 195      * @return int
 196      */
 197     public function getAffectedRows()
 198     {
 199         return sqlsrv_rows_affected($this->resource);
 200     }
 201
 202     /**
 203      * @return mixed|null
 204      */
 205     public function getGeneratedValue()
 206     {
 207         return $this->generatedValue;
 208     }
 209 }