PHP Web Development with PHP and MySQL

Professional Web Development with PHP & MySQL

Introduction of Professional Web Development Course

Do you know you can go from Zero Skills to a Fully Qualified Web Developer in only a few month?

Well let me tell you: If you are looking for a truly 100% Comprehensive Web Development Course, that will take you from learning the basics to professional the most professional web development techniques, then be certain that you have come to the right place.

Taking this course will help you achieve your dream of becoming a professional web developer, and you will be ready to build powerful and responsive websites to a highly professional degree using today’s most professional and up to date web technologies within a few months from now.

In order to guarantee the success of your learning experience, this course was divided into 20 perfectly structured Chapters consisting of ~120 hours of crystal clear and 100% hands on engaging lectures.

Each Chapter covers one of the major web technologies and will take you from the basics to professional skills. This is how:

You will first learn the basic concepts, and straight after that apply them in easy practical examples. Then you will easily navigate to more professional concepts and use them to build more professional applications. Once you have finished the chapter, you will then move to a bigger challenge where you will confidently build a “REAL LIFE FULL PROFESSIONAL PROJECT” using the skills you acquired in that chapter combined with previous ones.

What are the requirements?

  • We will teach you everything. All you need is a computer.
  • There is absolutely no pre-knowledge required. This is a 100% Comprehensive Web Development Course that will take you from Zero-skills to a Professional Web Developer, Step by Step with NO Step skipped.

What am I going to get from this course?

  • Design and build Powerful Websites on a highly professional level using the latest Web Technologies.
  • Use HTML and CSS to build website content and add stunning styling and decoration.
  • Use Javascript, jQuery & jQuery User Interface to create Interactive Dynamic Websites
  • Use Twitter Bootstrap to produce Responsive Websites that will adapt to any device size.
  • Use PHP, Ajax and mySQL to build dynamic database-driven websites.

Contents of Professional Web Development Training:

Topics

 No. Of Days Total Hours

Getting Start

 An Overview Web Development and its Future

1

3
What we need to achieve?
File & Folder Naming Conventions
Typical Website File & Folder Structure
Managing Your Production Files
Tools of the Trade

HTML

 Starting Your First Web Page

3

 9
HTML Tags, Attributes & Elements
The Doctype
The Basic Structure of an HTML Document
Comments
Page Title
Headings
Paragraphs
Emphasis & Strong Emphasis
HTML Parent/Child Structure
Hyperlinks
Lists
Images
Address
Tables
Forms
HTML Special Characters
HTML Entities
IDs & Classes
Span & Div
Header & Footer
Nav, Section & Article
IFrames
Aside
Time
Abbreviations & Quotes
Typography

CSS

 The Style Rule

3

 9
Inline styles
Internal styles
External styles
CSS Selectors, Properties & Values
Inheritance of Styles
Pixels, Percentages, Points & Ems!
ID Selectors
Class Selectors
Descendant Selectors
Grouping Selectors
The Box Model
Colours (or Colors)
Text Styling & Formatting
Sexy Typography
Borders
Margins
Paddings
Outlines
Scrolbars
Backgrounds
Styling Forms
Styling Lists
Cursors
Outlines
Styling Links
Block & Inline Elements
Float & Clear
CSS Positioning
CSS Specificity
Visibility
Layers
Pseudo Classes
Pseudo Elements
@ Rules
Text Effects
Media Types
Paged Media
Aural Media
Printing
Layouts
Validations

Bootstrap

 Bootstrap Overview 3 9
Bootstrap Grid system
Bootstrap Typography
Bootstrap Code
Bootstrap Tables
Bootstrap Forms
Bootstrap Buttons
Bootstrap Images
Bootstrap Helper classes
Bootstrap Responsive utilities
Bootstrap Using Less
Bootstrap Using Sass
Bootstrap Glyphicons
Bootstrap Dropdowns
Bootstrap Button groups
Bootstrap Button dropdowns
Bootstrap Input groups
Bootstrap Navs
Bootstrap Navbar
Bootstrap Breadcrumbs
Bootstrap Pagination
Bootstrap Labels
Bootstrap Badges
Bootstrap Jumbotron
Bootstrap Page header
Bootstrap Thumbnails
Bootstrap Alerts
Bootstrap Progress bars
Bootstrap Media object
Bootstrap List group
Bootstrap Panels
Bootstrap Responsive embed
Bootstrap Wells

PHP Fundamentals

 Introduction to PHP

5

15
Setting up xampp
Creating first php file
Embedding php into html
php output to the browser
Comments in php
Die and Exit functions in php
Variables in php
Single quotes vs double quotes
Arithmetic operators
Assignment Operators
Comparison Operators
Logical Operators
If statement in php
if – else in php
nested if statement
if – else – if statement
Switch in php
Conditional Operators in php
Increment Decrements operators in php
String operators in php
While loop in php
do while loop
for loop in php
nested for loop
Arrays in php
Associative Arrays
Multi-Dimensional Arrays
Array Traversal with foreach loop
Functions in php
Functions with arguments
Functions return value
Case Sensitivity in php
Variable Scope in php
Constants in php
Date and time in php
Generating Random numbers
Generating Random Strings
Static Variable
Math functions in php
PHP string functions
Explode and implode functions
useful array functions
Swapping variables values
Sorting arrays
PHP hash functions
PHP Super Globals
Getting server information in PHP
Getting visitor’s ip in PHP
 

PHP Object Oriented Programming

 What are classes and objects?

2

6
What are classes and how to define them in PHP
What are class methods and how to create them
How to instantiate a class
Adding Properties to Our Class
Class inheritance
Class Constructors & Destructors
Data Access
Static Data in Class
Static Method in Class
Practical OOP Programming in PHP

Forms & File Handling in php

 Creating html Form

2

6
$_REQUEST variable
$_GET variable
$_POST variable
Getting form values with $_REQUEST
Getting form values with $_GET
Getting form values with $_POST
Validating form data
Securing the form with htmlspecialchars
Send data to other php files
Writing data to files
Reading data from files
Appending data to files
Uploading files with PHP
Displaying uploaded files
Create File Download system using PHP
Reading data from files
Appending data to files

Session and Cookies in PHP

 Setting up session

1

3
Unsetting session
Creating a Counter using Session
Tracking Information Using Session
Creating cookies in php
Deleting cookies
Create a Login System Using Session and Cookies

Email in PHP

 Sending a basic e-mail

1

3
Sending an e-mail formatted with HTML
Multipart messages

Database Manage with PHP

 Introduction to Database

5

15
Introduction to PHPMyAdmin
Creating a Database in PHPMyAdmin
Creating Tables and Inserting Data in PHPMyAdmin
Connecting to the Database using PHP
Creating Records into the database table with PHP
Reading information in the Database with PHP
Creating the Update Records Form
Query to Read all data from database with PHP
Query to Insert data to database with PHP
Query to Update Database with PHP
Delete Records from Database with PHP

JavaScript

 JavaScript Overview

3

9
JavaScript – Syntax
JavaScript – Enabling
JavaScript – Placement
JavaScript – Variables
JavaScript – Operators
JavaScript – If…Else
JavaScript – Switch Case
JavaScript – While Loop
JavaScript – For Loop
JavaScript – For…in
JavaScript – Loop Control
JavaScript – Functions
JavaScript – Events
JavaScript – Cookies
JavaScript – Page Redirect
JavaScript – Dialog Boxes
JavaScript – Void Keyword
JavaScript – Page Printing
JavaScript – Objects
JavaScript – Number
JavaScript – Boolean
JavaScript – Strings
JavaScript – Arrays
JavaScript – Date
JavaScript – Math
JavaScript – RegExp
JavaScript – HTML DOM
 
 

JQUERY

 jQuery Overview

2

6
jQuery – Basics
jQuery – Syntax
jQuery – Selectors
jQuery – Attributes
jQuery – Traversing
jQuery – CSS
jQuery – DOM
jQuery – Events
jQuery – AJAX
jQuery – Effects
jQuery – Interactions
jQuery – Widgets
jQuery – Theming
 

CMS Project: Blogging System – Front End and First Steps

 Intro Tour

2

6
Turning on Some Important Features
Adding our assets/Working structure
Creating database and category table for the CMS
Connecting to the database with PHP
Making our files reusable
Inserting Data into Category Table and Displaying it
Creating the posts table
Post Comment Count Update
Inserting Data into the posts table and displaying it
Inserting the post image and displaying it
Creating a custom search engine
Adding Categories to the sidebar

CMS Project: Categories & POSTS

 Creating reusable code in the admin 1 3
Creating the navigation links in admin
Creating the admin category
Displaying data in category page
Adding Categories
Deleting Categories
Updating or Editing Categories
Creating a HTML table in admin to display a list of posts 1 3
Displaying posts list in admin
Including Pages based on condition technique
Creating Post HTML form in admin
Inserting Post Data From admin
Deleting Posts in admin
Creating the HTML edit form post page
Displaying the Edit Data in Post Edit Page
Dynamic Category Editing/Image Display
Finally updating Posts
Relating Categories to posts and Displaying it
Adding Category Dropdown to the Add Post Page
Adding Individual Post Page and Link
Creating the category page
Setting up some links and making an excerpt/read more features

CMS Project: Comment

 Creating the comments table and inserting data 2 6
Creating the comments page and HTML form in admin
Creating the Query for displaying comments in admin
Inserting new fields in Front-end comment form and testing it
Creating the Front-end Comment insert query
Relating Comments to posts
Deleting comments
Approving and unapproving comments
Displaying comments based on approval
Increasing comments count
Adjustments to visual for comments
Adjustments for comments
Adjustments for comments and Displaying Post Based on Status
Creating the comments table and inserting data
Creating the comments page and HTML form in admin
Creating the Query for displaying comments in admin
Inserting new fields in Front-end comment form and testing it
Creating the Front-end Comment insert query
Relating Comments to posts
Deleting comments
Approving and unapproving comments
Displaying comments based on approval
Increasing comments count
Adjustments to visual for comments
Adjustments for comments
Adjustments for comments and Displaying Post Based on Status

CMS Project: Users & Login

 Creating the users table and data insert 2 6
Creating user’s pages and links
Modifying user table heading
Creating the display query for users
Displaying users in admin
Adding users in admin
Deleting users
Changing user roles
Setting up the Edit User Page
Adding Select Options to User Role
Updating User
Creating the users table and data insert
Creating user’s pages and links
Modifying user table heading
Creating the display query for users
Displaying users in admin
Adding users in admin
Deleting users
Changing user roles
Setting up the Edit User Page
Adding Select Options to User Role
Updating User
Creating the login form
Making the login page
Select User Query
Validating User Query Front End
Setting Values with Sessions
Validating User Admin
Logout Page Improved Validation
Login improved

CMS Project: User Registration

 Downloading & Placing Form Markup 1 3
Extracting Form Values and Escaping
Validating Field using PHP and JQUERY
Displaying inline errors in form
Encrypting User Passwords
Inserting Registration Values to Database
Updating Our CMS due to Password Encryption

CMS Project: Pagination

 Pagination Intro 1 3
Pagination-Links and Get Request
Pagination-Get Request Processing
Pagination-Assigning a variable to the per page value
Pagination-Adding Some Style to Current Page

Freelancing Guide

 History of Freelancing 1 3
The Way of Freelancing Work
Prerequisite to Freelancing
How to Start Online Freelancing
How to get Clients
What work to Do
How to Bid in Freelancing Job Marketplaces
How to withdraw Freelancing earnings
Process of applying for a new Payoneer Master Card
Challenges of Freelancers
Some Exceptional Marketplaces
Considerable Topics of freelancing
Others Marketplaces
Total 40 Days 120 Hours