Select - Drop Down Options

Using the addField() function we can generate selects by simply parsing specific values in an array or specific settings to generate it from database values.

The minimum parameters to pass are:

addField([
  'type'=> 'select',
  'label'=> 'Label Title',
  'name'=> 'colName',  //optional
  'placeholder'=> 'Select an option',  //optional - default: Select an option
  'value'=> 'selected value', //optional, without one a "Select an option" option appears
  'options'=> [       //required, unless optionsdb is used (see next)
     0 =>['name' => 'OP1','value'=> 'VAL1'],
     1 =>['name' => 'OP2','value'=> 'VAL2'],
     2 =>['name' => 'OP3','value'=> 'VAL3'],
     ...
  ]
]);

If we want to get the options data from a database our array needs the following keys:

addField([
  'type'=> 'select',
  'label'=> 'Label Title',
  'name'=> 'colName',  //optional
  'showAll' => true, //optional, false by default
  'showAllTxt' => 'Show All Items', // optional, default Show All when Show All is true or Select an option (disabled) when no value is selected
  'value'=> 'selected value', //optional, without one a "Select an option" option appears
  'optionsdb'=> [       //required if options is not used
     'table' => 'TABLE NAME', //required
     'op_name' => 'COL_NAME', //required
     'op_val' => 'COL_NAME',  //required
     'where' => 'WHERE STATEMENT', //optional
     'order' => 'ORDER STATEMENT'  //optional
  ]
]);

'optionsdb'=> [
   "table" => "CLIENT_TYPE",
   "op_name" => "type_$mainLang",
   "op_val" => "CTID",
   "where" => "type_$mainLang != '' ",
   "order" => "order by type_$mainLang"
];

 addField([
  'type'=> 'select',
  'label'=> 'Label Title',
  'name'=> 'colName',  //optional
  'placeholder'=> 'Select an option',  //optional - default: Select an option
  'id' => 'selID', //optional, name is used as id if id is null
  'value'=> 'selected value', //optional, without one a "Select an option" option appears
  'attributes' => 'required', //optional
  'style' => 'border:1px solid red', //optional
  'showAll' => true, //optional, false by default
  'showAllTxt' => 'Show All Items', // optional, default Show All when Show All is true or Select an option (disabled) when no value is selected
  'class' => '', //optional
  'options'=> array(), //optional, required if optionsdb is not used
  'optionsdb'=> [       //required if options is not used
     'table' => 'TABLE NAME', //required
     'op_name' => 'COL_NAME', //required
     'op_val' => 'COL_NAME',  //required
     'where' => 'WHERE STATEMENT', //optional
     'order' => 'ORDER STATEMENT'  //optional
  ]
]);

$selValues = "value:name,value:name,value:name"

$selValues = 'VI:Visa,MC:Mastercard,AMEX:American Express';
addField('select','CC Provider','CC_PROVIDER:',$selValues);