If you're using a JS library, there is a good chance it supports an "autocomplete" widget. These work by using some event (e.g., "keyup" or whatever) to automatically send an asynchronous request to the backend with the current state of the search bar. The response will be handled by your Perl application and should return a list of entries to populate the dropdown list. Conceptually, this is straigtforward. However if you choose when to query the list poorly (e.g., too early) then it can quickly become both a user experience issue and a potential resource spike issue on your server. So on the server side, you just need a trad request handler given a "search term" (state of the input field). On the client side is where you do all the fancy stuff. You can get fancy on the server side with caching and whatnot, but I'd focus on getting it right on the client side first. Note: I have a forever hobby website that I maintain that includes a custom search. I've resisted putting in autocomplete, mainly because all the interesting stuff required is on the front end and I prefer the interesting stuff to be on the back end. So I have thought about it, just never executed on it.

In reply to Re: Auto completing a form from and to a mysql database by perlfan
in thread Auto completing a form from and to a mysql database by Dazz45X

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.