BlackBelt PHP and MySQL Skills for Creating Dynamic Website
4.7 (39 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.
551 students enrolled
Wishlisted Wishlist

Please confirm that you want to add BlackBelt PHP and MySQL Skills for Creating Dynamic Website to your Wishlist.

Add to Wishlist

BlackBelt PHP and MySQL Skills for Creating Dynamic Website

Learning how to create programs that are safe and efficient enough to survive in real life from ground zero.
4.7 (39 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.
551 students enrolled
Created by OnlyKiosk Tech
Last updated 10/2016
Current price: $10 Original price: $150 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 9 hours on-demand video
  • 40 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
  • You only need a computer with internet access
  • All software needed in the class is free of charge and easy to install and run
  • No previous coding experience needed

The aim of this course is to help you master web development in the most efficient way. 

The content design of this course is inspired by the Jiu Jitsu ranking system. 

The whole course includes seven levels: yellow, orange, green, blue, purple, brown and black. 

In yellow, orange and green course, considering you just started your PHP study, the learning curve is kept at a rather smooth level.

You will learn the most fundamental coding concepts and simple operations.

In blue belt, things start to change. The learning curve starts to get steep and you will need to combine skills learnt at different times together.

After purple belt, you will start to build programs that can be used in real-life situation. This means you will need to take into consideration safety and efficiency. 

We know that everybody forgets. We also know that you have other things going on with your life and your study will be constantly interrupted. Therefore, every time previous knowledge is needed, we will give you a timely review. We believe this can make your study easier and more efficient.

Starting from purple belt, you will learn how to build program that can survive in real life. This means you need to learn more than just coding skills. You will learn program design and safety and efficiency knowledge. 

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
Compare to Other MySQL Courses
Curriculum For This Course
187 Lectures
18 Lectures 47:58

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.

Preview 02:53

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.

Preview 04:47

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

Preview 02:38

A new data type: NULL.

Assigning NULL to a variable can empty that variable.

Preview 01:07

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

Preview 03:24

Pass value by reference.

The ampersand can tie two variables to one value.

Preview 03:45

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.

Preview 00:49

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

Preview 05:02

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

Preview 04:28

ClassResource Yellow-1
17 pages

ClassResource: Yellow-2
12 pages

ClassResource: Yellow-5
11 pages

ClassResource: Yellow-6
17 pages
Orange Belt
14 Lectures 41:30

The building stone of PHP is expression.

The tool we can use to process data: operator.

OrangeBelt: 1. expression and 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.

OrangeBelt: 3. give your program a steering wheel: IF statement

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

In this case, IF statement is not convenient.

SWITCH statement.

OrangeBelt: 4. another steering wheel: SWITCH statement

What kind of value will be regarded as FALSE.

Ternary operator.

OrangeBelt: 5. something important you should know

WHILE statement.

How to let the program do repetitions.

OrangeBelt: 6. how to echo 1 million "Hello, OnlyKiosk"

OrangeBelt: 7. practice the WHILE statement

There is another form of WHILE statement: do while.

OrangeBelt: 8. another WHILE statement: DO WHILE

Another form of LOOP statement: FOR statement

OrangeBelt: 9. 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
Green Belt
22 Lectures 45:00

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.

GreenBelt: 1. introduction to FUNCTION

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

Preview 03:51

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.

GreenBelt: 3. the returned value of a function

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.

GreenBelt: 4. another thing you should know about RETURN

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

GreenBelt: 5. what kind of difference & can make here?

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

GreenBelt: 6. use the keyword GLOBAL to break the wall of function

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

Preview 04:17

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.

GreenBelt: 10. the aircraft carrier-- ARRAY

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

GreenBelt: 11. most important tool for dealing with array -- foreach()

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: 15. OPTIONAL: callback --we drive a robot, and robot drives the car

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
Blue Belt
35 Lectures 01:25:35

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???

Preview 04:10

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

BlueBelt: 2. relative URL and absolute URL

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.

BlueBelt: 3. conversion between string and array --implode()

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

BlueBelt: 4. conversion between string and array --explode()

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

BlueBelt: 5. another way to convert string into array --split()

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: 7. OPTIONAL: get a part of a string --substr()

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.

BlueBelt: 11. operating files --all the basics you need to know

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

BlueBelt: 12. open a file and close a file -- fopen() and fclose()

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

BlueBelt: 13. read contents from a file --fread()

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

BlueBelt: 14. put contents into a file --fwrite()

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: 15. 4 functions you are recommended to learn 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?

BlueBelt: 19. how to read large files

how to copy, relocate and rename a file

BlueBelt: 20. do CTRL + C/ X/ V using copy() and rename()

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: 23. check if a directory exists or not

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
Purple Belt
46 Lectures 02:25:24
Purple: 1. Preface

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

Purple: 2. HTML Introduction

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

PurpleBelt: 7. sending data using a hyperlink

PurpleBelt: 8. how to upload

PurpleBelt: 9. demonstration of uploading files

PurpleBelt: 10. security issues you must deal with

PurpleBelt: 11. control the size of the uploaded file

PurpleBelt: 12. control the type of the uploaded file

PurpleBelt: 13. rename the uploaded file

PurpleBelt: 14. create a new home for uploaded files

PurpleBelt: 15. final adjustments to the upload program

PurpleBelt: 16. how to download

PurpleBelt: 17. demonstration of downloading files

PurpleBelt: 18. download security

PurpleBelt: 19. why we need to learn OOP before MySQL

PurpleBelt: 20. why OOP is the future

PurpleBelt: 21. Introduction of Object-oriented Programming

PurpleBelt: 22. How to create a CLASS

PurpleBelt: 23. how to use or INSTANTIATE a new class

PurpleBelt: 24. Demonstration of creating and instantiating a class

PurpleBelt: 25. Super assign

PurpleBelt: 26. the __construct() method

PurpleBelt: 27. MySQL database introduction

PurpleBelt: 28. PHPMyAdmin

PurpleBelt: 29. Data type

PurpleBelt: 30 Data types used by MySQL database

PurpleBelt: 31. dmonstration of creating a database

PurpleBelt: 32. Introduction of MySQLi and getting connected to MySQL

PurpleBelt: 33. Demonstration of connecting to MySQL database

PurpleBelt: 34. SQL: SELECT

PurpleBelt: 36. Better organization of retrieved data- Part 1

PurpleBelt: 37. better organization of the retrieved data Part2

PurpleBelt: 38. Summary of SELECT

PurpleBelt: 39. UPDATE and DELETE data from database

ClassResource: Purple- 1
21 pages

ClassResource: Purple-2
48 pages

ClassResource: Purple-3
66 pages

ClassResource: Purple-4
34 pages

ClassResource: Purple-5
54 pages

ClassResource: Purple-6
21 pages

ClassResource: Purple-7
38 pages
Brown Belt
27 Lectures 01:34:57

BrownBelt: 2. problems caused by special characters and how to solve it

BrownBelt: 3. database operation review

BrownBelt: 4. how to encrypt information and analysis of regsitration system

BrownBelt: 5. demonstration of creating the registration system

BrownBelt: 6. how to create the log in part

BrownBelt: 7. demonstration of creating the log in part

BrownBelt: 8. a problem occured

BrownBelt: 9. how does an university manage its students

BrownBelt: 10. the ID card and fingerprint scanner -- COOKIE and SESSION

BrownBelt: 11. how to create COOKIE --setcookie()

BrownBelt: 12. OPTIONAL: supplement to COOKIE

BrownBelt: 13. make the ID card and card scanner

BrownBelt: 14. scan the ID card

BrownBelt: 15. revoke the ID card --how to log out

BrownBelt: 16. change of plans

BrownBelt: 17. how to deal with more than one table?

BrownBelt: 18. how to keep record of the uploaded files

BrownBelt: 19. a security problem and how to solve it

BrownBelt: 20. block repetitive uploading by refreshing page

ClassResource: Brown-1
16 pages

ClassResource: Brown-2
20 pages

ClassResource: Brown-4
18 pages

ClassResource: Brown-5
17 pages

ClassResource: Brown-6
31 pages

ClassResource: Brown-7
10 pages

ClassResource: Brown-9
16 pages
Black Belt
25 Lectures 01:25:16
ClassResource: Brown-8
9 pages

BLACKBELT: 2. store value to SSESSION


BLACKBELT: 4. set an expiry date to SESSION

BLACKBELT: 5. make the fingerprint scanner

BLACKBELT: 6. demonstration of making the fingerprint scanner

BLACKBELT: 10. how to create a paint brush

BLACKBELT: 11. output the image

BLACKBELT: 12. draw a dot, line and rectangle

BLACKBELT: 16. how to install and use the verification code

BLACKBELT: 17. how to convert a picture into a canvas

BLACKBELT: 18. how to watermark a picture with strings

BALCKBELT: 19. how to watermark a picture with another picture

BLACKBELT: 20. how to crop a picture

BLACKBELT: 21. how to scale down a picture to make a thumbnail

BLACKBELT: 22. why 4 zeros?

ClassResource: Black-1
27 pages

ClassResource: Black-2
9 pages
About the Instructor
OnlyKiosk Tech
4.8 Average rating
402 Reviews
11,363 Students
5 Courses
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.