BlackBelt PHP and MySQL Skills for Creating Dynamic Websites

Course Curriculum

Chapter 1: YellowBelt:

Lecture 1: YellowBelt: 1. Ready your tools

Lecture 2: YellowBelt: 2. Anatomy of a typical PHP file

Lecture 3: YellowBelt: 3. data type and data value

Lecture 4: YellowBelt: 4. the basket offered by PHP: VARIABLE

Lecture 5: YellowBelt: 5. difference between single and double quotes

Lecture 6: YellowBelt: 6. how to empty the basket: assign NULL to a variable

Lecture 7: YellowBelt: 7. Value assignment between variables

Lecture 8: YellowBelt: 8. the magic &: assignment BY REFERENCE

Lecture 9: Yellow: 9. SUMMARY

Lecture 10: YellowBelt: 10. REVIEW-1 MV: South China in Mist and Rain

Lecture 11: YellowBelt: 11. REVIEW-2 MV: Pipa's Words

Lecture 12: ClassResource Yellow-1

Lecture 13: ClassResource: Yellow-2

Lecture 14: ClassResource: Yellow-3

Lecture 15: ClassResource: Yellow-4

Lecture 16: ClassResource: Yellow-5

Lecture 17: ClassResource: Yellow-6

Chapter 2: Orange Belt

Lecture 1: OrangeBelt: 1. expression and operator

Lecture 2: OrangeBelt: 2. practice

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

Lecture 4: OrangeBelt: 4. another steering wheel: SWITCH statement

Lecture 5: OrangeBelt: 5. something important you should know

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

Lecture 7: OrangeBelt: 7. practice the WHILE statement

Lecture 8: OrangeBelt: 8. another WHILE statement: DO WHILE

Lecture 9: OrangeBelt: 9. FOR statement

Lecture 10: OrangeBelt: 10. Supplement to short-cut

Lecture 11: ClassResource: Orange- 1

Lecture 12: ClassResource: Orange- 2

Lecture 13: ClassResource: Orange-3

Lecture 14: ClassResource: Orange- 4

Chapter 3: Green Belt

Lecture 1: GreenBelt: 1. introduction to FUNCTION

Lecture 2: GreenBelt: 2. how to create a function and why argument order is vital

Lecture 3: GreenBelt: 3. the returned value of a function

Lecture 4: GreenBelt: 4. another thing you should know about RETURN

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

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

Lecture 7: GreenBelt: 7. function arguments with default values

Lecture 8: GreenBelt: 8. last supplement and how to create a CONSTANT

Lecture 9: GreenBelt: 9. demonstration of creating a CONSTANT

Lecture 10: GreenBelt: 10. the aircraft carrier– ARRAY

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

Lecture 12: GreenBelt: 12. demonstration of foreach()

Lecture 13: GreenBelt: 13. a little challenge for you

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

Lecture 15: GreenBelt: 15. OPTIONAL: callback –we drive a robot, and robot drives the car

Lecture 16: GreenBelt: 16. OPTIONAL: array_walk()

Lecture 17: ClassResource: Green- 1

Lecture 18: ClassResource: Green-2

Lecture 19: ClassResource: Green-3

Lecture 20: ClassResource: Green-4

Lecture 21: ClassResource: Green-5

Lecture 22: ClassResource: Green-6

Chapter 4: Blue Belt

Lecture 1: BlueBelt: 1. cross-file communicaiton

Lecture 2: BlueBelt: 2. relative URL and absolute URL

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

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

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

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

Lecture 7: BlueBelt: 7. OPTIONAL: get a part of a string –substr()

Lecture 8: BlueBelt: 8. OPTIONAL: switch part of a string –str_replace()

Lecture 9: BlueBelt: 9. regular expression Part 1

Lecture 10: BlueBelt: 10. regular expression Part 2

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

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

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

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

Lecture 15: BlueBelt: 15. 4 functions you are recommended to learn by yourself

Lecture 16: BlueBelt: 16. the four functions

Lecture 17: BlueBelt: 17. demonstration of using the four functions

Lecture 18: BlueBelt: 18. a function called feof()

Lecture 19: BlueBelt: 19. how to read large files

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

Lecture 21: BlueBelt: 21. a challenge for you

Lecture 22: BlueBelt: 22. answer to the challenge

Lecture 23: BlueBelt: 23. check if a directory exists or not

Lecture 24: BlueBelt: 24. create new directories

Lecture 25: BlueBelt: 25. delete a directory

Lecture 26: BlueBelt: 26. open, scan and close a directory

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

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

Lecture 29: ClassResource: Blue-1

Lecture 30: ClassResource: Blue-2

Lecture 31: ClassResource: Blue-3

Lecture 32: ClassResource: Blue-4

Lecture 33: ClassResource: Blue-5

Lecture 34: ClassResource: Blue-6

Lecture 35: ClassResource: Blue-7

Chapter 5: Purple Belt

Lecture 1: Purple: 1. Preface

Lecture 2: Purple: 2. HTML Introduction

Lecture 3: Purple:3. Display an image and make a hyperlink

Lecture 4: PurpleBelt: 4. sending and receiving data using HTML techniques

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

Lecture 6: PurpleBelt: 6. try the GET method

Lecture 7: PurpleBelt: 7. sending data using a hyperlink