v5:reference:connection:getassoc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:reference:getassoc [2016/01/13 02:31] – ↷ Links adapted because of a move operation 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 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 | + | The presentation |
- | For a detailed description of the SQL and bind parameters passed, see [[v5: | + | For a detailed description of the SQL and bind parameters passed, see [[v5: |
In addition it should be noted that the presentation of the returned data is modified by the number of columns requested in the SQL statement and the setting of the optional parameters '' | In addition it should be noted that the presentation of the returned data is modified by the number of columns requested in the SQL statement and the setting of the optional parameters '' | ||
Line 129: | Line 129: | ||
| | ||
</ | </ | ||
+ | ===== How ADODB_ASSOC_CASE affects returned data ===== | ||
+ | In certain instances, the '' | ||
+ | <code php> | ||
+ | /* | ||
+ | * Connection to mysql ' | ||
+ | */ | ||
+ | $SQL = " | ||
+ | $r = $db-> | ||
+ | print_r($r); | ||
+ | /* | ||
+ | * Returns: | ||
+ | Array | ||
+ | ( | ||
+ | [Georgi] => Wielonsky | ||
+ | [Bezalel] => Ranon | ||
+ | [Parto] => Kambil | ||
+ | ........ | ||
+ | ) | ||
+ | */ | ||
+ | </ | ||
+ | Setting ADODB_ASSOC_CASE to ASSOC_CASE_LOWER: | ||
+ | <code php> | ||
+ | /* | ||
+ | * Connection to mysql ' | ||
+ | */ | ||
+ | $SQL = " | ||
+ | $r = $db-> | ||
+ | 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 | ||
+ | ) | ||
+ | ....... | ||
+ | ) | ||
+ | */ | ||
+ | </ | ||
+ | Setting ADODB_ASSOC_CASE to ASSOC_CASE_UPPER: | ||
+ | <code php> | ||
+ | /* | ||
+ | * Connection to mysql ' | ||
+ | */ | ||
+ | $SQL = " | ||
+ | $r = $db-> | ||
+ | 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 | ||
+ | ) | ||
+ | ....... | ||
+ | ) | ||
+ | */ | ||
+ | </ | ||
+ | |||
- | + | ===== Using The Recordset Method ===== | |
+ | The method can also be used as a recordset method | ||
+ | |||
+ | <code php> | ||
+ | $ar = $db-> | ||
+ | </ |
v5/reference/connection/getassoc.txt · Last modified: 2017/05/09 01:09 by mnewnham