PHP with MySQL Beyond the Basics

with Kevin Skoglund
please wait ...
PHP with MySQL Beyond the Basics
Video duration: 0s 10h 26m Intermediate Updated Mar 18, 2015


In PHP with MySQL Beyond the Basics, expert instructor Kevin Skoglund introduces powerful PHP programming techniques using object-oriented programming (OOP). Both novice and experienced PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that OOP offers. Kevin shows how OOP techniques can streamline database queries, help manage sessions, and simplify user logins. While building a real-world web application, Kevin also includes practical advice on topics ranging from structuring code to logging user actions. Exercise files accompany the course.

Topics include:
  • Defining and using classes, methods, and attributes
  • Understanding class inheritance and access modifiers
  • Working with files and directories
  • Uploading files to a server via forms
  • Sending emails with PHP
  • Using pagination and View templates
Business Developer Web


Welcome to PHP with MySQL Beyond the Basics. My name is Kevin Skoglund and I run a web development company called Nova Fabrica that develops websites and database driven applications. This tutorial is the sequel to PHP with MySQL Essential Training and I'm going to assume that you either watch that training or that you already feel comfortable with the fundamentals of PHP, MySQL and how to use them together to create pages that interact with databases. In this tutorial, we're going to build on those essential training skills, to learn how to use PHP and MySQL in object oriented programming.

Object oriented programming or OOP is a large and important subject that will get most of our attention. We'll also discover some intermediate PHP techniques like working with the server's file system, uploading files and sending emails. Now, it's not just theory either. In this tutorial, we'll build a complete PHP project using all of these techniques so that you can see the concepts in action and get some experience using them in real world situations. Now because you aren't a beginner anymore, there will be times when I ask you to do some basic coding on your own but it shouldn't be anything that you can't handle. That way, we'll be able to keep our focus on the techniques that are new.

So, I'll assume that you already know the basics like making sure that an integer is actually an integer or checking an array is not empty before you try to loop through it. At the end of the tutorial, we'll have the skeleton of a working web application but one that still needs improvements and testing using skills that you already have. Enough with the introductions though. Let's get started learning more about PHP and MySQL.

Find answers to the most frequently asked questions about PHP with MySQL Beyond the Basics .

Expand all | Collapse all
please wait ...
Q: When I try to launch phpMyAdmin in WAMP, I get the following error: 
#1045 - Access denied for user 'root'@'localhost' (using password: NO). 
How can I fix this problem?
A: The error is telling you that MySQL wants a password. (Not WAMP or  PHP.) You will need to configure phpMyAdmin to send MySQL the correct 
password ("using password: NO" indicates that you are not sending any right now). The phpMyAdmin setup is shown in the tutorial and the online 
documentation can help if you get stuck:

Q: This course was updated on 03/19/2015. What changed?
A: We updated several movies to use the newer MySQL database adapter (mysqli) and added a new movie on late static binding in chapter six, "Foundations of an OOP Project."
please wait ...