O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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