Php Fundamentals and Mysql- part 1 (core/structure Php)

COURSE OUTLINE:

1. INTRO TO PROGRAMMING

1.1. Language and the Logic of Programming

1.2. Types of Programming Languages and Vocabulary

1.3. What is PHP

1.4. Why use PHP

1.5. Installing AppServ, WAMP, XAMPP

1.6. Client/Server Communications

2. PHP LANGUAGE BASIC SYNTAX

2.1 Opening and Closing Tags

2.2 echo and print commands

2.3 embedding PHP in HTML

2.4 embedding HTML in PHP

2.5 Comments

3. PHP VARIABLES

3.1 How to declare variable and assign value

3.2 General rules for writing variable name

3.3 Introduction to different data types

3.4 How to use gettype() and settype() functions

3.5 Introduction to Constants

4. PHP OPERATORS

4.1 Assignment Operator

4.2 Concatenation Operator

4.3 Combined Assignment Operator

4.4 Comparison Operator

4.5 Logical Operator

4.6 Increment, Decrement Operator

5. SUPER-GLOBAL ARRAYS

5.1 $_SERVER

5.2 $_POST

5.3 $_GET

5.4 $_SESSION

5.5 $_FILES

6. CONDITIONAL STATEMENTS

6.1 IF Statement

6.2 IF-Else Statement

6.3 If-ElseIf-Else Statement

6.4 Switch Statement

7. LOOPS

7.1 For Loop

7.2 While Loop

7.3 Do-While Loop

7.4 Break and Continue statements in loop

7.5 Nested Loop (loop inside loop)

8. LOOPS

8.1 For Loop

8.2 While Loop

8.3 Do-While Loop

8.4 Break and Continue statements in loop

8.5 Nested Loop (loop inside loop)

9. STRING FUNCTIONS

- strlen()

- trim()

- ucfirst()

- ucwords()

- strtoupper()

10. DATE AND TIME FUNCTIONS

10.1 Date() Function

10.2 Time() Function

10.3 Parameters (Y,y,M,m,D,d,F,A,a,h,i,s).

11. ARRAYS

11.1 Difference between Array and Variable

11.2 How to define an array

11.3 Associative Array

11.4 Multi-dimensional Array

11.5 Foreach Loop

11.6 Print_r() function

12. ARRAY FUNCTIONS

- count()

- is_array()

- sizeof()

- in_array()

- array_merge()

13. FUNCTIONS

- strtolower()

- strstr()

- substr()

- addslashes()

- htmlspecialchars()

- str_replace()

- str_repeat()

- Md5

- array_push()

- array_shift()

- array_pop()

- sort()

- array_sum()

13.1 What are functions.

13.2 How to write a function.

13.3 Using arguments or Parameters

13.4 Variable Scope

 Variable inside function

 Variable outside function.

14. PHP SESSIONS

14.1 What are sessions?

14.2 How session works?

14.3 How to start and destroy a session?

14.4 ob_start() function.

15. PHP FILE HANDLING

- fopen()

- fread()

- fclose()

- fwrite()

In this part of the course you will learn about the Relational Database Management Systems

(RDBMS), MySQL Database and how to work with MySQL database.

16. PHP DATABASE BASICS

16.1 Introduction to Relationship Databases

16.2 Introduction to MySQL

16.3 Introduction to MySQLi and PDO

16.4 Connecting MySQL database with PHP

16.5 CRUD (Create, Read, Update, Delete Records)