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

 

Php + Mysql + Joomla

Our Programming Student's Review
Programming Review 1 2 3 4 5
Our Programming Student's Video Review

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. 

 

SALIENT FEATURES

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

APPLICATION

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

TOPICS COVERED :

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

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.

 

JOOMLA 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
• Free extensions at http://www.mamboforge.net
• After the split, a large and eager community of users and developers was quickly established

APPLICATION

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.

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, Lesoth

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 

Managing Content

• Content by Section 
• Section 
• Category
• Add/Edit Section Category 
• All Content Items 
• Static Content Manager 
• Content Parameters 
• Publishing 
• Images 
• Parameters
• Meta Info 
• Link to Menu
• Section Manager 
• Category Manager 
• Frontpage Manager 
• Archive Manager 

Components, Modules, and Mambots

• Components Menu 
• Installing and Uninstalling Components 
• Installed Components 
• Banner 
• Manage Clients 
• Manage Banners
• Contacts 
• Manage Contacts
• Contacts Categories 
• Mass Mail
• News Feeds 
• Manage Newsfeeds
• Manage Categories
• Polls 
• Syndicates 
• Weblinks 
• Weblink Items
• Weblink Categories 
• Module Menu 
• Install/Uninstall 
• Site Modules 
• All Menus (mod_mainmenu) 
• Banner 
• Login Form
• Syndicate
• Statistics 
• Template Chooser 
• Archive  
• Sections
• Related Items 
• Wrapper
• Polls 
• Who's Online 
• Random Image
• Newsflash 
• Latest News 
• Popular 
• Search
• Administrator Modules 
• Logged
• Components 
• Popular 
• Latest Items 
• Menu Stats
• Unread Messages
• Online Users
• Quick Icons
• System Message 
• Pathway
• Toolbar
• Full Menu
• Copying a Module
• Mambots Menu
• Installing New Mambots
• Site Mambots
• Search Mambots

Forum, Comments, and Calendar

• What can Simpleboard do?
• Installation of Simpleboard
• Uninstallation
• Simpleboard Administration
• Simpleboard Configuration
• Forum Administration
• User Administration
• Uploaded Files Browser
• Uploaded Images Browser
• Edit CSS File
• Prune Forums
• Prune Users
• Support Websites
• Load Sample Data
• Update Database to Version 1.1.0 Stable
• User Front End
• Set Up a User Profile
• Simpleboard Module
• Installation
• Comments
• Installation
• Administration
• View Comments
• Edit Settings
• Edit Language
• Front End
• Calendar
• Installation
• Configuration
• Events Config
• Manage Event Categories
• User Front End
• Module
• Event Mambot

Image Gallery and Document Management

• Gallery
• zOOm Media Gallery
• Installation
• Administration
• Gallery Manager
• Media Manager
• zOOm Thumb Coder
• Settings
• Optimize Tables
• Update zOOm Media Gallery
• Integration of the Gallery into your Website
• User Front End
• Lightbox
• E-Cards
• Comments and Ratings
• Modules for the zOOm Media Gallery
• Document Management/Download Area
• Installation
• Administration
• Categories
• Group
• Files
• Documents
• Licenses
• Themes
• Configuration
• Updates
• Statistics
• Integration into the Website
• Modules
• Mambots

E-Commerce and I18N

• Online Store
• Installation
• Configuration
• Work on Store Data
• Add Tax Rates
• Configuration
• Product Categories
• Joomla! Configuration
• The Order Process
• Order Administration in the Back End
• Modules
• Mambots
• Joomla! Internationalization
• Installation of a Different Language File 
• Translation of a Menu Entry
• Multilingualism with MambelFish
• Installation of MambelFish (Component and Module)
• MambelFish Configuration
• Translation with MambelFish
• Mambot for MambelFish
• Integrate your Own Components into MambelFish

Your Own Templates

• Corporate Identity
• HTML/XHTML, CSS, and XML
• HTML/XHTML
• CSS
• In the Central HTML File
• In a Separate CSS File
• Within an HTML Tag
• Combinations
• XML
• Create Your Own Templates
• Concept
• Fixed Size or Variable Size
• Structure
• HTML Conversion
• File Structure of the Template
• First Trial Run
• Integration of the Joomla! Module
• Creating a Template Package
• Installation with the Joomla! Template Installer
• Creating Templates with Dreamweaver Extension
• Installation
• Create New Template File
• Template Structure
• Insertion of the Joomla! Modules
• Live Site
• Templates and <div> Tags
• Barrier Free Joomla!
• Criteria for Accessible Websites
• Clarity
• Browser Compatibility
• Valid Source Code and Logically Structured Page Architecture
• Contrasts
• Graphics and Pictures
• Font Sizes
• Additional Criteria and Information
• The Reality
• Is Joomla! Barrier-Free?
• Is it Possible to make Joomla! Barrier-Free?
• The Technology
• The People
• Barrier-Free Sites with Joomla!

Your Own Program Extensions

• Sample joomlabook Component
• The MySQL Table 
• The Front End
• Integration into the Main Menu
• Joomla! Administration 
• Create Installation Package 
• Modules 
• Source Code 
• Installation 
• View of the Website 
• Mambots