Differences

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

--- v5:userguide:learn_abstraction:key_value_pairs [2016/03/17 01:24] – mnewnham
+++ v5:userguide:learn_abstraction:key_value_pairs [2021/02/21 13:45] (current) – typo, httpheader for json, param names for mysqli example peterdd
@@ Line 44: / Line 44: @@
 * Program adodbExample.php
 */
-include 'adodb_dir/adodb.inc.php';
+include_once 'adodb_dir/adodb.inc.php';
 /*
@@ Line 63: / Line 63: @@
 $db = newAdoConnection('mysqli');
-$db->connect('parameter1','parameter2','etc','etc');
+#$db->debug=true;
+$db->connect('dbhost','dbuser','dbpassword','dbname');
 $sql = "SELECT state_code,name
          FROM us_states
      ORDER BY state_code";
-$result = $db->execute($SQL);
+$result = $db->execute($sql);
 while ($r = $result->fetchRow())
 {
@@ Line 80: / Line 81: @@
 * Return the data to the calling progam
 */
+if(!$db->debug){
+    header('Content-Type: application/json');
+}
 print json_encode($rows);
 </code>
@@ Line 86: / Line 90: @@
 The method [[v5:reference:recordset:fetchnextobj|fetchNextObject()]] returns data as a PHP object which can be easily JSON encoded.
-{{htmlmetatags>metatag-keywords:(php, programming, json, javascript, jquery, adodb, select2, plugin, ajax)}}
+{{htmlmetatags>metatag-keywords=(php, programming, json, javascript, jquery, adodb, select2, plugin, ajax)}}
-{{htmlmetatags>metatag-description:(An example of how to use ADOdb to serve a jquery plugin using ajax )}}
+{{htmlmetatags>metatag-description=(An example of how to use ADOdb to serve a jquery plugin using ajax )}}