~Get Your Files Here !

  01 - Introduction

   001 Introduction How to Get the Most Out of the Course_en.srt

  02 - Software Installation and Setup

   001 Recommended Software Overview_en.srt

   002 Install XAMPP on Windows_en.srt

   003 Install XAMPP on MAC OS X_en.srt

   004 Install XAMPP on Ubuntu Linux_en.srt

   005 Install Atom on Windows_en.srt

   006 Install Atom on MAC OS X_en.srt

   007 Install Atom on Ubuntu Linux_en.srt

  03 - Variables

   001 Write Your First PHP Code Display a Message in Your Web Browser_en.srt

   002 Variables in PHP What They are, How to Create Them, and How to Name Them_en.srt

   003 Basic Variable Types Strings and Numbers_en.srt

   004 Basic Variable Types Boolean and Null_en.srt

   005 Perform Operations on Variables Operators_en.srt

   006 Strings Using Single or Double Quotes and Variable Interpolation_en.srt

  04 - Arrays

   001 Introduction to Arrays Create an Array and Access its Elements_en.srt

   002 Assign Manual Array Indexes and Create Associative Arrays_en.srt

   003 Create and Access Multidimensional Arrays_en.srt

   004 Process Each Element of an Array foreach Loops_en.srt

   005 Process the value and index of each array element using a foreach loop_en.srt

  05 - Control structures

   001 Run Code Conditionally the if Construct_en.srt

   002 Compare One Value to another Comparison Operators_en.srt

   003 Run Code Multiple Times Based on a Condition While Loops_en.srt

   004 Run Code a Specific Number Of Times For Loops_en.srt

   005 Add More Conditions to an If Statement Using Elseif_en.srt

   006 Perform Different Actions Based on Different Conditions The Switch Statement_en.srt

  06 - An Introduction to HTML

   001 The Language of Web Pages an Introduction To Html_en.srt

   002 Use Head and Body Elements to Structure An Html Document_en.srt

   003 Structure the Content of your Page Using Heading and Paragraph Elements_en.srt

   004 Give Text Emphasis or Importance Using the em and Strong Elements_en.srt

   005 Display Ordered and Unordered Lists of Items_en.srt

   006 Insert Images Into an Html Document_en.srt

   007 Add a Link from One Page to Another Using a Hyperlink_en.srt

   008 Add Semantic Structure to The Body of an Html Document_en.srt

  07 - Mixing PHP and HTML

   001 Create Dynamic Content Mixing HTML and PHP_en.srt

   002 Use PHP Control Structures Mixed with HTML_en.srt

   003 Make HTML More Readable Use Whitespace and Comments_en.srt

   005 Make PHP Easier To Maintain Use Comments and Coding Standards.mp4

   external-assets-links.txt

  08 - An Introduction to Databases

   001 Where to Store Data in a Dynamic Website An Introduction to Databases_en.srt

   002 Access the Database Server Using phpMyAdmin And Create a Database_en.srt

   003 Use Tables to Store Structured Data in a Database_en.srt

   004 Select Some Data from The Database An Introduction to Sql_en.srt

   005 Using Indexes Make Queries Faster and Order the Result Set_en.srt

   006 Connect to the Database from PHP_en.srt

   007 Query the Database from PHP And Get the Results_en.srt

   008 Combine PHP and HTML to Show a Formatted List of Articles_en.srt

  09 - Multiple Pages in PHP

   001 Add a New Page to Show a Single Article_en.srt

   002 Passing Data in the URL Send the Article ID Using the Query String_en.srt

   003 Avoid SQL Injection Validate the ID Passed in from the Query String_en.srt

   004 Don't Repeat Yourself Extract Repeated Code to a Separate File_en.srt

   006 Organise and Secure Access to the Included Files.mp4

   external-assets-links.txt

  10 - An Introduction to HTML Forms

   001 Getting Data From the User An Introduction to Forms in HTML_en.srt

   002 Change the Method the Form Uses to Send its Data get vs post_en.srt

   004 Get Different Types of Data from the User Basic Input Types.mp4

   005 Access Data from the form on the Server.mp4

   006 Add a Multi-line Text Control the textarea Element.mp4

   007 Present a Fixed List of Options the Select Element.mp4

   008 Toggle an Option on or off checkboxes.mp4

   009 Select only one Option from a List Radio Buttons.mp4

   010 Add an Accessible Caption to Each Input the Label Element.mp4

   011 Make the Form Easier to Use fieldsets and placeholders.mp4

   012 Common form Control Attributes readonly, disabled and autofocus.mp4

   013 Validate Input Using HTML5 form Validation.mp4

   external-assets-links.txt

  11 - Inserting Data Into the Database from PHP

   002 Add a Form to Insert a New Article.mp4

   003 Insert Data Into the Database The SQL INSERT INTO Statement.mp4

   004 Insert a New Article Into the Database and Get the ID of the New Record.mp4

   005 How SQL Injection Attacks Work.mp4

   006 Avoid SQL Injection Attacks Escape Input.mp4

   007 Avoid SQL Injection Attacks Use Prepared Statements.mp4

   external-assets-links.txt

  12 - An Introduction to Functions and Validation in PHP

   001 Functions Define and Call a Function in PHP_en.srt

   002 Create a Function to Connect to the Database_en.srt

   003 Validate the Form Data and redisplay the Form with Error Messages if Invalid_en.srt

   004 Maintain Previously-supplied Data When redisplaying an Invalid Form_en.srt

   005 Avoid Cross-site Scripting (XSS) Attacks Escape Untrusted Content_en.srt

   006 Insert NULL if the Publication Date is Empty_en.srt

   007 Validate the Publication Date is a Valid Date and Time_en.srt

   008 Redirect to the Article Page After Inserting a New Article_en.srt

  13 - Editing Data in the Database from PHP

   001 Editing Existing Articles Create a Function to Get a Single Article_en.srt

   002 Add a Form for Editing an Existing Article_en.srt

   003 Add a Validation Function and Validate the Form Data_en.srt

   004 Change Existing Data in the Database The SQL UPDATE Statement_en.srt

   005 Update an Existing Article in the Database_en.srt

   006 Create a Function to Redirect to Another URL_en.srt

  14 - Deleting Data from the Database from PHP

   001 Delete Existing Data in the Database The SQL DELETE Statement_en.srt

   002 Delete an Existing Article in the Database_en.srt

   003 Use the POST Request Method to Delete the Article_en.srt

   004 Get Confirmation from the User Before Deleting the Article_en.srt

   005 Improve Database Performance Only use SELECT when Necessary_en.srt

  15 - Using Sessions to Log in and Restrict Access

   001 Make the Web Browser Remember you Between Visits An Introduction to Sessions_en.srt

   002 Store Data in the Browser Cookies in PHP_en.srt

   003 Store a Value in the Session to Log in and Log out a User_en.srt

   004 Add a Login form and Process the User's Login Credentials_en.srt

   005 Completely Destroy the Session on Logout and Redirect Back to the Index Page_en.srt

   006 Increase Security Prevent Session Fixation Attacks_en.srt

   007 Restrict Access to a Page to a Logged-in User Only_en.srt

  16 - An Introduction to Object-Oriented PHP

   001 Classes and Objects An Introduction to Object-Oriented PHP_en.srt

   002 Object Attributes Adding Properties to a Class_en.srt

   003 Object Functions Adding Methods to a Class_en.srt

   004 Object Initialisation the Constructor Method_en.srt

   005 Control Access Public and Private visibility of Properties and Methods_en.srt

   006 Public Properties vs Getter and Setter Methods_en.srt

   007 Static Properties and Methods_en.srt

   008 Constants Using Define and const to Create Constant Values_en.srt

   009 Inheritance Using the Extends Keyword to reuse Code and reduce Repetition_en.srt

   010 Overriding Methods and Using the Parent Keyword to Call the Parent Class Code_en.srt

   011 Control Access Protected Visibility of Properties and Methods_en.srt

  17 - PDO PHP Data Objects

   001 Add a Database Class and Connect to the Database Using PHP Data Objects (PDO)_en.srt

   002 Queries in PDO Change the Index Page to Use the New Database Class_en.srt

   003 Catch Database Errors Using Exceptions and try ... catch Blocks_en.srt

   004 Prepared Statements with Named Parameters in PDO view an Individual Article_en.srt

   005 Create an Article Class and Use it on the Index and Article Pages_en.srt

   006 Fetch the Database Record as an Object Instead of an Array_en.srt

   007 Update the Article Record Using PDO_en.srt

   008 Move the Validation Function to the Article Class_en.srt

   009 Delete the Article Record Using PDO_en.srt

   010 Insert a new Article Record Using PDO and get the ID of the New Record_en.srt

  18 - Authentication Using the Database

   001 Create a User Class and a Method to Authenticate a User_en.srt

   002 Create a Table to Store User Data in the Database_en.srt

   003 Authenticate the User with Data from the Database_en.srt

   004 Store Passwords Securely PHP Password Hashing Functions_en.srt

   005 Store the Password as a Hash in the Database and Verify it on Login_en.srt

  19 - Class Autoloading

   001 Convert the auth Include into a Class_en.srt

   002 Convert the url Include into a Class_en.srt

   003 Autoloading Classes Require Class Files Automatically_en.srt

   004 Add an Initialisation Script Including an Autoloader_en.srt

   005 Returning a Value Using Require Add a Script to get the Database Connection_en.srt

  20 - Site Administration

   001 Move all Authentication-related Code to the Auth Class_en.srt

   002 Create an Admin Index and Load Classes Relative to the site root Directory_en.srt

   003 Displaying Tabular Data in HTML Tables_en.srt

   004 Display the Admin List of Articles in a Table and Restrict Access to the Page_en.srt

   005 Add Sitewide Navigation Links_en.srt

   006 Move the Edit and Delete Article Scripts to the admin Area_en.srt

   007 Move the New Article Script to the admin Area_en.srt

  21 - Pagination

   001 Pagination Split Database Results up Into Pages_en.srt

   002 Add a Method to the Article Class to get a Single Page of Article Records_en.srt

   003 Add a Paginator Class and Calculate the offset and Limit from the Page Number_en.srt

   004 Get the Page Number from the Query String_en.srt

   005 Validate the Page Number using the filter_var Function_en.srt

   006 Add Previous and Next Pagination Links_en.srt

   007 Calculate the Total Number of Records and Pages_en.srt

   008 Add Pagination to the admin Index and Create Shared Pagination Links_en.srt

  22 - Uploading Files

   001 Uploading Files Add a Form to Upload an Article Image_en.srt

   002 Handle the Upload Error Code_en.srt

   003 Restrict the Size of all Uploaded Files using PHP Configuration Settings_en.srt

   004 Restrict the Size of an Uploaded File in an Individual Form_en.srt

   005 Restrict the Type of an Uploaded File_en.srt

   006 Create a Folder for Uploads and Move the Uploaded File into it_en.srt

   007 Sanitise the Uploaded Filename as a Security Precaution_en.srt

   008 Don't Overwrite Existing Files in the Uploads Folder_en.srt

   009 Save the Filename to the Article Record in the Database_en.srt

   010 Display the Uploaded Image if an Article has one_en.srt

   011 Delete the Previous image File when an Article Image is Updated_en.srt

   012 Add an Option to Delete an Article's Image file_en.srt

  23 - Database Relationships

   001 Database Relationships Create a Table and Data for Categories_en.srt

   002 One-to-one Relationships Between Tables_en.srt

   003 One-to-many Relationships Between Tables_en.srt

   004 Joins Selecting Data from Multiple, Related Tables at Once_en.srt

   005 Relationship Constraints_en.srt

   006 Many-to-many Relationships Between Tables_en.srt

  24 - Using Relationships Article Categories

   001 Show an Article's Categories on the Individual Article Page_en.srt

   002 Get an Article's Categories in an Object Method_en.srt

   003 Add a Category Class and form Inputs to edit an Article's Categories_en.srt

   004 Insert Article Categories while Avoiding Duplicate Records in the Join Table_en.srt

   005 Insert Article Categories more Efficiently using a Single Query_en.srt

   006 Delete Article Category Records if Unchecked in the Form_en.srt

   007 Add Categories When Inserting a new Article Record_en.srt

   008 Pagination and Joins Show Categories in the Index Page_en.srt

  25 - JavaScript and PHP

   001 Execute Code in the Browser An Introduction to JavaScript_en.srt

   002 Using the jQuery Library_en.srt

   003 Add jQuery and a Custom Script file to the CMS_en.srt

   004 Add Delete Confirmation Using JavaScript and POST_en.srt

   005 Client-side form Validation Using the jQuery Validation Plugin_en.srt

   006 An Introduction to Ajax with PHP_en.srt

   007 Use JSON to Safely Encode Structured Data in an Ajax Request_en.srt

  26 - Dates and Times

   001 Only Show an Individual Article if it's been Published_en.srt

   002 Only Show Published Articles on the Index Page_en.srt

   003 Use the DateTime Class and the Time Element to Show the Published Date and Time_en.srt

   004 Show the Published Date and Time of Articles in the admin Area_en.srt

   005 Publish Unpublished Articles Using an Ajax Request_en.srt

  27 - An Introduction to CSS

   001 Add Styling and Formatting to HTML an Introduction to CSS_en.srt

   002 Using CSS Frameworks Bootstrap et al_en.srt

   003 Add a General Layout and Style the Navigation Links_en.srt

   004 Add Styling and Layout to Forms and Tables_en.srt

   005 Add a Custom Stylesheet and Style the List of Articles_en.srt

   006 Add a Date and Time Picker Plugin to make Selecting Dates and Times Easier_en.srt

  28 - Sending Emails from PHP

   001 Add a Contact Page for Sending an Email_en.srt

   002 Validate the Submitted Contact Form_en.srt

   003 Get Access to a Mail Server_en.srt

   004 How to Send Email from PHP the Mail Function and PHPMailer_en.srt

   005 Send Email from the Contact Page Using PHPMailer_en.srt

  29 - Configuration and Error Handling

   001 Extract Environment-dependent Settings out into a Single Configuration File_en.srt

   002 Deny Direct Access to the config file from a Browser_en.srt

   003 Handing Errors and Exceptions user-defined Handling Functions_en.srt

   004 Display Error and Exception Details Depending on the Environment_en.srt

   005 HTTP Status Codes and Handling Ajax Errors_en.srt

  30 - Conclusion

   001 Deployment Publish your Code on a Live Server_en.srt

   002 Conclusion Where to go from Here_en.srt

  31 - Extra Information - Source code, and other stuff

   001 cms-db.sql.txt

   002 Bonus Lecture and Information_en.srt

  Bonus Resources.txt