Dropdown autocomplete from database

Question

how to create dropdown with autocomplete from data source mysql with "id" as value attribute and "region" as dropdown list

Answer 1

https://www.google.com/search?q=Dropdown+autocomplete+from+mysql+database&oq=Dropdown+autocomplete+from+mysql+database

Answer 2

With that user can fill in data other than provided, and also can not id region in question. And also with datalist tags may be simpler. Is there anything that can be used like a tag select so that the data sent is the id of the region?