Friends I'm looking for a way to autocomplete an input in the html, where the value of that input will be the id.
This is my procedure mysql.
DELIMITER $$
create procedure BuscarMusica
(in musica varchar(90))
begin
select m.id,m.musica
from mp3 as m where m.musica like CONCAT("%",musica,"%") ;
END$$
DELIMITER ;
I do a get service calling this procedure of the Mysql in Nodejs, therefore the url of my api is like this:
localhost: 3000 / searchMusic /: name
Which I want to consume that service that believes in an ajax get and autocomplete it in the input that is in this code
<div class="ui-widget">
<label for="musica">Musica: </label>
<input id="musica">
</div>