PHP with Mysql Course Content

Prerequisites

  Html

  Java Script

  CSS

HTML

·         Introduction  to html

·         What is html?

·         Introduction to editors and browsers.

·         What is tag?

·         Discuss about basic tags of html.

·         Discuss about head section tags.

·         What is an attribute?

·         Discuss about an attribute?

·         Discuss about textformatting tags

·         Discuss about body tags(marquee,img,embed,anchor,named anchor)

·         Image mapping

·         Introduction to tables.

·         Diffrence b/w th and td

·         Discuss about table attributes in notepad.

·         Template creation with tables

·         Lists

·         Introduction to forms

·         Discuss about forms.

CSS

·         Introduction to css                                                                       

·         What is css?

·         Types of css.

·         What is inline css

·         Discuss inline css

·         What is internal css

·         Discuss internal css

·         Discuss about properties

·         Types of selector.

·         Difference b/w class selector and id selector.

·         What is div?

·         Template creation with divs.

·         Difference b/w div and span

·         External css

JavaScript

·         Introduction to  JavaScript

·         What is JavaScript

·         What  is statement

·         Types  of  statements.

·         What is variable

·         Variable declaration

·         What  is an operator?

·         Types of operator

·         Discuss operators theratically and practically.

·         Condition Statements

·         Introduction to loops

·         For loop examples

·         While Loop Examples.

·         Difference b/w while and dowhile loops

·         Functions

 Parameterized functions

  Non-parameterized functions

  Recursive functions

  Difference b/w parameterized and non-parameterized functions

  Math calculations using functions

  Math calculations using functions and forms

·         Introduction to Objects

·         What is property and method?

·         String object

·         Math Object

·         Navigator object

·         Screen object

·         Date Object

·         Array Object

·         Introduction to HTMLDOM

·         Document object

·         Window object

·         Discuss dropdown menu practically

·         Discuss navigation menu practically

                                                            

PHP

Introduction to php

·        History Of PHP

·        What is php?

·         Versions and Difference between them

·         Installation process of XAMPP

PHP Basics

·         Default Syntax

·         How to write php page?

·         Php output statement and method

·         Where to save php page

·         How to run php page

·         Styles of PHP Tags

·         Comments in PHP

·         Output Functions

·         Data Types

·         Configuration Settings

·         Error Types

 Variables in PHP  

·         Variable Declarations

·         Variable Scope

·         PHP’s Superglobal Variables

·         Variable Variables

  Constants in PHP

• Magic Constants
• Standard Pre-defined Constants
• User defined Constants

Control Structures

        ·  Execution Control Statements

         ·  Conditional Statements

         ·  Looping Statements

 Functions

• Creating Functions
• Passing Arguments by Value
• Passing Arguments by Reference
• Recursive Functions

Arrays

·         What is an array?

·         Discuss about single-dimensional array

·         Discuss about two-dimensional array

·         Discuss about multi-dimensional array

·         Array methods

·         Array sorting methods

·         Built-in Array

Loops

·         For each as loop

·         While list each loop

·         For in loop                        

Include Functions

·         Include, Include_once

·         Require, Require_once

Regular Expressions

·         Validating textboxes,emails,phone number,etc

·         Creating custom regular expressions           

Object Oriented Programming in PHP

·         Class,Objects,Fields,Properties,Methods,Constants,_Set()

·         Access Specifiers

·         Encapsulation And Types

·         Inheritence and Types

·         Method OverLoading ,Method Overriding ,Polymorphism

·         Constructors,Parameterized Constructors and Destructors

·         Interface , Final Abstract

·         Static Class Members, Instance Of keyword, Helper Functions

·         Object Cloning and Copy

·         Reflections

PHP with MYSQL

·         What is MySQL

·         Integration with MySQL

·         My SQL functions

·         Gmail Data Grid options

·         SQL Injection

·         Uploading and downloading images in Database

·         Registration and Login forms with validations

·         Send data from client to server with form validation

·         Pagging , Sorting …

Strings And Regular Expressions 

·         Declarations styles of String Variables

·         Heredoc style

·         String Functions

·         Difference b/w explode and implode methods

·         Regular Expression Stntax(POSIX)

·         PHP’s Regular Expression Functions(POSIX Extended)

Working  with Files and Operating System

•  File Functions
• Open, Create and Delete files
• Create Directories and Manipulate them
• Information about Hard Disk
• Directory Functions
• Calculating File, Directory and Disk Sizes

 Error and Exceptional Handling

·         Error Logging

• Configuration Directives
• PHP’s Exception Class
• Throw New Exception
• Custom Exceptions

Date and Time Functions

Admin login creation

Admin panel creation

Mail

 Authentication

• HTTP Authentication
• PHP Authentication
• Authentication Methodologies

Query String   

Cookies

• Why Cookies
• Types of Cookies
• How to Create and Access Cookies

Sessions

• Session Variables
• Creating and Destroying a Session
• Retriving and Setting the Session ID
• Encoding and Decoding Session Data
• Auto-Login
• Recently Viewed Document Index

·         Login page creation with remember me(sessions and cookies)

Ajax

              Introduction to Ajax

·         What is XMLHTTPRequest object?

·         Ajax properties

·         Ajax methods

·         Ajax event  handler

·         Ajax with php and mysql

·         Double drop down list box

Web Services

• Why Web Services
• RSS Syntax
• SOAP
• How to Access Web Services

XML Integration

• What is XML
• Create a XML file from PHP with Database records
• Reading Information from XML File

MYSQL Concepts

·        Introduction

·         Storage Engines

·         Functions

·         Operators

·         Constraints

·         DDL commands

·         DML Commands

·         DCL Command

·         TCL Commands

Discuss about queries

·         Creating tables

·         Inserting values to tables

·         Retrieving data from tables

·         Update and delete data

·         Exploring where keyword

·         Exploring order by keyword

·         Exploring rand keyword

·         Exploring  like keyword

·         Exploring limit keyword

·         Exploring  as keyword

·         Group by

·         Views

·         Joins [Inner Join , Left Join , Right Join]

·         Curosrs

·         Indexing

·         Stored Procedures

·         Mysql with PHP Programming

Introduction to Jquery

   What is jquery?

o   Introduction to Jquery selectors

o   Introduction jquery filters

o   Types of jquery filters

o   Jquery animations and effects

o   Jquery events and functions

o   Jquery UI

o   Jquery with ajax

o   Php with jquery examples

WORDPRESS 

v  DownLoad and Install Wordpress

v  DashBoard OverView

v  Posts

v  How to use Images in WordPress

v  Pages

v  How to Create Menus

v  Comments

v  Working with Themes

v  Plugins

v  Widgets

v  Managing Users

v  Set Site Title, Tag Line , PermaLinks , FrontPage

v  How to Make WordPress Blog.

v  How to make WordPress WebSite

v  How to make Ecommerce Website

JOOMLA

Introduction

·        Why Joomla?

·        Installation

·        FrontEnd & administrator

·        Adding New Category

Articles

·       How to add Articles?

·       How to link articles to your menu?

Menus

• How to make new menu?
•  Menu Manager
• Add New Menu Item
• How To Add a Contact Page?

Modules

·       Module Manager

·       Add a New Module

§  Creating a Category Blog

§  Archived Articles

§  Featured Articles Menu Item

§  Batch Process

§  Archived Article Module

§  Bread Crumbs

§  Latest Users Module

§  Statistics Module

§  Search Module

§  Random Image Module

§  Login Module

§  Redirect Manager

§  Who’s Online Module

§  Wrapper Module

§  Mass Mail Users

§  Single News Feed Menu Item

§  Add News Feed

§  List News Feeds in a category

§  Add a contact Form

§  Enable SEF

§  Update Extension

§  Update Joomla

§  Add an Artcicle

§  Assign Template

§  Global Cofiguration

• Working With Images
• Working With Templates
• Working With Extensions
• Working  With Plugins
• Working With Components
• Easy URL’S

Thanks

Srinivas

9059361460
srinivas.r.salesforce@gmail.com