Assignment 11

Now we will be hooking your PHP site up to your MySQL database.

We will be using mysqli functions to do this.

  1. Connect to your database using PHP. This will require your password. Put your password in an external file, add that file to a .gitignore file, and then use PHP to read in the contents of that file. This will prevent you from pushing your password to git.

  2. Make one PHP page per each of the queries you made in the last assignment. Perform the query, then display the results on the page mixed with ul/li tags for good HTML formatting.

  3. Make a PHP page that takes in a name variable as a query string. If the query string is present, perform a query in the database for that user. If the data is present, display it on the page. If the search results no results, show "No user found".

    If the query string is not present show a form allowing the user to enter a name that will reload the same page with the entered value as a query string.

    DO NOT ALLOW SQL INJECTION TO OCCUR ON YOUR PAGE