editor dependend with NULL option
editor dependend with NULL option
koniahin
Posts: 186Questions: 39Answers: 7
I got editor dependent working nicely with a list of country and region codes. I now realize that we don't always have the region name to select from the list. In that case we need to add a NULL or empty --select-- option as the first item in the select list. How do we do that?
$regions = $db
->select( 'regions', ['regions.region_code as value', 'regions.region_name as label'], ['regions.country_code' => $_REQUEST['values']['roster.pob_country_code'], 'publish' => 'Yes'] )
->fetchAll();
echo json_encode( [
'options' => [
'roster.pob_region_code' => $regions
]
] );
Answers
Rather than doing it on the server-side, it is easiest to to it on the client-side with the options that
selectmakes available. Specifically the:placeholderplaceholderDisabledplaceholderValueproperties will be the ones of interest to you.
You'll likely also need a set formatter to convert the empty string submitted by the HTTP variables to be a null value. See the docs for that here.
Allan