docker.tar.gz

Serve /usercode

Run index.php (quiet composer install)

Serve /usercode (quiet composer install)

execute_apcu

This course is for people who have already learned the basics of PHP (or just finished the "Learn PHP from Scratch" course) and want the bigger picture of making big web applications with this language.

First, you'll learn how all PHP web applications communicate with the world and how to turn multiple source code files into one application. Then you'll learn multiple approaches to structuring the whole application. It will help you write code that's easy to maintain. Also, this is a common topic for job interview questions.

Next, you'll learn different data storage methods, from user sessions to databases. This course doesn't duplicate the official documentation but instead provides an overview of the various tools you can use. You'll learn how to use them in PHP, their tradeoffs, and how to pick what's best for your project.

Finally, you'll learn how to make automated tests for your project to ensure that it works as expected.

Developing Web Applications with PHP

There’s a standard language for writing commands and queries for relational databases. It’s called Structured Query Language (SQL). With SQL we can compose complex commands that filter data and process on the database management system-side. SQL is standard among all the relational database management systems, so we can learn it once, and it will be helpful for a long time.

SQL is a rich language with many nuances, so it’s impossible to learn it entirely in one lesson. This current lesson offers an overview of the most common features SQL provides. For specific, practical problems, it’s better to read the documentation for the database management system. Although SQL is a standard language, each RDBMS implements it differently and provides different data types and functions.

We’ll use a theater managing application as an example again. In particular, we’ll work with two tables, `plays` and `performances`.

Introduction

Communicating with the Client

Static Web Application

Structuring Code Files

Application Architecture Basics

PHP-Based Web Application

Storing State

Databases

Using a Database in the PHP Application

Testing

Testing the PHP Application

Advanced Architecture Patterns

Final Assessment

Conclusion

SQL: Managing Tables