Training on Program On Web Development With PHP & Mysql

Training on Program On Web Development With PHP & Mysql

Course Fee: 5000 Tk

Class Start: 02/01/2017

Overview: PHP and MySQL™ are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications. This hands-on MySQL and PHP training course teaches attendees everything they need to successfully build data-driven Web sites using MySQL and PHP.


Course Objective

Learning HTML

Overview of CSS and CSS frameworks

Familiarity with PHP languages and syntax

Integration of PHP with HTML

Processing form data

Inserting form data into MySQL

Fetching data from MySQL

Sending Emails using PHP using inbuilt methods

Uploading images/files on the server

Securing contents using Cookies and Sessions

Who Should Attend
This course is designed for individuals who have been developing web pages with a GUI and want to progress to developing using three tier architecture (Client, Middle, and Database).

All MySQL and PHP training attendees must be fluent in HTML. The course can be customized to any level of programming and relational database familiarity.

Course Duration


64 Hours, 32 Classes, 2 Hours per class


Course Content

Lesson 01: Web Technology Introduction

  • How Internet Works
  • How Website Works
  • What is Domain, Hosting, Server, DNS
  • What is cPanel and Domain Control Panel
  • How Multiple Programming Codes work to Run a


Lesson 02: HTML

  • Introduction – Code Editors and other Basics Concepts of Web Technology
  • Editors - HTML can be edited by using a professional HTML editor.
  • Elements – Concept of Tags, Code Writing Concepts
  • Attributes – Common Attributes of HTML Tags and their Use
  • Basic – About HTML Basic structure
  • Headings and Comments – Use of Heading and Comments
  • Paragraphs – Paragraph, Div and their Implementation
  • Formatting – Font Formatting, Different Tags to Format Fonts


Lesson 03: HTML

  • Links – Implementation of Links, and Description of Link Attributes
  • Head – Head Elements, and the Contents of Head
  • Images – Image Tags and its Attributes
  • Tables – Detailed Table Attributes and Uses of Table
  • Lists – Unordered, Ordered, Description Lists and other List Tags
  • Blocks – Div, Span, Layout and their Usages in Modern HTML
  • Forms – Implementation of Forms and all type of Inputs
  • HTML Forms Element - This chapter describes all HTML form elements.
  • HTML Input types - This chapter describes the input types of the  element.
  • HTML Input Attributes - The value attribute specifies the initial value for an input field
  • iFrames – Syntax of iFrame and its Usage


Lesson 04: CSS

  • Syntax – How to write CSS Codes
  • ID & Class – Implementation of CSS using ID and Class
  • Style Sheet – Integration of Style sheets inside HTML
  • Backgrounds – Creating background with CSS
  • Text and Fonts – Text and Font formatting with the help of CSS
  • Links – Styling hyperlinks
  • Lists – Creating List and List contents with CSS
  • Tables – Creating table designs with CSS


Lesson 05: CSS

  • Box Model – Margin, Border, Padding, and Content Management
  • Border – Border creation with CSS
  • Outline – Outline, border, contents
  • Margin – Explanation of the use of Margin using CSS
  • Padding – Possible Padding Values, padding Sides and Properties
  • Grouping – Grouping and Nesting
  • Dimension – Dimension Concepts in CSS
  • Positioning – Static, Fixed, Relative and Absolute Positioning & Overlapping
  • Navigation Bar – Navigation Bar, Link and Menu Creation


Lesson 06: HTML 5

  • introduction
  • HTML5 Support - You can teach old browsers to handle HTML5
  • HTML5 All Elements – About HTML5 All Element
  • HTML5 Migration – HTML5 Migration
  • HTML5 Forms – All HTML form element.
  • HTML Video -HTML5, there was no standard for showing videos on a web page.
  • HTML YouTube -The easiest way to play videos in HTML, is to use YouTube.


Lesson 07: CSS 3

  • CSS3 Animation
  • CSS3 Borders
  • CSS3 Backgrounds
  • CSS3 Fonts
  • CSS3 Multiple Columns
  • CSS3 Text Effects
  • CSS3 Transition Effects
  • CSS3 user Interface
  • CSS3 2D Transform
  • CSS3 3D Transform


Lesson 08: Bootstrap

  • How to download & using bootstrap
  • Grid system
  • Drop Down Menu
  • Carousel
  • Thumbnails
  • Navigational tabs, pills, and lists
  • Accordion
  • Modals
  • Button groups


Lesson 09: JavaScript

  • JS Introduction
  • JS Syntax
  • JS Statements
  • JS Comments
  • JS Variables
  • JS Data Types
  • JS Operators
  • JS Functions
  • JS Objects
  • JS Events
  • JS Dates
  • JS Arrays
  • JS Switch
  • JS Loop For
  • JS Breaks
  • JS Window
  • Alert Box
  • Confirm Box
  • Prompt Box


Lesson 10: JS HTML DOM

  • DOM Methods
  • DOM Document
  • DOM Elements
  • DOM Events
  • DOM Navigation


Lesson 11: Basic PHP

  • Syntax, Print / Echo – Basic concepts on PHP
  • Variables, Data Types, Constants – Data Types and Variables in PHP
  • Operators – Operators in PHP Programming
  • If...Else...Else-If – Different conditional statements in PHP
  • Switch – PHP Switch Case
  • While Loops – Implementation of While loop
  • For Loops – Practical implementation of for loop
  • Functions – Doing tasks using PHP functions
  • Arrays – Array and multi-dimensional data handling
  • Date – Use of Date functions and their Elements
  • Important Common PHP Functions – Trim,Round, Min, Max, Get Browser


Lesson 12: MySQL Database

  • Database Management Tools – PhpMyAdmin/MySQLyog Concepts
  • MySQL Intro – How, when and where to use MySQL
  • MySQL Connect – How to get connected to MySQL
  • CREATE DB/Table – How to Create Database
  • INSERT INTO – How to insert data in Database at Data-tables
  • SELECT – How to select and grab Data from Database
  • WHERE – How to select Data from Database using Conditions
  • ORDER BY – How to bring Data from Database in Order
  • UPDATE – How to Update Data in a Database
  • DELETE – How to Delete Data/Table in a Database
  • BASIC JOIN – How to use JOIN and the Importance of it in Database
  • KEYS – Use and Importance of Primary and Unique Key in Database
  • MySQL Functions – Some Important MySQL Functions


Lesson 13: PHP Form Handling

  • Form Handling – on-Page and off-Page form handling Technique
  • Form Validation – Detailed guideline to use Form in PHP
  • Form Required Field Check – Verifying data that will be accepted by Form


Lesson 14: Advanced PHP

  • Include – PHP Include Concepts
  • Require - PHP Require Concepts
  • Dynamic Contents – Dynamic implementation of Forms and Tables
  • File Handling and Upload – File Handling and Upload using PHP
  • Cookies – How to use Cookies in PHP
  • Sessions – Use of Session, Guideline about Login-Registration System
  • Error, Exception – Error and Exception Handling using PHP
  • E-Mail – PHP Email System, SMTP Email System
  • Readymade Functions – Get IP, Password Generator, Excel Generator


Lesson 15: Jquery

  • Introduction
  • jQuery Syntax
  • jQuery Selectors
  • jQuery Events
  • jQuery Hide/Show
  • jQuery Fade
  • jQuery Slide
  • jQuery Animate


Lesson 16: jQuery HTML

  • jQuery Get
  • jQuery Set
  • jQuery Add
  • jQuery Remove
  • jQuery CSS Classes
  • jQuery css()
  • Drag & Drops
  • Sortable
  • Resize
  • Accordion
  • Datepicker
  • Instant Search


Lesson 17: About Domain & Hosting – Cpanel

·  Introduction Cpanel

·  How to purchase Domain & Hosting

·  Upload Your website

·  Backup Your website

·  Email create

·  Redirect URL

·  Much More