Training: PHP MySQL Fundamentals

Ref. PHP-01
Duration:
3
 days
Exam:
Not certifying
Level:
Fundamental

Description

Designed to provide beginner programmers with a solid foundation in the PHP language, this course guides you through the basics of PHP with an experiential approach. PHP Fundamentals course provides you with an overview of the PHP language, main concepts, and helps you develop and adopt the methodologies and best practices of coding professionally in PHP.

Participant profiles

  • Non programmers and beginners with less than 6-12 months of software development experience who want to learn the basics of the PHP language
  • Web designers who intend to learn the basics of professional web programming and become PHP Developers would benefit from this course

Objectives

  • Understand the syntax and structural elements of PHP
  • Know how to correctly apply the various control-flow structures
  • Understand PHP data types, type-juggling, and operator precedence
  • Organize code into reusable functions
  • Accomplish tasks using PHP’s wealth of built-in file system and array functions
  • Understand essential elements of HTTP such as cookies and sessions
  • Understand the basics of validating input and escaping output
  • Build forms to collect information from a user
  • Interact with a database using PHP’s MySQL functions

Prerequisites

  • Basic knowledge of HTML
  • Some familiarity with web sites – what they are and the very basics of how they work – but no programming experience

Course content

Module 1: Your First PHP Scripts
  • Lesson 1: Setting up your Environment
  • Lesson 2: Understand PHP development workflow
  • Lesson 3: Writing your first scripts
  • Lesson 4: Echo, print() and printf()
Module 2: Variables
  • Lesson 1: Introducing variables
  • Lesson 2: Variable operators
Module 3: Arrays
  • Lesson 1: Declaring simple PHP arrays
  • Lesson 2: Associative arrays
  • Lesson 3: Multidimensional arrays
  • Lesson 4: Super Global arrays
Module 4: Conditionals
  • Lesson 1: Simple conditionals
  • Lesson 2: Complex conditionals
  • Lesson 3: Switch/Case/Break
  • Lesson 4: Ternary cperator
Module 5: Loops
  • Lesson 1: While… Do While Loop
  • Lesson 2: For loops
  • Lesson 3: Foreach loops
Module 6: Custom PHP Functions
  • Lesson 1: Includes
  • Lesson 2: Creating a simple function
  • Lesson 3: Function arguments
  • Lesson 4: The return statement
Module 7: Server File I/O
  • Lesson 1: Saving files on the server
  • Lesson 2: Reading files on the server
  • Lesson 3: Append and delete
  • Lesson 4: CSV files
Module 8 : Sending email with PHP
  • Lesson 1: Sending text e-mail
  • Lesson 2: Sending HTML e-mail
Module 9 : Working with the mySQL Database
  • Lesson 1: Setting up the database
  • Lesson 2: Retrieving a query from the database
  • Lesson 3: Storing information in the database
  • Lesson 4: Deleting and updating database records
  • Lesson 5: Complex queries
Module 10: Useful PHP classes and objects
  • Lesson 1: Date object
  • Lesson 2: Strings in PHP
  • Lesson 3: sessions
  • Lesson 4: cookies

Documentation

  • Digital courseware included

Lab / Exercises

  • During the course participants are encouraged to actively participate in the learning experience by running example files during lectures and performing coding challenges during labs.
  • Each lab session allows you to compare your solution to the instructor’s

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 2'150.-
Inclus dans ce cours
  • Training provided by an industry expert
  • Digital documentation and materials
  • Achievement badge

lun03juil(juil 3)09:00mer05(juil 5)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun03juil(juil 3)09:00mer05(juil 5)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun07Aoû(Aoû 7)09:00mer09(Aoû 9)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun07Aoû(Aoû 7)09:00mer09(Aoû 9)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionPHP-01

lun11Sep(Sep 11)09:00mer13(Sep 13)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun11Sep(Sep 11)09:00mer13(Sep 13)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun16Oct(Oct 16)09:00mer18(Oct 18)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun16Oct(Oct 16)09:00mer18(Oct 18)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionPHP-01

lun20Nov(Nov 20)09:00mer22(Nov 22)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun20Nov(Nov 20)09:00mer22(Nov 22)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun25Déc(Déc 25)09:00mer27(Déc 27)17:00VirtuelAnnuléeVirtual Etiquettes de sessionPHP-01

lun25Déc(Déc 25)09:00mer27(Déc 27)17:00Genève, Route des Jeunes 33B, 1227 CarougeAnnulée Etiquettes de sessionPHP-01

mer27Déc(Déc 27)09:00ven29(Déc 29)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionPHP-01

mer27Déc(Déc 27)09:00ven29(Déc 29)17:00VirtuelVirtual Etiquettes de sessionPHP-01

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X