| @@ 159-184 (lines=26) @@ | ||
| 156 | * @param string $table |
|
| 157 | * @return array |
|
| 158 | */ |
|
| 159 | public function field_data($table) |
|
| 160 | { |
|
| 161 | if (($query = $this->query('PRAGMA TABLE_INFO('.$this->protect_identifiers($table, TRUE, NULL, FALSE).')')) === FALSE) |
|
| 162 | { |
|
| 163 | return FALSE; |
|
| 164 | } |
|
| 165 | ||
| 166 | $query = $query->result_array(); |
|
| 167 | if (empty($query)) |
|
| 168 | { |
|
| 169 | return FALSE; |
|
| 170 | } |
|
| 171 | ||
| 172 | $retval = array(); |
|
| 173 | for ($i = 0, $c = count($query); $i < $c; $i++) |
|
| 174 | { |
|
| 175 | $retval[$i] = new stdClass(); |
|
| 176 | $retval[$i]->name = $query[$i]['name']; |
|
| 177 | $retval[$i]->type = $query[$i]['type']; |
|
| 178 | $retval[$i]->max_length = NULL; |
|
| 179 | $retval[$i]->default = $query[$i]['dflt_value']; |
|
| 180 | $retval[$i]->primary_key = isset($query[$i]['pk']) ? (int) $query[$i]['pk'] : 0; |
|
| 181 | } |
|
| 182 | ||
| 183 | return $retval; |
|
| 184 | } |
|
| 185 | ||
| 186 | // -------------------------------------------------------------------- |
|
| 187 | ||
| @@ 239-264 (lines=26) @@ | ||
| 236 | * @param string $table |
|
| 237 | * @return array |
|
| 238 | */ |
|
| 239 | public function field_data($table) |
|
| 240 | { |
|
| 241 | if (($query = $this->query('PRAGMA TABLE_INFO('.$this->protect_identifiers($table, TRUE, NULL, FALSE).')')) === FALSE) |
|
| 242 | { |
|
| 243 | return FALSE; |
|
| 244 | } |
|
| 245 | ||
| 246 | $query = $query->result_array(); |
|
| 247 | if (empty($query)) |
|
| 248 | { |
|
| 249 | return FALSE; |
|
| 250 | } |
|
| 251 | ||
| 252 | $retval = array(); |
|
| 253 | for ($i = 0, $c = count($query); $i < $c; $i++) |
|
| 254 | { |
|
| 255 | $retval[$i] = new stdClass(); |
|
| 256 | $retval[$i]->name = $query[$i]['name']; |
|
| 257 | $retval[$i]->type = $query[$i]['type']; |
|
| 258 | $retval[$i]->max_length = NULL; |
|
| 259 | $retval[$i]->default = $query[$i]['dflt_value']; |
|
| 260 | $retval[$i]->primary_key = isset($query[$i]['pk']) ? (int) $query[$i]['pk'] : 0; |
|
| 261 | } |
|
| 262 | ||
| 263 | return $retval; |
|
| 264 | } |
|
| 265 | ||
| 266 | // -------------------------------------------------------------------- |
|
| 267 | ||
| @@ 261-286 (lines=26) @@ | ||
| 258 | * @param string $table |
|
| 259 | * @return array |
|
| 260 | */ |
|
| 261 | public function field_data($table) |
|
| 262 | { |
|
| 263 | if (($query = $this->query('PRAGMA TABLE_INFO('.$this->protect_identifiers($table, TRUE, NULL, FALSE).')')) === FALSE) |
|
| 264 | { |
|
| 265 | return FALSE; |
|
| 266 | } |
|
| 267 | ||
| 268 | $query = $query->result_array(); |
|
| 269 | if (empty($query)) |
|
| 270 | { |
|
| 271 | return FALSE; |
|
| 272 | } |
|
| 273 | ||
| 274 | $retval = array(); |
|
| 275 | for ($i = 0, $c = count($query); $i < $c; $i++) |
|
| 276 | { |
|
| 277 | $retval[$i] = new stdClass(); |
|
| 278 | $retval[$i]->name = $query[$i]['name']; |
|
| 279 | $retval[$i]->type = $query[$i]['type']; |
|
| 280 | $retval[$i]->max_length = NULL; |
|
| 281 | $retval[$i]->default = $query[$i]['dflt_value']; |
|
| 282 | $retval[$i]->primary_key = isset($query[$i]['pk']) ? (int) $query[$i]['pk'] : 0; |
|
| 283 | } |
|
| 284 | ||
| 285 | return $retval; |
|
| 286 | } |
|
| 287 | ||
| 288 | // -------------------------------------------------------------------- |
|
| 289 | ||