Jewellery Designing Interrior Designing Fashion Designing Aonline Training Franchise Scheme Send Free E-Greetings "Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)."
Franchise Scheme Latest Courses At Compufield
Compufield now in Bandr
Franchise enquiry welcome It corporate Training World wide


click here for photoshop Course content

  Programming Courses :
 Diploma in Java Programming I Diploma in Database-Administration [RDBMS] I Diploma in DOT NET Tech I Diploma in ORACLE Database Administrator (OCP) I
 Diploma in ORACLE Database Administrator (OCP) I Diploma in Internet Application & E-Commerce I  Diploma in Software Engineering I
 Dip in Web Designing, Software Engineering, E-Commerce & Global Marketing I Dip in Web Designing, Multimedia, E-Commerce & Global Mkt I
 Dip in Web Designing, Multimedia Pro, Software Engineering, E-Commerce & Global Mkt I
  Individual Courses :
  JDBC & JavaBeans I JSP I J2EE I
Search For Our Courses

ISO 9001:2000 Certified Computer Institute
Why do
Foreign/Indian Students prefer to study at COMPUFIELD?

Join our Newsletter

Enter your E-Mail

ABout Us
Our Students
Business Offer


Php + Mysql + Joomla

Our Programming Student's Review
Zohair Mala., Course-"JDK, Javabeans, JDBC, Java Script & Web Publishing", Country-"Kuwait" Abhishek Shukla., Course-"PHP & MYSQL", Country-"India" Musaddique Kazi., Course-"C,C++, Javascript and Web Publishing", Country-"India" Kavita Maheshwari., Course-"Java Script", Country-"India"
Programming Review
1 2 3 4 5

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. 



  • PHP is an HTML-embedded server side 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 developersto write dynamically generated database driven pages quickly.


  • 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 sites.


Part I: Working with My SQL

 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
     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
  • MySQL Control Center
  • Using MacSQL
  • Top
     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
  • Top
    New features of Mysql 5.0  
  • Function
  • Triggers
  • Views
  • Procedures
  • Information Schema

    Part II: 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
    Using Built-in Variables  
  • PHP variables
  • Apache variables
  • Other Web server variables
    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
  •  Top
    Control Structures  
    The if Statement   
  • Determining true or false in PHP
  • Comparison operators
  • Logical operators
  • Complex if statement
  • if…else statements
  • if…elseif statements
  • White…
  • do…while
  • for
  • foreach
  • continue and break
  •  Top
    PHP’s Built-in Functions  
    Function Basics  
  • Arguments
  • Return values
    Function Documentation  
    Important PHP Functions  
  • String handling functions
  • Regular expression functions
  • Variable functions
  • Type-conversion functions
  • Array functions
  • Object/class functions
  • Print functions
  • Date/time functions
  • File-system functions
  • Script Control functions
  • Random number generator functions
  • Session functions
  • MySQL functions
  • HTTP header functions
  • Image functions
  • Mail functions
  • URL functions
  • Error functions
  • Output buffering
  • Information functions
  •  Top
    Writing Organized and Readable Code  
  • 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
  •  Top
     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 seesions and cookies


    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
    • Free extensions at
    • After the split, a large and eager community of users and developers was quickly established


    • Joomla is an award-winning content management system (CMS).
    • 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.
    • Joomla is used all over the world to power Web sites of all shapes and sizes.
    • Joomla is designed to be easy to install and set up even if you're not an advanced user.
    • Joomla is the most popular open source CMS currently available as evidenced by a vibrant and growing community of friendly users and talented developers.
    • Joomla is free, open, and available to anyone under the GPL license.

    • Team Lesotho, Lesoth
    • Installing Joomla!

    Customizing Joomla!

    Forum, Comments, and Calendar

    E-Commerce and I18N

    Your Own Templates

    Your Own Program Extensions

    Course Duration Fees (Indian Rs.) Fees (US $)
    75 sessions of 1 hr. each 11500 330


    Lodging, boarding and travelling not included in the fees.
    The above mentioned fees is for one course.
    COMPUFIELD offers a unique style of learning -

    One computer : One student : One Instructor
    Maximum Instructor to Student Ratio 1:4
    Sessions : Each session will be of 1 hour.
    The timing can be fixed based on our mutual convenience,between 9.00 a.m. to 7.00 p.m.
    Overseas Students take 5 to 10 hours per day to complete their courses.
    Course duration in days = total sessions divide by number of sessions per day.
    The Above Mentioned Tuition Fees Includes Service Tax
    No extra charges/refund for more/less time taken to complete the course.


    Enquire About This Course
    Classroom Training In Mumbai - India Only
    (Number-Coutry code & city code)
    e.g. +91-22-23676218
    *Course Of Interest
    Type 12345 in the above box
    (*) Signed fields are mandatory.
    *** Data entered in the form
    will be kept confidential..

    Solve your Queries Online related to our Courses
    Mobile Number
    M.E. Khairaz (MD)
    Yahoo Messenger
    Whats App
    Connect With us@

    Address (HO) : Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road, Mumbai - 400 036, India.
    +91-22-23676218 / 23671772
    Mobile: +91 9820134058
    Bandra (W): 1st Floor. O'Priya Building, Peter Dias Road, Near Mehboob Studio , Bandra (West) Mumbai - 400 050, India compufield bandra address
    +91 - 26551794 / +91 9322755916
    Andheri (W): Office No R- 26, 1st Floor, RNA Complex Lokhandwala, 3rd Cross Lane, Next to High Point Restaurant, Andheri (West) Mumbai - 400 053, India
    +91 9820494017