Data Analysis
TWD :: PHP PROJECT 01
OBJECTIVE Use PHP and MySQL to create a database table administration interface. A sample of this
assignment is available at:
https://bcitcomp.ca/twd/php_project/
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
string).
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’
features.
- 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:
<a href=’page.php?link=one’>link one</a>
<a href=’page.php?link=two’>link two</a>
Page | 3 jethro
- Use sessions wherever possible to remember important data across multiple
pages.
SUBMISSION Before the end of day Dec 20, compress file(s) into a .zip or .rar file named
php_project_lastname_firstname.zip
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:
php_project_lastname01_firstname01_lastname02_firstname02.zip
Whittlesey 2012 sets up an exhaustive continuum for any exchange of any substance starting with one medium then onto the next, principally, however not only, including language to language, language to different mediums, e.g., pictures (films, kid's shows, and so forth.) or from different mediums to different mediums, with interpretation, comprehended as in exactly the same words replication in the thin sense, at the one end, transposition including different degrees of free rendering of the source, and adjustment saw as the uttermost expelled from the source. He calls attention to that genuine interpretation in the thin sense he proposes is somewhat confined then again, with numerous guidelines: exclusions of words, expressions, and sentences, not to mention entire segments, is disliked, as are augmentations, or bends of the source or its purpose. Interpretations must summon a similar picture as the source messages and pass on their content.9 The exactness of an interpretation must be obvious, which is considerably less simple for transposition or adaptation.10
Whittlesey likewise refers to such models as condensed variants of the works of art, making old messages increasingly available absolutely by modernizing the language; decorating, enhancing or really
J. Pierrepont Finch, a youthful window washer in New York City with enormous aspirations, peruses the book How to Succeed in Business Without Really Trying. The "Book Voice" reveals to him that he will be fruitful in the business world in the event that he follows the book's recommendation. Energized, Finch enters the World Wide Wicket Company looking for an occupation ("How To Succeed").
Finch catchs J.B. Biggley, the leader of the organization, who sends him to the work force supervisor, Mr. Bratt. Rosemary Pilkington, an entirely, youthful secretary working at the organization, is dazzled purchase Finch's intensity and causes him meet Mr. Bratt. Bratt is initially curt to Finch, thus Finch discloses to him that Biggley sent him and that they were companions.