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
-
Getting Started
- What The Course Covers
- Course Setup Using XAMPP
- Installing XAMPP On Windows
- Installing MAMP On The Mac
- Installing XAMPP On Linux
- Configuring PHP And MySQL
- Configuring Apache
- Using Editors And IDEs
- Saving Your Code
- Searching PHP And MySQL Documentation
- Getting Help And Verifying XAMPP Status
- Setup And Finding Course Files
- Lab: Building A New Website
- Solution: Building A New Website
-
Understanding The Basics
- Creating Variables In PHP
- Assigning Different Data Types
- Performing Arithmetic Operations
- Adding Comments To The Code
- Assigning Constant Values
- Using The printf Command To Format A String
- Understanding The substr Command
- Working With Strings
- Debugging An Application
- Lab: Mixing HTML And PHP
- Solution: Mixing HTML And PHP
-
Working With Arrays
- Working With Numeric Keys
- Working With Associative Arrays
- Assigning Values To Arrays
- Creating A Multidimensional Array
- Searching Arrays
- Sorting Arrays
- Removing Values From Arrays
- Measuring Array Differences
- Merging Arrays
- Lab: Using An Array To Generate A Drop Down Menu
- Solution: Using An Array To Generate A Drop Down Menu
- Creating Control Structures: Looping And Branching
-
Managing The Code: Functions
- Using Built-In Functions
- Creating Your Own Functions
- Returning Values
- Defining Mandatory And Optional Parameters
- Using Parameters By Reference
- Handling A Variable Number Of Parameters
- Understanding Global Variables
- Lab: Creating A Function Which Paginates Rows Of Data
- Solution: Creating A Function Which Paginates Rows Of Data
- Managing The Code: Object-Oriented Programming
- Managing The Code: External Libraries
- Managing Files
-
Managing A MySQL Database
- Understanding RDBMS Terminology
- Command Line Access
- Using phpMyAdmin
- Configuration
- Creating A Database
- Managing Tables - Part 1
- Managing Tables - Part 2
- Understanding Indexes And Relationships
- Establishing Relationships And Constraints
- Lab: Defining Tables And Relationships For A Website
- Solution: Defining Tables And Relationships For A Website
- Understanding Structured Query Language (SQL)
-
Using PHP To Interact With A MySQL Database
- Understanding The Different MySQL Database Extensions
- Reading Data From A Table
- Writing Data To A Table
- Updating Data In A Table
- Deleting Data From A Table
- Reading Data From Multiple Tables
- Lab: Display Products And Members Using PHP And MySQL
- Solution: Display Products And Members Using PHP And MySQL
-
Using Regular Expressions
- Understanding The Three Regular Expression Command Sets
- Defining Basic Patterns
- Using preg_match For Form Validation
- Finding All Matches With preg_match_all
- Using preg_replace For Intelligent Search And Replace
- Lab: Using Regular Expressions To Validate Form Data
- Solution: Using Regular Expressions To Validate Form Data
- Managing Email
- Working With Date And Time
-
Managing Web Operations
- Reading Inbound Information From Built-In Global Variables
- Handling Cookies
- Managing Sessions
- Setting Headers And Performing Redirection
- Reading Incoming Header Information
- Using Output Buffering
- Deploying An Application To A Website
- Lab: Using Cookies And Sessions To Implement A Shopping Cart
- Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 1
- Solution: Using Cookies And Sessions To Implement A Shopping Cart - Part 2
-
Building Web Forms
- Capturing Form Data
- Understanding Form Input Elements
- Working With Select Tags
- Defining Checkboxes And Radio Buttons
- Handling File Uploads
- Securing Form Data: Inbound Filtering
- Securing Form Data: Form Data Validation
- Securing Form Data: Output Escaping
- Lab: Integrating Form Data With The Database
- Solution: Integrating Form Data With The Database
- About The Author
Product information
- Title: PHP and MySQL
- Author(s):
- Release date: December 2012
- Publisher(s): Infinite Skills
- ISBN: 9781771370578
You might also like
video
Dynamic Web Design with PHP and MySQL
In this PHP - MYSQL training course you will learn how to leverage PHP and MySQL …
video
PHP and MySQL: 24-Hour Trainer
Step-by-step lessons for using PHP and MySQL in a unique book-and-video combination Assuming no previous experience …
video
PHP and MySQL (Video Training)
For every developer who wants to build production-quality applications using PHP and MySQL. In this one-of-a-kind …
video
Learn to Build Web Applications with PHP, MySQL, and JavaScript
Becoming a professional full stack web developer requires a solid understanding of the software tools most …