Handling database errors gracefully--and securely - PHP Tutorial

Contents

• Introduction Introduction

  • Welcome

    1m 30s
  • What you should know before watching this course

    3m 51s
  • Using the exercise files

    5m 13s
  • Configuring MAMP to show errors (Mac)

    3m 36s
• 1. Introduction to PHP 1. Introduction to PHP

  • How PHP makes web pages dynamic

    5m 23s
  • How to use PHP in a web page

    6m 43s
  • Using variables to store information

    2m 52s
  • Storing numbers and text in variables

    5m 18s
  • Displaying the values of number and text variables

    8m 9s
  • Using functions to manipulate values

    4m 36s
  • Adding comments to PHP scripts

    4m 46s
• 2. Using Server-Side Includes for Common Page Elements 2. Using Server-Side Includes for Common Page Elements

  • What are server-side includes?

    4m 4s
  • Deciding which include command to use

    5m 40s
  • Challenge: Moving common elements to include files

    1m 54s
  • Solution: Moving common elements to include files

    7m 4s
  • Making sure internal links still work in an include file

    6m 1s
• 3. Using Conditions to Change Page Output 3. Using Conditions to Change Page Output

  • How PHP makes decisions

    3m 30s
  • Changing output depending on the current time

    9m 1s
  • Adjusting the server's time zone

    8m 57s
  • Displaying an up-to-date copyright notice

    6m 18s
  • Challenge: Displaying an image of the month

    2m 15s
  • Solution: Displaying an image of the month

    5m 12s
  • Understanding what PHP treats as true and false

    2m 57s
• 4. Working with Multiple Values in Arrays and Loops 4. Working with Multiple Values in Arrays and Loops

  • Storing multiple values in a variable as an array

    4m 28s
  • Inspecting an array's elements

    4m 13s
  • Challenge: Inserting the appropriate alt text

    1m 27s
  • Solution: Inserting the appropriate alt text

    5m 26s
  • Displaying an array as a comma-separated list

    3m 13s
  • Looping through an array's values

    7m 17s
  • Labeling array elements

    7m 21s
  • Looping through an array's labels and values

    5m 29s
  • Finding if a value exists in an array

    3m 51s
  • Challenge: Displaying a seasonal feature

    3m 6s
  • Solution: Displaying a seasonal feature

    8m 30s
• 5. Getting User Input from a Form 5. Getting User Input from a Form

  • Getting form input sent by the POST method

    4m 48s
  • Retrieving values from a URL's query string

    4m 8s
  • Challenge: Plan the order form

    2m 28s
  • Solution: Plan the order form

    4m 42s
  • Finding and extracting a substring

    7m 38s
  • Organizing the form data into arrays

    7m 15s
  • Using a loop to build a table for the data

    4m 42s
  • Controlling which rows are displayed

    7m 45s
  • Creating a custom function to extract part of a file name

    7m 43s
  • Calculating the order total

    6m 34s
  • Using PHP sessions to preserve data

    3m 14s
  • Storing data in session variables

    7m 33s
  • Ending the PHP session and deleting the data

    5m 37s
• 6. Displaying Content from a Database 6. Displaying Content from a Database

  • Loading data into MySQL

    5m 37s
  • Connecting to the database

    7m 47s
  • Querying the database

    6m 15s
  • Displaying the results of the query

    3m 50s
  • Using modulo division to establish a repeating series

    4m 20s
  • Repeating output at specific intervals in a loop

    4m 56s
  • Linking to a details page

    2m 40s
  • Embedding a variable in a query securely

    6m 5s
  • Handling database errors gracefully--and securely

    8m 40s
• 7. Handling Errors 7. Handling Errors

  • Dealing with PHP errors

    4m 15s
  • Why is my page blank or incomplete?

    3m 53s
  • Tracking down parse errors

    4m 32s
  • What to do with "failed to open stream"

    3m 22s
  • What does "headers already sent" mean?

    6m 18s
  • What does undefined index, variable, or constant mean?

    5m 52s
  • What on earth is T_ENCAPSED_AND_WHITESPACE?

    1m 59s
• Conclusion Conclusion

  • What's next?

    2m 26s