in reply to Auto completing a form from and to a mysql database

This is 95% a client side problem. You'd need to use something like jQuery and javascript on the client to populate things that you get back from the server (e.g. when they've typed your three letters in the Artist field it'd fire off an AJAX request to /api/complete?field=Artist&entry=van which would return a JSON list of everything matching "van" in your DB).

Here's a sample mojo implementation that a quick search turned up on SO.

The cake is a lie.
The cake is a lie.
The cake is a lie.

Replies are listed 'Best First'.
Re^2: Auto completing a form from and to a mysql database
by marto (Cardinal) on Oct 15, 2020 at 16:28 UTC

    "You'd need to use something like jQuery and javascript"

    Probably not. For personal projects I ditched it's while back

[reply]

      Searching for "autocomplete" on that page returns no results though.

      You certainly could roll your own autocomplete without it, and there are other (JS) frameworks which probably provide a similar widget but . . . bleh.

      The cake is a lie.
      The cake is a lie.
      The cake is a lie.

[reply]

        That's quite the turn around from saying jQuery was "needed" :P That page is about getting rid of jQuery as a dependency, not replacing every plugin upon which jQuery is required. While there are various options for drop in jQueryless autocomplete/typeahead HTML5 has datalist which negates a lot of the use cases anyway.

[reply]
Re^2: Auto completing a form from and to a mysql database
by Dazz45X (Novice) on Oct 15, 2020 at 15:25 UTC

    Thanks for your helpFletch

    That link looks useful I've got something that looks similar but with different libraries I'll give it a go a bit later. Guess I need to have a look at AJAX whilst I'm at it as well

    Thank you
[reply]

In Section Seekers of Perl Wisdom