Web Design/PHP challenges

Challenge 1: Idiot Box Survey
Scenario: You are working as IT Support for a small high school in your area. The Parents and Community committee has commissioned a small project to help kids in the school work out exactly how much time they're spending in front of the TV, Computer or Video Game Consoles, as well as collect data on how free time is spent.

Creating the form
You've been asked to whip up a prototype form to collect the following info (remember your target audience when labeling your fields!):
 * First and last name
 * Number of Years in Business
 * Year at School (e.g. 7-12)
 * Number of siblings
 * At what time do they go to bed, and at what time do they wake up.
 * Approximate time spent on homework per day
 * time spent watching TV/DVD etc. per day
 * Time spent using computer or games console per day
 * time spent with family per day
 * time spent with friends per day

You do not necessarily need to make your form pretty or worry about Javascript input validation for the prototype, but it certainly needs to be easy to use. For example: <!DOCTYPE html> colls data  FIRST NAME:  LAST NAME:  AGE:  GRADE:  How many siblings do you have?:  At what time do you go to bed?:  <    br> At what time do you wakeup?:  what is the approximate time you spent on your homework per day?: 

what is the approximate time you spent watching TV/DVD per day?:  what is the approximate time you spent using computer or games console per day?:  what is the approximate time you spent with family per day?:  what is the approximate time you spent with friends per day?:  hint click the clock icon to select time 

Processing your form
Your prototype will also require a php script (or server-side language of your choice) to process the info. The P&C committee have asked for the following:
 * A message saying "Great! Thanks [firstname] for responding to our survey".
 * A display of the students details formatted suitably (just name, birth-year, current school year and number of siblings)
 * An email should be sent to a set email address with a subject of, for example, "David Terry's Survey results." and a message that includes the data entered (no need to worry about formatting or headers in the email).

Challenge 2: Idiot Box Statistics
You receive an email from the P&C Committee asking that once you have this working, your challenges are to modify your response so that it also says: "Based on the information you've entered, you will spend:"
 * x hours watching TV or movies per year.
 * y hours doing homework per year.
 * z hours per year in front of a TV or computer screen per year
 * a hours per year with friends and family

Note, this information does not need to be included in the email. With this you will be ready to demonstrate your prototype!

Extra challenges
Not for the faint-hearted!
 * Use the students' current year at school to work out how many years they have left at school, and from this, how many hours they will spend doing homework or watching a screen until they finish school.
 * Work out the percentage of awake time spent in front of a screen.

Challenge 3: Combining Your Form and Response
After working through Part 3 of Zend's PHP for beginners series, you've worked out that it's a bit neater to put all your code into the one file (rather than having separate files for your form and form processing).

Modify your prototype from Challenge 1 to use just one php file that either displays your survey form or processes the results, depending on whether the form has been submitted (based on the tutorial).

Challenge 3.5: Looping the Loop
Part 3 of Zend's PHP for beginners also gives you an overview of a few different ways that you can repeat stuff in your PHP code. The following challenges are designed to help you re-enforce in your mind how while loops and for loops can be used.

Take a look at the following piece of code and work out what it does as you read through it, then copy-n-paste it into a PHP file to test it out.

Your challenges:
 * Modify the loop so that it displays the numbers from 1 to 100
 * Modify the loop so that it displays the even numbers between 1 and 100
 * Modify the loop so that it displays the numbers from 100 to 1 (i.e. in reverse order)

The above while loop can also be written in other ways (such as a for-loop), but for the moment, it's best that you learn how to use one method well. For those who are interested and feel very confident, you might want to look through the following code (otherwise just skip over it!) PHP Manual - for loops does a great job explaining why you have three different things in the first line: for (part1; part2; part3). If you are keen to try out the for loop, you can do all of the above challenges, but using a for-loop instead of a while loop. Now, use the above to:
 * Copy-n-paste and modify the above piece of code so that it prints the numbers as a single unordered list. i.e. the HTML output should look like:

Last but not least,
 * Copy-n-paste and modify your code to create a simple form that allows the user to select the day of the month that they were born. i.e. the HTML output should look something like:

Challenge 4: Input Validation with PHP
Below is an example IF statement that will check if a user has entered any information into the 'first_name' field. Your challenge is after the example!

Now, for the IF statement in your PHP code: The first line of code checks for one thing, shown below:

It checks if  is NOT equal to an empty string.

If this is TRUE then the following will be printed:

Yes, the input box: 'first_name' was filled in!

And the contents of this input box was: Frank

But, if what the IF-statement checks is not true then the following will be printed:

The input box 'first_name' had nothing in it.

Your challenge is to use the above example to validate your Idiot box survey form! Remember, always break the problem down into small chunks... start by validating just one field, then when that works, add the next etc. (If you're already using JavaScript form validation for this exercise, you'll need to switch it off to test your PHP input validation!

Challenge 5: Putting Stuff into a DB
The P&C committee is happy with your prototype and have given you the go-ahead to develop the database functionality.

This challenge will require you to:
 * create the database table using PhpMyAdmin (or similar),
 * Using PhpMyAdmin, add some data to your database and note the SQL query that was used to add the data (copy the complete query).
 * Update your form processing code so that after displaying the results your code
 * 1) Connects to your database server
 * 2) Selects your database
 * 3) Runs the query that PhpMyAdmin generated for you
 * 4) Closes the connection to your database server

Here's some template code to get you started:


 * Once the last step has been tested and works (you'll need to check whether the test information has actually made its way into your database), modify your query so that the actual information entered into the form is inserted into your database and test it again.

Challenge 6: Getting Stuff out of a DB
After reviewing your form for entering new data for the survey, the P&C committee ask you to create a page that displays all the collected data.

You warn them that they will need to implement some security around this function before going live with the survey application (so that only certain people can view the information), but you agree to get a prototype going to show them how it will work (i.e., you don't need to worry about the security issue for the moment!).

Step-by-step:
 * Create a special page of your site that displays the data from your table. Here's some template code to look through, modify and try out:

After getting the above template code to work with your database (and more importantly, verifying that you understand how it's working, especially the while loop):
 * Modify the code above so that, instead of each row of your table being displayed as a paragraph, each row is outputted as a row of an HTML table.

Challenge 7: Displaying Details for One Record
The following week you meet up with the committee again to demonstrate your work. The committee is impressed to see that you've formatted the survey information in a nice table, but have a few concerns. The biggest concern of the committee is that it is a lot of information to display on the screen at once.

They would like to modify the application so that when the survey results from the database are displayed, only the following information is included in 3 columns:
 * Name: first name and last name,
 * Total hours spent in front of a screen per week,
 * Total hours spent with friends and family per week.

Furthermore, when these results are displayed, the committee would like to be able to click on the name of a student to view the details for that student.

On a piece of paper, see if you can break down your task into a number of steps to tackle (before going on)!

Step-by-step: Test this code by entering the URL "yourdomain.com/path_to_your_file/details.php?id=4" into your browser and see if you can get it working.
 * Modify your results from Challenge 6 so that each row displays the name, Screen hours per week and Social hours per week and test.
 * Add the following link around each student name: &lt;a href="details.php?id=4" title="View student details" &gt;&lt;/a&gt; Note that this linking URL contains some extra information so that the file details.php will know which student we want to view. Make sure the links appear.
 * Create a new file called details.php with the normal HTML structure. Initially, just add the following PHP code inside the body (Note, it includes an intentional error):

Hint 1: We've incorrectly used the $_POST array, even though we haven't actually posted any information from a form using the method="post". Hint 2: Instead we want to GET the information that was sent through the URL.

Once you think it's working, modify the url in your browser to "details.php?id=2" to see if it really is working! Next,
 * Check out the W3Schools explanation of the $_GET array in PHP.
 * Use PHPMyAdmin to see if you can find out the SQL query that will return one specific row of your database table (i.e., you want to select all the fields from your table WHERE the id is equal to 4.) Test that it works in PHPMyAdmin using other values for the ID.
 * Add the code to your details.php to:
 * 1) Connect to the database server,
 * 2) Select your database,
 * 3) Run your SQL query,
 * 4) Display the result of your query (Note: you won't need a while loop this time, as there should only ever be one result! You can use an if statement instead to make sure that your query did return a result)

Test that this works, first by entering the URL in your browser "details.php?id=4", then change the id to display different records.

Now the only remaining problem is that every student listed on our summary page links to the one student details page (the student with the id=4). The last element of this challenge is:
 * Modify the link around each student name so that each link contains the corresponding id for that student.

Challenge 8: Deleting Stuff from a Database
If you've come this far, then your PHP/MySQL skills have come a long way! This challenge provides hints, but doesn't give you the details. You'll need to work hard and use your resources well!

Hints:
 * Update your page that displays all the records, to include an extra column for each record that simply has the text "delete", or if you prefer icons, a little trash-can icon.
 * Add the following link around your trashcan icon:
 * Modify your page so that, when your delete link is clicked, your page displays the text "The record with the id of 4 would have been deleted" (you'll need to put this inside an if-statement so that it only appears when the user has clicked on one of your delete links).
 * Use PHPMyAdmin to find the SQL syntax required to delete an item from your database.
 * Update your if-statement so that your code runs the SQL query to delete the record.

Once you have your delete functionality working, it would be a great time to add a very simple menu to your survey application so that you can navigate between the form and the summary page (where you can delete records or view the details of records).

Lastly:
 * Add a link to the details page (where you view the details of one particular record, from Challenge 7) to delete the current record!

Challenge 9: Putting It All Together
After completing your survey application for the local Parents and Community committee, your application was used by hundreds of schools in your state! Everyone loved it! And lots of people saw your web application skills in action!

Now you've been approached by the department to develop a prototype for a school enrolment application! At the moment the application will just be for one school and will need to:
 * Allow new students to be added, assigning them to a certain year. Required info:
 * first and last name,
 * D.O.B.,
 * Enrollment Date
 * Current School year (e.g. 7-12),
 * home phone,
 * mobile,
 * email,
 * 1st Contact name (usually parent),
 * 1st Contact phone,
 * 2nd Contact name,
 * 2nd Contact phone.
 * View a summary of all the students currently enrolled at the school, sorted by year and then name. The summary should include the students name, school year and email.
 * View the details of a particular student.
 * Delete a student (both from the summary view as well as from the individual view).

After discussing the prototype with your client contact, you also thought of a few improvements that you might add if you have time:
 * Making the email displayed on the summary view a link that can be clicked on. For example:
 * Including a link on the summary view to edit a student record. This will bring a form up that is identical to the new student form, but with all the fields pre-populated from the record in the database.
 * The ability to upload a photo for a student (to help teachers and administrators put names to faces!)
 * A short report that shows from the database how many students are currently enrolled in each year.

This is your chance to get your business off the ground! A contract with the Education department will help pay the bills!

Once you finish your prototype, it will be worth discussing with others how your database design could be improved too.