PHP : MySQL Initiation + Advanced

Logo de PHP

Goals


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

- Understanding the different methods of context management and implementing sessions and cookies

- Knowing how to handle any files in PHP

Program

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

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

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

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

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

Open a file
Close a file
Read the contents of a file
Read the contents of a file by line
Write in a file

Modification of the creation of pages to associate a file generated on the fly
Creation of an author database
Introduction to the relationship of tables in MySQL 5
Development of the add author function
Modification of the creation of pages to associate a author
Display functions for pages created by an author
Authentication of the authors on the administration
Storage of the authentication in session variables

Site and database design
Introduction to image manipulation: dynamically resizing an image
Organization of the catalog consultation interface by themes
Saving the shopping cart on a cookie
Classic and thematic search engine and pagination of results (depending on the remaining time)

* Website content management tool

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

Duration

5 days

Price

£ 1850

Audience

All

Prerequisites

Knowledge of HTML

Reference

PHP82-F

Sessions

Contact us for more informations about session date

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.
Hubert C.
Hubert C.
I appreciated that the trainer was listening to me. A well-established ease that allows you to feel at ease quickly. The trainer was able to listen to my requests and meet my expectations. Listening, funny and professional. Overall very good training.
Thomas L.
Thomas L.
Well-developed course with a real goal and practice exercises etc. Nothing to say I learned the things necessary for my evolution as a Webmaster, to be able to thus claim to become Webdeveloper. The training corresponds exactly to what I would hope. Very pedagogue, available and smiling. Very happy with the trainer. RAS
Laurent S.
Laurent S.
very interesting and well conducted training. In view of my two training sessions spent here, I would not hesitate to recommend you in my entourage for computer training;
Maxime R.
Maxime R.
The exercises follow from the previous ones which allows to have a real continuity which is very pleasant! All the points mentioned will allow me to achieve a lot of things that before this training seemed "complicated to me. First training carried out at Dawan, I am very satisfied and I would recommend without hesitation if I have the opportunity!
Julien B.
Julien B.
Trainer: Very attentive. Patient, great adaptability to the needs and expectations of each
Mickael H.
Mickael H.
Trainer: Strong technical skills. Lack of interaction with the presentation which is not present enough during the training. Otherwise very friendly and knowledgeable. Very good restaurant !!
Nicolas C.
Nicolas C.
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
Vincent R.
Vincent R.
As discussed with the trainer, I do not think I will have the opportunity to immediately apply the knowledge that I have just acquired through the training. I very much appreciated that this one offered to answer my possible questions even if it is in the rather distant future.
Laura T.
Laura T.
the course corresponded to my expectations, it allowed me to better understand the PHP language and to broaden my knowledge. very motivating to continue my programming learning. The trainer was able to carry out the training while managing the expectations, the difficulties according to the different levels of knowledge; He showed patience and understanding.
Serigné D.
Serigné D.
Précédent
Suivant