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)
�?��@�