PHP & MYSQL TRAINING IN DOUALA

Knowing this database system is very essential for the design of dynamic websites. These are the keys to create all the functionalities of a site or applications

BECOME A WEB DEVELOPER WITH PHP & MYSQL

Who are those concerned with this training ?

This Course is for web designers, Web builders, and web developers

Requirements

General knowledge on HTML and , CSS languages are necessary

TRAINING PROGRAM

General informations and Definitions

  • Theory on Web Programming (Languages, roles, applications)
  • Features and PHP strength
  • Functionality and Architecture
  • Data Base Theory
  • Write an object-oriented PHP scripts

PHP configuration

  • Install PHP on a server
  • Installation of a local server (Wimp or EasyPHP)
  • ini configuration

PHP source code Structure

  • File inclusion in HTML code
  • PHP Tags and instructions
  • Contants & Variables
  • Data types

Processing PHP code

Use of operators

Control structure (loops, instructions, conditions)

Functions and calls in PHP

String processing and conversions

Manipulation on strings of characters

Array management (merging, processing, splitting, keys…)

Common and usual functions

Mathematical functions

Date processing with PHP

Hash function

Application exercise: creating a limited access

Form processing and superglobals

Reminders on HTML forms

Retrieving data in PHP: GET and POST methods

Sending files via PHP

Sending emails with attachments

Web environment

.htaccess file and role related to PHP

Connection parameters

HTTP request

Possible interactions (javascript, servers, etc.)

Sessions and cookies

General operation and role

Reading and writing a cookie

Creation and use of sessions

Data security

File management

Permissions and access rights

Handling and management of directories and files

Reading and writing in a file

Security and files

MySQL databases

Presentation of MySQL and PhpMyAdmin

SQL commands and database creation

Interactions between PHP and MySQL

Query processing

Error handling

Code cleanup and comments

PHP error handling

SQL error handling

Application exercises in PHP-MySQL

Creating a form processed in PHP

Creating a complex MySQL database

Creating files on the fly

Creation of an administration interface (backoffice)

Assessment and questions

General Informations

Duration : 5 days

Objective : Learn how to create Dynamic Websites connected with MYSQL data base

Number of Trainee : Single or in a group of 15 people

Place : CES CITE SIC Douala Bassa

Cost: 50.000 Frs

Teaching Methods

Course Material: Audiovisual

Class Room: Air conditioned, well equipped and performant computers

Small number of trainees: 15 trainees

A USB key containing the lessons and some bonuses giving to all the participants

Practical Exercise realized by each participant

Discover our other webmaster training courses

Wordpress

One out of three websites in the world are built using the WordPress CMS. Learn how to easily create and manage a website without learning the lines of code

Joomla

Thanks to this intuitive and fun training, you will master how to create a website with Joomla from A to Z from the installation to the referencing

HTML5-CSS3

Discover step by step the two essential programming languages to integrate text, images, videos, menu and other features in a static site

SEO

This training will allow you to understand the workings and techniques of natural referencing in order to position yourself in front of the search engines

Are you ready to start your project?

Beyond a simple estimate, our agency guides and advises you on the best way to implement your project, provides you with a detailed study and pricing information.