Server Side Applications and Data Management

Suggested Exercises

Exercise formats:

[task] - set of actions to perform
[paper] - a paper to be written and a printed copy to be turned in in the proper format
[posted] - assignment to be published to the appropriate web site

Assignment Details
Set up XAMPP environment [task] Follow the instructions in the text Appendix A or B to set up your environment: Browser (All programs must work in IE and FireFox Code Editor (NotePad++) XAMPP Configure MySQL NetBeans xDebug Applications and Databases You should be able to use the latest versions of the tools instead of the versions listed in the book. Note: if you have a web server already installed you will have an Apache start error. To fix the problem either: Change the default port for the XAMPP Apache to 8080 (or another default) Remove the conflicting Web server Change the default port for the conflicting Web server
Test Applications [task] Do exercises 1-1 through 1-4 You may skip 1-3 if you are going to use NetBeans
Your Domain Name Get a domain name and server on the Internet. There are a mulititude of inexpensive server services avaialbe. your host is one of them and may be references in the exercises. Substitute your server as needed. Make sure it a working.
Exercises 2-1 and 2-2 [task/Post] Put your working versions of Exercise 2-1 and 2-2 on your host Complete Exercises 2-1 and 2-2 Set so the following urls start: www.yourdomain.com/hw/ch02_ex1 www.yourdomain.com/hw/ch02_ex2 Note: you must copy the index.html files, and one other file type as well The above links are directories!
Ch 3 and 4, your host [task] Do Exercises 3-1 and 4-1 on your local workstation Note that if you try to move this application and data intact to your host it will not work Think: Why doesn’t it work What can you do to get it to work Is there an easy common solution to get it to work on both? If so what is it?
Enhance Guitar Shop App [task] Do exercise 5-1 on your local workstation
Test and Debug [task] Do exercises 6-1 through 6-3. Only do 6-2 and 6-3 if you will be using NetBeans as you develop your code.
Ch 7 Forms [task] Do exercises 7-1 and 7-2. Post one of them to your host.
Ch 8 Control Statements [task] Do exercises 8-1 and 8-2. Post one of them to our host.
Ch 9 Strings and Numbers [task] Do exercises 9-1 and 9-2. Post one of them to your host.
Ch 10 Dates [task] Do exercise 10-1. Post it to your host. Note: the HW will work on your local host but fail if you are using your host. Three options: Fix the code so it works on your host and localhost (lots of work) Document why it doesn't work on your host and what need to be done by your host to fix the problem. Note that your host is aware of the problem and it exists for a reasonable reason. Only a minor deduction if the proper fix is identified. your host has a fix documented. Implement the fix. Full credit.
Ch 11 Arrays [task] Do exercise 11-1. Post it to your host.
Ch 12 Cookies and Sessions [task] Do exercises 12-1 and 12-2. Post one of them to your host.
Ch 13 Functions [task] Do exercise 13-1 Post to your host.
Ch 14 Objects [task] Do exercise 14-1 Post to your host.
Ch 15 Regular Expressions [task] Do exercise 15-1 and 15-2. Post one to your host.
Self exercise. Do exercise 16-1 or 16-2. If you clearly understood the steps in the exercise you're done. If you still have doubts do the other exercise. All the content of Chapter 16 is fair game for the test.
Ch 17 SQL Database [task] Do exercise 17-1 or 17-2. Then modify the files to work on your host and test the scripts there.
Ch 18 SQL Database [task] Do exercise 18-1. Then modify the files to work on your host and test the scripts there. Do 19-1. Skills here will be needed for HW15.
Ch 20 Database driven Web [task] Do exercise 20-1. Then modify the files to work on your host and test there.
Ch 21 Secure Web Sites [task] Do exercises 21-1 and 21-2. 21-1 will give you the skill for 21-2. Get 21-2 to work on your host and post the link.
Ch 22 Email and Web sites [task] This is a bonus exercise to implement 22-1. 10 points to get this to work on your host. Send an eMail to someone with Subject line of "My first computerized email" from the your host account.
Ch 23 Files and Uploads [task] Do exercise 23-1 . Get 23-1 to work on your host.
Ch 24 Files and Uploads [task] Exercise 24-1 . Identify the error on the home page for the first page of My Guitar Shop. Which module is responsible? Note what the fix should be.

Assignment Details

Set up XAMPP environment [task]

Follow the instructions in the text Appendix A or B to set up your environment:

Browser (All programs must work in IE and FireFox
Code Editor (NotePad++)
XAMPP
Configure MySQL
NetBeans
xDebug
Applications and Databases

You should be able to use the latest versions of the tools instead of the versions listed in the book.

Note: if you have a web server already installed you will have an Apache start error. To fix the problem either:

Change the default port for the XAMPP Apache to 8080 (or another default)
Remove the conflicting Web server
Change the default port for the conflicting Web server

Test Applications [task]

Do exercises 1-1 through 1-4

You may skip 1-3 if you are going to use NetBeans

Your Domain Name

Get a domain name and server on the Internet. There are a mulititude of inexpensive server services avaialbe. your host is one of them and may be references in the exercises. Substitute your server as needed.

Make sure it a working.

Exercises 2-1 and 2-2 [task/Post]

Put your working versions of Exercise 2-1 and 2-2 on your host

Complete Exercises 2-1 and 2-2
Set so the following urls start:

Note: you must copy the index.html files, and one other file type as well

The above links are directories!

Ch 3 and 4, your host [task]

Do Exercises 3-1 and 4-1 on your local workstation
Note that if you try to move this application and data intact to your host it will not work
Think:

Why doesn’t it work
What can you do to get it to work
Is there an easy common solution to get it to work on both? If so what is it?

Enhance Guitar Shop App [task]

Do exercise 5-1 on your local workstation

Test and Debug [task]

Do exercises 6-1 through 6-3. Only do 6-2 and 6-3 if you will be using NetBeans as you develop your code.

Ch 7 Forms [task]

Do exercises 7-1 and 7-2. Post one of them to your host.

Ch 8 Control Statements [task]

Do exercises 8-1 and 8-2. Post one of them to our host.

Ch 9 Strings and Numbers [task]

Do exercises 9-1 and 9-2. Post one of them to your host.

Ch 10 Dates [task]

Do exercise 10-1. Post it to your host.

Note: the HW will work on your local host but fail if you are using your host. Three options:

Fix the code so it works on your host and localhost (lots of work)
Document why it doesn't work on your host and what need to be done by your host to fix the problem. Note that your host is aware of the problem and it exists for a reasonable reason. Only a minor deduction if the proper fix is identified.
your host has a fix documented. Implement the fix. Full credit.

Ch 11 Arrays [task]

Do exercise 11-1. Post it to your host.

Ch 12 Cookies and Sessions [task]

Do exercises 12-1 and 12-2. Post one of them to your host.

Ch 13 Functions [task]

Do exercise 13-1 Post to your host.

Ch 14 Objects [task]

Do exercise 14-1 Post to your host.

Ch 15 Regular Expressions [task]

Do exercise 15-1 and 15-2. Post one to your host.

Self exercise. Do exercise 16-1 or 16-2. If you clearly understood the steps in the exercise you're done. If you still have doubts do the other exercise. All the content of Chapter 16 is fair game for the test.

Ch 17 SQL Database [task]

Do exercise 17-1 or 17-2. Then modify the files to work on your host and test the scripts there.

Ch 18 SQL Database [task]

Do exercise 18-1. Then modify the files to work on your host and test the scripts there.

Do 19-1. Skills here will be needed for HW15.

Ch 20 Database driven Web [task]

Do exercise 20-1. Then modify the files to work on your host and test there.

Ch 21 Secure Web Sites [task]

Do exercises 21-1 and 21-2. 21-1 will give you the skill for 21-2. Get 21-2 to work on your host and post the link.

Ch 22 Email and Web sites [task]

This is a bonus exercise to implement 22-1. 10 points to get this to work on your host. Send an eMail to someone with Subject line of "My first computerized email" from the your host account.

Ch 23 Files and Uploads [task]

Do exercise 23-1 . Get 23-1 to work on your host.

Ch 24 Files and Uploads [task]

Exercise 24-1 . Identify the error on the home page for the first page of My Guitar Shop. Which module is responsible? Note what the fix should be.

Last updated