Web Applications for Everybody

Explore a comprehensive web development course covering PHP, SQL, and JavaScript. Begin with PHP and SQL installation, then delve into structured query language basics and database design. Progress through dynamic web content creation, PHP fundamentals, arrays, functions, forms, and object-oriented programming. Learn to connect PHP with MySQL using PDO, manage sessions, and build a complete CRUD application. Transition to JavaScript, exploring its object-oriented features and the jQuery library. Examine JSON for data exchange and Handlebars for client-side templating. Conclude with advanced SQL topics and transactions, equipping you with essential skills for modern web application development.

1: Installing PHP and SQL

The first task is to work through the installation steps including installing a text editor, install ...

2: Introduction to Structured Query Language (SQL)

We learn about single table queries and the basic syntax of the SQL language.

3: Database Design

Covering database design with multiple tables, foreign keys, and the JOIN operation..

4: Introduction to Dynamic Web Content

We look at the basic structure of a web application and how a web browser interacts with a web serve ...

5: Introduction to PHP

We begin learning PHP.

6: Overview of PHP Language

We begin the syntax of the PHP language, control structures, and expressions.

7: PHP Arrays

We look at arrays and superglobals like $_GET in PHP language.

8: PHP Functions

We look at functions in PHP language.

9: PHP Forms

We look at how HTML forms are created and processed in the PHP language.

10: PHP Objects

We look at the object oriented pattern in the PHP language.

11: PHP and MySQL

We look at how we connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL com ...

12: PHP Sessions

We look at how PHP uses cookies and manages session data. We also look at how we properly handle PO ...

13: Building a CRUD Application

Now we buid our first 'complete' application that has multiple screens to Create, Read, Update and D ...

14: Basic JavaScript

We talk a quick look at the JavaScript language. We assume that you already know PHP - so it is a p ...

15: JavaScript Objects

We do a quick look at how the JavaScript language supports the Object-Oriented pattern.

16: JQuery

This is a brief introduction to the JQuery library which is widely used to do in-browser manipulatio ...

17: JSON - JavaScipt Object Notation

In this section we look at JavaScript Object Notation (JSON). JSON is commonly used as a syntax to ...

18: Handlebars UI Templates

In this section we look at moving the templates to build HTML fragments from the server (PHP) in to ...

19: Advanced SQL

This section covers some advanced SQL topics.

20: SQL Transactions

This section covers SQL transactions.