Differences

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

--- v5:reference:adodb_assoc_case [2019/05/08 13:17] – Rewrite and reformat, based also on 'Associative Key Case' page of 'Working With Fields' tutorial dregad
+++ v5:reference:adodb_assoc_case [2019/05/08 16:32] – [Possible values] reword dregad
@@ Line 13: / Line 13: @@
 |ADODB_ASSOC_CASE_UPPER|1|uppercase field names|
 |ADODB_ASSOC_CASE_NATIVE (Default)|2|native-case field names|
+With the default behavior, ''ADODB_ASSOC_CASE_NATIVE'', ADOdb does not perform any transformation on field names, and returns them exactly as they are defined by the DBMS.
 <WRAP tip>
-The default behavior, ''ADODB_CASE_NATIVE'', lets the DBMS control the fields' casing (i.e. ADOdb returns them exactly as they are defined by the DBMS). However, when writing portable code, it is strongly recommended to choose a default behavior and stick to it, as there is no consistent casing across databases and some DBMS may returned mixed-case keys.
+When writing portable code, it is strongly recommended to choose either upper or lower case.
+Relying on the native case default will likely cause compatibility issues, as there is no consistent casing across databases and some DBMS may returned mixed-case keys.
 </WRAP>
 ===== Usage =====
 <code php>
-define('ADODB_ASSOC_CASE',0);
+define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_LOWER);
-require "adodb/adodb.inc.php";
+require "adodb.inc.php";
+$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
-/*
+// $db Connection assumed
- * connection assumed
-*/
+print_r($db->getAll("SELECT accountNo, accountName FROM table"));
+/* Response is:
-$sql = "SELECT accountNo,accountName FROM table";
-$data = $db->getAll($sql);
-print_r($data);
-/*
- * Response is:
  [0]=>array('accountno'=>1,
             'accountname'=>'The First Account'
@@ Line 38: / Line 39: @@
             'accountname'=>'The Second Account'
             )
-            )
 */
 </code>
@@ Line 45: / Line 44: @@
 or:
 <code php>
-define('ADODB_ASSOC_CASE',1);
+define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_UPPER);
-require "adodb/adodb.inc.php";
+require "adodb.inc.php";
+$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
-/*
+// $db Connection assumed
- * connection assumed
-*/
+print_r($db->getAll("SELECT accountNo, accountName FROM table"));
+/* Response is:
-$sql = "SELECT accountNo,accountName FROM table";
-$data = $db->getAll($sql);
-print_r($data);
-/*
- * Response is:
  [0]=>array('ACCOUNTNO'=>1,
             'ACCOUNTNAME'=>'The First Account'
@@ Line 63: / Line 60: @@
             'ACCOUNTNAME'=>'The Second Account'
             )
-            )
 */
 </code>
@@ Line 71: / Line 66: @@
 <code php>
-define('ADODB_ASSOC_CASE',2);
+define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_NATIVE);
-require "adodb/adodb.inc.php";
+require "adodb.inc.php";
+$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
-/*
+// $db Connection assumed
- * connection assumed
-*/
+print_r($db->getAll("SELECT accountNo, accountName FROM table"));
+/* Response is:
-$sql = "SELECT accountNo,accountName FROM table";
-$data = $db->getAll($sql);
-print_r($data);
-/*
- * Response is:
  [0]=>array('accountNo'=>1,
             'accountName'=>'The First Account'
@@ Line 89: / Line 82: @@
             'accountName'=>'The Second Account'
             )
-            )
 */
 </code>