BlackBelt PHP and MySQL skills for Dynamic Website

PHP, MySQL, why and how
4.6 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
273 students enrolled
88% off
Take This Course
  • Lectures 187
  • Length 23.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

The structure of this course was inspired by the Jiu Jitsu ranking system. The whole course has been divided into 7 levels:

  • 1. Yellow Belt;
  • 2. Orange Belt;
  • 3. Green Belt;
  • 4. Blue Belt;
  • 5. Purple Belt;
  • 6. Brown Belt;
  • 7. Black Belt;

You will learn all the PHP fundamentals in Yellow, Orange, and Green belt.

The real power of PHP actually comes from its built-in functions. But there are over 1,000 of them, it would be impossible for you to learn all of them. And forgetting things is just human nature, therefore, it would also be a bad idea to demand that you remember every function you learn from this course. Though I have tried my best to only select the most commonly used one, there are still lots of functions to learn.

The best solution is to teach you how to use and learn from the manual. Even you forgot about how to use certain functions, you still can pick things up quickly by reading the manual. This is like teaching you how to fish, instead of giving you fish directly.

As a result, almost every function in the course are taught by using a manual. You will learn almost all your functions through the manual. In the future, if you need to learn new functions by yourself, you will feel much more comfortable and confident.

In the blue belt, we will learn how to get the file name extension and create new directories. In purple belt, we will learn how to upload files properly, which will require you to use techniques learnt in the blue belt. In the brown belt, you will learn how to use database techniques to manage all your uploaded files. In this way, you will constantly repeat using techniques learnt before.

We all forget things and that is a human nature that cannot be changed. But you can always hone your ability of picking up forgotten knowledge. For PHP programmers or any computer programmers, the manual is definitely the best choice. This is why throughout this whole course, using the manual, how to use the manual and getting used to seeking help from manual have been given top priority.

What are the requirements?

  • No previous coding experience needed
  • You need to have a computer with internet access
  • You need to be willing to challenge and push yourself

What am I going to get from this course?

  • Develop confidence in solving problems by yourself
  • Develop ability and confidence in teaching yourself the latest PHP techniques
  • Have a solid knowledge foundation in PHP basics
  • Be able to self-study a new built-in function by reading the PHP manual
  • Create a membership system that allows user to register and log in
  • Create a membership system that allows user to upload files
  • Be able to operate MySQL database
  • Be able to operate files and directories using PHP
  • Learn Object-oriented Programming

Who is the target audience?

  • This course is for anyone who wants to build a dynamic website using PHP and MySQL
  • This course is for anyone who wants to improve their PHP skills
  • This course is for anyone who wants to learn more PHP techniques

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: YellowBelt:
YellowBelt: 1. Ready your tools
YellowBelt: 2. Anatomy of a typical PHP file

Computer is invented to process data.

To better handle data, data has been divided into several types.

As a programmer, whenever you see the word data, ask two questions: data type and data value.


PHP has offered us a basket to store values. The basket is called variable.

You will learn how to create a variable and how to assign value to it.


when it comes to handling variable, single quotes and double quotes behave differently.


A new data type: NULL.

Assigning NULL to a variable can empty that variable.


you might think value assignment between variables are simple, but there might be things you not know.


Pass value by reference.

The ampersand can tie two variables to one value.


this is the end of the yellow belt, before you move on, you might want to slow things down a little bit and do a review of what you have learnt so far.


A review of what you have learnt in the Yellow Belt Lessons. and also hope you like the music.


A review of what you have learnt in the Yellow Belt Lessons.

ClassResource Yellow-1
17 pages
ClassResource: Yellow-2
12 pages
ClassResource: Yellow-3
7 pages
ClassResource: Yellow-4
22 pages
ClassResource: Yellow-5
11 pages
ClassResource: Yellow-6
17 pages
Section 2: Orange Belt

The building stone of PHP is expression.

The tool we can use to process data: operator.

OrangeBelt: 2. practice

Give your program a steering wheel so that it can make decisions.

The IF statement.

How to use it and how it works.


Sometimes the program needs to make decisions based on variable values.

In this case, IF statement is not convenient.

SWITCH statement.


What kind of value will be regarded as FALSE.

Ternary operator.


WHILE statement.

How to let the program do repetitions.

OrangeBelt: 7. practice the WHILE statement

There is another form of WHILE statement: do while.


Another form of LOOP statement: FOR statement

OrangeBelt: 10. Supplement to short-cut
ClassResource: Orange- 1
21 pages
ClassResource: Orange- 2
30 pages
ClassResource: Orange-3
17 pages
ClassResource: Orange- 4
7 pages
Section 3: Green Belt

The reason why making web apps using PHP is fast and convenient is because of all the brilliant built-in functions PHP has.

But as new learners, there might be some tricky parts about functions.

Always remember the key in using a function is that you have given each function argument a correct value and most importantly, you have put those values in the correct order.


sometimes, you just have to create your own functions, this lesson will teach you how to do that and how to do that properly.


normally, the value returned by a function is NULL. but sometimes, you need control the returned value because the following operations will depend on that.


the keyword RETURN also means the end. Codes behind it will not be executed. In the future, you will find that RETURN is a brilliant tool and you will use it a lot.


changing variable value is simple, but if you want to do that using a function, things are a little bit more complicated.


inside and outside a function, there are two different worlds. Using the keyword GLOBAL, you can break that wall.


you can set default values to function arguments. But if you want to do that properly, there are some rules you must follow.

GreenBelt: 8. last supplement and how to create a CONSTANT
GreenBelt: 9. demonstration of creating a CONSTANT

Compared with variable, array is much more powerful, In the future, you will probably use more arrays than variables.


array is powerful, but to use it, you must use a tool: the foreach loop statement

GreenBelt: 12. demonstration of foreach()
GreenBelt: 13. a little challenge for you
GreenBelt: 14. a few commonly used functions that can help you deal with array

callback can be very helpful sometimes, but its concept is a little tricky to understand.

GreenBelt: 16. OPTIONAL: array_walk()
ClassResource: Green- 1
16 pages
ClassResource: Green-2
33 pages
ClassResource: Green-3
13 pages
ClassResource: Green-4
25 pages
ClassResource: Green-5
10 pages
ClassResource: Green-6
4 pages
Section 4: Blue Belt

there is no way you can put all your codes in one file. but if you write your codes in different files, how do you allow those files to exchange information with each other???


to achieve cross-file communication, you must be able to locate each file.


you will be using array almost all the time in the future. This means you will constantly do all kinds of manipulations to arrays.

converting array into a string is the fist conversion technique you need to learn.


sometimes, you might need to convert a string into an array, so how to do that?


there is another way to convert a string into an array.

BlueBelt: 6. a project for you --create a file type detector

if you need a part of a string, how do you get that???

BlueBelt: 8. OPTIONAL: switch part of a string --str_replace()
BlueBelt: 9. regular expression Part 1
BlueBelt: 10. regular expression Part 2

you will learn something that will make you feel quite powerful: how to use PHP commands to create files.


how to open a file and how to close a file.


if you want to know the content of a file, how do you get that?


if you want to put new contents into a file, how do you do that?


here are four functions you are recommended to learn by yourself. I will teach you how to use those four functions in the next lesson, but for now, try to learn them all by yourself.

BlueBelt: 16. the four functions
BlueBelt: 17. demonstration of using the four functions
BlueBelt: 18. a function called feof()

how do you read a large file efficiently?


how to copy, relocate and rename a file

BlueBelt: 21. a challenge for you
BlueBelt: 22. answer to the challenge

to manage files, you need to have file folders or directories. so how to create them?

BlueBelt: 24. create new directories
BlueBelt: 25. delete a directory
BlueBelt: 26. open, scan and close a directory
BlueBelt: 27. another challenge for you: delete directories and files together
BlueBelt: 28. answer: how to delete directories and files together
ClassResource: Blue-1
16 pages
ClassResource: Blue-2
11 pages
ClassResource: Blue-3
6 pages
ClassResource: Blue-4
45 pages
ClassResource: Blue-5
38 pages
ClassResource: Blue-6
7 pages
ClassResource: Blue-7
30 pages
Section 5: Purple Belt
Purple: 1. Preface

although you are a back-end programmer, there are certain front-end techs you just have to know

Purple:3. Display an image and make a hyperlink
PurpleBelt: 4. sending and receiving data using HTML techniques
PurpleBelt: 5. demonstration of sending and receiving data using HTML
PurpleBelt: 6. try the GET method

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

OnlyKiosk Tech, Making Your Efforts More Effective

No matter where and whom you take your lessons from, you will always have to do all the hard work yourself.

You have to spend time and efforts learning, understanding, memorizing and practicing new knowledge. This is NO short-cut here.

But a good course can show the best route and help you avoid traps and detours. You can achieve maximum productivity from your time and efforts.

Based on user feedback, tech development, and our new thoughts and inspirations, we will keep adding new contents and improving existing ones.

We will cover basics as well as advanced applications. You will learn smart and creative tech combinations as well.

Web development has been a popular area for years. The internet has accumulated tons of free tutoring videos and materials.

Even if you are stuck with questions you cannot solve, just post them on stackoverflow, you will have your answers within a few minutes.

With all the free tutoring materials and teachers, what is the point of creating this paid online course?

It depends on what you really want.

If you just want to have a rough idea of how web apps work and create some basic programs, then there is really no need for you to pay for any courses. Free internet information is more than enough to meet your demands.

If you want to be able to turn your design and idea into programs that are safe and efficient enough to be applied in real life and solve all kinds of challenge, then this course is perfect for you.  

We believe a good online course should also be a navigator, not just explaining coding concepts.

It should show you where the real destination is and most importantly, take you there in the most efficient way.  

Why we emphasize real destination?

First of all, you should know a program that can work is very different from a program that can survive in real life.

This is like playing a racing game on your phone is definitely not the same as driving a real car on a real track.

For example, in our PHP lesson, we will teach you how to create an upload program.

We have seen books and courses that only teach how to upload files.

If you run that program in real life, it will not last a day. It will do more damage than good.

For an upload program to work in real life, you need to check file type and size before letting any file being uploaded.

You also need to protect your program from uploading the same file repeatedly by keeping refreshing the uploading page.  

Uploaded files should be properly renamed and stored. Most importantly, this process must be automatic.

Uploaded files must also be retrievable, therefore information about uploaded files should also be automatically recorded into database.

If one step is missing, your upload program will not survive the real life environment.

This is why we emphasize real destination. We want to show you the whole picture, rather than just a segment of it.

Knowing the whole picture is what separates a trustworthy professional programmer from a coding amateur.

Apparently the road to the real destination is quite long.

This is why a good course should be a navigator. It should show students the best route.

When designing our course contents, we acknowledge and most importantly, take in consideration two very important facts:

Everybody forgets and you have other things going on in your life and can only partly devote to your study.

This means your study will be constantly interrupted and when you resume your study, you might find what you have learnt has become rusty.

As a result, all your new knowledge are built on a collapsing foundation. At the end of your study, you will find that despite you have spent time and money, but you just cannot make satisfactory progress. You thought you have learnt everything but just cannot put them together can create a functional program.

So how do we solve this problem?

We divide our whole course content into small segments. At the end of each segment, there will be a review session summarizing everything you have learnt from that session.

When you are creating APPs, we will give a review session on key knowledge as well.

Apart from review sessions, we will also help you control your study pace. You will often hear we tell you that if you cannot answer this quiz, do not proceed and review previous lessons.

The biggest card up our sleeve is our content table.

You might think our upload program lesson starts here. But actually our upload lesson has started long before that. We have started to lay foundations for you since we teach you how to create a file type detector.

We divide a complicated program into components and will only add one component at a time. Most importantly, every time we add a new component, we will review the previous components again.

In the very end, despite the program we are creating is long and complicated, you will be able to master everything. 

Ready to start learning?
Take This Course