Search in
Courses Providers, List Your Courses for FREE
Menu

PHP & MySQL+Ajax+Joomla Course


Training/Coaching/Tuition

by Aonline Training


Mumbai
View Contact
Starting from:
INR 25,000
Per Course
(Taxes As Applicable)
Request Info
Subjects Covered & Categories
Basic Details
Eligibility:
(Pre-requisites)

C & C++ (Basics)
Php & MySQL

Medium of instruction:English
Request Info
Overview, Content & Syllabus

PHP and MySQL

Intoduction:

PHP is a powerful cross platform server side scripting language. It is a full featured programming language capable of managing huge database driven online environments. Using PHP you can query databases, create dynamic images, create e-commerce websites, manage security for online transactions, read & write files on the server, talk to remote servers - the possibilities are endless. MySQL is a small, compact database server ideal for stand-alone and enterprise applications. The PHP-MySQL combination is also cross-platform.

Like Javascript, php employs a syntax similar to C, and provides strong support for pattern matching and database access. Extension for a communicating with other network resources, such as mail and directory servers, is also available

PHP is an open source product. As with other open source products, such as Linux operating system and Apache HTTP server, PHP is not a commercial product. It is, instead, the result of contributions from a community of interested developers. Freely contributing to,and supporting its code base. One important result of its open source nature is that PHP is now available on a large number of platforms. It is compatible with Windows NT as well as several UNIX operating systems, and with a number of HTTP servers such as Apache, Microsoft’s IIS, and Netscape Enterprise server.

 

Applications:

  • Open source has brought a lot more than Unux to the computing world. It has also given us Linux, PHP and MySQL. PHP and MySQL are the world's best combination for creating database-driven websites.

 

Course Contents

Free Trial Session Is Limited To Phase I Only

Phase 1

Working with My SQL

 

1) Database Design with My SQL

2) Why use a Relational Database?

  • The update statements

  • The delete statements

  • The insert statements

3) Normalization

  • First normal form

  • Second normal form

  • Third normal form

4) Types of Relationships

  • The one-to-many relationship

  • The one-to-one relationship

  • The many-to-many relationship

5) The Structured query Language for Creating and Altering Tables

  • Essential Definitions

  • Null Values

  • Indexes

6) The create database Statement

7) The use database Statement

8) The create table Statement

9) Column Types

  • String column types

  • Numeric column types

  • Date and time types

10) Creating Indexes

11) The alter table Statement

  • Changing a table name

  • Adding columns

  • Dropping columns

  • Adding indexes

  • Dropping indexes

  • Changing column definitions

12) Using the show Command

  • show databases

  • show tables

  • show columns

  • show index

  • show table status

  • show create table

13) GUI Tools for Manipulating MySQL Tables and Data

  • Using phpMyAdmin

14) The Basic select Statement

  • The Where clause

  • order by

  • limit

  • group by and aggregate functions

15) Joining Tables

  • The two-table join (equi-join)

  • The multi-table join

 

Part II: Working with PHP

1) Getting Started with PHP-Variables

2) Accessing Variables Passed from the Browser

  • HTML forms variables

  • Passing arrays

  • Cookies

  • Sessions

3) Changing Variable Types

  • Variable Variables

4) Control Structures

5) The if Statement

  • Determining true or false in PHP

  • Comparison operators

  • Logical operators

  • Complex if statement

  • if…else statements

  • if…elseif statements

6) PHP’s Built-in Functions

  • Function Basics

  • Arguments

  • Return values

7) Writing Organized and Readable Code

  • Indenting

  • Code blocks

  • Function calls

  • SQL statements

8) Includes

  • Include0 and Require0

  • Include_once0 and Require_once0

9) User-Defined Functions

  • Function basics

  • Returning values

  • Using a variable number of arguments

  • Variable scope

 

Part III

Creating a shopping Cart

Where users can shop for Products and data stored in the backend

Admin Module / Security

Giving Accesstom Users / Clients / Admin

Creating the entire admin module using sessions and cookies

 

Ajax

Intoduction:

Ajax (also known as AJAX), shorthand for "Asynchronous JavaScript and XML," is a web development technique for creating interactive web applications. The intent is to make web pages feel more responsive by exchanging small amounts of data with the server behind the scenes, so that the entire web page does not have to be reloaded each time the user requests a change. This is intended to increase the web page's interactivity, speed, and usability.

 

SALIENT FEATURES

 

  • XHTML (or HTML) and CSS, for marking up and styling information.

 

  • The DOM accessed with a client-side scripting language, especially ECMAScript implementations such as JavaScript and JScript, to dynamically display and interact with the information presented.

 

  • The XMLHttpRequest object is used to exchange data asynchronously with the web server. In some Ajax frameworks and in certain situations, an IFrame object is used instead of the XMLHttpRequest object to exchange data with the web server, and in other implementations, dynamically added script tags may be used.

 

  • XML is sometimes used as the format for transferring data between the server and client, although any format will work, including preformatted HTML, plain text, JSON and even EBML. These files may be created dynamically by some form of server-side scripting.

 

Application

1) standards-based presentation using XHTML and CSS;

2) dynamic display and interaction using the Document Object Model;

3) data interchange and manipulation using XML and XSLT;

4) asynchronous data retrieval using XMLHttpRequest;

5) and JavaScript binding everything together.

 

Course contents

 

Free Trial Session Is Limited To Phase I Only

Introduction

  • Welcome

  • System Requirements

 

Getting to know Ajax

  • Downloading Data Behind the Scenes

  • Modifying Web Pages on the Fly

  • Searching in Real Time with Live Searches

  • Getting the Answer With Autocomplete

  • Dragging and Dropping HTML Elements With Ajax

 

Writing Ajax

  • Working With JavaScript in Browsers

  • Creating an XMLHttpRequest Object in JavaScript

  • Checking the XMLHttpRequest Object's readyState

  • property

  • Checking the XMLHttpRequest Object's status property

  • Getting Your Data With the XMLHttpRequest Object

  • Problems creating an XMLHttpRequest Object

  • Fetching Text Data From the Browser

  • Decoding the Fetched Data

  • Selecting Relative or Absolute URLs

  • Getting XMLHttpRequest Objects in Other Ways

  • Using Server-Side Scripting

  • Storing Ajax Data in XML

  • Passing Data to the Server with GET

  • Passing Data to the Server with POST

 

Getting More Ajax Power

  • Determining Which Browser the User Has

  • Handling Head Requests for More Data

  • Creating a Live Search Pt.1

  • Creating a Live Search Pt.2

  • Connecting to Google Suggest

  • Calling a Different Domain Safely

  • Using Two XMLHttpRequest objects

  • Handling Multiple XMLHttpRequest Requests

  • Returning JavaScript Objects From the Server

 

Creating Ajax Applications

  • Downloading Images Using Ajax

  • Creating a Shopping Cart

  • Handling Mouse Events

  • Enabling Dragging

  • Handling Drops

  • Communicating With the Shopping Cart on the Server

  • Creating an Ajax-driven Drop-down Menu System

  • Downloading Data with Drop-down Menu System

  • Displaying a Menu with a Drop-down Menu System

 

Exploring The Browser-Side Ajax Frameworks

  • Introducing Ajax Frameworks

  • Creating Ajax With libXmlRequest

  • Creating Ajax With AjaxLib

  • Creating Ajax With XHConn

  • Creating Ajax With Sack

  • Creating Ajax With Interactive Website Framework

  • Creating Ajax With Sarissa

 

Exploring the Server-Side Ajax Frameworks

  • Creating Ajax With PHP and Sajax Pt.1

  • Creating Ajax With PHP and Sajax Pt.2

  • Creating Ajax With PHP and Xajax

 

Using XML With Ajax

  • Understanding XML

  • Loading XML into a Browser Object

  • Navigating through XML Documents Using JavaScript

  • Extracting data from text nodes

  • Handling White Space in Mozilla and Firefox

  • Accessing Attribute Values in XML Elements

  • Accessing XML Elements by Name

  • Validating XML You Get From the Server

  • Validating XML With a DTD

 

Using CSS With Ajax in Web Pages

  • Introducing CSS

  • Setting Styles

  • Using an External Style Sheet

  • Working with Text Styles

  • Setting Colors and Backgrounds

  • Getting Newly-displayed Text Noticed

  • Showing Ajax Results

  • Hiding Ajax Results

  • Positioning Elements

  • Positioning Elements: Absolute Positioning

  • Positioning Elements: Relative Positioning

  • Stacking

 

Using PHP and Ajax

  • Using PHP in Web Pages

  • Understanding Basic PHP Syntax

  • Working With Variables

  • Working With Operators

  • Working With Strings

  • Working With Arrays

  • Making Choices With the if Statement

  • Using the switch Statement

  • Using for Loops in PHP

  • Using while Loops in PHP

  • Sending Data to the Server

  • Extracting Data from Checkboxes

  • Extracting Data from Radio Buttons

  • Extracting Data from Listboxes

  • Uploading Files

  • Reading Uploaded Files

  • Redirecting the Browser

 

Doing It Right: Ajax Best Practices

  • Handling the Back Button

  • Remember - Google Can't See Your Ajax Content

  • Watching Out for Browser Caching

  • Giving Visual Cues

  • Wrap-up

 

Joomla

Intoduction:

Joomla is an award-winning content management system (CMS), which enables you to build Web sites and powerful online applications. Many aspects, including its ease-of-use and extensibility, have made Joomla the most popular Web site software available. Best of all, Joomla is an open source solution that is freely available to everyone.

 

SALIENT FEATURES

The following lists a few Joomla! features:

 

  • Free source code

  • Simple workflow system

  • Caching mechanism to secure fast page creation with favorite pages

  • Wastepaper basket

  • Banner management

  • Data manager for uploading and administering data

  • Publication system for content

  • Content summaries in RSS format

  • Search-engine-friendly URLs

  • Multilingual front end

  • Macro language for data content (Mambots)

  • Administration interface that is separated from the homepage

  • Simple, expandable template, and component system

  • Simple, but powerful template system (HTML, CSS, PHP) without a complicated template language

  • Hierarchical user groups

  • Simple visitor statistics

  • WYSIWYG editor for content

  • Simple polling

  • System of evaluation for contents

  • After the split, a large and eager community of users and developers was quickly established

 

Application

1) Joomla is an award-winning content management system (CMS).

2) A content management system is software that keeps track of every piece of content on your Web site, much like your local public library keeps track of books and stores them.

3) Joomla is used all over the world to power Web sites of all shapes and sizes.

4) Joomla is designed to be easy to install and set up even if you're not an advanced user.

5) Joomla is the most popular open source CMS currently available as evidenced by a vibrant and growing community of friendly users and talented developers.

6) Joomla is free, open, and available to anyone under the GPL license.

 

Course Contents

 

Free Trial Session Is Limited To Phase I Only

Terms and Concepts

  • A Quick Glance into History

  • Joomla!—How was it Developed?

  • Structure of a CMS

  • Front End and Back End

  • Configuration Settings

  • Access Rights

  • Content

  • Templates

  • Extensions (Components)

  • Workflow

  • Joomla! as Real Estate

  • Joomla! Versions

  • Numbering System of Joomla! Versions

  • Roadmap

  • Joomla! Features

  • Examples of Joomla! Pages

  • Joomla.org

  • Porsche, Brazil

  • PC Praxis, Germany

  • BSI DANS, Norway

  • Team Lesotho, Lesotho

 

Installation

  • Setting Up the Local Server Environment

  • Windows

  • XAMPP for Windows

  • Linux

  • SUSE (10.x) OpenSUSE

  • Debian/Ubuntu

  • Your Own Server at a Provider

  • On a Virtual Server in the Net

  • Installing Joomla!

  • Selecting a Directory for Installation

  • An Example

  • Local Installation of Joomla!

  • Directory

  • Unpacking

  • Joomla! Web Installer

 

A Tour of Your New Homepage

  • Front End

  • Menus

  • Top Menu

  • Main Menu

  • Other Menu

  • Content

  • What is Content?

  • First Page/Front Page

  • The Latest Messages/The Most Often Read Messages

  • Advertising

  • Banner Area

  • Functions

  • Login Area

  • Polling

  • Who is Online?

  • Feeds

  • Back

  • Search Field

  • Decorative Elements

  • Prospects

  • Back End



Customizing Joomla!

  • A Different Look and Feel

  • Modifying the Menu Name

  • Changing the Template

  • Configuration of Joomla! Administration

  • Help Menu

  • Site Menu

  • Global Configuration

  • Site

  • Locale

  • Content

  • Database

  • Server

  • Metadata

  • Mail

  • Cache

  • Statistics

  • SEO (Search Engine Optimization)

  • Language Manager

  • Media Manager

  • Preview

  • Statistics

  • Template Manager

  • Site Templates

  • Install

  • Administrator Templates

  • Install

  • Module Positions

  • Trash Manager

  • User Manager

  • New

  • Menu Manager

  • Customize Existing Menu

  • New

  • Edit

  • Publish

  • Unpublish

  • Move

  • Copy

  • Trash

  • Create a New Menu

  • Content

  • Miscellaneous

  • Components

  • Links

  • Installers Menu

  • Messages Menu

  • Inbox

  • Configuration

  • Configuration

  • System Menu

  • Global Check-In

Request Info
Course Schedule & Price
Online
When Duration Where Remarks Price
Not Specified (Total 200 Hrs) Study Online (on your computer) Not Specified INR 25,000
Per Course
(Taxes As Applicable)
Price Notes: The cost for the course in Indian Rupees (INR) would change depending on the 'Current Rate' of US Dollar. Fees in (US $) 1250.

Request Info
Venues (Locations)
Mumbai, Warden Road (Head Office):- Chinoy Mansion, First Floor, Block # 2, Opposite St. Stephens Church Warden Road, Mumbai - 400 036, Maharashtra, India

Mumbai, Bandra West (Franchisee):- Aonline Training CO Peter Dias Road, Near Mehboob Studio,O'Priya Building1st Floor, Block No 6 Bandra West, Mumbai, Maharashtra, India

Mumbai, Andheri West (Franchisee):- Office No R- 26, 1st Floor, RNA Complex Lokhandwala rd Cross Lane, Next to High Point Restaurant Andheri West, Mumbai - 400 053, Maharashtra, India

Request Info
Courses