PHP with Mysql Training in Kovilpatti

HTML Basics

• Introduction
• What is difference between HTML and HTML5?
• HTML Overview
• DOCTYPE
• HTML Tag Vs Element
• HTML Attributes

Basic Formatting Tags

• Basic HTML Tags
• Basic Formatting Tags

HTML Grouping Using Div and Span

• Div Tag
• Span Tag

HTML Lists

• Unordered List
• Ordered List
• Definition List

Images

• Image and Image Mapping

Tables

• <table>
• <tr>, <th>
• <caption>
• <thead>, <tfoot> , <tbody>
• <colgroup>

Frames

• Iframes
• Attributes Using Iframe as the Target

Forms

• HTML Form Elements
• HTML Input Types
• HTML Input Attributes

HTML Media

• HTML Audio and HTML Video

• What is CSS?
• CSS Inclusion
• Selectors
• Colors
• Background
• Border
• Margin
• Padding
• Height
• Width
• Sizes
• Box-Model
• CSS Fonts
• CSS Text
• CSS links
• CSS Tables
• Display, Position
• Margin property
• Padding property
• CSS Lists Styles
• CSS Cursors
• CSS Overflow
• CSS Position
• Pseudo Classes
• Pseudo Elements
• Animation
• Transform
• Transition
• Media Query
• Box Sizing Flex and Grid

• Introduction
• Variable Declaration
• Arithmetic Operations
• Array
• Array Methods
• String
• String Method
• Math Module
• Condition Statements
• Loops
• Set, Map
• Events
• Module
• Oops
• Asynchronous
• Promise
• Async, Await
• FetchApi
• JavaScript Function
• Function Closure
• Regular Expression
• Error Handling DOM
• Event Listener
• Date Methods
• Object

Introduction to PHP

• Evaluation of Php
• Basic Syntax
• Defining variable and constant
• Php Data type
• Operator and Expression

Control Structure

• If Statement
• If……Else Statement
• If…If Else Statement
• Nested If Statement
• Switch Statement

Looping Structure

• For Loop
• While Loop
• Do…While Loop
• For each Loop

Functions

• Why to create Functions
• Types of Functions
• Call by value and Call by reference
• Recursive function

Strings & Arrays:

• Creating and accessing String
• Searching & Replacing String
• Formatting String
• String Related Library function
• What is Array
• Associative Array
• Numeric Array
• Multi-Dimensional Array

Handling Html Form with Php

• PHP Form Handling
• PHP Form Validation
• Different ways to carry form data (GET, POST)
• PHP Form URL/E-mail
• PHP Form Complete

Working with file and Directories

• Understanding file& directory
• Opening and closing a file
• working with directories
• File Uploading & Downloading

OOPs Concept

• Class & Object
• Access Modifier
• Properties of Object
• Encapsulation and abstraction
• Inheritance
• Polymorphism

Session and Cookie

• Introduction to Session Control
• Creating Cookies
• Set Cookies
• Destroying Cookies
• Creating Session
• Set Session
• Destroying Session

Database Connectivity with MySql

• Introduction to RDBMS
• Connection with MySql Database
• Performing basic database operation(DML)
• (Insert, Delete, Update, Select) Setting query parameter
• Executing queryJoin (Cross joins, Inner joins, Outer Joins, Self joins.)

Exception Handling

• Understanding Exception and error
• Try, catch, throw
• Error tracking and debugging

Introduction

• The Relational Model

Understanding Basic SQL Syntax

• Basic SQL Commands – SELECT
• Basic SQL Commands – INSERT
• Basic SQL Commands – UPDATE
• Basic SQL Commands – DELETE
• Querying Data with the SELECT Statement
•  The SELECT List
• SELECT List Wildcard (*)
• The FROM Clause
• How to Constrain the Result Set
• DISTINCT and NOT DISTINCT

Filtering results with Where Clause

• WHERE Clause
• Boolean Operators
• The AND Keyword
• The OR Keyword
• Other Boolean Operators BETWEEN, LIKE, IN, IS, IS NOT

Shaping Results with ORDER BY and GROUP BY

• ORDER BY
• Set Functions
• Set Function And Qualifiers
• GROUP BY
• HAVING clause

Matching Different Data Tables With JOINS

• CROSS JOIN
• INNER JOIN
• OUTER JOINs
• LEFT OUTER JOIN
• RIGHT OUTER JOIN
• FULL OUTER JOIN
• SELF JOIN

Creating Database Table Stamp

• CREATE DATABASE
• CREATE TABLE
• NULL Values
• PRIMARY KEY
• CONSTRAINT
• ALTER TABLE
• DROP TABLE

Introduction

• Introduction of Laravel
• Features of Laravel
• History of Laravel
• Introduction of MVC Pattern
• Laravel Directory Structure

Laravel Routing

• Laravel Basic Routing
• Routing Parameters
• Laravel Named Routes
• Laravel Middleware
• Laravel Route Groups

Laravel Controllers

• Laravel Controllers
• Routing Controllers
• Resource Controllers
• Controller Middleware

Laravel Views

• Passing data to view
• Sharing data to all views
• Blade Template Engine
• Introduction
• Template Inheritance
• Displaying Data
• Implement Control Structures

Laravel Blade Template

• Display Images
• Make Anchor
• Displaying Variables
• Conditional Statements
• Loop in blade
• PHP function
• Build Your Master layout
• Extending the master layout
• nested views
• Include Views
• Adding assets

Using Forms and Gathering Input

• Adding HTML 5 Package
• Creating A form using Blade Syntax
• Validating user input
• File Uploading
• Error message Handling
• Encrypting and decrypting data
• Preserving the data

Laravel Database

• Introduction Model
• Type of Database using
• Eloquent ORM Model
• Naming Convention
• Table name
• Primary key
• Timestamps
• Use model
• Display data from models in views
• Manage Mass Assignment
• CRUDS Operation (Create Read Update Delete Search Operations)
• Fluent
• Simple Query String
• Query Builder

Security & Session

• Removing Public from URL
• Sessions Effective

• Understanding data flow & Architecture
• Communication b/w view and controller
• Connectivity with MySQL database
• Data Validation
• Saving & Registering Data
• Receiving Data from MySQL
• CRUD Operation
• Login Panel