1. Introduction:

i. Why use PHP and MySQL?
ii. The PHP programming environment
iii. Overview of SQL

2. Client and server communication

3. Environment setup

i. Decisions about a testing environment
ii. WAMP/MAMP/LAMP
iii. Installing Apache, PHP, MySQL on your computer
iv. Testing on a remote server
v. Deciding on development tools
vi. Using phpmyadmin

4. PHP syntax.

5. Outputs (echo, print, var_dump ..etc)

6. Variables

7. Data types

8. Constants

9. Comments

10. Uses of Quotes (Single, Double)

i. Arithmetic operators
ii. Logical operators
iii. Comparisons
iv. Operator precedence

12. Mathematical functions

13. Control Statements (if..else, elseif, switch, ternary, null safe)

i. Electric bill calculation (For first 50 units – 3.50 tk/unit For next 100 units – 4.00
tk/unit For next 100 units – 5.20 tk/unit For units above 250 – 6.50 tk/unit)
ii. A PHP calculator using switch case (Addition, Subtraction, Multiplication, Division)
iii. Check if a person is eligible to vote by age
iv. Check if a person is eligible for marriage in BD by gender.
v. Check if number is positive or negetive
vi. Check if number is odd or even vii. Check if data is integer or string
vii. and many mores

14. Loops (for, foreach, while, do, do while)

15. Arrays

16. Array functions

i. array()
ii. is_array()
iii. in_array()
iv. array_merge()
v. array_keys()
vi. array_key_exists()
vii. array_shift()
viii. array_unshift()
ix. array_push()
x. array_pop()
xi. array_values()
xii. array_map()
xiii. array_unique()
xiv. array_slice()
xv. array_diff()
xvi. array_search()
xvii.array_reverse()

17. Array problem and solution

i. Find maximum number from an array

ii. Find 2nd max number from an array
iii. Sort array from min to max
iv. Calculate average number of an array
v. Merging 2 different types of array together
vi. Search data from an array
vii. Show array data in lowercase and uppercase
viii. Get unique values
ix. Remove duplicate values
x. Check if email address is unique
xi. Check unique username
xii. Merge 2 comma separated lists with unique value only
xiii. Difference between 2 multi-dimensional arrays
xiv. Check if all values are string or not
xv. Union of 2 arrays
xvi. Filter out array data with some specific keys
xvii.Filter a multi-dimensional array.
xviii. Remove all white spaces from an array
xix. Combine 2 array and use one array data as keys and others as values
xx. Convert string to array
xxi. and many more problem and solutions.

18. Random password generator (contains uppercase, lowercase, numeric and other)

19. Numbers

i. Making calculations
ii. Using built-in numeric functions
iii. Incrementing and decrementing

20. Strings

i. Concatenating strings
ii. Trimming strings
iii. Removing slashes and other harmful characters
iv. String functions

21. Functions (user define, built-in)

22. Regular expression (RegEx)

23. Superglobals ($GLOBALS, $_SERVER, $_REQUEST, $_POST, $_GET, $_FILES, $_ENV,
$_COOKIE, $_SESSION)

24. Form Handling

25. Form validation

26. Form required

27. Form URL/E-mail

28. File uploading

29. File validation

30. File inclusion (include, include_once, require, require_once)

31. Sending mail

32. Mail verification

33. Exception handling (try, catch, throw, finally)

34. Error Handling

35. Bugs, Debugging

36. Date, Time

37. Filters

38. JSON (encode, decode)

39. php File system

i. basename()
ii. dirname()
iii. copy()
iv. file()
v. file_exists()
vi. file_get_contents()
vii. file_put_contents()
viii. filesize()
ix. filetype()
x. is_dir()
xi. is_file()
xii. link()
xiii. unlink()
xiv. mkdir()
xv. rmdir()
xvi. move_uploaded_file()
xvii.pathinfo()

40. PHP core setting (PHP.ini)

41. Application structure guideline

42. Application skeleton

43. Request and response cycle

44. Security

45. Resources