DIPLOMA IN PHP AND MYSQL

  • Home -
  • DIPLOMA IN PHP AND MYSQL

DIPLOMA IN PHP AND MYSQL -(C1186)

DIPLOMA IN PHP AND MYSQL

CERTIFICATE IN PHP AND MYSQL

PHP Basics

  • Introduction
  • XAMPP & WAMPP
  • Configure php.ini
  • PHP Syntax
  • Variables, Strings, Constants, Operators
  • Echo / Print
  • If....Else......Elseif
  • Switch
  • Loops
  • For, Foreach , While
  • Functions
  • string functions - introduction
  • user defined functions
  • Strings & Patterns
  • Quoting
  • Matching
  • Extracting
  • Searching
  • Replacing
  • Formatting
  • PCRE
  • NOWDOC
  • Encodings

Arrays

·         Introduction

·         Array syntax

·         Array Index

·         get length without using pre-defined functions

·         Array push and pull

·         Associative arrays

  • loop through arrays
  • Multidimensional Arrays
  • Array functions
  • Array Sorting without using pre-defined functions
  • Date and Time
  • Date and Time
  • include, include_once, require, require_once
  • PHP Form
  • $_GET , $_POST , $_REQUEST
  • File Upload

Session

  • Sessions - introduction
  • Start a PHP session
  • session variables
  • modify session
  • destroy session
  • Cookies
  • Cookies
  • Start a PHP Cookies
  • Cookie variables
  • modify Cookie
  • destroy Cookie

Try….Catch

  • Error handling
  • try-catch-throw
  • Exception
  • Filters
  • Filers Advanced

OOP’s Concept

  • OOP's – introduction
  • Classes and objects
  • Constructor & Destructor
  • Inheritance
  • Static methods and properties
  • Methods overloading
  • Abstract Class & Interface

MySql

  • Introduction
  • database
  • CREATE, ALTER, DELETE, DROP tables
  • INSERT, UPDATE, DELETE table datas
  • WHERE conditions
  • AND, OR, IN, BETWEEN, LIKE,DISTINCT, ORDER BY, GROUP BY, UNION
  • Sub-queries
  • LEFT JOIN, RIGHT JOIN, INNER JOIN
  • Database Programming
  • PHP & MySql
  • PHP MySql functions
  • one-tier architecture
  • two-tier architecture
  • three-tier architecture
  • File programming
  • File handling
  • File Open/Read
  • File Create/Write
  • File uploading and downloading.

jQuery

  • jQuery Install
  • jQuery Syntax
  • jQuery Selectors
  • jQuery Events jQuery Effects
  • jQuery Hide/Show
  • jQuery Fade
  • jQuery Slide
  • jQuery Animate
  • jQuery Stop()
  • jQquery Callback
  • jQuery Chaining
  • noConflict
  • JSON
  • Angular Js

AJAX

  • Introduction
  • Jquery AJAX example
  • AJAX Database programming with PHP
  • Pagination
  • First, Next , Prev, Last links
  • Query string
  • CMS – Wordpress
  • Introduction to CMS
  • Wordpress Installation
  • Theme Customization
  • How to create a blog using Wordpress

MVC Overview

  • Codeigniter
  • Models, views, controllers
  • Installation
  • Working with Simple Database Program
  • Simple Crud Operation(CREATE,READ,UPDATE,DELETE,SEARCH)
�?��@�


Course