Learning PHP MySQL Training Video

expand all / collapse all

• 00. Free Videos From This Course

  • What The Course Covers
  • About The Author
  • Working With Strings
  • Sorting Arrays
  • Using if, else, And elseif
  • Determining The Visibility Level
  • PHP Extensions And PECL
  • Using phpMyAdmin
  • Adding Data Using INSERT
  • Writing Data To A Table
  • Defining Basic Patterns
  • Sending Mail Using mail
  • Understanding Timestamps
  • Handling Cookies

• 01. Getting Started

  • 0101 What The Course Covers
  • 0102 Course Setup Using XAMPP
  • 0103 Installing XAMPP On Windows
  • 0104 Installing MAMP On The Mac
  • 0105 Installing XAMPP On Linux
  • 0106 Configuring PHP And MySQL
  • 0107 Configuring Apache
  • 0108 Using Editors And IDEs
  • 0109 Saving Your Code
  • 0110 Searching PHP And MySQL Documentation
  • 0111 Getting Help And Verifying XAMPP Status
  • 0112 Setup And Finding Course Files
  • 0113 Lab: Building A New Website
  • 0114 Solution: Building A New Website

• 02. Understanding The Basics

  • 0201 Creating Variables In PHP
  • 0202 Assigning Different Data Types
  • 0203 Performing Arithmetic Operations
  • 0204 Adding Comments To The Code
  • 0205 Assigning Constant Values
  • 0206 Using The printf Command To Format A String
  • 0207 Understanding The substr Command
  • 0208 Working With Strings
  • 0209 Debugging An Application
  • 0210 Lab: Mixing HTML And PHP
  • 0211 Solution: Mixing HTML And PHP

• 03. Working With Arrays

  • 0301 Working With Numeric Keys
  • 0302 Working With Associative Arrays
  • 0303 Assigning Values To Arrays
  • 0304 Creating A Multidimensional Array
  • 0305 Searching Arrays
  • 0306 Sorting Arrays
  • 0307 Removing Values From Arrays
  • 0308 Measuring Array Differences
  • 0309 Merging Arrays
  • 0310 Lab: Using An Array To Generate A Drop Down Menu
  • 0311 Solution: Using An Array To Generate A Drop Down Menu

• 04. Creating Control Structures: Looping And Branching

  • 0401 Comparing Values
  • 0402 Using if, else, And elseif
  • 0403 Using switch
  • 0404 Setting Up A for Loop
  • 0405 Configuring while And do while Loops
  • 0406 Using A foreach Loop
  • 0407 Branching With continue, break, And goto
  • 0408 Lab: Using Loops To Display Rows Of Data On A Web Page
  • 0409 Solution: Using Loops To Display Rows Of Data On A Web Page

• 05. Managing The Code: Functions

  • 0501 Using Built-In Functions
  • 0502 Creating Your Own Functions
  • 0503 Returning Values
  • 0504 Defining Mandatory And Optional Parameters
  • 0505 Using Parameters By Reference
  • 0506 Handling A Variable Number Of Parameters
  • 0507 Understanding Global Variables
  • 0508 Lab: Creating A Function Which Paginates Rows Of Data
  • 0509 Solution: Creating A Function Which Paginates Rows Of Data

• 06. Managing The Code: Object-Oriented Programming

  • 0601 Defining Classes
  • 0602 Adding Properties
  • 0603 Creating Methods
  • 0604 Determining The Visibility Level
  • 0605 Building Classes By Inheritance
  • 0606 Handling Exceptions
  • 0607 Introducing The MVC (Model-View-Controller) Design Pattern
  • 0608 Lab: Building An MVC Website Using OOP
  • 0609 Solution: Building An MVC Website Using OOP

• 07. Managing The Code: External Libraries

  • 0701 Loading Code With include
  • 0702 Loading Code With require
  • 0703 Loading Code Once Only
  • 0704 PHP Extensions And PECL
  • 0705 PHP Libraries And PEAR
  • 0706 Lab: Downloading An External Library
  • 0707 Solution: Downloading An External Library

• 08. Managing Files

  • 0801 Using The f* Family
  • 0802 Using The *file* Family
  • 0803 Understanding Streams
  • 0804 Updating The Error_Log
  • 0805 Parsing Directory Structures
  • 0806 Lab: Reading A CSV File
  • 0807 Solution: Reading A CSV File

• 09. Managing A MySQL Database

  • 0901 Understanding RDBMS Terminology
  • 0902 Command Line Access
  • 0903 Using phpMyAdmin
  • 0904 Configuration
  • 0905 Creating A Database
  • 0906 Managing Tables - Part 1
  • 0907 Managing Tables - Part 2
  • 0908 Understanding Indexes And Relationships
  • 0909 Establishing Relationships And Constraints
  • 0910 Lab: Defining Tables And Relationships For A Website
  • 0911 Solution: Defining Tables And Relationships For A Website

• 10. Understanding Structured Query Language (SQL)

  • 1001 Retrieving Data Using SELECT
  • 1002 Adding Data Using INSERT
  • 1003 Editing Data Using UPDATE
  • 1004 Removing Data Using DELETE
  • 1005 Performing Advanced Queries Using JOIN
  • 1006 Lab: Creating Select, Insert, Update, And Delete SQL Statements
  • 1007 Solution: Creating Select, Insert, Update, And Delete SQL Statements

• 11. Using PHP To Interact With A MySQL Database

  • 1101 Understanding The Different MySQL Database Extensions
  • 1102 Reading Data From A Table
  • 1103 Writing Data To A Table
  • 1104 Updating Data In A Table
  • 1105 Deleting Data From A Table
  • 1106 Reading Data From Multiple Tables
  • 1107 Lab: Display Products And Members Using PHP And MySQL
  • 1108 Solution: Display Products And Members Using PHP And MySQL

• 12. Using Regular Expressions

  • 1201 Understanding The Three Regular Expression Command Sets
  • 1202 Defining Basic Patterns
  • 1203 Using preg_match For Form Validation
  • 1204 Finding All Matches With preg_match_all
  • 1205 Using preg_replace For Intelligent Search And Replace
  • 1206 Lab: Using Regular Expressions To Validate Form Data
  • 1207 Solution: Using Regular Expressions To Validate Form Data

• 13. Managing Email

  • 1301 Sending Mail Using mail
  • 1302 Using External Mail Libraries
  • 1303 Adding An Attachment To Email
  • 1304 Sending Email Using SMTP
  • 1305 Lab: Using PHP To Send A Confirmation Email
  • 1306 Solution: Using PHP To Send A Confirmation Email

• 14. Working With Date And Time

  • 1401 Understanding Timestamps
  • 1402 Using The date Command
  • 1403 Using The DateTime Class
  • 1404 Performing Date Arithmetic
  • 1405 Lab: Capturing Date Of Birth Using DateTime
  • 1406 Solution: Capturing Date Of Birth Using DateTime

• 15. Managing Web Operations

  • 1501 Reading Inbound Information From Built-In Global Variables
  • 1502 Handling Cookies
  • 1503 Managing Sessions
  • 1504 Setting Headers And Performing Redirection
  • 1505 Reading Incoming Header Information
  • 1506 Using Output Buffering
  • 1507 Deploying An Application To A Website
  • 1508 Lab: Using Cookies And Sessions To Implement A Shopping Cart
  • 1509 Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 1
  • 1510 Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 2

• 16. Building Web Forms

  • 1601 Capturing Form Data
  • 1602 Understanding Form Input Elements
  • 1603 Working With Select Tags
  • 1604 Defining Checkboxes And Radio Buttons
  • 1605 Handling File Uploads
  • 1606 Securing Form Data: Inbound Filtering
  • 1607 Securing Form Data: Form Data Validation
  • 1608 Securing Form Data: Output Escaping
  • 1609 Lab: Integrating Form Data With The Database
  • 1610 Solution: Integrating Form Data With The Database

• 17. About The Author

  • 1701 About The Author

In this video training title from Doug Bierer, you will learn the fundamentals of PHP and MySQL. These two platforms have been virtually inseparable for many years, and major groundbreaking websites such as WordPress, Wikipedia, and Facebook use PHP and MySQL technologies.

This computer software training is designed for the beginner; no previous programming or database experience is required. Your training begins with the absolute basics, covering topics such as creating variables, working with data types and outputting them to a webpage. You will learn how to work with arrays, how to use loops and control structures such as foreach, while and if. You will learn about functions and creating classes for object-oriented programming. You will master interacting with MySQL and using SQL functions to store and retrieve data. Doug also provides in-depth lessons on how PHP and MySQL can be used to send email, work with date and time functions, use cookies and sessions, building web forms, and much more.

Throughout this training course you will complete labs that re-enforce the concepts you have learnt. Once you have completed this video tutorial you will be well versed in the fundamentals of creating web applications using PHP and MySQL. Working files are included, allowing you to follow along with the author throughout the lessons.