BlackBelt PHP and MySQL Skills for Creating Dynamic Website
4.8 (32 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.
397 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.8 (32 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.
397 students enrolled
Created by OnlyKiosk Tech
Last updated 10/2016
English
Current price: $10 Original price: $150 Discount: 93% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • 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
Description

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
187 Lectures
23:35:40
+
YellowBelt:
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
05:58

OrangeBelt: 2. practice
03:09

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
08:55

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
05:20

What kind of value will be regarded as FALSE.

Ternary operator.

OrangeBelt: 5. something important you should know
06:43

WHILE statement.

How to let the program do repetitions.

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

OrangeBelt: 7. practice the WHILE statement
01:34

There is another form of WHILE statement: do while.

OrangeBelt: 8. another WHILE statement: DO WHILE
01:31

Another form of LOOP statement: FOR statement

OrangeBelt: 9. FOR statement
01:54

OrangeBelt: 10. Supplement to short-cut
02:42

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
02:43

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
01:05

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
00:40

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?
04:16

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
01:30

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
05:35

GreenBelt: 9. demonstration of creating a CONSTANT
01:58

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
04:54

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()
01:14

GreenBelt: 12. demonstration of foreach()
01:28

GreenBelt: 13. a little challenge for you
03:29

GreenBelt: 14. a few commonly used functions that can help you deal with array
03:04

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
02:33

GreenBelt: 16. OPTIONAL: array_walk()
02:23

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
04:29

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()
02:00

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

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

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

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

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

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

BlueBelt: 7. OPTIONAL: get a part of a string --substr()
03:18

BlueBelt: 8. OPTIONAL: switch part of a string --str_replace()
01:49

BlueBelt: 9. regular expression Part 1
06:29

BlueBelt: 10. regular expression Part 2
05:49

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
01:37

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

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

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

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

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

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

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
00:24

BlueBelt: 16. the four functions
01:06

BlueBelt: 17. demonstration of using the four functions
02:24

BlueBelt: 18. a function called feof()
01:29

how do you read a large file efficiently?

BlueBelt: 19. how to read large files
02:42

how to copy, relocate and rename a file

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

BlueBelt: 21. a challenge for you
00:36

BlueBelt: 22. answer to the challenge
06:14

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
01:46

BlueBelt: 24. create new directories
02:08

BlueBelt: 25. delete a directory
02:37

BlueBelt: 26. open, scan and close a directory
03:49

BlueBelt: 27. another challenge for you: delete directories and files together
01:40

BlueBelt: 28. answer: how to delete directories and files together
02:40

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
00:26

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

Purple: 2. HTML Introduction
01:57

Purple:3. Display an image and make a hyperlink
01:57

PurpleBelt: 4. sending and receiving data using HTML techniques
03:08

PurpleBelt: 5. demonstration of sending and receiving data using HTML
03:55

PurpleBelt: 6. try the GET method
01:53

PurpleBelt: 7. sending data using a hyperlink
01:27

PurpleBelt: 8. how to upload
03:08

PurpleBelt: 9. demonstration of uploading files
05:16

PurpleBelt: 10. security issues you must deal with
00:34

PurpleBelt: 11. control the size of the uploaded file
03:26

PurpleBelt: 12. control the type of the uploaded file
03:35

PurpleBelt: 13. rename the uploaded file
03:45

PurpleBelt: 14. create a new home for uploaded files
02:42

PurpleBelt: 15. final adjustments to the upload program
05:53

PurpleBelt: 16. how to download
01:16

PurpleBelt: 17. demonstration of downloading files
04:06

PurpleBelt: 18. download security
05:35

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

PurpleBelt: 20. why OOP is the future
01:47

PurpleBelt: 21. Introduction of Object-oriented Programming
02:47

PurpleBelt: 22. How to create a CLASS
05:36

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

PurpleBelt: 24. Demonstration of creating and instantiating a class
03:23

PurpleBelt: 25. Super assign
02:32

PurpleBelt: 26. the __construct() method
04:32

PurpleBelt: 27. MySQL database introduction
01:56

PurpleBelt: 28. PHPMyAdmin
05:05

PurpleBelt: 29. Data type
04:15

PurpleBelt: 30 Data types used by MySQL database
09:10

PurpleBelt: 31. dmonstration of creating a database
03:57

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

PurpleBelt: 33. Demonstration of connecting to MySQL database
04:00

PurpleBelt: 34. SQL: SELECT
06:23


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

PurpleBelt: 37. better organization of the retrieved data Part2
05:39

PurpleBelt: 38. Summary of SELECT
01:47

PurpleBelt: 39. UPDATE and DELETE data from database
05:46

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
04:01

BrownBelt: 3. database operation review
05:23

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

BrownBelt: 5. demonstration of creating the registration system
15:06

BrownBelt: 6. how to create the log in part
02:44

BrownBelt: 7. demonstration of creating the log in part
07:34

BrownBelt: 8. a problem occured
01:59

BrownBelt: 9. how does an university manage its students
01:02

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

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

BrownBelt: 12. OPTIONAL: supplement to COOKIE
02:45

BrownBelt: 13. make the ID card and card scanner
05:36

BrownBelt: 14. scan the ID card
08:41

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

BrownBelt: 16. change of plans
01:57

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

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

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

BrownBelt: 20. block repetitive uploading by refreshing page
04:32

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
00:57

BLACKBELT: 3. delete SESSION
04:28

BLACKBELT: 4. set an expiry date to SESSION
01:41

BLACKBELT: 5. make the fingerprint scanner
01:42

BLACKBELT: 6. demonstration of making the fingerprint scanner
06:05




BLACKBELT: 10. how to create a paint brush
02:21

BLACKBELT: 11. output the image
03:46

BLACKBELT: 12. draw a dot, line and rectangle
03:34




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

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

BLACKBELT: 18. how to watermark a picture with strings
02:13

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

BLACKBELT: 20. how to crop a picture
05:59

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

BLACKBELT: 22. why 4 zeros?
01:00

ClassResource: Black-1
27 pages

ClassResource: Black-2
9 pages
About the Instructor
OnlyKiosk Tech
4.8 Average rating
257 Reviews
10,752 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.