You can use mod_auth_mysql for this purpose so you don't have to code. I found this link about that, but i am sure there are better documentations too.

--
tune