ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:getassoc

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
v5:reference:connection:getassoc [2017/05/09 00:57]
mnewnham [Description]
v5:reference:connection:getassoc [2017/05/09 01:09]
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