PHP – basics of the language + creating and managing MySQL databases

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

Your first PHP pages - You will learn how to combine basic HTML and CSS with PHP code, so you can build simple dynamic web pages on your own and clearly understand how a web application works.

Confident script writing - You will master variables, data types, conditions, loops and arrays, which will help you write clear scripts for real tasks instead of relying on copied code snippets.

Custom functions in action - You will learn how to create functions with arguments and return values, so you can organize your code, reuse solutions efficiently and develop your own scripts much faster.

Working with data and files - You will use practical string, math, date and time functions, and learn how to read from and write to text files, giving you tools to build useful backend features.

Object-oriented basics - You will understand classes, objects, constructors, properties, methods and inheritance, making it easier for you to move into a more modern and structured PHP coding style.

Using MySQL with PHP - You will learn SQL queries and the INSERT, UPDATE, DELETE and SELECT operations, so you can build applications that store and retrieve data from a database in a structured way.

Passing data between pages - You will practice GET and POST methods, session variables and cookies, so you can build forms and mechanisms that transfer information between pages and PHP scripts.

Simple project portfolio - During the course, you will create a survey, a simple CMS and a budget app, so you finish with more than theory and gain practical examples that show your first PHP skills.

Training programme

1. Overview of key elements related to creating websites

basic HTML tags,
basic CSS tags.

2. Introduction to the basic concepts of the PHP language

variables,
constants,
data types,
conditional statements if ... elseif ... else and switch,
loops (for, do while, while, foreach),
continue statements,
break statements,
arrays.

3. Explanation of how to create your own functions in PHP

appearance,
arguments,
returning values.

4. Overview of a wide range of built-in functions in the PHP language

text,
date and time,
mathematical.

5. Discussion of ways of working with text files in PHP

reading data,
writing.

6. Introduction to object-oriented programming in PHP

class,
object,
constructor,
inheritance,
properties and methods.

7. Overview of issues related to PHP integration with the MySQL database

structured query language for database handling,
data insertion (INSERT),
data editing (updating) (UPDATE),
data deletion (DELETE),
data retrieval (SELECT),
creating simple queries.

8. Explanation of data and variable transfer mechanisms between different pages and scripts

GET method,
POST method,
session variables,
cookies,
passing variables within the service.

9. Description of practical project examples completed during the course

survey,
simple CMS,
web application „budget”.

What are the prerequisites for participating in the training?

Basic computer skills - You should be comfortable using an operating system, launching programs, saving files and working in a web browser so you can focus on learning PHP itself.

Web browser familiarity - You should know how to use a web browser, open pages, forms and links, and understand the basic way websites work before you start the course.

Logical thinking - You should be ready to analyze simple relationships, follow steps in order and look for the causes of errors, because this will make learning programming easier.

Willingness to code - You should be ready to type code on your own and test examples in practice, because the course is based on hands-on exercises rather than theory alone.