PHP and MySQL

Video description

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.

Table of contents

  1. Getting Started
    1. What The Course Covers
    2. Course Setup Using XAMPP
    3. Installing XAMPP On Windows
    4. Installing MAMP On The Mac
    5. Installing XAMPP On Linux
    6. Configuring PHP And MySQL
    7. Configuring Apache
    8. Using Editors And IDEs
    9. Saving Your Code
    10. Searching PHP And MySQL Documentation
    11. Getting Help And Verifying XAMPP Status
    12. Setup And Finding Course Files
    13. Lab: Building A New Website
    14. Solution: Building A New Website
  2. Understanding The Basics
    1. Creating Variables In PHP
    2. Assigning Different Data Types
    3. Performing Arithmetic Operations
    4. Adding Comments To The Code
    5. Assigning Constant Values
    6. Using The printf Command To Format A String
    7. Understanding The substr Command
    8. Working With Strings
    9. Debugging An Application
    10. Lab: Mixing HTML And PHP
    11. Solution: Mixing HTML And PHP
  3. Working With Arrays
    1. Working With Numeric Keys
    2. Working With Associative Arrays
    3. Assigning Values To Arrays
    4. Creating A Multidimensional Array
    5. Searching Arrays
    6. Sorting Arrays
    7. Removing Values From Arrays
    8. Measuring Array Differences
    9. Merging Arrays
    10. Lab: Using An Array To Generate A Drop Down Menu
    11. Solution: Using An Array To Generate A Drop Down Menu
  4. Creating Control Structures: Looping And Branching
    1. Comparing Values
    2. Using if, else, And elseif
    3. Using switch
    4. Setting Up A for Loop
    5. Configuring while And do while Loops
    6. Using A foreach Loop
    7. Branching With continue, break, And goto
    8. Lab: Using Loops To Display Rows Of Data On A Web Page
    9. Solution: Using Loops To Display Rows Of Data On A Web Page
  5. Managing The Code: Functions
    1. Using Built-In Functions
    2. Creating Your Own Functions
    3. Returning Values
    4. Defining Mandatory And Optional Parameters
    5. Using Parameters By Reference
    6. Handling A Variable Number Of Parameters
    7. Understanding Global Variables
    8. Lab: Creating A Function Which Paginates Rows Of Data
    9. Solution: Creating A Function Which Paginates Rows Of Data
  6. Managing The Code: Object-Oriented Programming
    1. Defining Classes
    2. Adding Properties
    3. Creating Methods
    4. Determining The Visibility Level
    5. Building Classes By Inheritance
    6. Handling Exceptions
    7. Introducing The MVC (Model-View-Controller) Design Pattern
    8. Lab: Building An MVC Website Using OOP
    9. Solution: Building An MVC Website Using OOP
  7. Managing The Code: External Libraries
    1. Loading Code With include
    2. Loading Code With require
    3. Loading Code Once Only
    4. PHP Extensions And PECL
    5. PHP Libraries And PEAR
    6. Lab: Downloading An External Library
    7. Solution: Downloading An External Library
  8. Managing Files
    1. Using The f* Family
    2. Using The *file* Family
    3. Understanding Streams
    4. Updating The Error_Log
    5. Parsing Directory Structures
    6. Lab: Reading A CSV File
    7. Solution: Reading A CSV File
  9. Managing A MySQL Database
    1. Understanding RDBMS Terminology
    2. Command Line Access
    3. Using phpMyAdmin
    4. Configuration
    5. Creating A Database
    6. Managing Tables - Part 1
    7. Managing Tables - Part 2
    8. Understanding Indexes And Relationships
    9. Establishing Relationships And Constraints
    10. Lab: Defining Tables And Relationships For A Website
    11. Solution: Defining Tables And Relationships For A Website
  10. Understanding Structured Query Language (SQL)
    1. Retrieving Data Using SELECT
    2. Adding Data Using INSERT
    3. Editing Data Using UPDATE
    4. Removing Data Using DELETE
    5. Performing Advanced Queries Using JOIN
    6. Lab: Creating Select, Insert, Update, And Delete SQL Statements
    7. Solution: Creating Select, Insert, Update, And Delete SQL Statements
  11. Using PHP To Interact With A MySQL Database
    1. Understanding The Different MySQL Database Extensions
    2. Reading Data From A Table
    3. Writing Data To A Table
    4. Updating Data In A Table
    5. Deleting Data From A Table
    6. Reading Data From Multiple Tables
    7. Lab: Display Products And Members Using PHP And MySQL
    8. Solution: Display Products And Members Using PHP And MySQL
  12. Using Regular Expressions
    1. Understanding The Three Regular Expression Command Sets
    2. Defining Basic Patterns
    3. Using preg_match For Form Validation
    4. Finding All Matches With preg_match_all
    5. Using preg_replace For Intelligent Search And Replace
    6. Lab: Using Regular Expressions To Validate Form Data
    7. Solution: Using Regular Expressions To Validate Form Data
  13. Managing Email
    1. Sending Mail Using mail
    2. Using External Mail Libraries
    3. Adding An Attachment To Email
    4. Sending Email Using SMTP
    5. Lab: Using PHP To Send A Confirmation Email
    6. Solution: Using PHP To Send A Confirmation Email
  14. Working With Date And Time
    1. Understanding Timestamps
    2. Using The date Command
    3. Using The DateTime Class
    4. Performing Date Arithmetic
    5. Lab: Capturing Date Of Birth Using DateTime
    6. Solution: Capturing Date Of Birth Using DateTime
  15. Managing Web Operations
    1. Reading Inbound Information From Built-In Global Variables
    2. Handling Cookies
    3. Managing Sessions
    4. Setting Headers And Performing Redirection
    5. Reading Incoming Header Information
    6. Using Output Buffering
    7. Deploying An Application To A Website
    8. Lab: Using Cookies And Sessions To Implement A Shopping Cart
    9. Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 1
    10. Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 2
  16. Building Web Forms
    1. Capturing Form Data
    2. Understanding Form Input Elements
    3. Working With Select Tags
    4. Defining Checkboxes And Radio Buttons
    5. Handling File Uploads
    6. Securing Form Data: Inbound Filtering
    7. Securing Form Data: Form Data Validation
    8. Securing Form Data: Output Escaping
    9. Lab: Integrating Form Data With The Database
    10. Solution: Integrating Form Data With The Database
  17. About The Author
    1. About The Author

Product information

  • Title: PHP and MySQL
  • Author(s):
  • Release date: December 2012
  • Publisher(s): Infinite Skills
  • ISBN: 9781771370578