Work through the worksheet to create a basic login page
The problem with the page we have just created is that the php login verifier file re-rects successful logins to an unsecure html page. If a user knew the url of the secure page, they could just navigate directly to that (i.e. type in ServierSide2.html into the address bar of their browser).
To avoid this we make all the pages into PHP pages. \You can mix PHP code with html, so you can use the php bits which only est on the server to undertake secure operations, and return the html to the client.
What we want to do is to pass some sort of token from the login verifier page to the secure page, so that the secure page will not open unless it has the secure token (as an alternative we could build the verification code into the secure page, but having it as a separate page becomes more flexible later when we will be using that page to access user details from a database)
There are three possible ways to pass a token from one a page to another:
We are therefore going to use session variables
follow the worksheet to see how
Folllow the worksheet on creating a database using SQL to query it:
Write an sql query to find out Walker Knapp's password
Write an SQL query to change Martina Avery's password
Write a query to create a new record for:
Write a query to delete the record for Orson Bond
Read and follow the instruction sheet