Introduction
  • Introduction: How to Get the Most Out of the Course
Software Installation and Setup
  • Recommended Software Overview
  • Install XAMPP on Windows
  • Install XAMPP on MAC OS X
  • Install XAMPP on Ubuntu Linux
  • Install Atom on Windows
  • Install Atom on MAC OS X
  • Install Atom on Ubuntu Linux
Variables
  • Write Your First PHP Code: Display a Message in Your Web Browser
  • Variables in PHP: What They are, How to Create Them, and How to Name Them
  • Basic Variable Types: Strings and Numbers
  • Basic Variable Types: Boolean and Null
  • Perform Operations on Variables: Operators
  • Strings: Using Single or Double Quotes and Variable Interpolation
  • PHP concepts, variables and operators
  • Variables and Operators
Arrays
  • Introduction to Arrays: Create an Array and Access its Elements
  • Assign Manual Array Indexes and Create Associative Arrays
  • Create and Access Multidimensional Arrays
  • Process Each Element of an Array: foreach Loops
  • Process the value and index of each array element using a foreach loop
  • Arrays
  • Arrays
Control structures
  • Run Code Conditionally: the if Construct
  • Compare One Value to another: Comparison Operators
  • Run Code Multiple Times Based on a Condition: While Loops
  • Run Code a Specific Number Of Times: For Loops
  • Add More Conditions to an If Statement Using Elseif
  • Perform Different Actions Based on Different Conditions: The Switch Statement
  • Control structures and comparison operators
  • Control structures and comparison operators
An Introduction to HTML
  • The Language of Web Pages: an Introduction To Html
  • Use Head and Body Elements to Structure An Html Document
  • Structure the Content of your Page Using Heading and Paragraph Elements
  • Give Text Emphasis or Importance Using the em and Strong Elements
  • Display Ordered and Unordered Lists of Items
  • Insert Images Into an Html Document
  • Add a Link from One Page to Another Using a Hyperlink
  • Add Semantic Structure to The Body of an Html Document
  • HTML
  • HTML basics
Mixing PHP and HTML
  • Create Dynamic Content: Mixing HTML and PHP
  • Use PHP Control Structures Mixed with HTML
  • Make HTML More Readable: Use Whitespace and Comments
  • Addendum: changes to the available resources in the following video
  • Make PHP Easier To Maintain: Use Comments and Coding Standards
  • Mixing PHP and HTML
  • Mixing PHP and HTML
An Introduction to Databases
  • Where to Store Data in a Dynamic Website: An Introduction to Databases
  • Access the Database Server Using phpMyAdmin And Create a Database
  • Use Tables to Store Structured Data in a Database
  • Select Some Data from The Database: An Introduction to Sql
  • Using Indexes: Make Queries Faster and Order the Result Set
  • Connect to the Database from PHP
  • Query the Database from PHP And Get the Results
  • Combine PHP and HTML to Show a Formatted List of Articles
  • Databases
  • Databases - connecting and selecting data
Multiple Pages in PHP
  • Add a New Page to Show a Single Article
  • Passing Data in the URL: Send the Article ID Using the Query String
  • Avoid SQL Injection: Validate the ID Passed in from the Query String
  • Don't Repeat Yourself: Extract Repeated Code to a Separate File
  • Organise and Secure Access to the Included Files
  • Multiple pages in PHP
  • Multiple pages in PHP
An Introduction to HTML Forms
  • Getting Data From the User: An Introduction to Forms in HTML
  • Change the Method the Form Uses to Send its Data: get vs post
  • Get Different Types of Data from the User: Basic Input Types
  • Access Data from the form on the Server
  • Add a Multi-line Text Control: the textarea Element
  • Present a Fixed List of Options: the Select Element
  • Toggle an Option on or off: checkboxes
  • Select only one Option from a List: Radio Buttons
  • Add an Accessible Caption to Each Input: the Label Element
  • Make the Form Easier to Use: fieldsets and placeholders
  • Common form Control Attributes: readonly, disabled and autofocus
  • Validate Input Using HTML5 form Validation
  • Forms in HTML
  • HTML Forms
Inserting Data Into the Database from PHP
  • Add a Form to Insert a New Article
  • Insert Data Into the Database: The SQL INSERT INTO Statement
  • Insert a New Article Into the Database and Get the ID of the New Record
  • How SQL Injection Attacks Work
  • Avoid SQL Injection Attacks: Escape Input
  • Avoid SQL Injection Attacks: Use Prepared Statements
  • Inserting data into the database
  • Databases - inserting data
An Introduction to Functions and Validation in PHP
  • Functions: Define and Call a Function in PHP