从mysql表填充的自动完成的输出

Question

My textboxes get autocomplete populated from mysql tables.

I want to display the output list from the textbox into a selectable option instead of an list item.

echo '<li onClick="fill(\''.$result->naam_klant.'\');">'.$result->naam_klant.'</li>';

My code so far:

'<select onClick="fill(\''.$result->naam_klant.'\');"><option value=$result->naam_klant></option></select>';

Can you guys help me with this ?

UPDATE

    if(isset($_POST['queryString'])) {
         $queryString = $db->real_escape_string($_POST['queryString']);
        // Is the string length greater than 0?
        if(strlen($queryString) >0) {
            $query = $db->query("SELECT naam_klant FROM overboekingen WHERE naam_klant LIKE '$queryString%' LIMIT 10");     
            if($query) {
                 while ($result = $query ->fetch_object()) {
                     echo '<li onClick="fill(\''.$result->naam_klant.'\');">'.$result->naam_klant.'</li>';
                    '<select onClick="fill(\''.$result->naam_klant.'\');"><option value=$result->naam_klant></option></select>';
                }
            } else {
                echo 'ERROR: There was a problem with the query.';
            }
        } else {

        } // There is a queryString.
    } else {
        echo 'There should be no direct access to this naam_klant script!';
    }   
}

?>

Answer 1

You don't give enough information, how you is your results structured?

<select onchange="fill(this.value);" onfocus="this.selectedIndex = -1;">
<? 
    for ($i=0; $i < count(results); $i++) { 
        $result = results[i];
        echo "<option value='{$result->naam_klant}'>option {$result->naam_klant}</option>
";
    }  
?>
</select>

Update

Since you want a selectable option instead of an list item

if ($query) {
   echo '<select onchange="fill(this.value);" onfocus="this.selectedIndex = -1;">
';
   while ($result = $query->fetch_object()) {
         echo '<option value={$result->naam_klant}>{$result->naam_klant}</option>
';
   }
   echo '</select>
';
}