Differences

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

--- v5:userguide:learn_abstraction:key_value_pairs [2016/03/17 01:20] – mnewnham
+++ v5:userguide:learn_abstraction:key_value_pairs [2016/08/14 21:44] – mnewnham
@@ Line 1: / Line 1: @@
 <- v5:userguide:learn_abstraction:basic_query|A Basic Query ^ v5:userguide:learn_abstraction:start_lesson|Start Of Lesson ^ v5:userguide:learn_abstraction:using_execute|Using The Execute Method ->
+~~NOTOC~~
 ====== Key/Value Pairs ======
+===== An Associative Array =====
 An often-used SQL construction is to read a table for a key/value pair. This can be used in creating Select Boxes, Radio groups etc. ADOdb contains a shortcut command [[v5:reference:connection:getassoc|getAssoc()]] to assist in the task.
@@ Line 50: / Line 52: @@
 class jsonObject
 {
+   /*
+    * The jquery plugin requires each pair of data be a json object,
+    * with the key called 'id' and the description called 'text'
+    */
     public $id;
     public $text;
@@ Line 80: / Line 86: @@
 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 )}}