Login to account

I am trying to create website similar to ones that credit card companies use to provide their clients with transaction history of their credit cards. What I have seen is that they uses template pages and call the results from a database. When going to the different template pages would the variables carryover from the login page to the subsequent pages or how would that work? Would MySQL be powerful enough to support something like this? Please give me your thoughts. Ben