View the step-by-step solution to:

Use any web server with MySQL and PHP support (free hosted or anything else available) to create a small MySQL database (database/table definition...

This question was answered on Mar 17, 2010. View the Answer
Use any web server with MySQL and PHP support (free hosted or anything else available) to create a small MySQL database (database/table definition provided below). Also create a web interface to manipulate this database. In particular the web interface should enable users to insert, select, update and delete database/table records. Users should be able to select table data using MySQL’s where clause and order by keyword. They should also be able to update table records using the where clause.
You can name your database whatever you like. Create only one table named persons in your database for this assignment. The persons table should contain the fields (columns) exactly as follows:
personID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(personID), FirstName varchar(15), LastName varchar(15), Age int, City varchar(15)
Note that this table definition is almost the same as the one at on the web page at http://www.w3schools.com/php/php_mysql_create.asp
In fact, much of the PHP/MySQL code for Assignment #5 can be copied (and edited) from the website http://www.w3schools.com/php/php_mysql_intro.asp
Some of your HTML for this assignment will look like the HTML for inserting a record at http://www.w3schools.com/php/php_mysql_insert.asp
If a user types in the appropriate URL to view your Assignment 5 web interface, your web page should
1. Display a very nicely formatted web page that describes what the web interface does, and then
2. Display the entire current contents of the persons table (the contents will change), and then
3. Display radio buttons/dropdown lists, text fields or other input areas that prompt the user to enter database requests (e.g., insert, select, update, delete) together with the appropriate additional input associated with the request (e.g., a new age to update).
Following a Submit button click, your code should invoke a PHP program (action) that completes the request of the user. In particular, your web page should
4. Display the result (including the entire contents of the persons table) after the user’s request has been completed (or displays an error). Use a second web page to display the results if you prefer. Then your web page should
5. Display the option to Quit or Enter Another Request.
6. If the user wants to enter another request, then cycle back to #1 above.
7. If the user chooses Quit, delete the entire persons table.
Populate the persons table with the following information at start up, before any requests are made:
FirstName
LastName
Age
City
Ravi
Shankar
90
Mumbai
Paul
McCartney
67
Liverpool
Yao
Ming
30
Houston
Nelson
Mandela
91
Johannesburg
- - - -
AJAX usage okay. Some students have asked if they can use AJAX on this assignment. Please feel free to use AJAX (Asynchronous JavaScript and XML) if you prefer, but it is not required that you do so. You can earn the full 20 points on this assignment without AJAX. Reference for AJAX: http://w3schools.com/php/php_ajax_intro.asp
Put your initial HTML code with the questions, form and input areas in a file named mike- mahoney_assignment-5.php (but use your own name).

Top Answer

We need you to clarify your question for our tutors! Clarification request: Dear Student,... View the full answer

This question was asked on Mar 17, 2010 and answered on Mar 17, 2010.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards