Video Demos for Lecture 11
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)
- login_yourname.php: how to specify MySQL username & password in PHP file; Upload to server and set permissions; Test in Browser and View Source to notice that the PHP code is not visible (4:36)
- Customize Filezilla: so that you are directly into the folder with your username in the YourCourseFolder on the studentweb server (2:16)
- Step 1: require_once; Interpret error message; mysql_connect; mysql_select_db (4:46)
- Step 2: formulate SQL query, send to MySQL database and receive result table; Introduce intentional spelling mistake to practice how to troubleshoot; Test file in Browser (3:14)
- Step 3: use FOR loop to display result table; Use MySQL Workbench to make sure correct field names are used (3:28)
- Step 4: use mysql_fetch_row to make code more efficient; Use MySQL Workbench to determine the correct numercial index for specific fields in result table (4:16)