Retrieve data from mysql database using PHP without submit button

See more:

HTML

PHP

MySQL

Hello,

I am trying to have an html form, that when the user enters an ID it automatically queries a select command from a mysql database that returns data that are related to his ID

For example:

ID:
Name:

I want that when the user enters his ID, instantly the name will be filled without using a submit button and he must stay in the same page (to fill other info)

What I have tried:

I've tried to put like a php code inside the "input type="text" value="php script that has select from database"
But it's not working..

Any ideas appreciated.