ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:recordset:getmenu

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
Last revisionBoth sides next revision
v5:reference:recordset:getmenu [2019/01/01 23:49] mnewnhamv5:reference:recordset:getmenu [2019/11/24 00:08] – No longer required to use ADODB_FETCH_NUM dregad
Line 1: Line 1:
 ====== getMenu ====== ====== getMenu ======
 ~~NOTOC~~ ~~NOTOC~~
-<WRAP info> 
-This method requires that ADODB_FETCH_MODE be set to ADODB_FETCH_NUM prior to execution of the SQL statement that will provide the recordset. 
-</WRAP> 
 <WRAP right box> <WRAP right box>
 == See Also == == See Also ==
Line 10: Line 7:
 == Syntax == == Syntax ==
   string getMenu(   string getMenu(
-      optional string $selectName='',+      string $selectName,
       optional mixed $defaultValue=false,       optional mixed $defaultValue=false,
       optional mixed $blankFirstItem=true,       optional mixed $blankFirstItem=true,
Line 22: Line 19:
 </WRAP> </WRAP>
 ===== Description ===== ===== Description =====
-The function ''getMenu()'' Generate an HTML SELECT tag string from a recordset, and return the string.  + 
-If the returned recordset has a single column, the option values and descriptions are the same. +The function ''getMenu()'' generates an HTML SELECT tag string from a recordset, and returns the string. 
-If the returned recordset has 2 cols, the 1st column is the description and the 2nd column is the value. By default, the 2nd column is matched against the defaut, if provided.  + 
-If the recordset returns more than 2 columns, the 3rd and greater columns are discarded.+If the recordset has a single column, the option values and descriptions are the same. 
 +If it has 2 columns, the first one is the description and the second is the value. By default, the 2nd column is matched against ''$defaultValue'', if provided.  
 + 
 +Any extra column beyond the first two will be discarded. 
 + 
 +NOTE: Until ADOdb 5.20.13this method required that [[v5:reference:adodb_fetch_mode|ADODB_FETCH_MODE]] be set to ''ADODB_FETCH_NUM'' prior to execution of the SQL statement that will provide the recordsetStarting with 5.20.14, all fetch modes are supported 
 ===== Parameters ===== ===== Parameters =====
 ==== $selectName ===== ==== $selectName =====
Line 36: Line 39:
   * true (default) - creates an empty ''<option></option>'' tag   * true (default) - creates an empty ''<option></option>'' tag
   * false - does not creates an empty ''<option></option>'' tag   * false - does not creates an empty ''<option></option>'' tag
-  * string value - creates an ''<option value=``>STRING</option>'' tag+  * string value - creates an ''<option value="">STRING</option>'' tag
   * string value format ''value:description'' - creates an ''<option value='value'>description</option>'' tag   * string value format ''value:description'' - creates an ''<option value='value'>description</option>'' tag
  
v5/reference/recordset/getmenu.txt · Last modified: 2019/11/24 00:16 by dregad