I'm offering 500fg to whoever can help me do this assignment that involves PHP/SQL....I really don't know how to do PHP at all since I have never even seen it before... need a .php file and a .sql file for this! I can do the SQL part since I have learned that but I need help with the PHP! Here is the assignment (sorry for length):
World Database:
Use “\d <tablename>” or “\d <tablename>” to see column information for a table.
Primary keys are underlined. Foreign keys are in italics.
City: (ID, Name, CountryCode, District, Population)
Country: (Code, Name, Continent, Region, SurfaceArea, IndepYear, Population, GNP, GNPOld,
LifeExpectancy, LocalName, GovernmentForm, HeadOfState, Capital, Code2)
CountryLanguage: (CountryCode, Language, IsOfficial, Percentage)
Loading a Database from a Dump File
For this assignment we will be using the same database dump file that we used for lab 1. If you’ve lost your
copy, you may retrieve a new one with the following command:
wget
http://babbage.cs.missouri.edu/~cdh7x9/cs3380ta/world.sqlThe world.sql file should be in your current directory now.
Assignment
Create the directory ~/public_html/lab5 and then copy your PHP file(s) to ~/public_html/lab5/
You should extend your Lab 3 assignment file by implementing the following features:
1) Users should be able to delete a city, country, or language. This should be integrated with the search
feature – i.e., search results should display a delete button or a check box next to each row.
2) Users should be able to update a city, country, or language. Specifically, the City.Name,
Country.Name, and CountryLanguage.isOfficial fields should be updatable. This does not need to be
integrated with the search results.
3) Users should be able to insert a Country. At the very least, users must be required to specify the
country’s name, country code, population, continent, region, surfacearea, local name, government
form, and code2. (These are all of the NOT NULL fields of the table.) If the user fails to specify a
value for one of those fields, the insertion should fail and an error message should be returned. This
does not need to be integrated with the search results.
An example of this functionality can be found at
http://babbage.cs.missouri.edu/~cdh7x9/cs3380ta/f12/lab5/. You do not need to style your website to look the same as the example, though you are free to use any of the
HTML or CSS you find there in your own lab. It must be possible to navigate between all of these functions.
If I am on the Insert page, I should be able to click a link and return to the Search page, and vice versa.
You must do three things to submit this assignment:
1. You must host your file in your public_html directory at the following address:
http://babbage.cs.missouri.edu/~pawprint/cs3380/lab5/index.php2. You must upload your lab5/index.php file to Blackboard by the due date.
3. In your Blackboard submission, you must send a link to your web page.
Do not stop hosting the file on your Babbage account until you receive a grade for the assignment! This
includes dropping the tables in your database. We need your lab to be hosted so that we can grade it.
If you wish to break the assignment up into separate files for each type of functionality, that’s acceptable as
well. However, you still need to have a page called index.php so that we can find it to grade your assignment.
If you split the assignment into multiple files, you must submit all files in either a tarball or a .zip file.