PHP Homework

( Menu )

( Parts Edit ) ( Parts Form HTML File )

( Parts Delete ) ( Parts View )

( Parts Edit Entry )

( Parts Delete Entry ) ( Parts Save Record )

( Parts Edit Save )

( Parts Include ) ( Parts Reset )

Part I - Create an HTML form to add records to a table you will soon create for this lab. I used CoolText.com to create my banner. Create your own image that you will use in the various modules for this lab. My form passes the fields to a scripted named part_save_rec.php – which we will write later.

HTML Color Names: Visit http://www.w3schools.com/html/html_colornames.asp to see your choices for HTML colors.

Form document:

Part II - Create an Include file for a common Function: Review page 109 of the textbook. The purpose of an include file is to make your code more concise, and to eliminate the need to modify your script in more than one place. In this lab, we will need to connect to the MySQL database many times. Therefore, we will create an Include file with a function called “doDB()” that we can call anytime we need to connect to our database. First, this makes your program more concise and second, if you change your password, you only need to change one line of code, rather than many. Study my example code below. I named the following script parts_include.php. However, it is common to name an include file inc_something.php. Notice that I declared $db_connect as a global variable so it can be seen outside the function doDB(). You can create an include file for another purpose (or not), but I created this one to connect to the MySQL database – something I must do many times in this project.

Part III - Create a Reset Table Module: Now that you know what your fields are, we need to create a table in your MySQL database to store this data. I would like you to add two more fields: date_added and date_modified so we can monitor dates. You can fill them with the function now(). I also added the command mysql_query("DROP TABLE auto_parts"); so we can use this module to delete an old table and start fresh with a new one. I did not link it to my Menu because I did not want to delete it by mistake – do as you please.

Part IV - Create a Document to save the data in the From: Now that you have a form to gather information and a table to store this data, it is time to write the document to save your field information. I named my file: parts_save_rec.php. I added a confirmation line and links back to add more parts or return to the menu (that we have not written yet).

Part V - View the Table Data: After you add a few records, write a document to view these records. This is what my parts_view_all.php file produces.

Remember, whenever you use an HTML command line in php, start with echo, place the line in quotes, and end with a semicolon. If there are multiple commands on the same line, separate them with a comma. (Quiz question) Example line:

echo "<center>","<table border=10 cellspacing=5 cellpadding=5 bgcolor=tan>";

If there are quotes in the HTML code, add a backslash before each of them. Example:

"<td colspan=7><center><img src=\"parts_banner.png\" width=\"600\" height=\"152\"></center></td>";

I never used parts_view_all.php in my program. Instead, I created it as a rough draft, and then used a modified version of it named: parts_view.php.

This completes lab #9. Submit a Word document with a link to your viewing site (Part V). Be sure to include a graphic banner and a least one time field using the PHP now() function.

Code for displaying Parts:

Part VII: Create a Menu: Because this program has many modules, a menu will provide a way to link to them. Feel free to be more creative. If you’d like, use buttons or graphics for your links.

· Create a link to your HTML form to add more records.

· Add a link to edit a record.

· Add a link to a delete a record.

· Using SQL commands, plan to view the data in a variety of different sorted orders.

· Also provide a menu choice to filter the data in a variety of ways as well.

HTML for Menu:

Part VIII - View Data in Sorted or Filtered Order:

To view your data by part number, use the ORDER BY command:

To view only selected data, filter your records with the WHERE command

Notice I added totals at the end of the table. To display the number of records queried, include a line like this one:

To accumulate the total part quantity, I declared a variable at the beginning of the program:

Then, I coded the following line in my while loop:

To show totals, I added the following lines after the table.

Start with the script you wrote in Part V and add a case/switch statement to the top.

Part IX – Delete a Record: To delete records I wrote a two-part script. The first part allows the user to choose the record they wish to delete from a drop down menu, and the second part deletes it. Write a two-part or all-in-one form to accomplish this task.

I programmed a drop-down list of Record ID numbers to select from. Once an ID is selected, clicking the Delete button (submit) will take the user to a second script to delete the record with this ID.

Script to allow user to select the record to Delete:

Once the user selects a record to delete, the submit button links to the script that will delete the record from your table.

Part X: Delete the selected record: Write a script that will delete the selected record. This is the command block that focused on the record for deletion:

This is the command block to delete the record:

This is the command block to send a message to the user:

This is the messages posted when the record was deleted. Links back to delete more records or return to the menu were included:

PHP to delete the selected entry:

Part XI - Edit a Record: I created 3 different modules for this routine:

1. Choose a record to edit. Start with the script you wrote to choose a record to delete.

2. Create a form to edit the selected record. Start with the form you wrote to add a record.

3. Save the changes. Start with the script you wrote to delete the selected record.

You may want to use an all-in-one module.

The “choose a record to edit” script is exactly the same as the one used to “choose a record to delete” (the exact same thing only different?). Just change the form action file and the word Delete to Edit .

The second module is a sticky form where the program displays the form information and the user is able to edit the record:

Lab Assignment #9 Point Distribution: (25 points total)

1. Part I- 4 point

2. Part II and III- 5 points

3. Part IV - 5 points

4. Part V- 5 points

5. Part VI - 5 points

6. You recorded and submitted a message for me providing feedback - 1 points

Lab Assignment #10 Point Distribution: (25 points total)

1. Part VII- 4 point

2. Part VIII - 5 points

3. Part IX- 5 points

4. Part X- 5 points

5. Part XI - 5 points

6. You recorded and submitted a message for me providing feedback - 1 points

View the PHP script on the next page.

The last thing to do is save the changes you made in the edit routine. I used the following command block to save the changes to the record:

PHP Script:

Wow, we made it! When you completed this lab, submit a Word document in the drop box for Lab 10 with a link to your menu.

1 | Page