Differences

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

--- v5:reference:connection:getassoc [2016/02/09 01:35] – [Description] mnewnham
+++ v5:reference:connection:getassoc [2017/05/09 01:09] (current) – mnewnham
@@ Line 14: / Line 14: @@
 The function executes a statement and returns all of the returned rows in an array or false if the statement execution fails, or if only 1 column is requested in the SQL statement. If no records match the provided SQL statement, an empty array is returned.
-The presentation of the returned data can be modified by the variable [[v5:reference:adodb_assoc_case|$ADODB_ASSOC_CASE]].
+The presentation of certain aspects of the returned data can be modified by the constant [[v5:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] (see below for examples).
 For a detailed description of the SQL and bind parameters passed, see [[v5:reference:connection:execute|execute()]].
@@ Line 129: / Line 129: @@
 </code>
+===== How ADODB_ASSOC_CASE affects returned data =====
+In certain instances, the ''ADODB_ASSOC_CASE'' constant changes the casing of inner keys. **The casing of outer keys is never affected**, so in this first example, the data will always be returned as it appears in the database
+<code php>
+/*
+* Connection to mysql 'employees' database assumed.
+*/
+$SQL = "SELECT first_name,last_name from employees";
+$r = $db->getAssoc($SQL);
+print_r($r);
+/*
+* Returns:
+Array
+(
+    [Georgi] => Wielonsky
+    [Bezalel] => Ranon
+    [Parto] => Kambil
+    ........
+)
+*/
+</code>
+Setting ADODB_ASSOC_CASE to ASSOC_CASE_LOWER:
+<code php>
+/*
+* Connection to mysql 'employees' database assumed.
+*/
+$SQL = "SELECT first_name,last_name,emp_no from employees";
+$r = $db->getAssoc($SQL);
+print_r($r);
+/*
+* Returns:
+Array
+(
+    [Georgi] => Array
+        (
+            [last_name] => Wielonsky
+            [emp_no] => 499814
+        )
+    [Bezalel] => Array
+        (
+            [last_name] => Ranon
+            [emp_no] => 499846
+        )
+    [Parto] => Array
+        (
+            [last_name] => Kambil
+            [emp_no] => 499529
+        )
+    .......
+ )
+*/
+</code>
+Setting ADODB_ASSOC_CASE to ASSOC_CASE_UPPER:
+<code php>
+/*
+* Connection to mysql 'employees' database assumed.
+*/
+$SQL = "SELECT first_name,last_name,emp_no from employees";
+$r = $db->getAssoc($SQL);
+print_r($r);
+/*
+* Returns:
+Array
+Array
+(
+    [Georgi] => Array
+        (
+            [LAST_NAME] => Wielonsky
+            [EMP_NO] => 499814
+        )
+    [Bezalel] => Array
+        (
+            [LAST_NAME] => Ranon
+            [EMP_NO] => 499846
+        )
+    [Parto] => Array
+        (
+            [LAST_NAME] => Kambil
+            [EMP_NO] => 499529
+        )
+    .......
+ )
+*/
+</code>
+===== Using The Recordset Method =====
+The method can also be used as a recordset method
+<code php>
+$ar = $db->Execute("SELECT * FROM ACT")->getAssoc();
+</code>