CFv5 - Autocompleter with DB table

Question

Where do I place the db read?

right now my setup sheet is as follows:

in on load;
--autocompleter
--db read
--html render form

in on ajax_province
--custom code

my code:


    <?php
    $countries = array();
    if ( !$form->data['Data'] || count($form->data['Data']) < 1 ) {
      // no result was found
      $countries[] = 'Nessun comune in lista';
    } else {
      foreach ( $form->data['Data'] as $d ) {
        $countries[$d['id']] =  $d['id'];
        $countries[$d['name']] =  $d['name'];
      }
    }

    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);
    ?>

Unfortunately it does not work

giusebos · Accepted Answer

ok, I had a problem of adaptation of the code to my table


        <?php
        $lista_regioni = array();
        if ( !$form->data['Datareg'] || count($form->data['Datareg']) < 1 ) {
          // no result was found
          $lista_regioni[] = 'Nessuna regione nella lista';
        } else {
          foreach ( $form->data['Datareg'] as $d ) {
            $lista_regioni[$d['idRegione']] =  $d['idRegione'];
            $lista_regioni[$d['nomeRegione']] =  $d['nomeRegione'];
          }
        }
        foreach($lista_regioni as $una_regione){
         if(!empty($form->data['tag']) AND stripos($una_regione, $form->data['tag']) === false){
          continue;
         }
         $json[] = array('id' => $una_regione, 'text' => $una_regione);
        }
        echo json_encode($json);
        ?>

correct string $json[] = array('id' => $una_regione, 'text' => $una_regione);
wrong string $json[] = array('idregione' => $una_regione, 'text' => $una_regione);