PHP : MySQL Initiation - Dawan.training

Goals

- Know how to develop Web sites and applications with PHP, in particular using MySQL databases

Program

PHP overview

Operating principles
The Web context
Variables
Data types at a glance
Operators
Conditional statements
A particular type: arrays
Loops, browsing arrays
Sort arrays in alphabetical order
Introduction to superglobals
Retrieving form data
Send an e-mail
Constants

Case study: online application system

Organize PHP scripts - functions

Declaration of functions
Parameters and the return statement
Creation of function libraries
Predefined functions: examples, organization, documentation
Functions for arrays, mathematics, strings, dates
Other examples of functions
How to identify the types of variables?
Uploading files: the $ _FILES variable and associated functions

Case study: improving the online application system

Discover the methods of managing the application context

Principles of interaction with the user
Form reminders
Hidden fields
Long URLs
Introduction to sessions
Secure access to the administration of applications with sessions
Presentation of cookies
Display the date of the last access to the platform administration of applications

Databases

Usefulness of databases
Presentation of PHPMyAdmin
Building a database with PHPMyAdmin
SQL under PHPMyAdmin:
– The main instructions
– Reading SQL code
– Generation of multiple queries
– Good habits: testing your queries with PHPMyAdmin
Functions for accessing the databases data
Formulation of requests in a PHP file

To go further with PHP: creation of a CMS *

Specifications and organization of development
Creation of HTML code generation libraries (without connection to databases)
Generation of pages from libraries
Creation of the database
Function for inserting pages and storage in the MySQL database
Function for modifying pages
Page deletion function
Modification of the HTML code generation libraries to link them to the database

Conclusion and assessment

* Website content management tool

Passing the certification (if provided for in the funding)

Passing of the certification (if foreseen in the financing).

Duration

3 days

Price

£ 1110

Audience

All

Prerequisites

Knowledge of HTML

Reference

PHP81-F

Sessions

Practical and functional Very pleasant and didactic. Training adapted to my level. Trainer: Very attentive to all my requests and clear answers to my questions.

If all the trainers were like Kevin, the trainings would be a total pleasure

the trainer adapted to our needs and allowed us to move forward on our issues

Good Atmosphere. The training room needs to be adapted. Very good central location. The training is too short to understand the basics. It will take more time. I would prefer to understand simpler concepts and then progress in the difficulty. We had a knowledgeable trainer

it was just a little warm in the room 🙂 Nothing to say, excellent. Exactly what I was looking for, I just regret not staying 5 days, but my startup budget did not allow it. Trainer: Once again nothing to say, excellent Despite the absence of the original trainer, the succession was more than assured. Thank you 🙂

Room a bit small, otherwise very good.

Too bad not to have had "Sublime Text" instead of "Notepad ++" to simplify the understanding of the participants thanks to a better syntax highlighting of the codes typed / seen. I find that the PHP - MySQL Initiation training over 3 days should rather be spread over 5 days, especially for people who are completely new to this field. Trainer: Very competent person, very open and attentive to participants. VERY GOOD ! (One small note: possibly avoid technical abbreviations which do not necessarily speak to participants from the start.)