Reference no: EM13187249
For this project you will use HTML, forms, PHP, and MySQL to collect data from users, store that data in a MySQL database table, retrieve and display the data from the table, make changes to the data in the table, and delete records from the table. The subject or "theme" of your web site and table will be up to you - a web site with a coherent theme where you collect data from users. I expect the web pages to include some formatting - the details are included below.
Project Outline
Your project will include files and scripts to do the following:
Create Table: Write a PHP script to create a table in your database server to hold your user data.
Data Input:
•Create a nicely formatted (based on formatting topics we've covered so far) web page with a form to collect user data. Include at least one image on the page, a different background color, and a table to structure form elements. The form should use the POST method to send data to a PHP script. You should collect at least 5 pieces of data from the user.
•Write the PHP script called in the previous step to add the data to the data table.
Data Retrieval and Display :
•Modify the Data Input page from above to include only one text box in the form - to input the id of a record the user would like to retrieve. On submit, the form should call a PHP script to retrieve and display the record.
•Write the PHP script called in the previous step to display the data for that record. Format the data nicely.
Data Edit :
•Create a page and scripts to modify a data record. Use the web page from the Data Retrieval and Display section to first retrieve and display the data. Then include a form with a Submit button (label it Update) that calls a PHP script to update the record from the table.
Data Delete:
•Create a page and scripts to delete a data record. Use the web page from the Data Retrieval and Display section to first retrieve and display the data. Then include a form with a Submit button (label it Delete) that calls a PHP script to delete the record from the table.
Bonus:
• Write a PHP script to retrieve and output ALL the data from the database. See Slide 7 of the PHP - Databases PowerPoint as reference. Format the data as nicely as possible.
|
Our domestic civil rights shortcomings
: Why does it consider "our domestic civil rights shortcomings" a threat to the triumph of democratic ideals in the Cold War?
|
|
What is the period of oscillations
: Its center of mass is located at a distance of s=0.120 m from the center of the circle. If the disk is allowed to oscillate side to side as a pendulum, what is the period of oscillations?
|
|
Identify the specific elements of the law of negligence
: Identify the specific elements of the law of negligence that Patty must prove to recover any actual damages from Donald. Explain why those elements are critical to this situation.
|
|
How would a downward change in the money supply affect
: How would a downward change in the money supply affect you personally How would it affect your career What impact would rational expectations have on your decisions in this situation
|
|
Create a table in your database server
: Write a PHP script to create a table in your database server to hold your user data - Create a nicely formatted (based on formatting topics we've covered so far) web page with a form to collect user data
|
|
Why did the leading scholars of the sixteenth century
: Why did the leading scholars of the sixteenth century make the ideas of Zhu Xi the unshakable center of Confucian thought?
|
|
What is the dimensions of the garden
: a farmer purchases 730 feet of fencing to enclose a rectangular garden. If the length of the garden is 5 feet more than 3 times the width. what is the dimensions of the garden?
|
|
What is the scale of the drawing
: Blaise drew a scale drawing of a swimming pool. In real life, the pool is 12 meters wide. It is 15 millimeters wide in the drawing. What is the scale of the drawing?
|
|
What the equilibrium could be if the interest rate increased
: Consider the inter-temporal model of consumption of a household who has a first period income of 300 and a second year income of 330. The interest rate is 10%. The household saves 100 in period one. a) Write the budget constraint of period one and..
|