For this project you will use html forms php and mysql to

Assignment Help PHP Web Programming

Reference no: EM13379990

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.

Reference no: EM13379990

Questions Cloud

Questiona military information system on a base overseas : questiona military information system on a base overseas tracks personnel on the base.nbsp each military member is

Which is not a factor to consider in software evaluationa : which is not a factor to consider in software evaluation?a. performance effectivenessb. performance efficiencyc.

In online marketing a shopping cart is a piece of : in online marketing a shopping cart is a piece of e-commerce software on a web server that allows visitors to an

Questionsince its establishment in 2003 fresh grocers has : questionsince its establishment in 2003 fresh grocers has expanded its business from a single store in queensland to

For this project you will use html forms php and mysql to : for this project you will use html forms php and mysql to collect data from users store that data in a mysql database

1 meets size criteria -2 incorporates a consistent look and : 1. meets size criteria -2. incorporates a consistent look and feel and an easy-to-use and consistent navigation toolset

Green river clothing company case study channel structure : green river clothing company case study channel structure and members.read the case study green river clothing company

Timothy is a 35 percent partner in the total partnership a : timothy is a 35 percent partner in the total partnership a calendar-year-end entity. timothy has an outside basis in

1 sales for the past 12 months at the young company are : 1. sales for the past 12 months at the young company are given here.monthsales

User Account

All Pages