The Learn PHP Tutorial

Learn PHP Tutorial Level 2 Video

Learn PHP Tutorial Level 2 Video Picture

Watch right now!

  • Combine PHP and the MySQL database using object-oriented programming
  • Build a complete news board application from scratch with reusable components!
  • FREE!

Table of Contents

1. Introduction
  [1:56] Who uses PHP and MySQL? What type of websites can you build with it? We introduce the power and flexibility that PHP and MYSQL database provide.
 
2. PHP and databases
  [1:25] The true power of PHP can only be realized when it is coupled with a database. We introduce the INSERT and SELECT queries and explain how they work.
 
3. MySQL and phpMyAdmin
  [5:04] MySQL can be difficult to manage on its own, but phpMyAdmin makes administration of a MySQL database quick and easy!
 
4. What is a schema?
  [2:25] A "schema" is a way of defining the structure of a table in a database. We introduce this, as well as the concept of "relations" and the SQL JOIN command.
 
5. Creating a schema
  [4:28] In this chapter, we show you how to create your own database schema using phpMyAdmin.
 
6. Storing PHP information in a MySQL database
  [5:24] Now that you are a database expert, we start combining the power of the MySQL database with the flexibility of the PHP programming language, demonstrating how to store persistant data.
 
7. Retrieving PHP information from a MySQL database
  [4:57] With data stored, the next step is retrieval. This chapter shows how to read records from the database and process the information in your PHP application
 
8. Using PHP Objects
  [4:37] Object-oriented programming can be a difficult concept to grasp. We show you how to start using objects in PHP5 to speed up your programming and reduce errors.
 
9. Creating your own PHP Objects
  [3:19] Now that you know how to use objects, it's time to start creating your own! These techniques will teach you how to organize and combine data and functions to make your PHP code more manageable and robust.
 
10. Database Abstraction: PHP Data Objects (PDO)
  [4:54] The PHP Data Objects, or "PDO" library, is an excellent addition to PHP and greatly simplifies and optimizes the task of storing to and retriving data from a database such as MySQL.
 
11. PHP Sessions
  [3:12] PHP session variables allow an application to save or "persist" information between different pages. This feature makes implementing user logins and authenication much easier that it would be otherwise.
 
12. Putting it all together: News board with user login
  [10:38] Finally, we take all of our knowledge about PHP, objects, databases, MySQL, and sessions, and combine it into a fully functional News board application. The sample code includes two handy objects that can be reused in your own applications!
 
13. Conclusion and Summary
  [1:35] Wrapping up, we provide some advice and techniques, as well as helpful resources for building your new applications.
 
Syllogistic Software Inc. Logo

The fastest way to learn PHP, Guaranteed!

What's the best way to learn a new skill like PHP programming? By spending days reading a boring technical book? Or perhaps sifting through hundreds of small web tutorials - some outdated, or even just wrong. Of course not!

The best way to learn is by watching someone who really knows what they're doing, and then following their example!

Your own virtual mentor

Have you ever looked over the shoulder of an expert at work? These videos give you that same opportunity - on demand, in your home, at a coffee shop, or wherever you learn best.

Our professional trainers start with the basics, and then move through the steps at a pace you can control. Miss a key detail? Just pause or rewind as you catch up, and you're right back on track.

These videos will help you learn PHP in a tiny fraction of the time it would take reading a book or browsing online tutorials.