Login page using sessions and database

Question

HI

     how to create login page using sessions and after login it should redirect to another page(using sessions and stored procedures)