Preview Create RESTful APIs using PHP, POSTMAN and MySQL: Secure API

Introduction

Introduction

How to ask a Great Questions

Introduction CSS

Choosing Code Editor

Installing Code Editor (Sublime Text)

CSS Syntax

Creating a first page with CSS Style

Source Code file

CSS Basic

Inline CSS

Internal CSS

External CSS

CSS Classes

CSS IDs

Colors

Backgrounds

Floating

Positioning

Margins

Padding

Borders

CSS Intermediate

Styling Text

Aligning Text

Styling Links

Font Family

Font Styles

Applying Google Fonts

Box Model

Icons

Tables

Navigation-Menu

Dropdowns

CSS Advanced

Advanced Selectors

Forms

Website Layout

Rounded Corners

Color Keywords

Animations

Pseudo Classes

Gradients

Shadows

Calculations

Creating Responsive Page

CSS Expert

Button Styles

Pagination

Multiple Columns

Image Reflection

UI - UX Design

Social Media Icons

External CSS Style adding

Restful API Introduction

Section Introduction

Installing XAMPP for PHP, MySQL and Apache

Installing Code Editor(Visual Studio Code)

Postman API platform installation

Composer installation

Creating PHP Project on XAMPP

Hello World Program

Restful API Basic

What is PHP

What is Restful API

HTTP request GET, POST, PUT or DELETE

REST API project structure

Project1: Restful API Authentication

Create Database and table

Creating Project forms and folders

Database Connection

JSON Web Token Handler(JWT)

Auth Middleware Token Validation

Register form

Login form

User Token Authorization check form

Project1: Restful API - MySQL

Create Database and table

Adding Data to table - insert query

MySQL Select query

MySQL Update query

MySQL Delete query

Get Project2 Source Code

Create Database Connection

Restful API - Web API Services

Create Items Class PHP File

Create Method form

Creating Record Using Restful API

Reading Method form

Reading Record Using Restful API

Update Method form

Update Record Using Restful API

Delete Method form

Delete Method Using Restful API

Coding Exercise

Solution for Coding Exercise

SEO friendly Request URLs of REST API

MySQL Introduction

Overview of Databases

MySQL Installation

MySQL Workbench Installation

Connecting to MySQL using Console

MySQL Basic

Overview of Challenges

SQL Statement Basic

SELECT Statement

SELECT DISTINCT

Column AS Statement

COUNT function

MySQL Filtering Data

SELECT WHERE Clause – One

SELECT WHERE Clause – Two

ORDER BY

LIMIT

BETWEEN

IN Operator

LIKE and ILIKE

MySQL Functions

Overview of GROUP BY

Aggregation function SUM()

Aggregation MIN() and MAX()

GROUP BY - One

GROUP BY – Two

HAVING Clause

MySQL Joins

Overview Assessment

Overview of JOINS

Introduction to JOINS

AS Statement table

INNER JOIN

FULL Outer Join

LEFT Outer JOIN

RIGHT JOIN

Union

MySQL Advanced Commands

Basic of Advanced SQL Commands

Timestamps

EXTRACT from timestamp

Mathematical Functions

String Functions

SUBQUERY

MySQL Structure Creation

Basic of Database and Tables

DataTypes

Primarykey and Foreignkey

Create Table in SQL Script

MySQL Data Queries

Insert

Update

Delete

MySQL Structure Queries

Alter Table

Drop Table

MySQL Constraints

NOT NULL Constraint

UNIQUE Constraint

MySQL Backup and Restore

Overview of Databases and Tables

Backup database using phpMyAdmin

Restoring a Database

Preview - Create RESTful APIs using PHP, POSTMAN and MySQL: Secure API