ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:dictionary:metacolumns

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
dictionary:metacolumns [2015/10/16 18:36] mnewnhamv5:dictionary:metacolumns [2018/07/01 22:18] (current) – prefer functions start lowercase (#430) peterdd
Line 1: Line 1:
 ====== metaColumns ===== ====== metaColumns =====
-<WRAP todo> 
-This page is under construction 
-</WRAP> 
-<WRAP alert> 
-The portability of the returned data is currently questionable, in terms of field types and field name normalization. Later releases of ADOdb may change the returned values for specific drivers. As a ''Meta'' function, this function __should__ return portable information. 
-</WRAP> 
 ~~NOTOC~~ ~~NOTOC~~
 <WRAP right box> <WRAP right box>
Line 14: Line 8:
 </WRAP> </WRAP>
 ===== Description ===== ===== Description =====
-The function ''metaColumns()'' returns an array of [[reference:ADOFieldObject]] objects, each representing a description of each field of the requested table or view in the passed value ''$tableName''. Each database returns a core set of descriptions, plus additional information. See the driver documentation for more information.+The function ''metaColumns()'' returns an array of [[v5:dictionary:adofieldobject]] objects, each representing a description of each field of the requested table or view in the passed value ''$tableName''. Each database returns a core set of descriptions, plus additional information. See the driver documentation for more information.
  
 The formatting of the array cannot be controlled by ''ADODB_ASSOC_CASE'', the following casing occurs: The formatting of the array cannot be controlled by ''ADODB_ASSOC_CASE'', the following casing occurs:
  
-  * Field name (array key) - if the current value of [[reference:ADODB_FETCH_MODE]] is ADODB_FETCH_NUM, then the keys are returned as a numeric array, otherwise they are returned as an Upper Case key containing the name of the field.+  * Field name (array key) - if the current value of [[v5:reference:adodb_fetch_mode]] is ADODB_FETCH_NUM, then the keys are returned as a numeric array, otherwise they are returned as an Upper Case key containing the name of the field.
   * Information keys - Lower Case   * Information keys - Lower Case
   * Information - Lower Case   * Information - Lower Case
- 
- 
- 
-===== Core Fields ===== 
-The following fields are returned by all drivers: 
- 
  
 ===== Usage ===== ===== Usage =====
Line 33: Line 21:
  * Assume DB2 connection  * Assume DB2 connection
  */  */
-$ar = $db->MetaColumns('ACT');+$ar = $db->metaColumns('ACT');
 print_r($ar); print_r($ar);
 /* /*
v5/dictionary/metacolumns.1445013369.txt.gz · Last modified: 2017/04/21 11:28 (external edit)