PHP Training in Nepal

Course Contents

If you want to master PHP programming then the school of information technologies offers you the Best PHP Training and MySQL Training in Nepal with all the essential PHP course contents.

Basic Revision

• Choosing Code Editors / IDEs
• Core concepts of HTML/HTML5
• Understanding Uses and Modification of CSS Components for Web Developer
• Using Bootstrap framework
• O/P: Design Basic website layout, Tables, Forms

Basic Terminology

• Domain Registration
• Web Hosting
• FTP
• HTTP
• CPanel and Uploading website
• Client/Server Architecture

Setup with Different Environment

• Introduction to PHP
• How do PHP scripts work and why use PHP?
• Installation and Configuration: Setting up PHP Development Environment
• AMP Stack and Working with configuration files (php.ini and httpd. conf)
• Change Runtime Configuration of Server
• Basic overview of working in a team using version control tools like GIT, Github,
• Other tools overview like a composer for package management
• O/P: Setup Server and Modification of Configuration

Basic Starting of PHP Code

• Syntax, Quotes, Comments, and Special Characters
• Building and running our first program
• Output Commands (echo vs print)
• Debugging basics
• PHP with HTML
• How to embed PHP into HTML
• How to embed HTML into PHP
• Validating and Escaping

PHP Identifiers

• Variables and Constants
• PHP Data Types
• PHP Global Variables ($GLOBALS, $_SERVER, $_REQUEST,$_POST,$_GET,$_FILES,$_ENV,$_SESSION,$_COOKIE)
• What is Array?
• Basic Uses of Array
• Accessing and playing with Arrays
• Important inbuilt array functions : array_merge, array_sort, rsort, ksort, krsort, in_array, array_search, array_keys, array_values, array_chunk, array_count_values, array_unique, count,array_push,  array_pop, array_shift, array_unshift
• O/P: Displaying Tables Data Using Array with using array functions.

Operators

• Introduction and types of operators
• Assignment Operators
• Arithmetic Operators
• Comparison Operators
• 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, for each)
• break and continue statements
• Nested control structures and loops
• Working with table and array data using loops,
• Handling 2 dimensional, 3 dimensional and multi
• Dimensional array data and display in tabular form,
• O/P: Display Table information with different types of loops and conditions.

Understanding HTTP Verbs and Methods

• Form handling with GET Method POST Method
• Working with forms (in detail)
• Creating a form with different form inputs
• Using hidden fields
• Redirecting the user from one page to another
• Upload and Delete Files (multipart form-data)
• Server Side Validations
• O/P: Retrieve of Form data, Starting project setup idea and login form validations

 Session and Cookies

• Understanding Session and Cookies
• Session Functions: session_start,session_destroy,assigning session variable,retrieving session variable
• Setting, Reading, Expiration of Cookies
• O/P: Develop Login System using Session and Cookie

Function

• Introduction to function
• Types of function (library functions(Inbuilt) & User Defined function(Custom))
• Function parameters (With or without and conditional parameters)
• Return Value Functions
• Variable scope into different function
• Working with Some useful functions (String, Date time, Array)
• File Inclusion Function(require,include)
• Email Functions (Sending Email) and Concept of SMTP

PHP String Manipulation Functions

•  Joining and Splitting String
• Compare String with strcmp
• Generate Substring with substr
• Determining the length of string with strlen
• String Patterns Matching
• Other string functions
• O/P: Displaying Information using all the above functions

File System Functions

• File Constants
• Creating and deleting a file
• Opening a file for writing, reading, or appending
• Reading and writing into files(String, Characters)
• Working with directories
• Checking for the existence of the file and check the size of files
• O/P: Concepts of maintaining Log for Projects 

Database

• Introduction to Database
• DBMS vs RDBMS?
• Introduction to MySQL / MariaDB
• Understanding Database, Tables, Row, Columns, index
• Introduction to SQL (Structured Query Language)
• Brief description of DDL, DML, DCL
• Using Database Management tools (PHPMyadmin/ MySQL Workbench etc.) to handle database
• DDL Command(Creating and managing database, Select Database and Data form table, Create Tables, Alter table and fields)
• DML(Inserting Data using different methods, Selecting Data, Updating Data)
• O/P: Create Database, Table, Altering Table Structure

CRUD Application using MySQL

• Login System Using Database
• ER Diagram
• Creating Users
• Insert Data into different tables
• Select Data into a different format
• Update information into the table
• Delete data from the database
• Soring, Searching data
• O/P: Complete Admin Panel and Displaying Tables into Different Table

Database Advance Topic

• DCL Commands (GRANT and REVOKE)
• Creating Primary, Index, and Unique Keys
• Primary Key, Foreign Key Relationship, and Mapping
• Maintaining Foreign Key Constraints
• Joins and Types of JOINS with examples
• Builtin Database Functions
• Prepared Statements
• Stored Procedures and Triggers
• Transactions

PHP Database Extensions and Drivers

• Mysql and Mysqli extension
• Concepts of PHP Data Objects (PDO) API
• ODBC Concepts

JavaScript and jQuery Concepts

• Introduction to JavaScript
• Data types, operators, conditions
• Events, function
• Array and Objects
• Introduction to Jquery
• jQuery Syntax
• jQuery implementation
• jQuery Effects and events
• jQuery Selectors and Traversing
• jQuery Custom Functions
• Client Side Validations
• Ajax ( Javascript and jquery) -Searching, Filtering, Loading Data
• O/P: implementation of jQuery and its plugin into projects

 Object-Oriented PHP

• Introduction to OOP
• Defining Class in PHP (Properties, Methods)
• Instantiating a class(Crate Objects)
• Constructors and Destructor
• Class constants / Attributes and methods
• Visibility Access(Access Modifiers) – public,private,protected
• Static ( properties and methods)
• Inheritance in PHP
• Overrides and Overloading
• Abstract Class and methods
• Object Interface
• interface vs abstract class
• OOP Keywords (Class Autoload, Static & Final Keywords)
• Autoloading Classes / Magic methods
• Serializing Objects and Destroying Objects
• Namespaces
• Built-in Functions that work with classes

Exception Handling

• Introduction to Exceptions Handling
• Using Try & Catch, Throw blocks
• Generating Custom Exceptions
• Multiple Catch Blocks
• Default Exception processing

Project Work Using OOP PHP -CMS

• File structure / Code file organization
• Code Structure and Documentation
• Login System using OOP
• CRUD using OOP
• Displaying information using OOP

Web Security in PHP

• Introduction to Web Security
• Implementing Security in PHP
• Security concerns in MySQL
• SQL/OS/Code Injection
• Cross-Site Scripting (XSS) / CSRF Attacks
• Session Hijacking
• Client-side Validating Forms with JavaScript
• HTML5 Form Validation
• Server-side Validating Forms

MVC Framework Baseline

• .htaccess Files and regular expressions
• Bootstrapping Applications
• File structure / Code file organization
• Managing Code Library and Folders
• Design pattern and introduction
• Model / View / Controller design pattern implementation
• Library Classes
• Model classes and abstraction, database access and patterns
• View classes and layouts
• Design Patterns

MVC-Projects

• Creating an MVC framework
• The flowchart and DFD Diagram
• UML Diagram
• Class
• Use Case
• Interaction diagram
• Create Projects using payment gateway

 Project Work:

• Create a Real-time CRUD application using the  Bootstrap template.

Web services and API

• Web services
• Data formats (JSON,SML)
• Parsing APIs
• Web services requests
• SOAP services
• RESTFUL services
• Handling JSON in PHP
• Parsing JSON  

XML with PHP

• What is XML
• XML Syntax
• Document Type Definitions(DTD)
• Parsing XML With PHP
• Web services with XML
• PHP and XML
• Fetching and handling RSS Feeds
• Using XML as a String

Version Control and Composer (Dependency Manager)

• Composer and installations
• Composer.phar
• Composer.json
• GIT and Github
• Setup Repository
• Important Keywords(Pull, Push, Fetch, Commit)

Framework: Laravel

• Introduction with the latest version
• Routing
• Migration
• Seeding
• Controllers
• Models
• Views
• Requests
• Session and Flash Message
• Scaffolding
• Templating using blade
• O/P: Create CRUD projects using laravel

Extra Features for  Project:

• Introduction to GD library
• Working with images
• Create PDF
• Generate Excel File
• Reading CSV and Writing CSV
• Image generation
• Creating a Simple Image
• Using True Type Fonts
• Saving and Building on Existing Images
• Creating a Captcha Image

 Deployment of Projects

• Domain Registration
• Web Hosting
• Uploading Website
• Upload Database
• Making Website Live