Differences

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

--- v5:reference:recordset:fieldtypesarray [2021/05/05 03:17] – mnewnham
+++ v5:reference:recordset:fieldtypesarray [2021/05/05 03:31] (current) – mnewnham
@@ Line 3: / Line 3: @@
 <WRAP right box>
 == See Also ==
-[[v5:reference:recordset:fetchField]]\\
+[[v5:reference:recordset:fetchField|fetchField()]]\\
+[[v5:reference:recordset:fieldCount|fieldCount()]]\\
 == Syntax ==
-  array fieldTypesArray()
+  mixed fieldTypesArray()
 </WRAP>
@@ Line 13: / Line 13: @@
 -------------------------------------
 ===== Example =====
+This example uses a postgres database so returns numerous Postgress specific fields
 <code php>
-$sql = "SELECT * FROM employees";
+$sql = "SELECT * FROM dept_emp";
 $result = $db->execute($sql)
-print_r($results->fieldTypesArray());
+print_r($resul->fieldTypesArray());
+/*
+* Returns
+Array
+(
+    [0] => ADOFieldObject Object
+        (
+            [name] => emp_no
+            [max_length] => 0
+            [type] => 3
+            [orgname] => emp_no
+            [table] => dept_emp
+            [orgtable] => dept_emp
+            [def] =>
+            [db] => employees
+            [catalog] => def
+            [length] => 11
+            [charsetnr] => 63
+            [flags] => 53251
+            [decimals] => 0
+            [primary_key] => 2
+            [not_null] => 1
+            [auto_increment] => 0
+            [binary] => 0
+            [unsigned] => 0
+        )
+    [1] => ADOFieldObject Object
+        (
+            [name] => dept_no
+            [max_length] => 4
+            [type] => 254
+            [orgname] => dept_no
+            [table] => dept_emp
+            [orgtable] => dept_emp
+            [def] =>
+            [db] => employees
+            [catalog] => def
+            [length] => 16
+            [charsetnr] => 255
+            [flags] => 20491
+            [decimals] => 0
+            [primary_key] => 2
+            [not_null] => 1
+            [auto_increment] => 0
+            [binary] => 0
+            [unsigned] => 0
+        )
+    [2] => ADOFieldObject Object
+        (
+            [name] => from_date
+            [max_length] => 10
+            [type] => 10
+            [orgname] => from_date
+            [table] => dept_emp
+            [orgtable] => dept_emp
+            [def] =>
+            [db] => employees
+            [catalog] => def
+            [length] => 10
+            [charsetnr] => 63
+            [flags] => 4225
+            [decimals] => 0
+            [primary_key] => 0
+            [not_null] => 1
+            [auto_increment] => 0
+            [binary] => 128
+            [unsigned] => 0
+        )
+......etc.
+*/
 </code>