ISI ACADEMY Web applications Programming Diploma using PHP& MySQL

(1)

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

(2)

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

(3)

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 Validation

Track 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

(4)

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)

(5)

 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

(6)

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.

www.facebook.com/isiacademy

[email protected] 01220111166 – 01220111164 – 23620220 1 نيدلا حلاص دجسم ماما لينملا ايارس ش – نيدلا حلاص دجسم ماما -لينملا