Source/carbon/database/Database_result.php

   1 <?php
   2 /*------------------------------------------------------------
   3 *  CarbonPHP framework (C) Tom Bell
   4 *  http://tombell.org.uk
   5 *------------------------------------------------------------*/
   6
   7 if (!defined('CARBON_PATH'))
   8 {
   9         exit('Direct script access is not allowed.');
  10 }
  11
  12 class Carbon_Database_result
  13 {
  14         public $conn_id = null;
  15         public $result_id = null;
  16         public $result_array = array();
  17         public $result_object = array();
  18         public $current_row = 0;
  19         public $num_rows = 0;
  20
  21         public function result($type = 'object')
  22         {
  23                 return ($type == 'object') ? $this->result_object() : $this->result_array();
  24         }
  25
  26         public function result_object()
  27         {
  28                 if (count($this->result_object) > 0)
  29                 {
  30                         return $this->result_object;
  31                 }
  32
  33                 if ($this->result_id === false || $this->num_rows() == 0)
  34                 {
  35                         return array();
  36                 }
  37
  38                 $this->database_data_seek(0);
  39
  40                 while($row = $this->database_fetch_object())
  41                 {
  42                         $this->result_object[] = $row;
  43                 }
  44
  45                 return $this->result_object;
  46         }
  47
  48         public function result_array()
  49         {
  50                 if (count($this->result_array) > 0)
  51                 {
  52                         return $this->result_array;
  53                 }
  54
  55                 if ($this->result_id === false || $this->num_rows() == 0)
  56                 {
  57                         return array();
  58                 }
  59
  60                 $this->database_data_seek(0);
  61
  62                 while ($row = $this->database_fetch_assoc())
  63                 {
  64                         $this->result_array[] = $row;
  65                 }
  66
  67                 return $this->result_array;
  68         }
  69
  70         public function row($index = 0, $type = 'object')
  71         {
  72                 return ($type == 'object') ? $this->row_object($index) : $this->row_array($index);
  73         }
  74
  75         public function row_object($index = 0)
  76         {
  77                 $result = $this->result_object();
  78
  79                 if (count($result) == 0)
  80                 {
  81                         return $result;
  82                 }
  83
  84                 if ($index != $this->current_row && isset($result[$index]))
  85                 {
  86                         $this->current_row = $index;
  87                 }
  88
  89                 return $result[$this->current_row];
  90         }
  91
  92         public function row_array($index = 0)
  93         {
  94                 $result = $this->result_array();
  95
  96                 if (count($result) == 0)
  97                 {
  98                         return $result;
  99                 }
 100
 101                 if ($index != $this->current_row && isset($result[$index]))
 102                 {
 103                         $this->current_row = $index;
 104                 }
 105
 106                 return $result[$this->current_row];
 107         }
 108
 109         public function first_row($type = 'object')
 110         {
 111                 $result = $this->result($type);
 112
 113                 if (count($result) == 0)
 114                 {
 115                         return $result;
 116                 }
 117
 118                 return $result[0];
 119         }
 120
 121         public function last_row($type = 'object')
 122         {
 123                 $result = $this->result($type);
 124
 125                 if (count($result) == 0)
 126                 {
 127                         return $result;
 128                 }
 129
 130                 return $result[count($result) - 1];
 131         }
 132
 133         public function next_row($type = 'object')
 134         {
 135                 $result = $this->result($type);
 136
 137                 if (count($result) == 0)
 138                 {
 139                         return $result;
 140                 }
 141
 142                 if (isset($result[$this->current_row + 1]))
 143                 {
 144                         $this->current_row++;
 145                 }
 146
 147                 return $result[$this->current_row];
 148         }
 149
 150         public function previous_row($type = 'object')
 151         {
 152                 $result = $this->result($type);
 153
 154                 if (count($result) == 0)
 155                 {
 156                         return $result;
 157                 }
 158
 159                 if (isset($result[$this->current_row - 1]))
 160                 {
 161                         $this->current_row--;
 162                 }
 163
 164                 return $result[$this->current_row];
 165         }
 166
 167         public function num_rows()
 168         {
 169                 return $this->num_rows;
 170         }
 171
 172         public function num_fields()
 173         {
 174                 return 0;
 175         }
 176
 177         public function list_fields()
 178         {
 179                 return array();
 180         }
 181
 182         public function field_data()
 183         {
 184                 return array();
 185         }
 186
 187         public function free_result()
 188         {
 189                 return true;
 190         }
 191
 192         public function database_data_seek()
 193         {
 194                 return true;
 195         }
 196
 197         public function database_fetch_assoc()
 198         {
 199                 return array();
 200         }
 201
 202         public function database_fetch_object()
 203         {
 204                 return array();
 205         }
 206 }
 207
 208 ?>