Differences

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

--- v5:reference:adodb_assoc_case [2022/06/08 16:10] – [ADODB_ASSOC_CASE] fix incorrect indication of when constant must be declared dregad
+++ v5:reference:adodb_assoc_case [2022/06/08 16:14] (current) – [Usage] fix code samples to reflect correct initialization of ADODB_ASSOC_CASE dregad
@@ Line 30: / Line 30: @@
 ===== Usage =====
 <code php>
-define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_LOWER);
 require "adodb.inc.php";
+define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_LOWER);
 $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
-// $db Connection assumed
+$db = ADONewConnection('mysql');
+$db->connect($host, $user, $password, $database);
 print_r($db->getAll("SELECT accountNo, accountName FROM table"));
@@ Line 50: / Line 51: @@
 or:
 <code php>
-define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_UPPER);
 require "adodb.inc.php";
+define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_UPPER);
 $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
-// $db Connection assumed
+$db = ADONewConnection('mysql');
+$db->connect($host, $user, $password, $database);
 print_r($db->getAll("SELECT accountNo, accountName FROM table"));
@@ Line 73: / Line 76: @@
 <code php>
-define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_NATIVE);
 require "adodb.inc.php";
+define('ADODB_ASSOC_CASE', ADODB_ASSOC_CASE_NATIVE);
 $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
-// $db Connection assumed
+$db = ADONewConnection('mysql');
+$db->connect($host, $user, $password, $database);
 print_r($db->getAll("SELECT accountNo, accountName FROM table"));