PHP My SQL Training

1) Introduction to web

• Content of webpage
• Static vs dynamic webpage
• Technologies to create static webpage
• Technologies to create dynamic webpage

2) Installation

• Installation of PHP, MySQL or MariaDB and Apache
• Installation of IDE

3) Introduction to PHP

• How to display output
• Datatypes and variable declaration
• Datatype conversion
• Using comments
• Operators
• Type casting

4) Control flow in PHP

4.1) Conditionals

• The if statement
• The else statementX
• The else if statement
• The switch statement

4.2) Looping

• while loop
• do...while loop
• for loop
• breaking out of a loop

5) Arrays in PHP

• Numerically Indexed arrays
• Associative arrays
• Assignment using the array keyword
• foreach loop
• Multidimensional arrays

6) Form Handling in PHP

• Difference between GET ,POST and Request
• Building Forms
• Retrieving submitted data

7) Functions in PHP

• String functions
• Date time functions
• Array functions
• Math Functions
• Mysqli Functions
• Create your own functions

8) Reusing Code in PHP

• include include_once statement
• require require_once statement
• Breaking HTML, CSS template and reuse of it

9) Session in PHP

• Starting a session
• Ending a session
• Insert Show value in session
• Update Destroy value of session
• Login Control Demo

10) Cookies in PHP

• Setting a cookie
• Accessing cookie
• Destroying a cookie

11) File Handling

• File Functions
• Create,Delete File
• Update File Content
• File Upload

12) Mail

• Mail() Example
• PHPMailer Library use

13) SQL

• SQL using MySQL or MariaDB
• Creating a database
• Selecting database
• Datatypes
• Creating a table
• Inserting data into table
• Show data from table
• Drop table
• Drop database
• Constraints
• Joins

14) PHP Mysql CRUD

• Insert
• Display
• Edit
• Delete

15) Forms and Form Validation

• How webpack works
• Project and npm setup
• Creating basic folder and file structure
• Setting up basic Webpack configuration

16) Project

17) Ajax

• What is Ajax?
• Using XMLHttpRequest
• GET method
• POST method
• JSON example
• Inserting data into City State Example

18) Web services

• Introduction to web service
• Introduction to JSON
• Creating web service
• Consuming web service
• JSON parsing

19) Wordpress

• Installation of WordPress
• Getting started with WordPress
• WordPress as a blogging platform
• WordPress as a content management system
• Work with WordPress themes
• Manage multimedia in WordPress
• Install plugins in WordPress
Page builder plugin
• Page builder plugin
• Adding of google map
• Adding of contact form
• Export and import of data