/lenasys/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/lenasys/trunk

« back to all changes in this revision

Viewing changes to codeigniter/system/database/drivers/oci8/oci8_result.php

  • Committer: galaxyAbstractor
  • Date: 2013-04-10 15:49:32 UTC
  • mto: (19.1.5 lenasys)
  • mto: This revision was merged to the branch mainline in revision 23.
  • Revision ID: galaxyabstractor@gmail.com-20130410154932-4vizlzk0ar5gykvi
* Added an simple admin panel to the codeviewer-cmssy stuff
* Redesigned a bit like the mockups - still stuff to come
* Implemented the codeviewer + admin panel again using the Framework CodeIgniter instead 

Show diffs side-by-side

added added

removed removed

Lines of Context:
codeigniter/system/database/drivers/oci8/oci8_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
 * oci8 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_oci8_result extends CI_DB_result {
 
28
 
 
29
        public $stmt_id;
 
30
        public $curs_id;
 
31
        public $limit_used;
 
32
 
 
33
        /**
 
34
         * Number of rows in the result set.
 
35
         *
 
36
         * Oracle doesn't have a graceful way to retun the number of rows
 
37
         * so we have to use what amounts to a hack.
 
38
         *
 
39
         * @return  integer
 
40
         */
 
41
        public function num_rows()
 
42
        {
 
43
                if ($this->num_rows === 0 && count($this->result_array()) > 0)
 
44
                {
 
45
                        $this->num_rows = count($this->result_array());
 
46
                        @oci_execute($this->stmt_id);
 
47
 
 
48
                        if ($this->curs_id)
 
49
                        {
 
50
                                @oci_execute($this->curs_id);
 
51
                        }
 
52
                }
 
53
 
 
54
                return $this->num_rows;
 
55
        }
 
56
 
 
57
        // --------------------------------------------------------------------
 
58
 
 
59
        /**
 
60
         * Number of fields in the result set
 
61
         *
 
62
         * @access  public
 
63
         * @return  integer
 
64
         */
 
65
        public function num_fields()
 
66
        {
 
67
                $count = @oci_num_fields($this->stmt_id);
 
68
 
 
69
                // if we used a limit we subtract it
 
70
                if ($this->limit_used)
 
71
                {
 
72
                        $count = $count - 1;
 
73
                }
 
74
 
 
75
                return $count;
 
76
        }
 
77
 
 
78
        // --------------------------------------------------------------------
 
79
 
 
80
        /**
 
81
         * Fetch Field Names
 
82
         *
 
83
         * Generates an array of column names
 
84
         *
 
85
         * @access      public
 
86
         * @return      array
 
87
         */
 
88
        public function list_fields()
 
89
        {
 
90
                $field_names = array();
 
91
                for ($c = 1, $fieldCount = $this->num_fields(); $c <= $fieldCount; $c++)
 
92
                {
 
93
                        $field_names[] = oci_field_name($this->stmt_id, $c);
 
94
                }
 
95
                return $field_names;
 
96
        }
 
97
 
 
98
        // --------------------------------------------------------------------
 
99
 
 
100
        /**
 
101
         * Field data
 
102
         *
 
103
         * Generates an array of objects containing field meta-data
 
104
         *
 
105
         * @access  public
 
106
         * @return  array
 
107
         */
 
108
        public function field_data()
 
109
        {
 
110
                $retval = array();
 
111
                for ($c = 1, $fieldCount = $this->num_fields(); $c <= $fieldCount; $c++)
 
112
                {
 
113
                        $F                      = new stdClass();
 
114
                        $F->name                = oci_field_name($this->stmt_id, $c);
 
115
                        $F->type                = oci_field_type($this->stmt_id, $c);
 
116
                        $F->max_length          = oci_field_size($this->stmt_id, $c);
 
117
 
 
118
                        $retval[] = $F;
 
119
                }
 
120
 
 
121
                return $retval;
 
122
        }
 
123
 
 
124
        // --------------------------------------------------------------------
 
125
 
 
126
        /**
 
127
         * Free the result
 
128
         *
 
129
         * @return      null
 
130
         */
 
131
        public function free_result()
 
132
        {
 
133
                if (is_resource($this->result_id))
 
134
                {
 
135
                        oci_free_statement($this->result_id);
 
136
                        $this->result_id = FALSE;
 
137
                }
 
138
        }
 
139
 
 
140
        // --------------------------------------------------------------------
 
141
 
 
142
        /**
 
143
         * Result - associative array
 
144
         *
 
145
         * Returns the result set as an array
 
146
         *
 
147
         * @access  protected
 
148
         * @return  array
 
149
         */
 
150
        protected function _fetch_assoc()
 
151
        {
 
152
                $id = ($this->curs_id) ? $this->curs_id : $this->stmt_id;
 
153
                return oci_fetch_assoc($id);
 
154
        }
 
155
 
 
156
        // --------------------------------------------------------------------
 
157
 
 
158
        /**
 
159
         * Result - object
 
160
         *
 
161
         * Returns the result set as an object
 
162
         *
 
163
         * @access  protected
 
164
         * @return  object
 
165
         */
 
166
        protected function _fetch_object()
 
167
        {
 
168
                $id = ($this->curs_id) ? $this->curs_id : $this->stmt_id;
 
169
                return @oci_fetch_object($id);
 
170
        }
 
171
 
 
172
        // --------------------------------------------------------------------
 
173
 
 
174
        /**
 
175
         * Query result.  "array" version.
 
176
         *
 
177
         * @access  public
 
178
         * @return  array
 
179
         */
 
180
        public function result_array()
 
181
        {
 
182
                if (count($this->result_array) > 0)
 
183
                {
 
184
                        return $this->result_array;
 
185
                }
 
186
 
 
187
                $row = NULL;
 
188
                while ($row = $this->_fetch_assoc())
 
189
                {
 
190
                        $this->result_array[] = $row;
 
191
                }
 
192
 
 
193
                return $this->result_array;
 
194
        }
 
195
 
 
196
        // --------------------------------------------------------------------
 
197
 
 
198
        /**
 
199
         * Data Seek
 
200
         *
 
201
         * Moves the internal pointer to the desired offset.  We call
 
202
         * this internally before fetching results to make sure the
 
203
         * result set starts at zero
 
204
         *
 
205
         * @access      protected
 
206
         * @return      array
 
207
         */
 
208
        protected function _data_seek($n = 0)
 
209
        {
 
210
                return FALSE; // Not needed
 
211
        }
 
212
 
 
213
}
 
214
 
 
215
 
 
216
/* End of file oci8_result.php */
 
217
/* Location: ./system/database/drivers/oci8/oci8_result.php */