Video Demos for Lecture 12
Flash files (with video index) that can be viewed in Browser:
- How to download PHP step-by-step files for Weeks 11 and 12 by selecting .txt file and then saving it as a .php to the local computer (2:55)
- Step 5: Discuss form with radio buttons and JavaScript validation functions and how to extend to be able to collect feedback for 10 tools (1:48)
- Step 6: Discuss PHP code to display $_POST and the displayPostArray function (2:46)
- Step 7: Create "tools" table in MySQL database using MySQL Workbench; discuss how to extend CREATE TABLE query (7:48)
- Step 8: Discuss PHP code needed to connect to MySQL database; Use isset function to make sure values in $_POST are defined; Cleanse data using mysql_fix_string function; Create SQL query to insert form data in "tools" table in MySQL database; Use MySQL Workbench to check that data got inserted into "tools" table (5:54)
- Step 9: Discuss PHP code needed to display contents of "tools" MySQL table (1:20)
- Step 10: Discuss how to incorporate CSS & XHTML in PHP code; Show how to compute up-to-date average score for each tool by using SQL query that returns sum of scores for each tool; Show how to comment out code; Test PHP page on server (5:35)