Course PHP/MySQL

Interactive PHP/MySQL Course

Master PHP and MySQL from the ground up! This online course comprehensively covers essential topics in the PHP programming language. Through PHP lessons, you will gain insights into object-oriented programming, variables, arrays, and much more.

4.8(518 reviews)
Start course

Preview first lesson free

  • 69 lessons
  • 37 videos

This course includes

  • Certificate on completion

What you'll learn

This is a PHP and MySQL programming course for beginners. You will learn how to effectively learn the basics of PHP and learn how to create professional websites from scratch.

In PHP lessons you will learn:

  • How to configure a web server to work with PHP and databases
  • How to install XAMPP for Windows, OSX (MacOS)
  • How to manage databases using PHPMYADMIN
  • Basics of designing a MySQL database structure for your website
  • How to work with files using PHP
  • How to read data from XML/JSON files, process and automatically add data to the database
  • What is GET, POST, PUT, HEAD, DELETE, PATCH, OPTIONS
  • How to embed PHP scripts in an HTML page
  • Basic methods of protecting your website from hacking
  • What are arrays for, types of arrays and how to work with them
  • What are variables and constants
  • What are loops and how to use loops in your programs
  • How to use built-in functions in PHP
  • How to convert strings using PHP
  • What is polymorphism, encapsulation, inheritance and OOP
  • How to work with MySQL, MariaDB databases
  • Why do you need the SQL query language and how to build SQL queries

And this is only a small part of what you will learn by taking PHP lessons. You can find out more about the PHP training plan below. Please note that PHP/MySQL is a theoretical course, without which knowledge it will be difficult for you to master PHP frameworks such as Codeigniter, Laravel, Yii2 and others.



Interactive training in PHP and MySQL will help you most effectively master the programming language from scratch. After completing the theoretical PHP/MySQL course, we recommend moving on to the course Linux /GIT/Hosting.

Course curriculum

37 videos · 32 interactive lessons

Module 1 — Installing PHP and Setting Up the XAMPP Web Server
2 lessons
1▶️Installing and Configuring XAMPP for Windows16:28Free2▶️Installing and Configuring XAMPP-VM for Mac18:47Free
Module 2 — Variables and Constants
9 lessons
3▶️Variables in PHP6:44Free4❓Quiz: PHP Variable Names0:15Free5❓Quiz: Creating a Variable0:15Free6💻PHP Variables2:00Free7💻PHP Variables and HTML2:00Free8▶️Variable Types and Constants2:58Free9❓Quiz: PHP Types (1)0:10Free10❓Quiz: PHP Types (2)0:10Free11💻Constants3:00Free
Module 3 — Conditional Operators and Branching
8 lessons
12▶️Branching. The if/else Conditional Operators6:29Free13❓Quiz: if/else (Part 1)0:15Free14💻Conditional Operators. If/Else2:00Free15❓Quiz: if/else (Part 2)1:00Free16▶️Branching. Conditional Operators. Switch7:37Free17❓Quiz: if/else vs switch0:15Free18❓Quiz: switch default0:15Free19💻The switch Conditional Operator2:00Free
Module 4 — Loops
7 lessons
20▶️Loops in PHP. The while Loop5:03Free21❓Quiz: The while Loop0:15Free22💻The While Loop1:00Free23▶️The DO WHILE Loop2:3624❓Quiz: The DO WHILE Loop0:1525▶️The FOR Loop1:3726❓Quiz: Incrementing $i0:15
Module 5 — Arrays and Array Functions
17 lessons
27▶️Arrays in PHP7:4828💻Arrays in PHP. The count() Function and Loops3:0029▶️Arrays in PHP. The Foreach Loop4:3430💻Arrays in PHP. The FOREACH Loop3:0031▶️Arrays. Ways to Create Arrays in PHP3:4132❓Quiz: Array Keys0:1533▶️Array Functions6:4634❓Quiz: array_push0:1535❓Quiz: shuffle0:1536❓Quiz: array_unique0:1537💻Array Functions. Unique Array Elements2:0038💻Array Functions. Inserting Elements into an Array2:0039▶️The implode and explode Functions7:2440💻The implode and explode Functions2:0041❓Quiz: implode0:1542▶️Multidimensional Arrays in PHP8:1243▶️Multidimensional Arrays. Ways to Create Them3:42
Module 6 — Functions and Creating Your Own Functions
9 lessons
44▶️Getting Data from an HTML Form. The GET and POST Methods11:2845❓Quiz: The action Attribute in an HTML Form0:1546❓Quiz: The GET and POST Methods0:1547▶️String Functions. Protecting Your Website Form9:2148❓Quiz: The trim Function0:1549❓Quiz: The htmlspecialchars Function0:1550▶️Creating Your Own Functions. Validating with Functions7:3351❓Quiz: The is_numeric() Function0:1552▶️Functions. Interaction Between Functions5:13
Module 7 — The SQL Language and Working with Databases
8 lessons
53▶️MySQL and phpMyAdmin. Getting Started9:5354▶️Reading Data from MySQL. The SELECT Statement14:3555▶️Inserting Data into MySQL. The INSERT Statement4:5956▶️Updating Data in a MySQL Table. The UPDATE Statement2:3957▶️Deleting Data from a MySQL Table. The DELETE Statement5:4758▶️Database Design. Storing Data in Separate Tables8:0159▶️SQL Queries. INNER JOIN5:0260▶️SQL Queries. LEFT JOIN and RIGHT JOIN4:33
Module 8 — Working with XML and Files
4 lessons
61▶️Working with XML. Reading XML and Outputting It to the Browser as an Array7:3962▶️Working with XML. Creating a Function to Write XML Data into MySQL11:5163▶️Working with XML. Writing XML Data into the Database16:3264▶️Working with Files Using PHP16:12
Module 9 — Object-Oriented Programming (OOP)
5 lessons
65▶️OOP. Classes, Getters and Setters10:4966▶️OOP. Encapsulation4:3167▶️OOP. Inheritance15:0568▶️OOP. Polymorphism. Interfaces7:3169▶️OOP. Polymorphism. Abstract Classes16:15

Reviews (518)

4.8

Reviews from students

P
Pavel Didenko
April 2023

Нормально, но довольно поверхностно. Даёт представление о языке PHP, как с ним работать и как использовать SQL для сайта.

D
Danylo Tyshkul
March 2023

Прекрасный курс

Я
Ядыгар Эрешов
February 2023

Курс отличный блогодаря преподавателю, как всегда все четко и ясно без лишней воды!

O
Oksana Buzhovych
February 2023

Не сильно сподобався курс, для людини яка має загальне уявлення в роботі з mysql занадто скучно. Також хотілось би щоб не просто писали код з функціями і виводили якесь число (результат функції) а оті всі функції показувати на прикладі інтеграції в сам сайт. Як показує практика на прикладі такого можна було би краще засвоювати матеріал, бачити де можна використовувати ті чи інші функції у сайтах.

Frequently asked questions

How is the training going?

The training is divided into video lectures, interactive tasks and tests. In video lectures you receive theoretical material and, with the help of interactive tasks, reinforce the theory in practice. You write code directly in the browser and instantly get the result of checking your code - whether it is correct or not. Almost every lesson has links to additional materials and source code.

When does the training start? Do I need to wait for the group to be full?

Immediately after payment, you will receive full access to this course without any delay.

Will I receive a certificate after completing the course?

Yes! For successful completion of each course, you will receive a certificate. All certificates received for courses can be found in your profile.

Why is the price so low?

One of the missions of the FructCode project is to make expensive IT education accessible to everyone!

Are the courses up-to-date?

Yes! Courses on the FructCode platform are updated quite often, including source codes. Please note that courses marked as 'DEPRECATED' are not updated.

What equipment is needed to take the course?

You can access FructCode courses on any operating system, including Windows, Mac OS, or Linux, as well as on mobile devices. For the best experience, we recommend using a monitor with a screen resolution of at least 1920x1080.

What should I do if I face difficulties during a task in training?

If you encounter difficulties while working on an assignment during the course, or if you have a question about the course content, feel free to reach out in the FructCode community at https://fructcode.com/en/qa/. Other students who have successfully tackled the same assignment will be there to assist you.

What is XP and why is it needed?

XP stands for 'experience' and is earned by successfully completing tasks. The more XP you accumulate, the more experienced you become in programming.

How can I participate in the rating?

The overall rating encompasses all actively engaged users in the training program. It is updated once daily.

I found your courses on other sites. Is there a difference in where I study?

Yes! Only on FructCode.com can you access the latest versions of my courses. On other sites, you might find pirated, older, or outdated versions, which may lead to errors due to changes in programming. When you purchase my courses on FructCode.com, you're not just investing in your knowledge, but also supporting the creation of new courses.

What if the course is not suitable for me or I don't like it?

You have a 14-day right of withdrawal from the date of purchase. A refund can be issued if you have not yet completed 3 or more lessons, earned 100 or more XP, or waived your right of withdrawal by opting into immediate access at checkout. To request one, contact support at info@fructcode.com — see our Terms of Use for the full policy.

What should I do if my video lecture doesn't work or the assignment doesn't open?

The most common reason for this issue is the presence of browser extensions like Adblock. If you encounter a technical problem, please reach out to our support team at info@fructcode.com, and we'll do our best to assist you promptly.

If I still have questions regarding the course, who should I reach out to?

If you have any further questions about FructCode courses, please reach out to our support team at info@fructcode.com, and we will do our best to respond as promptly as possible.

Your instructor

Sergei Nikonov
Sergei Nikonov
  • Founder of the FructCode project
  • Boasts over 15 years of expertise in web development
  • Worked in large companies in the USA and Europe on high-load web projects
  • Led numerous in-person and online seminars on web development