2 // This file is part of Moodle - http://moodle.org/
4 // Moodle is free software: you can redistribute it and/or modify
5 // it under the terms of the GNU General Public License as published by
6 // the Free Software Foundation, either version 2 of the License, or
7 // (at your option) any later version.
9 // Moodle is distributed in the hope that it will be useful,
10 // but WITHOUT ANY WARRANTY; without even the implied warranty of
11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 // GNU General Public License for more details.
14 // You should have received a copy of the GNU General Public License
15 // along with Moodle. If not, see <http://www.gnu.org/licenses/>.
18 * sqlsrv specific recordset.
21 * @copyright 2009 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com}
22 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v2 or later
25 defined('MOODLE_INTERNAL') ||
die();
27 require_once(__DIR__
.'/moodle_recordset.php');
29 class sqlsrv_native_moodle_recordset
extends moodle_recordset
{
34 public function __construct($rsrc) {
36 $this->current
= $this->fetch_next();
39 public function __destruct() {
43 private function fetch_next() {
44 if ($row = sqlsrv_fetch_array($this->rsrc
, SQLSRV_FETCH_ASSOC
)) {
45 unset($row['sqlsrvrownumber']);
46 $row = array_change_key_case($row, CASE_LOWER
);
51 public function current() {
52 return (object)$this->current
;
55 public function key() {
56 // return first column value as key
57 if (!$this->current
) {
60 $key = reset($this->current
);
64 public function next() {
65 $this->current
= $this->fetch_next();
68 public function valid() {
69 return !empty($this->current
);
72 public function close() {
74 sqlsrv_free_stmt($this->rsrc
);
77 $this->current
= null;