Dual Diploma in Web Technology & Multimedia:PHP+MySQL + C & C++(Basic)

COMPUFIELD® Computer Institute
In Mumbai

Rs 85,000
+ VAT
You can also call the Study Centre
22236... More
Compare this course with other similar courses
See all

Important information

Description

Important information
Venues

Where and when

Starts Location
On request
Mumbai
OPriya Bldg.,1st Floor, Dr. Peter Dias Road, Near Mehboob Studio,, 400050, Maharashtra, India
See map
On request
Mumbai
Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road,, 400036, Maharashtra, India
See map

Course programme

PHP

PHP is a powerful cross platform server side script language. It is a full featured programming language capable of managing huge database driven online environments. Using PHP you can query databases, create images, read & write files, talk to remote servers - the possibilities are endless.

Salient Features

PHP is an HTML-embedded scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated pages quickly

Application

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


Php Topics Covered


Part I: Working with PHP

Getting Started with PHP-Variables

Assigning Simple Variables Within a Script
~
~
~ Delimiting strings
Assigning arrays within a script
Assigning two-dimensional arrays in a script

Accessing Variables Passed from the Browser
~
~
~
~ HTML forms variables
Passing arrays
Cookies
Sessions

Testing Variables
~
~isset0
empty0
is_null0
is_int0
is_double0
is_string0
is_array0
is_bool0
is_object0
is_resource0
is_scalar0
gettype0

Changing Variable Types
~ Variable Variables

Control Structures

The if Statement
~
~
~
~
~
~ Determining true or false in PHP
Comparison operators
Logical operators
Complex if statement
if...else statements
if...elseif statements

switch...case
~
~
~
~
~
~ Loops
White...
do...while
for
foreach
continue and break

PHP's Built-in Functions
~
~
~ Function Basics
Arguments
Return values

Function Documentation
~
~
Important PHP Functions
String handling functions

Writing Organized and Readable Code
~
~
~
~ Indenting
Code blocks
Function calls
SQL statements

Includes
~
~ Include0 and Require0
Include_once0 and Require_once0

User-Defined Functions
~
~
~
~ Function basics
Returning values
Using a variable number of arguments
Variable scope

Object-Oriented Programming
~
~
~
~ Classes, Continued
Object cloning
Destructors
Exceptions
Synopsis:

The data is stored in Products Table, Supplier Table, Category Table. Each product has a single supplier and single category.
Each supplier supplies multiple products under multiple categories

1) Login Page
The user will be authenticated before they enter the website for the correct username/password.
There are 2 types of users Admin / User, the admin would have administrative rights, where as a user will only be able to view the products

2) Search Page
After login, the user will be directed to a search page, where they can search for a product by selecting the supplier / category name.

In advance search, string searches can be done.

3) Product Result list
This page will return the result of the search criteria.
A single page will display the records dynamically from the database, 5 records at a time. Using the Next / Previous button users can navigate through the list of products

4) Details
Once the user clicks on the product name in the result list page, they are directed to the details page, where user can get the detail information with a image of the product

If the user is an admin, they would be given an option to add / update / delete If the user is not a admin, the following permissions will be disabled.

5) Add / Update / Delete
Displaying data from multiple tables using forms & Adding / Updating / Deleting data

6) Security
Extensive use of Sessions / Cookies for security purposes

7) E-Commerce Module
Once the above project is completed, it's taken to a next level where the e-commerce module is generated. Multiple Products can be added to the shopping cart, a dynamic bill is generated and user is forwarded to a payment gateway to complete the transaction.


MySQL

Salient Features

It's easy to use:
MySQL software can be downloaded in less than 15 minutes.

It's flexible: MySQL runs on more than 20 platforms, including Windows, Mac OS X, and Linux, and its open source code allows you to customize it to fit your unique requirements.

It's highly scalable: Whether you're looking to post a few things a month to your Web site or looking to add content daily, MySQL is fit to handle Web sites large and small and will easily grow as your business does.

It's free: A commercial license can be bought if you plan on redistributing it.

It's secure: Security features ensure that only authorized users can access your databases.

It also provides 24/7 tech support and community support.

Application

Open source has brought a lot more than Unix 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 sites.

Mysql Topics Covered

Database Design with My SQL

Why use a Relational Database?

Blasted Anomalies
~
~
~ The update anomaly
The delete anomaly
The insert anomaly

Normalization
~
~
~ First normal form
Second normal form
Third normal form

Types of Relationships
~
~
~ The one-to-many relationship
The one-to-one relationship
The many-to-many relationship

Advanced Database Concepts
~
~
~ Referential integrity
Transactions
Stored procedures

The Structured query Language for Creating and Altering Tables

Essential Definitions
~
~
Null Values
Indexes

The create database Statement

The use database Statement

The create table Statement

Column Types
~
~
~ String column types
Numeric column types
Date and time types

Creating Indexes

Table Types
~
~
~ MyISAM InnoDB Tables
Berkeley DB
Heap

The alter table Statement
~
~Changing a table name
Adding columns
Dropping columns
Adding indexes
Dropping indexes
Changing column definitions

Using the show Command
~show databases
show tables
show columns
show index
show table status
show create table

GUI Tools for Manipulating MySQL Tables and Data
~ Using phpMyAdmin

The Structured Query Language for Inserting, Editing, and Selecting Data
~The insert Statement
The update Statement
The delete Statement
The replace Statement

The Basic select Statement
~

~ The Where clause
order by
limit
group by and aggregate functions

Joining Tables
~The two-table join (equi-join)
The multi-table join
The outer join
The self join
Unions
Correlated subqueries


C

C is a general purpose Programming Language. C has proven to be a pleasant, powerful, and versatile language for a wide variety of Programs. Many of the modern languages like C++, Visual C++, Java, JavaScript, etc. is based on C Language. Therefore, not Knowing this Language is considered as a handicap. 90% of UNIX Operating System is written in C Language.

C Topics Covered


Syntax
~
~
~ Compilers
Errors
Commenting your code

C Basics
~ History of C
Characteristics of C
Character set
Identifier
Underline ( Underscore '_' )
Keywords
We need Data and A Program
Constants
Operators
Some Terminology
Data Types Printing Out and Inputting Variables
Escape Sequence
Exercise

Control Constructs
~
~if statement
else statement
else if statement
Nesting of if Block
For statement
While statement
Infinite loops
Programming Examples
Exercise

Remaining Control Constructs
~goto statement
break statement
continue statement
switch statement
do-while statement
Programming Example
Exercise

Arrays
~Declaring Arrays
Initializing Array
Printing Arrays
Taking Input for Arrays
Character Arrays
Array Dimensions
Initializing 2D Array
Array Sizes [size of operator]
Programming Examples
Exercise

Strings
~What are strings
Reading a single character
Reading a line of text [string]
String handling functions
Programming examples
Exercise

Functions
~
~Defining a function
Calling a function
Default return type and type void
Argument (Parameter)
Categories of functions
Function Prototype
Recursion
Scope and lifetime of a variable
Storage Classes
Automatic variable(internal or local variable)
External Variabel( Global Variable)
Static Variable
Register variable
Scope rule of a function
Passing an array to a function
Programming Examples
Exercise

Strings
~What are strings
Reading a single character
Reading a line of text [string]
String handling functions
Programming examples
Exercise

PHASE - III

Structures and Unions

~
~Structures
Defining a structurs
Accessing structure members
Operations on structures
Structure Initialization
typedef
Arrays of structure
Arrays as structure members (fields)
Sending an entire structure as parameter to a function
Unions
Defining a Union
Initializing Unions
Arrays of Union variables
Unions inside structures
Final Remark on unions
Programming Examples
Exercise

Pointers
~
~What is a pointer
Where is a pointer stored
'&'- The "Address Of" operator
what a pointer points to
Accessing Variables value using Pointers
Pointer Arithmetic
Equivalence between Pointer and Arrays
Pointer to an Array
Modifying Variables using pointers
Call by reference
Arrays of pointers
Arrays of char pointers
Pointers to functions
Pointers to structures
Passing pointer to structure to function
Structure within structure
Pointers to pointers
Programming Examples
Exercise

C Preprocessors
~Preprocessor Directives
File Inclusion
Macro Substitution
Exercise

C Standard Libraries and Header Files
~Header Files
Is the use of header file absolutely necessary?
Standard Library
Character conversion :
Time Functions :
Exercise


C++

C++ is a object oriented Programming language which includes concepts like polymorphism, data-hiding, operator overloading, encapsulation and inheritance, which are not observed in C. User defined objects (instances) can be reused with and without modifications to generate new application. This reduces coding to greater extent. Even for file accessing, we use file objects.

C++ Topics Covered

Introduction
~
~History of C++
What is Object Oriented Programming
Application Of C++
A Simple C++ Program
Cascading of I/O Operators
Structure of a C++ Program

Tokens And Control Structure
~
~Tokens
Data Types
Type Compatibility
Arithmetic Operators
Relational Operators
Logical Operators
Assignment Operators
Increment Operators
Conditinal Operators
Bitwise Operators
Special Operators
Operators in C++
Order of Precedence
Expressions
Operator Overloading
Control Structure
Simple if Statement
if - else Statement
switch Statement
do Statement
break Statement
for Statement
Additinaol features of for loop
Nested for

Arrays
~Introduction
One dimensional Arrays
Two dimensional Arrays

Strings
~Reading String From The Terminal
Reading Multiword String From The Terminal
String Hanling Functions
Table of Strings

Functions
~
~The main() function
Simple C++ functions
Functions Prototying
Return Value and Their Types
Function Overloading
Friend And Virtual Functions
Programming Examples
Exercise

Classes
~
~Revision of C Structures
Limitations of C Structures
Class
Creating Objects
Accessing Class Member
Defining Member FunctionsClasss And structures
Private Member Functions
Static Data Members
Static Member Functions
Array of Objects
Objects As Function Arguments
Friend Functions

Constructors And Destructors
~
~Introduction
Default Constructor
Argumented constructor
Copy Constructor
Multiple Constructor
Destructors

Operator overloading
~Definition
Overloading Unary Operator using Member function
Overloading Unary Operator using Friend function
Overloading Binary Operator using Member functio
Overloading Binary Operator using Friend function

Inheritance
~
~Introduction
Base Class
Derived Class
Types of Inheritance
Virtual Base Class
Abstract Class

Virtual Functions And Polymorphism
~
~Introduction To Pointers
Pointer To Object
this Pointer
Pointer to derived Classes
Virtual Functions

File Operations in C++
~
~C++ Streams
Opening And Closing a File
Detecting End of File
File Pointers And Their Applications
Sequential Input And Output Operations
write() And read() Functions
More About open() : File Modes
Reading And Writing A Class Object

Compare this course with other similar courses
See all