ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:userguide:learn_abstraction:key_value_pairs

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
v5:userguide:learn_abstraction:key_value_pairs [2016/03/17 01:20] mnewnhamv5:userguide:learn_abstraction:key_value_pairs [2016/03/17 01:24] 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 -> <- 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 ====== ====== 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. 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 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 $id;
     public $text;     public $text;
v5/userguide/learn_abstraction/key_value_pairs.txt · Last modified: 2021/02/21 13:45 by peterdd