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 revision Previous revision
Next revision
Previous revision
v5:reference:recordset:getmenu [2019/05/07 16:08]
dregad [Description]
v5:reference:recordset:getmenu [2019/11/24 00:16]
dregad Add wrap around fetch mode note
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 26: Line 23:
  
 If the recordset has a single column, the option values and descriptions are the same. 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 ​the defaut, if provided. ​+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. Any extra column beyond the first two will be discarded.
 +
 +<WRAP info left>
 +Until ADOdb 5.20.13, this 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 recordset. Starting with 5.20.14, all fetch modes are supported
 +</​WRAP>​
 +
 ===== Parameters ===== ===== Parameters =====
 ==== $selectName ===== ==== $selectName =====
Line 39: Line 41:
   * 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