Assignment Instructions

Data Analysis.





OBJECTIVE Use PHP and MySQL to create a database table administration interface. A sample of this
assignment is available at:
REQUIREMENTS You may complete this assignment with a partner or on your own.
You will write a web application that allows a user to administer the students table on the bcit
database. The user will need to be able to view the current state of the table, as well as add,
delete or edit a record.
Write a PHP page that displays the entire students table as an HTML table, one record per row.
Include an “Add Student” link somewhere near the table. Include two additional data cells per
row, one containing a “Delete” and the other a “Update” link. The screenshot below shows an
example of how it might look:
The Update and Delete links should send record-specific information via a
$_GET query string to the script(s) responsible for updating and deleting from
the database (see the shared FTP server for an example of using the query
MORE on next page…
Page | 2 jethro
Functional Features
Write script(s) for handling each operation:
– Add Student: Display a form with inputs for Student Number, First and Last
names, and a Submit button.
– Delete: Display the record information of the record they chose to delete.
Give them one last chance to change their mind, eg: ask the user if they are
sure they want to delete the record, and display a form with a radio button
option of ‘yes’ and ‘no’.
– Update: Display a form with fields for Student Number, First and Last names.
Pre-populate these fields with the current record data. Add a Submit button.
Regardless of the database operation performed, after executing the SQL
query, be sure to forward the user back to the page that displays all table data,
so that they can see the latest table status.
Usability Features
Provide feedback to the user as they interact with your scripts. Display positive
feedback, such as: “A new record has been added to the table” and also error
messages, eg: “The record could not be updated as requested.”
Security Features
Thoroughly validate all form data. Protect against SQL injection attacks.
HINTS – Build your scripts slowly and test thoroughly as you go. Try to break the
problem down into smaller parts, and solve each part before proceeding to
the next. For example, first deal with displaying the student records in a table,
after completing that functionality, deal with one of the operations, eg: ‘Add a
student’ and complete that before dealing with the ‘Delete’ or ‘Update’
– A $_GET query string is the only way to identify which link in a series of links
may have been clicked to make the most recent request. It requires adding the
query string to the href, eg:
link one
link two
Page | 3 jethro
– Use sessions wherever possible to remember important data across multiple
SUBMISSION Before the end of day Dec 20, compress file(s) into a .zip or .rar file named
using your last and first name. Upload the compressed file to the FTP Dropbox.
If completed with a partner, include both names in the file, eg:

The post Data Analysis first appeared on Bestchoice Writers.

Data Analysis

Calculate Price

Price (USD)

Why Choose Us For Your Assignment?


We value all our customers' privacy. For that reason, all information stays private and confidential and will never be shared with third parties.


With our service you will never miss a deadline. We use strict follow-ups with our writers to ensure that all papers are submitted on time.


We have no tolerance for plagiarism. All papers go through thorough checking to ensure that no assignments contain plagiarism.

Money Back

You feel unsatisfied with your results? No worries. We offer refunds to our customers if any paper is not written according to the instructions.

Clients Love Us

Client #121678
Client #121678
Read More
This is by far the best I have ever scored in a custom essay. I am surprised the writer handled this assignment so well despite the short notice. I will definitely use your service next time.
Client #21702
Client #21702
Read More
When I was recommended to you by my friends, I wasn't sure you could deliver excellent results for Masters research papers until I submitted my first order. I am all yours now.
Client #20730
Client #20730
Read More
Excellent Services! You are the only assignment helper I can rely on. I have worked with many before and your services are exceptional. I have recommended you to my friends and the results are similar.
Client #20387
Client #20387
Read More
I rarely write reviews online but your services are worth promoting. My paper was so urgent I was sure I was gonna miss the deadline but you turned things around. You are awesome!
Client #20189
Client #20189
Read More
I am a satisfied customer. I know I should have given a 5 star because you deserve it but I will give 4.6 because I almost missed a deadline because of a revision. Luckily it was minor and the writer acted promptly.
Client #20187
Client #20187
Read More
Great paper but there is still some room for improvement. I am impressed by your fast responses and how you tacked my concerns professionally. Thank you for being among the few genuine essay writing service providers.
Client #19783
Client #19783
Read More
I can't thank you enough for being a great part of my college life. I recommended you to two more of my friends. I am sure they will be making their orders soon. I love the fact that you offer free pages for referrals. I will be referring a few more and maybe I won't have to pay for my next two paper, LOL.