Certificate in Web Development (Server Side)
PHP & MySQL + Joomla
PHP
PHP is a widely-used general-purpose scripting language that is especially suited for web development and can be embedded into HTML.
PHP's language syntax is similar to C's and Perl's. It generally runs on a web server like Apache which is configured to take PHP code as input
and create web page content as output. It can be deployed on most web servers and on almost every operating system and platform free of charge. PHP is installed on more than 20 million websites and 1 million web servers.
MySQL
MySQL is one of the most popular open source database management system recognized for its speed and reliability. It is commonly used with
web pages. More than 11 million Websites are built around MySQL.
Current MySQL customers such as eBay, Google, Twitter, Yahoo, Facebook, and YouTube, SlashDot, LiveJournal are perfect examples of how
MySQL is used to organize and store multiple databases that can be quickly accessed by millions of people at once.
Joomla
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.
PHP
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 developers to write dynamically generated database
driven pages quickly.
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.
TOPICS COVERED
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 |
|
| |
|
| |
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
|
|
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.
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
|
|
JOOMLA
|
+91-22-236762182