Learn PHP Tutorial Level 2

Download Exercise Files

videos for php

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.

Download Exercise Files Level 2

Learn PHP Tutorial Level 2