Autocompleter with data from DB Read

Hello,

I want to use an "autocompleter" with data from one table field in my database. My DB Read action returns a list of themes so an array (multi read is set to "yes" and model ID is "select_theme"). Starting from the autocompleter demo proposed in chronoforms v5 how should I adapt the following custom code including the declaration of the variable $countries :

<?php
$countries = ........ ;
foreach($countries as $country){
 if(!empty($form->data['tag']) AND stripos($country, $form->data['tag']) === false){
 continue;
 }
 $json[] = array('id' => $country, 'text' => $country);
}
echo json_encode($json);

Thanks for help.

Hi veronique,
​
v5 is outdated, are you willing to try this feature on the new v7 beta ?

Hi Max,
​
Thank you but I still need this form in version 5, I can't resume everything in version 7 more limited in fields.

what features you are cirrently using on v5 for this form ?