PHP & MySQL course for absolute beginners | Become a PHP pro

Learn the absolute basics about PHP from scratch and take your skills to another level
Rating: 4.4 out of 5 (275 ratings)
12,005 students
PHP & MySQL course for absolute beginners | Become a PHP pro
Rating: 4.4 out of 5 (275 ratings)
12,005 students
You will learn how to download and install PHP and MySQL tools.
You will learn how to work between a user interface and a database back-end that stores critical information.
You will learn to work with the most used data types.
You will learn what operators are.
How to use conditional statements, while loops, do while loops, for loops, foreach loops.
You will learn why you should use functions.
You will learn the basic build-in functions.
You will learn the most important superglobals.
You will learn how to create a working file upload system.
You will learn how to create a working contact form.
How to use forms to submit data to databases.
You will learn how to use databases.
You will learn MySQL Queries.
Password hashing.
Error handling.
You will learn why you should use prepared statements.
You will learn how to create a login/register script.
And way more...

Requirements

  • Basic HTML (I will be discussing most of the stuff that we need).
  • No programming experience at all.
  • A working computer/laptop.
Description

Welcome to the course ‘PHP For Beginners’ In this course we will go step by step to digest all the basics topics in PHP, so if you are looking for a quick and understandable way to become a master in PHP, this is a perfect course to start with. Most of the sections will have programming exercises and at the end of every section, I will be making the exercises to show you the solutions! The reason why I think it’s important to make the exercises is because you can only learn PHP by DOING IT!

We will also be looking at the basics of MySQL Database since the final section of this course is inserting data in a table, then we will be outputting the data from the table in the browser, and then we will be creating our own login and register script!

In the beginning years when I started programming, I came across so many videos and tutorials where tutors would’ve just create the code without explaining it and I always wondered “why are you doing it this way”? Therefore, I try to give you examples why you should use this method instead of another method and I try to give you real life examples.

This course is created in a logical order to make you a PHP hero in on time! The course has been divided into the following main sections:

1. Introduction

2. Variables and Data Types

3. Operators in PHP

4. Control structures

5. Functions in PHP

6. Build-in functions in PHP

7. How to work with superglobals in PHP

8. Introduction to databases

9. Using a database to create a register/login script

Why you should learn PHP

Anything that you can do on a web server, you can do with PHP. Do you read blogs? Well, blogs are created in PHP! Do you order stuff online? Well, that’s also created with PHP! What I’m trying to say it: PHP IS EVERYWHERE!

Who this course is for:
  • Students that want to learn PHP and MySQL
Course content
9 sections • 70 lectures • 7h 37m total length
  • Course overview
    04:34
  • Installing XAMPP on Mac
    06:00
  • Installing a free code editor (Optional)
    06:21
  • PHP code in HTML
    02:41
  • Phpinfo
    03:27
  • Using Echo statement in PHP
    03:55
  • Using Print statement in PHP
    01:43
  • Adding comments in PHP
    03:43
  • Line break
    04:42
  • Variables in PHP
    06:29
  • Multiple ways to add variables in echo/print
    05:17
  • Data types
    04:22
  • Arrays
    07:56
  • Associative arrays
    04:51
  • Multidimensional arrays
    06:17
  • Solutions exercises data types
    17:36
  • Arithmetic operators
    04:03
  • Assignment operators
    04:16
  • Comparison operators
    06:39
  • Logical operators
    05:46
  • Increment and decrement operators
    03:20
  • Conditional statement
    07:12
  • Switch statement
    04:04
  • While loop
    02:53
  • Do-while loop
    03:54
  • For loop
    07:28
  • Foreach loop
    04:33
  • Solutions control structures
    17:22
  • Introduction to functions
    04:00
  • Creating our first function
    03:57
  • Functions with arguments/parameters
    04:44
  • Functions with return value
    07:00
  • Global and local scope in PHP
    02:28
  • Constants
    05:30
  • Including documents
    09:26
  • Requiring documents
    02:49
  • Solutions function exercises
    14:42
  • Introduction to build-in functions
    02:56
  • Math build-in functions
    03:08
  • String build-in functions
    07:12
  • Array build-in functions
    08:07
  • Date and time build-in functions
    10:54
  • Random number build-in function
    02:38
  • Solution build-in functions
    11:53
  • Introduction to superglobals
    05:11
  • Superglobal 'Post' in PHP
    04:38
  • Superglobal 'Get' in PHP
    03:36
  • Superglobal 'Session' in PHP
    04:40
  • Superglobal 'Cookie' in PHP
    05:44
  • Superglobal 'Files' in PHP
    07:46
  • How to create a working upload system
    16:59
  • Create and write to a file
    08:53
  • How to read from a file
    04:39
  • Creating a working contact form
    14:48
  • Introduction to databases
    05:48
  • Creating a MySQL database
    04:55
  • Creating a MySQL table
    09:40
  • Inserting data using MySQL
    06:41
  • Selecting data using MySQL
    05:33
  • Updating data using MySQL
    03:23
  • Deleting data using MySQL
    02:34
  • Ordering data using MySQL
    04:01
  • Connecting to the database in PHP
    06:11
  • Printing database data in the browser
    07:32
  • Markup for login/register page
    11:32
  • Saving data from a register form
    05:47
  • Error handlers in the PHP script
    09:25
  • Prepared statements to prevent SQL injection
    11:59
  • Password hashing in register script
    05:04
  • Login script
    17:46

Instructor
Web Developer & Designer
Dary Nazar
  • 4.4 Instructor Rating
  • 275 Reviews
  • 12,005 Students
  • 1 Course

My name is Dary Nazar and I am a software engineer. After I U-turned away from a comfortable yet unfulfilling life, I cherished into this field – teaching programming. At this point in my development, I have experience in all facets of programming.

I’m constantly learning new web technologies and design methods. Currently, I’m playing around with Node.js and Python, apart from polishing my designs.

I try to make complex topics as easy as possible by explaining it to you in a simple and understandable way.