Directions
The BaseballStats Version 4 Assignment adds UPDATE functionality to the Baseball Stats Interface created in Module 8 Assignment 3.
- Download the
BaseballStats Version 4 (BaseballStatsV4.pdf)
Download BaseballStats Version 4 (BaseballStatsV4.pdf)
file for instructions on completing creating an web based interface to update the baseball_stats database.
- The most helpful resources to review for completing this assignment (besides the files from Assignment 3) are the header.html, footer.html, index.php, mysqli_connect.php, view.php, and password.php files from Ch 09.
Submit the a9header.html, footer.html, a9index.php, a9mysqli_connect.php, a9view.php, and a9update.php files and any supporting .css files when you are finished.
Baseball Stats V4 In this assignment, we provide more functionality to the HTML interface used by the administrator of the baseball_stats database. In Week 15, we gave the adminstrator the right to view the champs table within the baseball_stats database via a file called a9view.php. In Week 16, we will give the administrator the right to update the champs table within the baseball_stats database via a file called a9update.php. It is assumed that later we will also provide an interface to view and update the teamstats table. In order to update the baseball_stats database, you also need to connect from the PHP script to the MySQL database which is accomplished by the a9mysqli_connect.php file. The administrator will use the home page a9index.php file to navigate between the View Champs (created in Week 15) and Update Champs Table (created in Week 16) pages. Link to the same css files used in the Ch 09 assignments covered in the textbook. This assignment counts for 30 points. The a9index.php, a9mysqli_connect.php, a9view.php, and a9update.php files must be free of errors that are throwing error messages with line numbers when viewed in the web server. It is assumed that your a9index.php, a9mysqli_connect.php, a9view.php files from Week 15 are error free prior to starting Week 16. If you submit the a9update.php file with errors causing error messages and line numbers to appear and no output to be displayed, you will lose 15 points off of this assignment. I will debug and correct the first 5 errors for you when giving feedback, but I will not debug beyond your first 5 errors. To review, after Week 15, the baseball_stats database has the following records in the teamstats table In addition, the baseball_stats database has the following records in the champs table. In addition, the a9header.html, a9index.php, and a9view.php files were created as required in Week 15 that show the following interface: 1. Create the a9update.php file based on the password.php file used in Ch09. . Save the a9update.php file in the following path on your webserver: htdocs/Ch09/. Requirements are as follows: (30 Points) a. Your a9update.php file should have a page title that reads Update thePennants and World Series. (2 points) b. Include the a9header.html file. (2 points) c. Check for for submission. (2 points) d. Require the a9mysqli_connect.php file. (2 points) e. If the Team Id is not entered on the HTML form, ensure that a message You forgot to enter the Team ID. Is displayed to the user. (2 points) f. If the Team is not entered on the HTML form, ensure that a message You forgot to enter the Team is displayed to the user. (2 points) g. If the number of Pennants Won is not entered on the HTML form, ensure that a message You forgot to enter the Pennants to be updated is displayed to the user. (2 points) h. If the number of World Series Won is not entered on the HTML form, ensure that a message You forgot to enter the World Series to be updated is updated to the user. (2 points) i. Check to see if the errors array is empty. (2 points) j. If so, check to see if a valid Team Id and Team has been entered and proceed with the necessary code to update the champs table with the Pennants and World Series. Display a message to the user that The Pennants and World Series have been updated!. (2 points) k. If the query did not run OK, display a message to the user that says System Error The Pennants and World Series could not be changed due to a system error. We apologize for any inconvenience. Provide a debugging message to the programmer displaying the query that went wrong. (2 points) l. If the valid Team ID and Team combination was not entered correctly, be sure to display a message: The team id and team name combination does not match any on file. Please view the teams again to see the correct team id and team names to use. (2 points) m. Close the database connection. (2 points) n. Include the footer.html file. (2 points) o. Test the operation of the a9update.php file by updating the following records: (2 points) New York Yankees who have won 40 Pennants and 27 World Series. San Francisco Giants who have won 22 Pennants and 7 World Series. St. Louis Cardinals who have won 22 Pennants and 11 World Series. Then click on View Champs to run the a9view.php file to view the newly updated Champs table. The results appear as follows: Submit the a9header.html, footer.html, a9index.php, a9mysqli_connect.php, a9view.php, and a9update.php files and any supporting .css files to Blackboard in the Week 16 Baseball Stats Version 4 link. Helpful Hints: 1. The most helpful resources to review for completing this assignment (besides baseball_stats database from Week 14) are the header.html, footer.html, index.php, mysqli_connect.php, view.php, and password.php files from Ch 09. 2. Remember that parse errors are usually the result of mismatched (), [], {}, “”, or ‘’. They should normally be paired up. I use the Find feature in my text editor to count all of the ( entered and then count all the ) entered. Unless you had need for an escape sequence, the counts should be the same. I repeat for the other brackets and double and single quotation marks. 3. Don’t try to code the whole program at once. Break it into smaller programs in a logical manner.