Subversion Repositories oidplus

Rev

Rev 1152 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
635 daniel-mar 1 
<?php
2 
 
3 
/*
4 
 * OIDplus 2.0
1086 daniel-mar 5 
 * Copyright 2019 - 2023 Daniel Marschall, ViaThinkSoft
635 daniel-mar 6 
 *
7 
 * Licensed under the Apache License, Version 2.0 (the "License");
8 
 * you may not use this file except in compliance with the License.
9 
 * You may obtain a copy of the License at
10 
 *
11 
 *     http://www.apache.org/licenses/LICENSE-2.0
12 
 *
13 
 * Unless required by applicable law or agreed to in writing, software
14 
 * distributed under the License is distributed on an "AS IS" BASIS,
15 
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16 
 * See the License for the specific language governing permissions and
17 
 * limitations under the License.
18 
 */
19 
 
1050 daniel-mar 20 
namespace ViaThinkSoft\OIDplus;
635 daniel-mar 21 
 
1086 daniel-mar 22 
// phpcs:disable PSR1.Files.SideEffects
23 
\defined('INSIDE_OIDPLUS') or die;
24 
// phpcs:enable PSR1.Files.SideEffects
25 
 
635 daniel-mar 26 
class OIDplusQueryResultODBC extends OIDplusQueryResult {
1130 daniel-mar 27 
        /**
28 
         * @var bool
29 
         */
635 daniel-mar 30 
        protected $no_resultset;
1130 daniel-mar 31 
 
32 
        /**
33 
         * @var mixed
34 
         */
635 daniel-mar 35 
        protected $res;
36 
 
1116 daniel-mar 37 
        /**
1130 daniel-mar 38 
         * @param mixed $res
1116 daniel-mar 39 
         */
635 daniel-mar 40 
        public function __construct($res) {
41 
                $this->no_resultset = is_bool($res);
42 
 
43 
                if (!$this->no_resultset) {
44 
                        $this->res = $res;
45 
                }
46 
        }
47 
 
1116 daniel-mar 48 
        /**
49 
         *
50 
         */
635 daniel-mar 51 
        public function __destruct() {
52 
                // odbc_close_cursor($this->res);
53 
        }
54 
 
1116 daniel-mar 55 
        /**
56 
         * @return bool
57 
         */
635 daniel-mar 58 
        public function containsResultSet(): bool {
59 
                return !$this->no_resultset;
60 
        }
61 
 
1116 daniel-mar 62 
        /**
63 
         * @return int
64 
         */
635 daniel-mar 65 
        private function num_rows_workaround(): int {
1130 daniel-mar 66 
                $dummy = array();
635 daniel-mar 67 
 
68 
                // go to the end of the result set
69 
                $till_eof = 0;
70 
                while ($temp = odbc_fetch_into($this->res, $dummy)) $till_eof++;
71 
 
72 
                // reset cursor
73 
                @odbc_fetch_row($this->res, 0);
74 
 
75 
                // count the rows in the result set
76 
                $ret = 0;
77 
                while ($temp = odbc_fetch_into($this->res, $dummy)) $ret++;
78 
 
79 
                // this would indicate that the odbc_fetch_row() could not reset the cursor
80 
                if ($ret < $till_eof) return -1;
81 
 
82 
                // go back to the row were started with
83 
                @odbc_fetch_row($this->res, $ret-$till_eof);
84 
 
85 
                return $ret;
86 
        }
87 
 
1116 daniel-mar 88 
        /**
89 
         * @return int
90 
         * @throws OIDplusException
91 
         */
1152 daniel-mar 92 
        protected function do_num_rows(): int {
635 daniel-mar 93 
                $ret = odbc_num_rows($this->res);
94 
 
95 
                // Workaround for drivers that do not support odbc_num_rows (e.g. Microsoft Access)
96 
                if ($ret === -1) $ret = $this->num_rows_workaround();
97 
 
98 
                return $ret;
99 
        }
100 
 
1116 daniel-mar 101 
        /**
102 
         * @return array|null
103 
         */
1152 daniel-mar 104 
        protected function do_fetch_array()/*: ?array*/ {
635 daniel-mar 105 
                $ret = odbc_fetch_array($this->res);
106 
                if ($ret === false) $ret = null;
107 
                return $ret;
108 
        }
109 
 
1116 daniel-mar 110 
        /**
1156 daniel-mar 111 
         * @return object|null
1116 daniel-mar 112 
         */
1152 daniel-mar 113 
        protected function do_fetch_object()/*: ?object*/ {
635 daniel-mar 114 
                $ret = odbc_fetch_object($this->res);
115 
                if ($ret === false) $ret = null;
116 
                return $ret;
117 
        }
783 daniel-mar 118 
}