UdemyCourseDownloader PHP for Beginners

/24. Using Relationships Article Categories/

8. Pagination and Joins Show Categories in the Index Page.mp4

1. Show an Article's Categories on the Individual Article Page.mp4

1. Show an Article's Categories on the Individual Article Page.vtt

1.1 Source code - Using Relationships Article Categories - Show an Article's Categories on the Individual Article Page.html

2. Get an Article's Categories in an Object Method.mp4

2. Get an Article's Categories in an Object Method.vtt

2.1 Source code - Using Relationships Article Categories - Get an Article's Categories in an Object Method.html

3. Add a Category Class and form Inputs to edit an Article's Categories.mp4

3. Add a Category Class and form Inputs to edit an Article's Categories.vtt

3.1 PHP array_column.html

3.2 Source code - Using Relationships Article Categories - Add a Category Class and form Inputs to edit an Article's Categories.html

4. Insert Article Categories while Avoiding Duplicate Records in the Join Table.mp4

4. Insert Article Categories while Avoiding Duplicate Records in the Join Table.vtt

4.1 Source code - Using Relationships Article Categories - Insert Article Categories while Avoiding Duplicate Records in the Join Table.html

4.2 MariaDB INSERT IGNORE.html

4.3 MariaDB Error Codes.html

5. Insert Article Categories more Efficiently using a Single Query.mp4

5. Insert Article Categories more Efficiently using a Single Query.vtt

5.1 PHP implode.html

5.2 Source code - Using Relationships Article Categories - Insert Article Categories more Efficiently using a Single Query.html

5.3 PDOStatementbindValue.html

6. Delete Article Category Records if Unchecked in the Form.mp4

6. Delete Article Category Records if Unchecked in the Form.vtt

6.1 Source code - Using Relationships Article Categories - Delete Article Category Records if Unchecked in the Form.html

6.2 PHP array_fill.html

6.3 MariaDB NOT IN.html

6.4 PHP count.html

7. Add Categories When Inserting a new Article Record.mp4

7. Add Categories When Inserting a new Article Record.vtt

7.1 Source code - Using Relationships Article Categories - Add Categories When Inserting a new Article Record.html

8. Pagination and Joins Show Categories in the Index Page.vtt

8.1 Source code - Using Relationships Article Categories - Pagination and Joins Show Categories in the Index Page.html

9. Database relationships.html

/

udemycoursedownloader.com.url

Udemy Course downloader.txt

/01. Introduction/

1. Introduction How to Get the Most Out of the Course.mp4

1. Introduction How to Get the Most Out of the Course.vtt

/02. Software Installation and Setup/

1. Recommended Software Overview.mp4

1. Recommended Software Overview.vtt

2. Install XAMPP on Windows.mp4

2. Install XAMPP on Windows.vtt

3. Install XAMPP on MAC OS X.mp4

3. Install XAMPP on MAC OS X.vtt

3.1 XAMPP.html

3.2 Atom.html

4. Install XAMPP on Ubuntu Linux.mp4

4. Install XAMPP on Ubuntu Linux.vtt

5. Install Atom on Windows.mp4

5. Install Atom on Windows.vtt

6. Install Atom on MAC OS X.mp4

6. Install Atom on MAC OS X.vtt

6.1 Atom.html

7. Install Atom on Ubuntu Linux.mp4

7. Install Atom on Ubuntu Linux.vtt

/03. Variables/

1. Write Your First PHP Code Display a Message in Your Web Browser.mp4

1. Write Your First PHP Code Display a Message in Your Web Browser.vtt

1.1 Source code - Variables - Write Your First PHP Code Display a Message in Your Web Browser.html

2. Variables in PHP What They are, How to Create Them, and How to Name Them.mp4

2. Variables in PHP What They are, How to Create Them, and How to Name Them.vtt

2.1 Source code - Variables - Variables in PHP What They are, How to Create Them, and How to Name Them.html

3. Basic Variable Types Strings and Numbers.mp4

3. Basic Variable Types Strings and Numbers.vtt

3.1 Source code - Variables - Basic Variable Types Strings and Numbers.html

4. Basic Variable Types Boolean and Null.mp4

4. Basic Variable Types Boolean and Null.vtt

4.1 Source code - Variables - Basic Variable Types Boolean and Null.html

5. Perform Operations on Variables Operators.mp4

5. Perform Operations on Variables Operators.vtt

5.1 Source code - Variables - Perform Operations on Variables Operators.html

5.2 PHP Logical Operators.html

5.3 PHP Arithmetic Operators.html

5.4 PHP Type Juggling.html

5.5 PHP String Operators.html

6. Strings Using Single or Double Quotes and Variable Interpolation.mp4

6. Strings Using Single or Double Quotes and Variable Interpolation.vtt

6.1 Source code - Variables - Strings Using Single or Double Quotes and Variable Interpolation.html

6.2 PHP Strings.html

7. PHP concepts, variables and operators.html

8. Variables and Operators.html

/04. Arrays/

1. Introduction to Arrays Create an Array and Access its Elements.mp4

1. Introduction to Arrays Create an Array and Access its Elements.vtt

1.1 Source code - Arrays - Introduction to Arrays Create an Array and Access its Elements.html

2. Assign Manual Array Indexes and Create Associative Arrays.mp4

2. Assign Manual Array Indexes and Create Associative Arrays.vtt

2.1 Source code - Arrays - Assign Manual Array Indexes and Create Associative Arrays.html

3. Create and Access Multidimensional Arrays.mp4

3. Create and Access Multidimensional Arrays.vtt

3.1 Source code - Arrays - Create and Access Multidimensional Arrays.html

4. Process Each Element of an Array foreach Loops.mp4

4. Process Each Element of an Array foreach Loops.vtt

4.1 Source code - Arrays - Process Each Element of an Array foreach Loops.html

5. Process the value and index of each array element using a foreach loop.mp4

5. Process the value and index of each array element using a foreach loop.vtt

5.1 PHP foreach.html

5.2 Source code - Arrays - Process the value and index of each array element using a foreach loop​.html

6. Arrays.html

7. Arrays.html

/05. Control structures/

1. Run Code Conditionally the if Construct.mp4

1. Run Code Conditionally the if Construct.vtt

1.1 Source code - Control structures - Run Code Conditionally the if Construct.html

2. Compare One Value to another Comparison Operators.mp4

2. Compare One Value to another Comparison Operators.vtt

2.1 Source code - Control structures - Compare One Value to another Comparison Operators.html

3. Run Code Multiple Times Based on a Condition While Loops.mp4

3. Run Code Multiple Times Based on a Condition While Loops.vtt

3.1 Source code - Control structures - Run Code Multiple Times Based on a Condition While Loops.html

4. Run Code a Specific Number Of Times For Loops.mp4

4. Run Code a Specific Number Of Times For Loops.vtt

4.1 Source code - Control structures - Run Code a Specific Number Of Times For Loops.html

5. Add More Conditions to an If Statement Using Elseif.mp4

5. Add More Conditions to an If Statement Using Elseif.vtt

5.1 Source code - Control structures - Add More Conditions to an If Statement Using Elseif.html

6. Perform Different Actions Based on Different Conditions The Switch Statement.mp4

6. Perform Different Actions Based on Different Conditions The Switch Statement.vtt

6.1 Source code - Control structures - Perform Different Actions Based on Different Conditions The Switch Statement.html

7. Control structures and comparison operators.html

8. Control structures and comparison operators.html

/06. An Introduction to HTML/

1. The Language of Web Pages an Introduction To Html.mp4

1. The Language of Web Pages an Introduction To Html.vtt

1.1 Source code - An Introduction to HTML - The Language of Web Pages an Introduction To Html.html

2. Use Head and Body Elements to Structure An Html Document.mp4

2. Use Head and Body Elements to Structure An Html Document.vtt

2.1 Source code - An Introduction to HTML - Use Head and Body Elements to Structure An Html Document.html

3. Structure the Content of your Page Using Heading and Paragraph Elements.mp4

3. Structure the Content of your Page Using Heading and Paragraph Elements.vtt

3.1 Source code - An Introduction to HTML - Structure the Content of your Page Using Heading and Paragraph Elements.html

4. Give Text Emphasis or Importance Using the em and Strong Elements.mp4

4. Give Text Emphasis or Importance Using the em and Strong Elements.vtt

4.1 Source code - An Introduction to HTML - Give Text Emphasis or Importance Using the em and Strong Elements.html

5. Display Ordered and Unordered Lists of Items.mp4

5. Display Ordered and Unordered Lists of Items.vtt

5.1 Source code - An Introduction to HTML - Display Ordered and Unordered Lists of Items.html

6. Insert Images Into an Html Document.mp4

6. Insert Images Into an Html Document.vtt

6.1 Source code - An Introduction to HTML - Insert Images Into an Html Document.html

7. Add a Link from One Page to Another Using a Hyperlink.mp4

7. Add a Link from One Page to Another Using a Hyperlink.vtt

7.1 Source code - An Introduction to HTML - Add a Link from One Page to Another Using a Hyperlink.html

8. Add Semantic Structure to The Body of an Html Document.mp4

8. Add Semantic Structure to The Body of an Html Document.vtt

8.1 Source code - An Introduction to HTML - Add Semantic Structure to The Body of an Html Document.html

9. HTML.html

10. HTML basics.html

/07. Mixing PHP and HTML/

1. Create Dynamic Content Mixing HTML and PHP.mp4

1. Create Dynamic Content Mixing HTML and PHP.vtt

1.1 Source code - Mixing PHP and HTML - Create Dynamic Content Mixing HTML and PHP.html

2. Use PHP Control Structures Mixed with HTML.mp4

2. Use PHP Control Structures Mixed with HTML.vtt

2.1 Source code - Mixing PHP and HTML - Use PHP Control Structures Mixed with HTML.html

3. Make HTML More Readable Use Whitespace and Comments.mp4

3. Make HTML More Readable Use Whitespace and Comments.vtt

3.1 Source code - Mixing PHP and HTML - Make HTML More Readable Use Whitespace and Comments.html

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

4. Make PHP Easier To Maintain Use Comments and Coding Standards.vtt

4.1 Source code - Mixing PHP and HTML - Make PHP Easier To Maintain Use Comments and Coding Standards.html

5. Mixing PHP and HTML.html

6. Mixing PHP and HTML.html

/08. An Introduction to Databases/

1. Where to Store Data in a Dynamic Website An Introduction to Databases.mp4

1. Where to Store Data in a Dynamic Website An Introduction to Databases.vtt

1.1 Source code - An Introduction to Databases - Where to Store Data in a Dynamic Website An Introduction to Databases.html

2. Access the Database Server Using phpMyAdmin And Create a Database.mp4

2. Access the Database Server Using phpMyAdmin And Create a Database.vtt

3. Use Tables to Store Structured Data in a Database.mp4

3. Use Tables to Store Structured Data in a Database.vtt

3.1 Data Types - MariaDB.html

4. Select Some Data from The Database An Introduction to Sql.mp4

4. Select Some Data from The Database An Introduction to Sql.vtt

4.1 Comparison Operators - MariaDB.html

4.2 SQL Statements & Structure - MariaDB.html

5. Using Indexes Make Queries Faster and Order the Result Set.mp4

5. Using Indexes Make Queries Faster and Order the Result Set.vtt

6. Connect to the Database from PHP.mp4

6. Connect to the Database from PHP.vtt

6.1 PHP mysqli_connect.html

6.2 PHP MySQLi.html

6.3 Source code - An Introduction to Databases - Connect to the Database from PHP.html

6.4 PHP mysqli_connect_error.html

7. Query the Database from PHP And Get the Results.mp4

7. Query the Database from PHP And Get the Results.vtt

7.1 PHP mysqli_query.html

7.2 PHP Booleans.html

7.3 PHP Comparison Operators.html

7.4 Source code - An Introduction to Databases - Query the Database from PHP And Get the Results.html

7.5 PHP mysqli_fetch_all.html

7.6 PHP mysqli_fetch_row.html

8. Combine PHP and HTML to Show a Formatted List of Articles.mp4

8. Combine PHP and HTML to Show a Formatted List of Articles.vtt

8.1 Source code - An Introduction to Databases - Combine PHP and HTML to Show a Formatted List of Articles.html

9. Databases.html

/09. Multiple Pages in PHP/

1. Add a New Page to Show a Single Article.mp4

1. Add a New Page to Show a Single Article.vtt

1.1 PHP mysqli_fetch_assoc.html

1.2 Source code - Multiple Pages in PHP - Add a New Page to Show a Single Article.html

2. Passing Data in the URL Send the Article ID Using the Query String.mp4

2. Passing Data in the URL Send the Article ID Using the Query String.vtt

2.1 PHP Superglobals.html

2.2 Source code - Multiple Pages in PHP - Passing Data in the URL Send the Article ID Using the Query String.html

2.3 PHP $_GET.html

3. Avoid SQL Injection Validate the ID Passed in from the Query String.mp4

3. Avoid SQL Injection Validate the ID Passed in from the Query String.vtt

3.1 PHP is_numeric.html

3.2 PHP isset.html

3.3 Source code - Multiple Pages in PHP - Avoid SQL Injection Validate the ID Passed in from the Query String.html

3.4 PHP Logical Operators.html

4. Don't Repeat Yourself Extract Repeated Code to a Separate File.mp4

4. Don't Repeat Yourself Extract Repeated Code to a Separate File.vtt

4.1 Source code - Multiple Pages in PHP - Don't Repeat Yourself Extract Repeated Code to a Separate File.html

4.2 PHP include.html

5. Organise and Secure Access to the Included Files.mp4

5. Organise and Secure Access to the Included Files.vtt

5.1 Source code - Multiple Pages in PHP - Organise and Secure Access to the Included Files.html

5.2 Apache HTTP Server .htaccess files.html

6. Multiple pages in PHP.html

7. Multiple pages in PHP.html

/10. An Introduction to HTML Forms/

1. Getting Data From the User An Introduction to Forms in HTML.mp4

1. Getting Data From the User An Introduction to Forms in HTML.vtt

1.1 DevDocs - HTML form.html

1.2 Source code - An Introduction to HTML Forms - Getting Data From the User An Introduction to Forms in HTML.html

2. Change the Method the Form Uses to Send its Data get vs post.mp4

2. Change the Method the Form Uses to Send its Data get vs post.vtt

2.1 PHP $_GET.html

2.2 PHP $_SERVER.html

2.3 Source code - An Introduction to HTML Forms - Change the Method the Form Uses to Send its Data get vs post.html

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

3. Get Different Types of Data from the User Basic Input Types.vtt

3.1 HTML5 Please.html

3.2 Can I use... Support tables for HTML5.html

3.3 DevDocs - HTML input.html

3.4 mobile input types.html

3.5 Source code - An Introduction to HTML Forms - Get Different Types of Data from the User Basic Input Types.html

4. Access Data from the form on the Server.mp4

4. Access Data from the form on the Server.vtt

4.1 DevDocs - HTML button.html

4.2 Source code - An Introduction to HTML Forms - Access Data from the form on the Server.html

4.3 DevDocs - HTML input.html

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

5. Add a Multi-line Text Control the textarea Element.vtt

5.1 DevDocs - HTML textarea.html

5.2 DevDocs - HTML input type=text.html

5.3 Source code - An Introduction to HTML Forms - Add a Multi-line Text Control the textarea Element.html

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

6. Present a Fixed List of Options the Select Element.vtt

6.1 Source code - An Introduction to HTML Forms - Present a Fixed List of Options the Select Element.html

6.2 DevDocs - HTML select.html

7. Toggle an Option on or off checkboxes.mp4

7. Toggle an Option on or off checkboxes.vtt

7.1 Source code - An Introduction to HTML Forms - Toggle an Option on or off checkboxes.html

7.2 DevDocs - HTML input type=checkbox.html

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

8. Select only one Option from a List Radio Buttons.vtt

8.1 DevDocs - HTML input type=radio.html

8.2 Source code - An Introduction to HTML Forms - Select only one Option from a List Radio Buttons.html

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

9. Add an Accessible Caption to Each Input the Label Element.vtt

9.1 DevDocs - HTML label.html

9.2 Source code - An Introduction to HTML Forms - Add an Accessible Caption to Each Input the Label Element.html

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

10. Make the Form Easier to Use fieldsets and placeholders.vtt

10.1 DevDocs - HTML fieldset.html

10.2 Source code - An Introduction to HTML Forms - Make the Form Easier to Use fieldsets and placeholders.html

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

11. Common form Control Attributes readonly, disabled and autofocus.vtt

11.1 Source code - An Introduction to HTML Forms - Common form Control Attributes readonly, disabled and autofocus.html

12. Validate Input Using HTML5 form Validation.mp4

12. Validate Input Using HTML5 form Validation.vtt

12.1 Source code - An Introduction to HTML Forms - Validate Input Using HTML5 form Validation.html

12.2 HTML5 Pattern.html

12.3 Can I use... form validation.html

12.4 DevDocs - DOM HTMLSelectElement.setCustomValidity.html

12.5 DevDocs - HTML input type=number.html

13. Forms in HTML.html

14. HTML Forms.html

/11. Inserting Data Into the Database from PHP/

1. Add a Form to Insert a New Article.mp4

1. Add a Form to Insert a New Article.vtt

1.1 Source code - Inserting Data Into the Database from PHP - Add a Form to Insert a New Article.html

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

2. Insert Data Into the Database The SQL INSERT INTO Statement.vtt

2.1 Data Manipulation - MariaDB Knowledge Base.html

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

3. Insert a New Article Into the Database and Get the ID of the New Record.vtt

3.1 Source code - Inserting Data Into the Database from PHP - Insert a New Article Into the Database and Get the ID of the New Record.html

3.2 PHP mysqli_insert_id.html

4. How SQL Injection Attacks Work.mp4

4. How SQL Injection Attacks Work.vtt

4.1 crack mysql password - Google Search.html

4.2 Source code - Inserting Data Into the Database from PHP - How SQL Injection Attacks Work.html

4.3 CrackStation - Online Password Hash Cracking - MD5, SHA1, Linux, Rainbow Tables, etc..html

4.4 The mysql Database Tables - MariaDB Knowledge Base.html

5. Avoid SQL Injection Attacks Escape Input.mp4

5. Avoid SQL Injection Attacks Escape Input.vtt

5.1 PHP mysqli_escape_string.html

5.2 Source code - Inserting Data Into the Database from PHP - Avoid SQL Injection Attacks Escape Input.html

5.3 PHP mysqli_real_escape_string.html

6. Avoid SQL Injection Attacks Use Prepared Statements.mp4

6. Avoid SQL Injection Attacks Use Prepared Statements.vtt

6.1 PHP mysqli_stmt_execute.html

6.2 PHP mysqli_prepare.html

6.3 PHP Prepared Statements.html

6.4 PHP mysqli_stmt_bind_param.html

6.5 MariaDB General Query Log.html

6.6 Source code - Inserting Data Into the Database from PHP - Avoid SQL Injection Attacks Use Prepared Statements.html

7. Inserting data into the database.html

/12. An Introduction to Functions and Validation in PHP/

1. Functions Define and Call a Function in PHP.mp4

1. Functions Define and Call a Function in PHP.vtt

1.1 Source code - An Introduction to Functions and Validation in PHP - Functions Define and Call a Function in PHP.html

1.2 phpDocumentor Basic Syntax.html

1.3 PHP Function Reference.html

2. Create a Function to Connect to the Database.mp4

2. Create a Function to Connect to the Database.vtt

2.1 Source code - An Introduction to Functions and Validation in PHP - Create a Function to Connect to the Database.html

3. Validate the Form Data and redisplay the Form with Error Messages if Invalid.mp4

3. Validate the Form Data and redisplay the Form with Error Messages if Invalid.vtt

3.1 Source code - An Introduction to Functions and Validation in PHP - Validate the Form Data and redisplay the Form with Error Messages if Invalid.html

4. Maintain Previously-supplied Data When redisplaying an Invalid Form.mp4

4. Maintain Previously-supplied Data When redisplaying an Invalid Form.vtt

4.1 Source code - An Introduction to Functions and Validation in PHP - Maintain Previously-supplied Data When redisplaying an Invalid Form.html

5. Avoid Cross-site Scripting (XSS) Attacks Escape Untrusted Content.mp4

5. Avoid Cross-site Scripting (XSS) Attacks Escape Untrusted Content.vtt

5.1 Source code - An Introduction to Functions and Validation in PHP - Avoid Cross-site Scripting (XSS) Attacks Escape Untrusted Content.html

5.2 PHP htmlspecialchars.html

5.3 HTML Reserved characters.html

6. Insert NULL if the Publication Date is Empty.mp4

6. Insert NULL if the Publication Date is Empty.vtt

6.1 Source code - An Introduction to Functions and Validation in PHP - Insert NULL if the Publication Date is Empty.html

7. Validate the Publication Date is a Valid Date and Time.mp4

7. Validate the Publication Date is a Valid Date and Time.vtt

7.1 PHP date_create_from_format.html

7.2 MariaDB Date and Time Literals.html

7.3 Source code - An Introduction to Functions and Validation in PHP - Validate the Publication Date is a Valid Date and Time.html

7.4 PHP date_get_last_errors.html

8. Redirect to the Article Page After Inserting a New Article.mp4

8. Redirect to the Article Page After Inserting a New Article.vtt

8.1 Source code - An Introduction to Functions and Validation in PHP - Redirect to the Article Page After Inserting a New Article.html

8.2 PHP header.html

8.3 PHP $_SERVER.html

9. Functions.html

10. Functions in PHP.html

/13. Editing Data in the Database from PHP/

1. Editing Existing Articles Create a Function to Get a Single Article.mp4

1. Editing Existing Articles Create a Function to Get a Single Article.vtt

1.1 PHP mysqli_fetch_array.html

1.2 Source code - Editing Data in the Database from PHP - Editing Existing Articles Create a Function to Get a Single Article.html

2. Add a Form for Editing an Existing Article.mp4

2. Add a Form for Editing an Existing Article.vtt

2.1 Source code - Editing Data in the Database from PHP - Add a Form for Editing an Existing Article.html

3. Add a Validation Function and Validate the Form Data.mp4

3. Add a Validation Function and Validate the Form Data.vtt

3.1 Source code - Editing Data in the Database from PHP - Add a Validation Function and Validate the Form Data​​​.html

3.2 PHP empty.html

4. Change Existing Data in the Database The SQL UPDATE Statement.mp4

4. Change Existing Data in the Database The SQL UPDATE Statement.vtt

4.1 MariaDB UPDATE.html

5. Update an Existing Article in the Database.mp4

5. Update an Existing Article in the Database.vtt

5.1 Source code - Editing Data in the Database from PHP - Update an Existing Article in the Database.html

6. Create a Function to Redirect to Another URL.mp4

6. Create a Function to Redirect to Another URL.vtt

6.1 Source code - Editing Data in the Database from PHP - Create a Function to Redirect to Another URL.html

/14. Deleting Data from the Database from PHP/

1. Delete Existing Data in the Database The SQL DELETE Statement.mp4

1. Delete Existing Data in the Database The SQL DELETE Statement.vtt

1.1 MariaDB DELETE.html

2. Delete an Existing Article in the Database.mp4

2. Delete an Existing Article in the Database.vtt

2.1 Source code - Deleting Data from the Database from PHP - Delete an Existing Article in the Database.html

3. Use the POST Request Method to Delete the Article.mp4

3. Use the POST Request Method to Delete the Article.vtt

3.1 Source code - Deleting Data from the Database from PHP - Use the POST Request Method to Delete the Article.html

4. Get Confirmation from the User Before Deleting the Article.mp4

4. Get Confirmation from the User Before Deleting the Article.vtt

4.1 Source code - Deleting Data from the Database from PHP - Get Confirmation from the User Before Deleting the Article.html

5. Improve Database Performance Only use SELECT when Necessary.mp4

5. Improve Database Performance Only use SELECT when Necessary.vtt

5.1 Source code - Deleting Data from the Database from PHP - Improve Database Performance Only use SELECT when Necessary.html

5.2 Using SELECT - Stack Overflow.html

5.3 Create, read, update and delete - Wikipedia.html

6. Updating and deleting data in the database.html

/15. Using Sessions to Log in and Restrict Access/

1. Make the Web Browser Remember you Between Visits An Introduction to Sessions.mp4

1. Make the Web Browser Remember you Between Visits An Introduction to Sessions.vtt

1.1 PHP $_SESSION.html

1.2 PHP session_start.html

1.3 Source code - Using Sessions to Log in and Restrict Access - Make the Web Browser Remember you Between Visits An Introduction to Sessions.html

2. Store Data in the Browser Cookies in PHP.mp4

2. Store Data in the Browser Cookies in PHP.vtt

2.1 PHP session cookie runtime configuration.html

2.2 PHP session_start.html

2.3 PHP $_COOKIE.html

2.4 PHP setcookie.html

2.5 Source code - Using Sessions to Log in and Restrict Access - Store Data in the Browser Cookies in PHP.html

3. Store a Value in the Session to Log in and Log out a User.mp4

3. Store a Value in the Session to Log in and Log out a User.vtt

3.1 Source code - Using Sessions to Log in and Restrict Access - Store a Value in the Session to Log in and Log out a User.html

4. Add a Login form and Process the User's Login Credentials.mp4

4. Add a Login form and Process the User's Login Credentials.vtt

4.1 Source code - Using Sessions to Log in and Restrict Access - Add a Login form and Process the User's Login Credentials.html

5. Completely Destroy the Session on Logout and Redirect ack to the Index Page.mp4

5. Completely Destroy the Session on Logout and Redirect ack to the Index Page.vtt

5.1 Source code - Using Sessions to Log in and Restrict Access - Completely Destroy the Session on Logout and Redirect ack to the Index Page.html

5.2 PHP session_destroy.html

6. Increase Security Prevent Session Fixation Attacks.mp4

6. Increase Security Prevent Session Fixation Attacks.vtt

6.1 PHP session_regenerate_id.html

6.2 Source code - Using Sessions to Log in and Restrict Access - Increase Security Prevent Session Fixation Attacks.html

6.3 Session fixation - OWASP.html

7. Restrict Access to a Page to a Logged-in User Only.mp4

7. Restrict Access to a Page to a Logged-in User Only.vtt

7.1 Source code - Using Sessions to Log in and Restrict Access - Restrict Access to a Page to a Logged-in User Only.html

8. Sessions and cookies.html

/16. An Introduction to Object-Oriented PHP/

1. Classes and Objects An Introduction to Object-Oriented PHP.mp4

1. Classes and Objects An Introduction to Object-Oriented PHP.vtt

1.1 PSR-1 Basic Coding Standard.html

1.2 Source code - An Introduction to Object-Oriented PHP - Classes and Objects An Introduction to Object-Oriented PHP.html

2. Object Attributes Adding Properties to a Class.mp4

2. Object Attributes Adding Properties to a Class.vtt

2.1 Source code - An Introduction to Object-Oriented PHP - Object Attributes Adding Properties to a Class.html

3. Object Functions Adding Methods to a Class.mp4

3. Object Functions Adding Methods to a Class.vtt

3.1 PSR-1 Basic Coding Standard.html

3.2 Source code - An Introduction to Object-Oriented PHP - Object Functions Adding Methods to a Class.html

4. Object Initialisation the Constructor Method.mp4

4. Object Initialisation the Constructor Method.vtt

4.1 Source code - An Introduction to Object-Oriented PHP - Object Initialisation the Constructor Method.html

5. Control Access Public and Private visibility of Properties and Methods.mp4

5. Control Access Public and Private visibility of Properties and Methods.vtt

5.1 Source code - An Introduction to Object-Oriented PHP - Control Access Public and Private visibility of Properties and Methods.html

6. Public Properties vs Getter and Setter Methods.mp4

6. Public Properties vs Getter and Setter Methods.vtt

6.1 What are PHP magic methods.html

6.2 Source code - An Introduction to Object-Oriented PHP - Public Properties vs Getter and Setter Methods.html

6.3 php-getters-setters Atom package.html

7. Static Properties and Methods.mp4

7. Static Properties and Methods.vtt

7.1 Source code - An Introduction to Object-Oriented PHP - Static Properties and Methods.html

8. Constants Using Define and const to Create Constant Values.mp4

8. Constants Using Define and const to Create Constant Values.vtt

8.1 PHP define.html

8.2 PHP Class Constants.html

8.3 Source code - An Introduction to Object-Oriented PHP - Constants Using Define and const to Create Constant Values.html

8.4 PSR-1 Basic Coding Standard.html

9. Inheritance Using the Extends Keyword to reuse Code and reduce Repetition.mp4

9. Inheritance Using the Extends Keyword to reuse Code and reduce Repetition.vtt

9.1 Source code - An Introduction to Object-Oriented PHP - Inheritance Using the Extends Keyword to reuse Code and reduce Repetition.html

10. Overriding Methods and Using the Parent Keyword to Call the Parent Class Code.mp4

10. Overriding Methods and Using the Parent Keyword to Call the Parent Class Code.vtt

10.1 Source code - An Introduction to Object-Oriented PHP - Overriding Methods and Using the Parent Keyword to Call the Parent Class Code.html

11. Control Access Protected Visibility of Properties and Methods.mp4

11. Control Access Protected Visibility of Properties and Methods.vtt

11.1 Source code - An Introduction to Object-Oriented PHP - Control Access Protected Visibility of Properties and Methods.html

11.2 PHP Visibility.html

12. Object-oriented PHP.html

13. Object-Oriented PHP.html

/17. PDO PHP Data Objects/

1. Add a Database Class and Connect to the Database Using PHP Data Objects (PDO).mp4

1. Add a Database Class and Connect to the Database Using PHP Data Objects (PDO).vtt

1.1 PHP MySQLi dual procedural and object-oriented interface.html

1.2 PDO named placeholders.html

1.3 Source code - PDO PHP Data Objects - Add a Database Class and Connect to the Database Using PHP Data Objects (PDO).html

1.4 PHP PDO__construct.html

1.5 PHP Data Objects.html

1.6 PHP MySQLi.html

2. Queries in PDO Change the Index Page to Use the New Database Class.mp4

2. Queries in PDO Change the Index Page to Use the New Database Class.vtt

2.1 Source code - PDO PHP Data Objects - Queries in PDO Change the Index Page to Use the New Database Class.html

2.2 PHP PDOquery.html

3. Catch Database Errors Using Exceptions and try ... catch Blocks.mp4

3. Catch Database Errors Using Exceptions and try ... catch Blocks.vtt

3.1 Source code - PDO PHP Data Objects - Catch Database Errors Using Exceptions and try ... catch Blocks.html

3.2 PDO error handling.html

3.3 PHP Exceptions.html

3.4 PHP Exception class.html

4. Prepared Statements with Named Parameters in PDO view an Individual Article.mp4

4. Prepared Statements with Named Parameters in PDO view an Individual Article.vtt

4.1 PHP PDOprepare.html

4.2 PHP PDOStatementfetch.html

4.3 Source code - PDO PHP Data Objects - Prepared Statements with Named Parameters in PDO view an Individual Article.html

4.4 PHP PDOStatementbindValue.html

5. Create an Article Class and Use it on the Index and Article Pages.mp4

5. Create an Article Class and Use it on the Index and Article Pages.vtt

5.1 Source code - PDO PHP Data Objects - Create an Article Class and Use it on the Index and Article Pages.html

6. Fetch the Database Record as an Object Instead of an Array.mp4

6. Fetch the Database Record as an Object Instead of an Array.vtt

6.1 PHP PDOStatementsetFetchMode.html

6.2 Source code - PDO PHP Data Objects - Fetch the Database Record as an Object Instead of an Array.html

7. Update the Article Record Using PDO.mp4

7. Update the Article Record Using PDO.vtt

7.1 Source code - PDO PHP Data Objects - Update the Article Record Using PDO.html

8. Move the Validation Function to the Article Class.mp4

8. Move the Validation Function to the Article Class.vtt

8.1 Source code - PDO PHP Data Objects - Move the Validation Function to the Article Class.html

9. Delete the Article Record Using PDO.mp4

9. Delete the Article Record Using PDO.vtt

9.1 Source code - PDO PHP Data Objects - Delete the Article Record Using PDO.html

10. Insert a new Article Record Using PDO and get the ID of the New Record.mp4

10. Insert a new Article Record Using PDO and get the ID of the New Record.vtt

10.1 PHP PDOlastInsertId.html

10.2 Source code - PDO PHP Data Objects - Insert a new Article Record Using PDO and get the ID of the New Record.html

/18. Authentication Using the Database/

1. Create a User Class and a Method to Authenticate a User.mp4

1. Create a User Class and a Method to Authenticate a User.vtt

1.1 Source code - Authentication Using the Database - Create a User Class and a Method to Authenticate a User.html

2. Create a Table to Store User Data in the Database.mp4

2. Create a Table to Store User Data in the Database.vtt

2.1 Source code - Authentication Using the Database - Create a Table to Store User Data in the Database.html

3. Authenticate the User with Data from the Database.mp4

3. Authenticate the User with Data from the Database.vtt

3.1 Source code - Authentication Using the Database - Authenticate the User with Data from the Database.html

4. Store Passwords Securely PHP Password Hashing Functions.mp4

4. Store Passwords Securely PHP Password Hashing Functions.vtt

4.1 PHP sha1.html

4.2 PHP hash.html

4.3 PHP password_verify.html

4.4 Source code - Authentication Using the Database - Store Passwords Securely PHP Password Hashing Functions.html

4.5 PHP md5.html

4.6 PHP password_hash.html

5. Store the Password as a Hash in the Database and Verify it on Login.mp4

5. Store the Password as a Hash in the Database and Verify it on Login.vtt

5.1 Source code - Authentication Using the Database - Store the Password as a Hash in the Database and Verify it on Login.html

5.2 PHP password_hash online.html

6. PDO and password hashing.html

/19. Class Autoloading/

1. Convert the auth Include into a Class.mp4

1. Convert the auth Include into a Class.vtt

1.1 Source code - Class Autoloading - Convert the auth Include into a Class.html

2. Convert the url Include into a Class.mp4

2. Convert the url Include into a Class.vtt

2.1 Source code - Class Autoloading - Convert the url Include into a Class.html

3. Autoloading Classes Require Class Files Automatically.mp4

3. Autoloading Classes Require Class Files Automatically.vtt

3.1 Source code - Class Autoloading - Autoloading Classes Require Class Files Automatically.html

3.2 PHP spl_autoload_register.html

4. Add an Initialisation Script Including an Autoloader.mp4

4. Add an Initialisation Script Including an Autoloader.vtt

4.1 Source code - Class Autoloading - Add an Initialisation Script Including an Autoloader.html

5. Returning a Value Using Require Add a Script to get the Database Connection.mp4

5. Returning a Value Using Require Add a Script to get the Database Connection.vtt

5.1 PHP include.html

5.2 Source code - Class Autoloading - Returning a Value Using Require Add a Script to get the Database Connection.html

/20. Site Administration/

1. Move all Authentication-related Code to the Auth Class.mp4

1. Move all Authentication-related Code to the Auth Class.vtt

1.1 Source code - Site Administration - Move all Authentication-related Code to the Auth Class.html

2. Create an Admin Index and Load Classes Relative to the site root Directory.mp4

2. Create an Admin Index and Load Classes Relative to the site root Directory.vtt

2.1 Source code - Site Administration - Create an Admin Index and Load Classes Relative to the site root Directory.html

2.2 PHP dirname.html

2.3 PHP Magic constants.html

3. Displaying Tabular Data in HTML Tables.mp4

3. Displaying Tabular Data in HTML Tables.vtt

3.1 Source code - Site Administration - Displaying Tabular Data in HTML Tables.html

3.2 DevDocs - HTMLtable.html

4. Display the Admin List of Articles in a Table and Restrict Access to the Page.mp4

4. Display the Admin List of Articles in a Table and Restrict Access to the Page.vtt

4.1 Source code - Site Administration - Display the Admin List of Articles in a Table and Restrict Access to the Page.html

5. Add Sitewide Navigation Links.mp4

5. Add Sitewide Navigation Links.vtt

5.1 Source code - Site Administration - Add Sitewide Navigation Links.html

6. Move the Edit and Delete Article Scripts to the admin Area.mp4

6. Move the Edit and Delete Article Scripts to the admin Area.vtt

6.1 Source code - Site Administration - Move the Edit and Delete Article Scripts to the admin Area.html

7. Move the New Article Script to the admin Area.mp4

7. Move the New Article Script to the admin Area.vtt

7.1 Source code - Site Administration - Move the New Article Script to the admin Area.html

8. Autoloading classes and requiring files.html

/21. Pagination/

1. Pagination Split Database Results up Into Pages.mp4

1. Pagination Split Database Results up Into Pages.vtt

2. Add a Method to the Article Class to get a Single Page of Article Records.mp4

2. Add a Method to the Article Class to get a Single Page of Article Records.vtt

2.1 Source code - Pagination - Add a Method to the Article Class to get a Single Page of Article Records.html

3. Add a Paginator Class and Calculate the offset and Limit from the Page Number.mp4

3. Add a Paginator Class and Calculate the offset and Limit from the Page Number.vtt

3.1 Source code - Pagination - Add a Paginator Class and Calculate the offset and Limit from the Page Number.html

4. Get the Page Number from the Query String.mp4

4. Get the Page Number from the Query String.vtt

4.1 PHP Ternary Operator.html

4.2 PHP Null coalescing operator.html

4.3 Source code - Pagination - Get the Page Number from the Query String.html

5. Validate the Page Number using the filter_var Function.mp4

5. Validate the Page Number using the filter_var Function.vtt

5.1 PHP Validate filters.html

5.2 Source code - Pagination - Validate the Page Number using the filter_var Function.html

5.3 PHP filter_var.html

6. Add Previous and Next Pagination Links.mp4

6. Add Previous and Next Pagination Links.vtt

6.1 Source code - Pagination - Add Previous and Next Pagination Links.html

7. Calculate the Total Number of Records and Pages.mp4

7. Calculate the Total Number of Records and Pages.vtt

7.1 COUNT - MariaDB Knowledge Base.html

7.2 PHP PDOStatementfetchColumn.html

7.3 Source code - Pagination - Calculate the Total Number of Records and Pages.html

7.4 PHP PDOquery.html

8. Add Pagination to the admin Index and Create Shared Pagination Links.mp4

8. Add Pagination to the admin Index and Create Shared Pagination Links.vtt

8.1 PHP strtok.html

8.2 PHP $_SERVER.html

8.3 Source code - Pagination - Add Pagination to the admin Index and Create Shared Pagination Links.html

9. Tables and pagination.html

/22. Uploading Files/

1. Uploading Files Add a Form to Upload an Article Image.mp4

1. Uploading Files Add a Form to Upload an Article Image.vtt

1.1 PHP $_FILES.html

1.2 DevDocs - HTML input type=file.html

1.3 BLOB Data Types - MariaDB Knowledge Base.html

1.4 Source code - Uploading Files - Uploading Files Add a Form to Upload an Article Image.html

1.5 PHP $_POST.html

2. Handle the Upload Error Code.mp4

2. Handle the Upload Error Code.vtt

2.1 Source code - Uploading Files - Handle the Upload Error Code.html

2.2 PHP File Upload Error Messages.html

3. Restrict the Size of all Uploaded Files using PHP Configuration Settings.mp4

3. Restrict the Size of all Uploaded Files using PHP Configuration Settings.vtt

3.1 PHP How to change configuration settings.html

3.2 PHP File Upload Error Messages.html

3.3 PHP display_startup_errors.html

3.4 PHP ini_set.html

3.5 Source code - Uploading Files - Restrict the Size of all Uploaded Files using PHP Configuration Settings.html

4. Restrict the Size of an Uploaded File in an Individual Form.mp4

4. Restrict the Size of an Uploaded File in an Individual Form.vtt

4.1 Source code - Uploading Files - Restrict the Size of an Uploaded File in an Individual Form.html

4.2 Does 1 MB mean 1000000 bytes, 1024000 bytes, or 1048576 bytes.html

5. Restrict the Type of an Uploaded File.mp4

5. Restrict the Type of an Uploaded File.vtt

5.1 PHP POST method uploads.html

5.2 PHP Fileinfo.html

5.3 Incomplete list of MIME types.html

5.4 Source code - Uploading Files - Restrict the Type of an Uploaded File.html

5.5 Apache files with multiple extensions.html

5.6 MIME types.html

6. Create a Folder for Uploads and Move the Uploaded File into it.mp4

6. Create a Folder for Uploads and Move the Uploaded File into it.vtt

6.1 Source code - Uploading Files - Create a Folder for Uploads and Move the Uploaded File into it.html

6.2 PHP move_uploaded_file.html

7. Sanitise the Uploaded Filename as a Security Precaution.mp4

7. Sanitise the Uploaded Filename as a Security Precaution.vtt

7.1 PHP pathinfo.html

7.2 Source code - Uploading Files - Sanitise the Uploaded Filename as a Security Precaution.html

8. Don't Overwrite Existing Files in the Uploads Folder.mp4

8. Don't Overwrite Existing Files in the Uploads Folder.vtt

8.1 Source code - Uploading Files - Don't Overwrite Existing Files in the Uploads Folder.html

8.2 PHP file_exists.html

9. Save the Filename to the Article Record in the Database.mp4

9. Save the Filename to the Article Record in the Database.vtt

9.1 PHP substr.html

9.2 Source code - Uploading Files - Save the Filename to the Article Record in the Database.html

9.3 PHP mb_substr.html

10. Display the Uploaded Image if an Article has one.mp4

10. Display the Uploaded Image if an Article has one.vtt

10.1 Source code - Uploading Files - Display the Uploaded Image if an Article has one.html

11. Delete the Previous image File when an Article Image is Updated.mp4

11. Delete the Previous image File when an Article Image is Updated.vtt

11.1 PHP unlink.html

11.2 Source code - Uploading Files - Delete the Previous image File when an Article Image is Updated.html

12. Add an Option to Delete an Article's Image file.mp4

12. Add an Option to Delete an Article's Image file.vtt

12.1 Source code - Uploading Files - Add an Option to Delete an Article's Image file.html

13. Uploading files.html

/23. Database Relationships/

1. Database Relationships Create a Table and Data for Categories.mp4

1. Database Relationships Create a Table and Data for Categories.vtt

2. One-to-one Relationships Between Tables.mp4

2. One-to-one Relationships Between Tables.vtt

3. One-to-many Relationships Between Tables.mp4

3. One-to-many Relationships Between Tables.vtt

4. Joins Selecting Data from Multiple, Related Tables at Once.mp4

4. Joins Selecting Data from Multiple, Related Tables at Once.vtt

4.1 Visual Representation of SQL Joins.html

5. Relationship Constraints.mp4

5. Relationship Constraints.vtt

5.1 MariaDB Error Codes.html

6. Many-to-many Relationships Between Tables.mp4

6. Many-to-many Relationships Between Tables.vtt

/25. JavaScript and PHP/

1. Execute Code in the Browser An Introduction to JavaScript.mp4

1. Execute Code in the Browser An Introduction to JavaScript.vtt

1.1 JavaScript MDN.html

1.2 Node.js.html

1.3 Source code - JavaScript and PHP - Execute Code in the Browser An Introduction to JavaScript.html

2. Using the jQuery Library.mp4

2. Using the jQuery Library.vtt

2.1 plainJS - The Vanilla JavaScript Repository.html

2.2 jQuery.html

2.3 Source code - JavaScript and PHP - Using the jQuery Library.html

3. Add jQuery and a Custom Script file to the CMS.mp4

3. Add jQuery and a Custom Script file to the CMS.vtt

3.1 Source code - JavaScript and PHP - Add jQuery and a Custom Script file to the CMS.html

3.2 Using jQuery with a CDN.html

4. Add Delete Confirmation Using JavaScript and POST.mp4

4. Add Delete Confirmation Using JavaScript and POST.vtt

4.1 Source code - JavaScript and PHP - Add Delete Confirmation Using JavaScript and POST.html

5. Client-side form Validation Using the jQuery Validation Plugin.mp4

5. Client-side form Validation Using the jQuery Validation Plugin.vtt

5.1 jQuery Validation Plugin.html

5.2 DevDocs - HTML required (attribute).html

5.3 DevDocs - JavaScript Date.parse.html

5.4 Source code - JavaScript and PHP - Client-side form Validation Using the jQuery Validation Plugin.html

6. An Introduction to Ajax with PHP.mp4

6. An Introduction to Ajax with PHP.vtt

6.1 jQuery deferred.done().html

6.2 Send Ajax GET and POST requests - Plain JS.html

6.3 Source code - JavaScript and PHP - An Introduction to Ajax with PHP.html

6.4 jQuery.ajax().html

7. Use JSON to Safely Encode Structured Data in an Ajax Request.mp4

7. Use JSON to Safely Encode Structured Data in an Ajax Request.vtt

7.1 JSON.html

7.2 Source code - JavaScript and PHP - Use JSON to Safely Encode Structured Data in an Ajax Request.html