PHP and MySQL (Expert Level) - iSolution India - Professional Web Design Company in India, Apps Development, SEO, SMO

About Course

What you’ll learn

Communication Development

Typing Speed

Interview Prepairation

You will learn MySQL
You will learn how to launch your application online
You will learn about sessions
Email sending
You will learn to create clean URL’s and remove the .php from files
You will learn to debug your code
You will code refactoring
You will learn to use an API to bring data from a database to a graphical interface

You will learn how to use Databases
Object Oriented Programming
How to use forms to submit data to databases
You will learn about PHP security
Password hashing
You will learn to use composer (PHP package manager)
You will learn to use bootstrap by getting experience from the project
You will learn to create pagination
You will learn to debug (fix your code)
There is so much more and my hands are just tired of typing

Course Content

HTML

HTML Fundamentals

HTML Tags

HTML-Forms

HTML_Website Structure

CSS-Fundamentals

Basic of CSS

Deeper into CSS

Module Introduction
Understanding the Box Model
Understanding Margin Collapsing and Removing Default Margins
Diving Into the Height & Width Properties
Understanding the Display Property
Applying the Display Property & Styling our Navigation Bar
Understanding an Unexpected “inline-block” Behaviour
Working with “text-decoration” & “vertical-align”
Adding & Styling a CTA-Button

Understanding Background Image

Size & Units

PHP

Data Types & More

Control Structures

Custom Functions

PHP Built-in Functions

How To Use Form Data In PHP

How To Use Databases in PHP

Introduction to Databases

00:00
Introduction to PHPmyadmin

00:00
Creating a Database in PHPmyadmin

00:00
Creating Tables and Inserting Data in PHPmyadmin

00:00
Markup for Login Page

00:00
Receiving Post Data From Check

00:00
Connecting to the Database using PHP

00:00
Creating Records into the database table with PHP

00:00
Reading Information in the Database with PHP

00:00
Creating the Update Records Form

00:00
Fixing Name Attribute Value

00:00
Query to Read Id’s

00:00
Refactoring The Update Query into a Function

00:00
Delete Records From Database with PHP

00:00
ReFactoring all Database Query Code into Functions

00:00
Making All Files Modular and Refactoring

00:00
Practice Section 7

00:00

PHP Security

PHP And The Web

Object Oriented PHP Introduction

What are classes and objects ? Introduction

00:00
What are classes and how to define them in PHP

00:00
What are class methods and how to create them

00:00
How to instantiate a class

00:00
Adding Properties to Our Class

00:00
Class inheritance

00:00
Constructors

00:00
Data Access

00:00
Static Data in Classes

00:00
Practice Section 10

00:00

Working With Files

CMS Project / Blogging System – Frontend And First Steps

Intro tour of the CMS

00:00
Turning On Some Important Features

00:00
Adding our assets / working structure

00:00
Creating database and category table for the CMS

00:00
Connecting to the database with PHP

00:00
Making our files reuseable

00:00
Inserting Data into Category Table and Displaying it

00:00
Creating the posts table

00:00
Post Comment Count Update ( Edwin from the future )

00:00
Inserting Data into the posts table and displaying it

00:00
Inserting the post image and displaying it

00:00
Creating a custom search engine part 1

00:00
Creating a custom search engine part 2

00:00
Creating a custom search engine part 3

00:00
Adding Categories to the sidebar

00:00

CMS – POSTS

Creating a HTML table in admin to display a list of posts

00:00
Displaying posts list in admin

00:00
Including Pages based on condition technique

00:00
Creating Post HTML form in admin

00:00
Inserting Post Data From admin

00:00
Deleting Posts in admin

00:00
Creating the HTML edit form post page

00:00
Displaying the Edit Data in Post Edit Page

00:00
Dynamic Category Editing / Image Display

00:00
Finally Updating Posts

00:00
Relating Categories to posts and Displaying it

00:00
Adding Category Dropdown to the Add Post Page

00:00
Adding Individual Post Page and Link

00:00
Creating the category page

00:00
Setting up some links and making an excerpt

00:00

CMS – COMMENTS

Creating the comments table and inserting data

00:00
Creating the comments page and HTML form in admin

00:00
Creating the Query for displaying comments in admin part 1

00:00
Creating the Query for displaying comments in admin part 2

00:00
Inserting new fields in Front end comment form and testing it

00:00
Creating the Frond End comment insert query

00:00
Finishing the query to send comment data (Front end)

00:00
Relating Comments to posts

00:00
Deleting comments

00:00
Approving and unapproving comments

00:00
Displaying comments based on approval

00:00
Increasing comments count

00:00
Adjustments to visual for comments

00:00
Adjustments for comments and Displaying Post Based on Status

00:00

CMS – USERS

Creating the users table and data insert

00:00
Creating users pages and links

00:00
Modifying user table heading

00:00
Creating the display query for users

00:00
Displaying users in admin

00:00
Adding users in admin part 1

00:00
Adding users in admin part 2

00:00
Adding users in admin part 3

00:00
Adding users in admin part 4 and final

00:00
Deleting users

00:00
Changing user roles

00:00
Setting Up the Edit User Page

00:00
Displaying User Values in Edit Page

00:00
Adding Select Options to User Role

00:00
Updating User

00:00

CMS – LOGIN

CMS – Profile

CMS – Dashboard

Improving Our CMS

CMS – Extra Features

Adding Dynamic Category Selection for Edit Post Page

00:00
Adding extra element to dashboard

00:00
Adding Links to Post Images and Read More Button

00:00
Adding Post Update Notification

00:00
Adding Post Edit Link in Front End

00:00
Adding Bulk Options Posts, part 1

00:00
Adding Bulk Options Posts, part 2

00:00
Adding Bulk Options Posts, part 3

00:00
Adding Bulk Options Posts, part 5

00:00
Adding Bulk Options Posts, part 6

00:00
Adding Dropdown Option for Add Post Page

00:00
Adding Post Creation Notice to Add Post Page

00:00
Adding Link to Add New Button in Post Page

00:00
Adding Link to View Posts from Admin

00:00
Adding Dynamic Personalization to Admin

00:00
Adding Validation to Comments in Post Page

00:00

CMS – Extra Features – User Ragistration

Downloading & Placing Form Markup

00:00
Testing Registration Form

00:00
Extracting Form Values and Escaping

00:00
Starting Query and Default Tables Values

00:00
Fetching our Database for Default Values

00:00
Registering Users

00:00
Validating Fields

00:00
Encrypting User Passwords

00:00
Updating Our CMS due to password Encryption

00:00
User Page Display Shorter Password Field

00:00
User Page Dropdown Default Value Change

00:00
PHP and Javascript Confirm Before Action

00:00
Get Your Certificate

00:00
Wrapping this up! (IMPORTANT)

00:00
Make your Feature requests here!

00:00

CMS – Extra Features – Auther Related Posts

Pagination

CMS – Extra Features – User ONLINE

CMS – Extra Features – New Simple Password Encrypting and Login System

CMS – Extra Features – Improove Comment System Count and Diplay

CMS – Extra Features – Post For Specific User in Admin

CMS – More Security

Taking the Project To the Internet.

Sending Emails

Bootstrap Modal Delete Confirm Feature

No Posts or Category Message Feature

Some Miscellaneous Features

Having Fun With Bugs

Refactoring part 1

New Ragistration System

Create a better admin detection feature

00:00
Duplicate username function

00:00
Duplicate email function

00:00
Validation for registration

00:00
Setting up our Login user function

00:00
Adding some user friendly code

00:00
Displaying inline errors in form

00:00
Registering users with the new function

00:00
Login users with the new function

00:00
Deleting via POST

00:00

CMS – Extra Features – Pretty URL’s

CMS – Extra Features – Forgot Password System

CMS – Extra Features – Forgot Password System – Sending Email

Intro

00:00
Download all the files needed

00:00
UPDATE: on mail package

00:00
Installing third party library with composer

00:00
New – How to send emails

00:00
Updated – Sending email

00:00
Autoloading classes and setting up UTF-8 for emails

00:00
Sending code over email

00:00
Creating the reset page

00:00
Pulling data and testing it

00:00
Unique database values

00:00
Updating password and token columns

00:00
Making it everything work

00:00
Update search feature to work with the forgot password system code

00:00
Data based on current user!

00:00
Image fallback and comment display fix!

00:00

CMS – Extra Features – POST LIKES

What we are creating?

00:00
Creating the like button

00:00
Attaching the click event to the button

00:00
Setting up the Like AJAX request

00:00
Fetching the Posts

00:00
Updating post with Likes

00:00
Creating our first Like

00:00
Unliking Posts

00:00
Creating a helper function to the get the Logged-in User id – part 1

00:00
Creating a helper function to the get the Logged-in User id – part 2

00:00
Creating a helper function to detect if the user likes a specific post

00:00
Updating our Like button to be more dynamic

00:00
Fetching all Likes in the Post

00:00
Finishing Likes

00:00
Let’s add a Tooltip Feature

00:00

CMS – Extra Features – Creating A Separate Admin For Logged In Users

CMS – Extra Features – Multi Language Feature

Student Ratings & Reviews

No Review Yet

About Course

What you’ll learn

Course Content

HTML

HTML Fundamentals

Introduction to HTML

Installing VS Code

Hello World

HTML Tags

Document Structure

HTML Basics

Headings & Paragraph

Links in HTML

Working with Images

HTML-Forms

Creating a Contact Form

HTML_Website Structure

Creating The Header

Creating Nav Menu

Building Page Footer

CSS-Fundamentals

Introduction

What is CSS

Basic of CSS

Module Introduction

Understanding the Course Project Setup

Adding CSS to our Project with Inline Styles

Understanding the Tag & Creating a .css File

Applying Additional Styles & Importing Google Fonts

Deeper into CSS

Module Introduction

Understanding the Box Model

Understanding Margin Collapsing and Removing Default Margins

Diving Into the Height & Width Properties

Understanding the Display Property

Applying the Display Property & Styling our Navigation Bar

Understanding an Unexpected “inline-block” Behaviour

Working with “text-decoration” & “vertical-align”

Adding & Styling a CTA-Button

Understanding Background Image

Module Introduction

Understanding “background-size”

Working with “background-position”

Applying “background” Origin, Clip & Attachment

Styling Images

Working on the Image Layout

Understanding Filters

Size & Units

Module Introduction

Where Units Matter

An Overview of Available Sizes & Units

PHP

Data Types & More

Variables in PHP

Math

Arrays

Associative Arrays

Practice Section 2

Control Structures

if Statements

Comparison and Logical Operators

Switch Statements in PHP

While Loop in PHP

For Loop in PHP

Foreach Loop in PHP

Practice Section 3

Custom Functions

Defining functions

Function Parameters

Return Values From Functions

Global Variable and Scope

Constants

Newer Way of creating a Constant

Practice Section 4

PHP Built-in Functions

Math Functions

String Functions

Array Functions

Practice Section 5

How To Use Form Data In PHP