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

COMPUFIELD® Computer Institute
In Mumbai

Rs 85,000
Compare this course with other similar courses
See all

Important information


Important information

Where and when

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

Course programme


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


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

Testing Variables

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

~ Loops
continue and break

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

Function Documentation
Important PHP Functions
String handling functions

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

~ 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

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.


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.


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

~ 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
Stored procedures

The Structured query Language for Creating and Altering Tables

Essential Definitions
Null Values

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

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
group by and aggregate functions

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


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

~ Compilers
Commenting your code

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

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

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

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

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

~Defining a function
Calling a function
Default return type and type void
Argument (Parameter)
Categories of functions
Function Prototype
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

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


Structures and Unions

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

~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

C Preprocessors
~Preprocessor Directives
File Inclusion
Macro Substitution

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


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

~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
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
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

One dimensional Arrays
Two dimensional Arrays

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

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

~Revision of C Structures
Limitations of C Structures
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
Default Constructor
Argumented constructor
Copy Constructor
Multiple Constructor

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

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