ISI ACADEMY for PHP& MySQL
web applications Programming
ISI ACADEMY
Web applications Programming Diploma using PHP& MySQL
HTML - CSS - JavaScript – PHP - MYSQL
What You'll Learn
Be able to write, deploy, debug and run JavaScript code in the context of client-side Web Pages .
Be able to write JavaScript programs to add useful behavior to Web pages.
Understand PHP commands and program structure.
Build dynamic web pages.
Use PHP to process HTML forms.
Master regular expressions for form validation and other applications.
Read and write files with PHP
How to easily switch from MySQL to any of the other popular databases such as PostGre SQL and SQLite.
Implementation and Development Methodologies.
User Authentication and Session Security.
Interacting with Databases
How to handle files. Including reading both and writing data.
How to update existing records into MySQL database using PHP.
How to fetch records from MySQL database using PHP.
How to show your query result into multiple pages and how to create The navigation link.
Build and Design E-commerce project in PHP.
Career Opportunities
Modern statistics of 2013 say that 81% of web sites is made by PHP technology. So PHP programmers have a big market in compares to other programmers .
Who Needs to Attend
This course is for web development that needs to add dynamic content to their web sites, including form processing and database-driven content generation. it is designed for complete Beginners of web programming
Prerequisites
No previous programming experience is required.
Follow-On Courses
Course Outline
Track Two
Programming with HTML4 CSS and JavaScript
HTML outline:
Overview of Web Development – from a marketing perspective.
Fundamentals of Site Design – creating a flow chart and Page Structure
Introduction to HTML Tags & HTML Syntax
Browser Comparisons (Netscape, IE, Opera)
Formatting an HTML Document and Text Formatting
Applying Text Attributes
Creating Lists – Numerical, Alpha, and square boxes
Creating Hyperlinks – three types, absolute, relative and bookmark.
Embedding Graphics and Alternate commands
Creating Simple Tables – borders, shading.
Creating Complex Tables – colours, images, hyperlinks
Using Tables as a Layout Tool – framework for a page
Creating Forms – Guestbook, Customer Response Forms etc
Capturing Information from Forms
CSS Outline
Introduction to Cascading Style Sheets (CSS)
Designing with Style Sheets
Style Sheet Syntax
Class Selectors
The DIV and SPAN Elements
Linked (External) Style Sheets
Cascading Order
Text and Font Properties
Applying Colors
Background Techniques
Formatting with the Box Model
Borders
Floating Elements
Styling Lists
Positioning Elements Absolutely and Relatively
JavaScript Outline
JAVASCRIPT Introduction JAVASCRIPT How To JAVASCRIPT Where To JAVASCRIPT Statements JAVASCRIPT Comments JAVASCRIPT Variables JAVASCRIPT Operators JAVASCRIPT Comparisons JAVASCRIPT If...Else JAVASCRIPT Switch JAVASCRIPT Popup Boxes
JAVASCRIPT Functions
JAVASCRIPT For Loop
JAVASCRIPT While Loop
JAVASCRIPT Break Loops
JAVASCRIPT For...In JAVASCRIPT Events JAVASCRIPT Try...Catch JAVASCRIPT Throw
JavaScript Object
JAVASCRIPT String JAVASCRIPT Date JAVASCRIPT Array JAVASCRIPT Boolean JAVASCRIPT Math JAVASCRIPT RegExp JAVASCRIPT ValidationTrack Two
PHP and MySQL Basics:
1- Introduction
Introduction to dynamic websites
What is PHP?
What is Apache?
Server Side vs. Client Side Scripting
What is MySQL Database?
Why choose PHP and MySQL
2- PHP Programming
PHP Syntax
Hello world String
PHP variables and data types
PHP Operators
Conditional statements using If, else & Switch
Creating Arrays
Numeric Arrays
Associative Arrays
Array() Construct
PHP For and While Loops
Server Side Includes (SSI)
3- PHP Functions
Defining your own PHP functions
Functions Parameters
Function return value
Calling a function
PHP Built-in Functions
PHP Date and String functions
4- PHP Object Oriented Programming (OOP)
Create a Class
Constructor and destructor
Object
5- HTML Forms and PHP
What is Form
Form elements, Textbox, Textarea, select menu, file attachment, submit and
reset button
Form action and method
How to send form data
How to capture and display form data
URL Parameters
6- PHP Global Variables
POST and GET
Cookies
Session
7- MySQL Database:
Database concepts & RDBMS (Relational Database Management Systems)
Introduction to SQL (Structured Query Language)
Creating ERD (Entity Relationship Diagram)
What are MySQL data types
Creating and Editing Database and Tables
Primary key
Foreign key
Inserting Data in tables
Updating data
Deleting data
Selecting data
Searching for data using SQL Wild cards
Using group functions
MySQL built-in functions
Using table joins
Equi Join & Left Join multiple tables
8- Final project and Exam
Track Three
PHP and MySQL Advanced:
1- Create Dynamic Pages using PHP and MySQL
Connect PHP with MySQL
Insert web page data into database
Update data from web pages
View dynamic data on web pages
How to delete data from web pages
2- How to setup a website development project
Project Structure
Folder and File Structure
Database design
3- Project 1: Build a Contact us Email Form
Create Form on web page
Accept data
Mail function
4- Project2: Build a Login system
Create a login page
Connect login page to database
Validate login data
5- Project3: Build an online shop backend CMS
Database for shopping cart website
Add Product page
Upload product image
View products
Delete product from catalogue
Update products
View customers
View online orders
6- Project4: Create an E-commerce shopping cart website
E-commerce website design
Create a home page
Build a product search
Display e-commerce catalogue
Create a basket page
Add items to basket page
Update items quantity in basket
Remove items from basket
Customer checkout
Register customer details
Save Customer online order
Understand online transaction
Duration:
No Of Sessions: 28 (27 Learning & 1 Exam) (84 hour) No Of Hours Per Session: 3 Hours.