Deprecated: iconv_set_encoding(): Use of iconv.internal_encoding is deprecated in /home/wetechex/public_html/libraries/joomla/string/string.php on line 28

Deprecated: iconv_set_encoding(): Use of iconv.input_encoding is deprecated in /home/wetechex/public_html/libraries/joomla/string/string.php on line 29

Deprecated: iconv_set_encoding(): Use of iconv.output_encoding is deprecated in /home/wetechex/public_html/libraries/joomla/string/string.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at /home/wetechex/public_html/libraries/joomla/string/string.php:28) in /home/wetechex/public_html/plugins/system/jat3/jat3/core/parameter.php on line 107

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 652

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 654

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 24

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 25

Deprecated: Non-static method JSite::getMenu() should not be called statically, assuming $this from incompatible context in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 168

Deprecated: Non-static method JApplication::getMenu() should not be called statically, assuming $this from incompatible context in /home/wetechex/public_html/includes/application.php on line 539

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 168

Deprecated: Non-static method JSite::getMenu() should not be called statically, assuming $this from incompatible context in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 168

Deprecated: Non-static method JApplication::getMenu() should not be called statically, assuming $this from incompatible context in /home/wetechex/public_html/includes/application.php on line 539

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 168

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 652

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 654
Php and Mysql

We-Tech Experts


Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 652

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 654

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/content/seolinks/seolinks.php on line 0

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 80

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 84

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 652

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 654

Deprecated: Non-static method JSite::getMenu() should not be called statically, assuming $this from incompatible context in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 168

Deprecated: Non-static method JApplication::getMenu() should not be called statically, assuming $this from incompatible context in /home/wetechex/public_html/includes/application.php on line 539

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/system/SEOSimple/SEOSimple.php on line 168

Strict Standards: Only variables should be assigned by reference in /home/wetechex/public_html/plugins/content/seolinks/seolinks.php on line 0

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 652

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/wetechex/public_html/libraries/joomla/filter/input.php on line 654

Php and MySql

User Rating:  / 86
PoorBest 

CORE PHP (BASIC) + Mysql  + Advanced PHP

Introduction:-

PHP is the most popular and widely used server side scripting language for web development It is used to enhance web pages with PHP, you can do things like create username and password login Pages, check details from a form, create forums, picture galleries, surveys, and a whole lot more It is used to make the Dynamic pages in websites. PHP codes are embedding in HTML source codes for making the page dynamic.PHP can deal with most of the requirements in web development like database, file handling, arrays, graphics, string operations, file uploads, data processing etc.PHP can be used in any operating system with a web server supports PHP Apache web server is one of the popular web server dealing with PHP + Mysql.PHP Originally stood for Personal Home Page, it now stands for PHP- (Hypertext Preprocessor).

 

MYSQL

MySQL, pronounced either "My S-Q-L" or "My Sequel," is an open source relational database management system. It is based on the structure query language (SQL), which is used for adding, removing, and modifying information in the database. Standard SQL commands, such as ADD, DROP, INSERT, and UPDATE can be used with MySQL. MySQL is most commonly used for Web applications and for embedded applications and has become a popular alternative to proprietary database systems because of its speed and reliability. MySQL can run on UNIX,Windows and Mac OS.

 

MySQL is used in a wide range of applications, including data warehousing, e-commerce, Web databases, logging applications and distributed applications. It is also increasingly embedded in third-party software and other technologies. According to MySQL AB, their flagship product has over six million active MySQL installations worldwide. Customers include Cisco, Dun & Bradstreet, Google, NASA, Lufthansa, Hyperion, and Suzuki.

 

Core PHP + MYSQL

Ø  Introduce to PHP

Ø  HTML Basic

Ø  Idea About CSS

Ø  Working with JavaScript

Ø  JavaScript Validation

Ø  PHP Fundamentals

Ø  PHP Arrays

Ø  PHP Function

Ø  PHP Operators

Ø  Working with PHP Forms

Ø  PHP Cookies & PHP Session

Ø  Strings Handling into the PHP

Ø  Basic Mysql Concept

Ø  Advanced Mysql Concept

Ø  Mysql Joins and SQL Function

Ø  HTTP Handling –Ajax

Ø  Web programming

 

Advanced PHP

Ø  Cultivating Good Programming

Ø  Practices

Ø  Introduce Variables & Function in depth Knowledge

Ø  File Management Handling

Ø  Dealing with the PDF

Ø  Session Management

Ø  Advanced MYSQL

Ø  How to define Security

Ø  Error Handling & Code Optimization

 

 

Introduction

Ø  The Origin of PHP

Ø  PHP is better than Its alternatives

Ø  Interfaces to External systems

Ø  Hardware and Software requirements

Ø  What a PHP Script Looks Likec

Ø  Web Designing Basics and WYSIWYG Editor

Ø  Receiving User Input

Ø  Repeating Code

 

Basic PHP Development

Ø  How PHP scripts work

Ø  Basic PHP syntax

Ø  PHP data types

Ø  Google Caffeine

Ø  displaying type information

Ø  Testing for a specific data type

Ø  Changing type with Set type

Ø  Operators

Ø  Variable manipulation

Ø  Dynamic variables

Ø  Static vs. Dynamic Optimization

Ø  Analytics, Analysis and ROI Concept

 

Introduce Variables & Knowledge:-

Ø  Variable Scope (Global Variable & Static Variable)

Ø  Variable Function

Ø  Creating functions with argument lists

Ø  Dynamic functions creation

Ø  Introducing References

Ø  References and arrays

Ø  Function : passing arguments by reference

Ø  Function : Returning by Reference

 

File Management Handling

Ø  File Upload process over

 

 

String Manipulation

Ø  Formatting String for Presentation

Ø  Formatting String for Storage

Ø  Joining and Splitting String

Ø  Comparing String

Ø  Matching and replace Substring

 

Introduction To Database

Ø  What is RDBMS technology?

Ø  Introduction to SQL

Ø  Connecting to the MYSQL

Ø  Selecting a database

Ø  Adding data to a table

Ø  Displaying returned data on Web pages

Ø  Finding the number of rows

Ø  Looping through database

Ø  Inserting data

Ø  Deleting data

Ø  Entering and updating data

Ø  Executing multiple queries

Ø  Understanding Primary and Foreign Keys

Ø  Understanding Database Normalization

Ø  Dealing with Dates and Times

XML

Ø  Introduction to XML and its use.


AJAX (Asynchronous JavaScript and XML)

Ø  Introduction to AJAX

Ø  Introduction to XMLHttpRequest Object

Ø  Method and Properties of XMLHttpRequest

Ø  Application of AJAX in web application

Ajax with PHP

Ø  Ajax Overview

Ø  Ajax Technology Stack

Ø  Ajax Implementations

Ø  Installing and configuring HTML_Ajax Pear Module

Ø  Ajax Server

Ø   Ajax Client

 

Smarty Templates

Ø  Smarty Overview

Ø  Installing and configuring Smarty Pear Module

Ø  Setting up a Template

Ø  Passing Data to the Template

Ø  Smarty for Template Designers

Ø  Smarty for Programmers

Ø  Smarty in N-Tier Architecture

Control Structures

Ø  If(), else if() and else if condition Statement

Ø  The switch statement

Ø  Using the ? operator

Ø  Using the while() Loop

Ø  The do while statement

Ø  Using the for() Loop

Ø  Breaking out of loops

Ø  Nesting loops

Ø  Summary

 

Functions

Ø  What a function

Ø  Creating a function

Ø  Returning value from function

Ø  User-defined functions

Ø  Dynamic function calls

Ø  Variable scope

Ø  Accessing variable with the global statement

Ø  Function calls with the static statement

Ø  Setting default values for arguments

Ø  Passing arguments to a function by value

Ø  Passing arguments to a function by reference

Ø  Testing for function existence Arrays

Ø  Single-Dimensional Arrays

Ø  Multidimensional Arrays

Ø  Associative arrays

Ø  Accessing arrays

Ø  Getting the size of an array

Ø  Looping through an array

Ø  Looping through an associative array

Ø  Examining arrays

Ø  merging arrays

Ø  Sorting arrays

Ø  Sorting an associative arrays

Cookies

Ø  What is a Cookie?

Ø  Setting time in a cookie with PHP

Ø  Deleting a cookie

Ø  Creating session cookie

Ø  Working with the query string

Session

Ø  what is session?

Ø  Starting a session

Ø  Registering Session variables

Ø  working with session variables

Ø  destroying session

Ø  passing session Ids

Ø  encoding and decoding session variables

Ø  How to increase session expire time

Ø  How to work session without cookie?

Frame Work

Ø  Basic Concepts of Framework

Ø  Basic Concept of Code Igniter


OsCommerce (Open Source Shopping Cart)

Ø  Introduction to Shopping Cart

Ø  Introduction to ecommerce opensource

Ø  Discussion of various module of ecommerce


PHP Project

Ø  Project Discussion

Ø  Requirements analysis of Project

Security Guide

Ø  Security through.htaccess

Ø  Thread with the form data & Variable

Ø  SQL Injection thread

Ø  Rewrite URL

Ø  How to use SSL & HTTPS

Working With The File System

Ø  Creating and deleting a file

Ø  Reading and writing text files

Ø  Working with directories in PHP

Ø  Checking for existence of file

Ø  Determining file size

Ø  Opening a file for writing, reading, or appending

Ø  Writing Data to the file

Ø  Reading characters

 

Working With Forms

Ø  Forms

Ø  Super global variables

Ø  Super global array

Ø  A script to acquire user input

Ø  Importing user input

Ø  Accessing user input

Ø  Combine HTML and PHP code

Ø  Using hidden fields

Ø  Redirecting the user

Ø  File upload and scripts

Ø  Delete a File

Working With Regular Expressions

Ø  The basic regular expressions

Ø  Matching patterns

Ø  Finding matches

Ø  Replace patterns

Classes And Objects

Ø  Object oriented concepts

Ø  Define a class

Ø  Class attributes

Ø  An Object

Ø  Creating an object

Ø  Object properties

Ø  Object methods

Ø  Object constructors and destructors

Ø  Class constants

Ø  Static method

Ø  Class inheritance

Ø  Abstract classes

Ø  Final keyword

Ø  Implementing Interface

Ø  Object serialization

Ø  Understanding Advance and New

Ø  Checking for class and method existence

Ø  Iterators

Advance PHP techniques

Ø  Introduction about FTP/SMTP server

Ø  Math functions

Ø  File upload

Ø  File Download

Ø  E-mail with PHP

Ø  PHP configuration file

Ø  Error tacking and debugging

 

JavaScript (Jquery)

Ø  Introduction to JavaScript

Ø  Form validation using JavaScript

Ø  Email validation using JavaScript

Ø  Jquery

Advance Mysql

Ø  Mysql Privileged

Ø  ACID Properties

Ø  Database Query with sub query

Ø  Database Optimization

Ø  Indexing on Table