View the step-by-step solution to:

CS 3520 Assignment #5 - MySQL/PHP [20 pts: 10% of course grade] Due Wednesday March 17, 2010 at noon. Make sure you send me the URL, account and...

how can i built this MySQL files?
CS 3520 Assignment #5 – MySQL/PHP [20 pts: 10% of course grade] Due Wednesday March 17, 2010 at noon . I prefer that you create a web account for me to grade your assignment. Make sure you send me the URL, account and password of that web (free hosted) account in the comments section of dropbox. 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 . (continued)
Background image of page 1
-2- 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). If I will run your assignment using my own web server, assume it is called mahoney-web-server.org (the actual name will be something else). I will copy your files to my web server which supports PHP/MySQL. Then I will run your program with the following URL: http://mahoney-web-server.org/mike-mahoney_assignment-5.php (again, use your own name for this startup .php file). If you are not sure that I will be able to run your program on my web server, please feel free to send me the (free hosted) web server URL that you are using together with your account and password on that web server. Indeed, since it is free, you can create a new account especially for me to grade your assignment (make sure your files are uploaded to that site). It is recommended that you do this to ensure that everything works together the way it should. In any case, submit your code files via the assignment drop link (dropbox) in Blackboard. Due Wednesday March 17 at noon via the assignment drop option (orange text link). Upload your files even if you provide me with a URL/account/password (which should be in the comments area). Your PHP/MySQL code should emphasize clarity of structure and ease of comprehension, as if you were writing for another person rather than for a computer. Your web page formatting and user interface should be attractive and easy-to-use (especially the interface to the web page part). [end]
Background image of page 2

Top Answer

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

Sign up to view the full answer

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.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    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
Ask a homework question - tutors are online