ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:connection:getassoc

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
v5:reference:connection:getassoc [2017/05/09 00:57] – [Description] mnewnhamv5:reference:connection:getassoc [2017/05/09 01:09] (current) – mnewnham
Line 129: Line 129:
                      
 </code> </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 ===== ===== Using The Recordset Method =====
v5/reference/connection/getassoc.txt · Last modified: 2017/05/09 01:09 by mnewnham