Php 5 + mysql for beginners

Today, dynamic sites have become the absolute standard for website development, and we will long ago supplant classic, static HTML sites.

After studying the information in this video course, you are guaranteed to be able to create your own dynamic sites, and get acquainted with the most popular bundle for programming such sites - PHP and MySQL.
-----------------
Hello. Let me introduce myself, I am Nikolay, a web programmer. I have been and am still engaged in a variety of web projects, from simple (or educational) to complex technologies and solutions. You can get acquainted with a complete list of them using my portfolio - http://web-nick.com.

All these projects are made on pure PHP 5 + MySQL, or technologies based on PHP and MySQL (CMS, frameworks). And I guarantee that if you see the entire process of website development on PHP + MySQL on your computer screen, then learning these tools is not difficult.

The disk consists of 2 large partitions:

- Theoretical part by examples (we go through the theoretical foundations of PHP by examples);
- Website development (we create, and step by step, we expand a full-fledged website on PHP + MySQL);

What is included in the theoretical part:

Required knowledge base to start the course;
Introduction to the course;
Installing Denver;
Manual installation of Apache + PHP + MySQL + phpMyAdmin;
Installing PhpED;
Writing the first script in PHP;
The question of php-file and web-page encoding is considered;
Inserting comments in PHP;
Creating and using variables in PHP;
PHP constants declaration;
All kinds of arrays in PHP;
How PHP strings are merged;
Various PHP operations;
Functions and built-in functions in PHP;
PHP if-else construction;
PHP isset-unset
Empty construct in PHP;
Switch-case construction in PHP;
PHP include-require;
Construct for organizing while & do-while loops in PHP;
Construct for organizing for loops in PHP;
Construct for organizing foreach loops in PHP;
PHP exit-die
Working with strings in single and double quotes in PHP;
The built-in function defined;
Built-in trim function;
The built-in function strlen;
Built-in functions for working with date and time;
Built-in functions for organizing site security;
Built-in functions for changing PHP settings;
Working with the @ operator;
PHP built-in $ _SERVER array;
Working with Cookies in PHP;
Large section on working with MySQL;
Working with MySQL using phpMyAdmin;
Connecting to MySQL from PHP;
PHP query function for sending queries to MySQL;
SELECT statement in MySQL;
INSERT statement in MySQL;
UPDATE statement in MySQL;
DELETE statement in MySQL;
ORDER BY clause in MySQL;
Indexes in MySQL;
DISTINCT operator in MySQL;
COUNT operator in MySQL;
MySQL security;
Section on OOP (Object Oriented Programming):
Introduction to OOP;
Creating a class & object;
The "this" keyword in OOP;
OOP access specifiers;
Class constructor;
Static members of the class;
An example of a real "inner" class;
An example of a real "independent" class;
OOP summary;

What is included in the practical part:

Two sections of website development:

Section for site users (Front-End);
Section for the site administrator;

Installation of an html template for the subsequent development of the site;
Moving a piece of content to the database;
The theory of passing parameters through the address bar of the browser;
Passing parameters using the GET method;
We make the necessary modifications to the database;
We develop the extraction of articles by category;
We develop the display of one article;
We create the structure of the site blocks;
Create a news block;
We develop a built-in search on the site;
We study the transfer of data by the POST method using the example of developing feedback;
We develop page-by-page site navigation;

Site administrator section (Back-end) .....

---------

More about the product on the site - http://php5-beginners.web-nick.com