Google style search feature added to edit/manage CERTTS accounts

In the past few months, I’ve been interested in creating a Google style search to the admin page in CERTTS.  In the past, the search term was based solely on what was typed in the text box of the edit/update accounts page.  I was interested in having the ability to suggest (to the user entering the search term) names in the accounts table that the user may be searching for.  The edit/update accounts page now has the flexibility to search for accounts by last name or by username.  When the user starts typing the search term, a Google style suggestion box appears below the text box.  Based on what the user is typing, the script will access the database and display last names or usernames similar to what the search term is.  As the user completes more of the text in the search box, the possible matches will become fewer as the suggestions narrows down the possibilities.  This allows the user to begin the basic spelling of the name being searched and then choose from a drop-down list of suggestions that match the criteria.  Now that I’ve completed this suggestions script, I’m looking into ways that this suggestion style search can be implemented on more of the CERTTS forms.

Leave a comment