Training: PHP and MySQL Master the development of a dynamic and interactive website

Introduction to MySQL

This first part gives you the basic commands to administer a MySQL server. You have a full sql script that allows you to use the many examples in the book. Next are the different types of variables available with MySQL as well as user variables and system variables.

The author even explains how to create your first MySQL queries, reading information from a table, query options, updating information, deleting data, etc. You have everything you need to execute all of the simple MySQL queries, with many commented examples.

And to finish this part, you will learn how to export and import your MySQL data (backup and restore).

Use MySQL functions

In this second part, you go to a higher level with the use of MySQL functions. A very important part to simplify and speed up your dynamic websites.

In addition, you will learn the control functions, the comparison functions, the numeric functions, the character functions, the date functions, the cast and format functions, the system functions, the encryption and compression functions, the aggregate functions…

Build a database in MySQL.

The author teaches you how to create and delete a database and then manage users with their rights. You will also discover the management of tables with the different options (primary, unique keys and indexes…). You will also know how to use views and get information about your databases. Finally, there is a quick paragraph on exporting and importing a database.

Advanced techniques with MySQL

This is the most interesting part with MySQL. You will go to the next level and learn advanced techniques with MySQL.

In particular, the notions of GROUP BY, under requests, UNION, COMMIT and ROLLBACK. The author even discusses the use of regular expressions directly in your MySQL queries.

And finally, you will learn how to develop stored programs and triggers.

Introduction to PHP

And here is the rest, dedicated to the PHP language, with an introduction to PHP through several paragraphs. You will know the basic structure of a PHP page, the display of the Apache server configuration (PHP) and the basics of the language with constants, variables, data types, arrays, operators, conditions, loops, inclusion of files, script interruptions

Use PHP functions

In this part, you will manipulate constants, variables, data types, arrays, strings and dates.

The author also explains to you, how to generate a random number, a unique identifier, the manipulation of files on the server (creation, modification and deletion), the sending of mails and the usefulness of the headers (header) PHP.

Write PHP functions and classes

A really very complete part on functions and classes. An essential concept to master with the PHP language.

Through a multitude of paragraphs, the author discusses functions and classes in detail, always with many commented examples (exceptions, inheritance, abstract classes and methods, interfaces …

Handling errors in a PHP script

The author devotes several paragraphs to list the different types of errors returned by PHP and several techniques to deal with them effectively.
Manage forms and links with PHP

Forms with PHP, a vast subject, which the author explains in detail with a multitude of examples.

Everything goes there, you will know all the options of the forms (checkbox, list, radio, submit, reset …), the processing of a form and its sending directly via PHP. You will learn how to recover data transmitted via the url and the management of special characters. Depending on the type of form, you will know how to use the data entered by the user, always with PHP.

Obviously, the author teaches you how to check the validity of the data entered by the user. There are even several paragraphs with solutions on recurring problems with the recovered data. In addition, you will learn how to use filters (filter_var, filter_var_array ….), url redirection in the event of a server error and the file exchange between the Internet user and the server: the download (download) and upload (send files).

Access a MySQL database

The author explains how to access an MSQL database, the use of MySQLi and MySQL extensions. Once again, these two extensions are extremely detailed through numerous paragraphs accompanied by complete examples.

There is also a paragraph to present the extens