v5:userguide:learn_dictionary:metacolumns
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
v5:userguide:learn_dictionary:metacolumns [2016/03/16 03:06] – mnewnham | v5:userguide:learn_dictionary:metacolumns [2016/03/17 00:16] – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | <- v5: | + | <- v5: |
~~NOTOC~~ | ~~NOTOC~~ | ||
====== MetaColumns ====== | ====== MetaColumns ====== | ||
- | The metaColumns method returns an array of [[v5: | + | The metaColumns method returns an array of [[v5: |
<code php> | <code php> | ||
$m = $db-> | $m = $db-> | ||
Line 28: | Line 28: | ||
For example, in the example above, the actname field is of a type **// | For example, in the example above, the actname field is of a type **// | ||
+ | |||
+ | ===== Extended Attributes ===== | ||
+ | Some drivers return an extended set of attributes that represent DBMS specific functionality. For example, the IBM DB2 driver returns the normal 3 attributes above plus the following 3: | ||
+ | |||
+ | [not_null] => | ||
+ | [scale] => | ||
+ | [primary_key] => | ||
+ | |||
+ | If you are writing portable applications you should not rely on these attributes to be available across all databases. | ||
===== metaColumnNames ===== | ===== metaColumnNames ===== | ||
- | This method returns just the column names from the table. | + | This method |
+ | <code php> | ||
+ | |||
+ | $ar = $db-> | ||
+ | print_r($ar); | ||
+ | /* | ||
+ | * Returns: | ||
+ | COLUMN_1=> | ||
+ | COLUMN_2=> | ||
+ | COLUMN_3=> | ||
+ | */ | ||
+ | </ |
v5/userguide/learn_dictionary/metacolumns.txt · Last modified: 2016/03/20 15:05 by mnewnham