Create a form that passes two values to the PHP script.. namely username and password.
Then use the following query: SELECT * FROM user_table WHERE username='$username' AND password='$password'
If MySQL returns any results, let them in. Otherwise, don't.