Phone

9851196943 | 9805310618

Address

Bhupi Marg, Biratnagar-3

Advanced PHP with MySql Database

Beginner & Advanced Classes, this PHP and MySQL course will provide you with the skills and knowledge necessary to create dynamic database-driven websites

Web Development Fundamentals

  • Introduction to Web Technology
  • Choosing Code Editors / IDEs
  • Understanding HTML Markup
  • Introduction to HTML5
  • Introduction to CSS
  • Introduction and difference between Server Side and Client Side Scripting Language
  • Using Bootstrap framework

PHP Introduction

  • Introduction
  • PHP as a Server Side Scripting Language
  • How PHP scripts works and why use PHP?
  • Installation and Configuration: Setting up PHP Development Environment
  • AMP Stack and Working with configuration files (php.ini and httpd.conf)
  • PHP CLI (Command Line Interface)
  • Runtime Configuration
  • Basic overview of working in team using version control tool like GIT, Github,
  • Other tools overview like composer for package management
  • Syntax, Quotes, Comments and Special Characters
  • Building and running our first program
  • Data types
  • Debugging basics
  • PHP web concepts
    • Web Architecture (Client / Server communications)
    • How to embed PHP into HTML
    • How to embed HTML into PHP
    • Validating and Escaping

PHP Identifiers

  • Variables
  • Constants
  • Arrays
  • Single Dimensional & Multi-Dimensional Arrays
  • Accessing Arrays
  • Playing with Arrays
  • Array functions ? size, merging, sorting etc...

Operators

  • Introduction
  • Assignment Operators
  • Arithmetic Operators
  • Comparison Operators
  • Increment / Decrement Operators
  • String Operator (Concatenation)
  • Logical (or Relational) Operators
  • Conditional (or ternary) Operator

Control Structures (Conditional statements and Loops)

  • Usage of Control structures
  • Types of Conditional Statements
  • if else condition
  • The switch statement
  • Loop Statements
  • for, while , do while loops
  • break and continue statements
  • foreach loop
  • Nested control structures and loops

Understanding HTTP Verbs and Methods

  • GET Method
  • POST Method
  • Form Handling with these Methods
  • Working with forms (in detail)
  • Creating a form with different form inputs
  • Using hidden fields
  • Redirecting the user from one page to another
  • File handling using form (multipart form data)

PHP Global Variables (Superglobals)

  • $GLOBALS
  • $_SERVER
  • $_REQUEST
  • $_POST
  • $_GET
  • $_FILES
  • $_ENV
  • $_SESSION
  • $_COOKIE

Session

  • Understanding Session and Cookies
  • Creating session
  • Assigning data to Session Variables
  • Reading From Session Variables
  • Destroying Session and Session Data

Function

  • Introduction
  • Usage of function
  • Types of function (Predefined (Inbuilt) & User Defined function)
  • Function parameters (With or without and conditional parameters)
  • Arguments by value and reference
  • Returning values from a function
  • Variable Scopes of a function
  • Working with Some useful functions
  • Date and time function
  • Include and require
  • Templating using include and require

String Manipulation & Patterns

  • Formatting String for Presentation (printf, sprintf)
  • Formatting String for Storage
  • Joining and Splitting String
  • Comparing String
  • Matching and replace Substring
  • Extracting substrings
  • Determining the length of string
  • String Patterns
  • Matching patterns
  • Finding matches
  • Replace patterns

Sending Email

  • Introduction to SMTP
  • Sending Emails with PHP

Database

  • Introduction To Database
  • What is RDBMS technology?
  • Difference between SQL and NoSQL Database
  • Introduction to MySQL / MariaDB and Other databases
  • Understanding Database, Tables, Fields
  • Introduction to SQL (Structured Query Language)
  • Data modeling
  • MySQL Command Line Usage / Terminal MySQL
  • Using Database Management tools (phpMyAdmin/ MySQL Workbench etc.) to handle database
  • Creating and managing database
  • Selecting Database
  • Creating Tables
  • Auto Increment and Indexing a columns in tables
  • Inserting Data into tables in different ways via query
  • Updating Data and Table Structure
  • Selecting from table in different ways
  • Deleting tables and drop database
  • Alter Table structure

Advanced Course


Introduction to Object Oriented Programming

Database Operations Advanced Topics

  • User Management and Privileges
  • GRANT and REVOKE Statements
  • Creating Primary, Index and Unique Keys
  • Primary Key, Foreign Key Relationship and Mapping
  • Maintaining Foreign Key Constraints
  • Joins and Types of JOINS with examples
  • Sub Queries
  • VIEWS
  • Functions, built
  • in functions, User defined functions
  • Prepared Statements
  • Stored Procedures and Triggers
  • PL/SQL (CASE, LOOPS and Cursors)
  • Transactions
  • Patterns in database design

JavaScript and jQuery Basics

  • Introduction to JavaScript
  • Data types, operators, conditions
  • Events, function
  • Array and Objects
  • jQuery Syntax, Events
  • Some jQuery functions
  • jQuery Syntax and Events
  • jQuery Effects
  • jQuery Selectors and Traversing
  • jQuery Custom Functions
  • jQuery load, get, post
  • jQuery Ajax

Internet communications and Validations

  • HTML web forms and URLs
  • Server side input validation
  • Client side input validations
  • Session and cookie protection
  • Output control
  • Headers and browser caching

Web Security in PHP

  • Introduction to Web Security
  • Cross Site Scripting (XSS) / CSRF Attacks
  • Client side Validating Forms with JavaScript
  • HTML5 Form Validation
  • Server side Validating Forms

Project Work - A Project on PHP using database