How to filter and reduce drop down select box

Question

Using below code to display database values as drop down in rsjoomla

$items = "|Please Select[c]\n";
$db = JFactory::getDBO();
$db->setQuery("SELECT id, prod_name FROM __used_products ORDER BY prod_sorder ASC");
$result = $db->loadObjectList();
if($result)
foreach ($result as $r)
$items .= $r->id . '|' . $r->prod_name . "\n";

return rtrim($items);

However - as the drop down is of more than 200 items, is there a way for a user to start typing a word and the select box only shows possible matches?

For example, the drop down field has the following options:

• Alto
• Amaze
• Wagon r
• swift
• i10
• santro

Then if a user types in a - it should display matching results (Alto, Amaze)

Answer 1

Simple. You'll want to utilise jQuery Chosen which is shipped with Joomla.

Target a specific select box:

<?php JHtml::_('formbehavior.chosen', '.myclass'); ?>

<select class="myclass">
    // Options
</select>

---

Target all select boxes:

<?php JHtml::_('formbehavior.chosen', 'select'); ?>

<select>
    // Options
</select>

---

It will render something similar to the image below.