Login option based on database of registered users

Hello,
I think I have read everything about login page which dated far to 2007.
I wonder if any suggestions or changes been made so far?

I am trying to figure out the way how to use the database form and allow users to enter their email (as username) and password ( as they chosen) to access a web page link.

I believe it should be not as difficult, as database is there - form should recall and compare the data entered into fields to data in database and if correct send to web page.
I think it should be done in action or on click -- where main script is if input_email = Mail and if input_password=Password then go to www.blablabla...

Any ideas? I hope I am not alone in looking into this.

Thanks ever so much for any help! or suggestions..
marie