Php For Beginners With Mysql Create Api And Real Time App

in this course you will learn PHP and how to create real time application

What you'll learn
you will learn PHP
you will learn OOP
you will learn how to create db and table in MySQL database
you will learn how to create API
you will learn what is JWT
you will learn what is websocket and how to use it
you will learn create real time app
you will learn JS
after this course you will be able to create real time project with PHP
Requirements
No programming experience needed. You will learn everything you need to know
basic of HTML ,CSS and Bootstrap
Description
-PHP for Beginners with MySQL create API and real time app- in this course you will learn PHP and how to create real time application - 13.5 total hours - 11 sections 1-Environment setup:in this section you will learn Environment setup for PHP and run PHP scriptBasic syntaxin this section you will learn PHP syntaxOOPin this section you will learn what is OOP and create a class ,object, trait ,abstract class , interface and use method overridingsuper global variablein this section you will learn what is super global variable and how to use GLOBALS , SERVER ,GET ,POST ,SESSION ,COOKIE and REQUESTMySQL Database (PDO)in this section you will learn what is PDO and create CRUD appForm Handling and add condition for input fieldin this section you will learn create condition for input fieldFile Uploading and Sending Emailsin this section you will learn what SMTP and how to use it and how to upload filecreate API and use JWTin this section you will learn what is API and create CRUD applearn some basics of JSin this section you will learn some basics of JS and how to create element and add a new element to HTML DOMWebSocket and create a real-time database with MySQL databasein this section you will learn what is WebSocket and how to create a WebSocketcreate a simple chat application in PHPin this section you will learn how to create a simple chat application- 1 project- 10 coding challenges - 82 Repositories

Overview

Section 1: 1-Environment setup

Lecture 1 1-install vscode and extension

Lecture 2 2-install xampp

Lecture 3 3-install composer

Lecture 4 4-open localhost and phpmyadmin

Lecture 5 5-create first php script

Lecture 6 6-explain the coding challenge

Lecture 7 7-solve the coding challenge

Section 2: 2-Basic syntax

Lecture 8 1-PHP Syntax and echo

Lecture 9 2-php comments

Lecture 10 3-Double and Integer data type

Lecture 11 4-NULL and Booleans data type

Lecture 12 5-String and array data type

Lecture 13 6-Constant

Lecture 14 7-Comparison Operators

Lecture 15 8-php datetime

Lecture 16 9-if…else…elseif Statement

Lecture 17 10-switch statement

Lecture 18 11-while loop

Lecture 19 12-do…while loop

Lecture 20 13-for loop

Lecture 21 14-foreach loop

Lecture 22 15-Break and Continue

Lecture 23 16-explain the coding challenge

Lecture 24 17-solve the coding challenge

Section 3: 3-OOP

Lecture 25 1-What is OOP

Lecture 26 2-create first-class and constructor

Lecture 27 3-create Methods and Properties

Lecture 28 4-Private Access Modifiers and getter and setter

Lecture 29 5-Inheritance

Lecture 30 6-Overriding Inherited Methods

Lecture 31 7-Abstract Classes and Methods

Lecture 32 8-Interfaces

Lecture 33 9-Traits

Lecture 34 10-Static Methods

Lecture 35 11-Static Properties

Lecture 36 12-explain the coding challenge

Lecture 37 13-solve the coding challenge

Section 4: 4-super global variable

Lecture 38 1-$GLOBALS

Lecture 39 2-$_SERVER

Lecture 40 3-$_GET

Lecture 41 4-$_POST

Lecture 42 5-$_REQUEST

Lecture 43 6-$_COOKIE

Lecture 44 7-$_SESSION

Lecture 45 8-explain the coding challenge

Lecture 46 9-solve the coding challenge

Section 5: 5-MySQL Database (PDO)

Lecture 47 1-MySQL Database

Lecture 48 2-MySQLi and PDO

Lecture 49 3-Create a DB and connected to PHP

Lecture 50 4-Create table and relationship

Lecture 51 5-Insert Data

Lecture 52 6-Select Data

Lecture 53 7-WHERE, ORDER BY, and LIMIT

Lecture 54 8-Update Data

Lecture 55 9-Delete Data

Lecture 56 10-JOIN

Lecture 57 11-explain the coding challenge

Lecture 58 12-solve the coding challenge

Section 6: 6-Form Handling and add condition for input field

Lecture 59 1-Form Handling

Lecture 60 2-Form Handling with 2 page

Lecture 61 3-Form Validation

Lecture 62 4-explain the coding challenge

Lecture 63 5-solve a coding challenge

Section 7: 7-File Uploading and Sending Emails

Lecture 64 1-Create HTML form for uploading file

Lecture 65 2-Create PHP script for uploading file

Lecture 66 3-Check if File Already Exists

Lecture 67 4-Limit File Type

Lecture 68 5-Limit File Size

Lecture 69 6-Create HTML form for sending email

Lecture 70 7-Install php mailer 1

Lecture 71 8-Create SMTP Server

Lecture 72 9-Sending email by SMTP server

Lecture 73 10-explain the coding challenge

Lecture 74 11-solve the coding challenge

Section 8: 8-create API and use JWT

Lecture 75 1-what is api

Lecture 76 2-Install postman

Lecture 77 3-Select data

Lecture 78 4-Insert data

Lecture 79 5-Update data

Lecture 80 6-Delete data

Lecture 81 7-Using JWT to authenticate users

Lecture 82 8-How to Secure your API's Routes with JWT

Lecture 83 9-explain the coding challenge

Lecture 84 10-solve the coding challenge

Section 9: 9-learn some basics of JS

Lecture 85 1-Install Axios and get data from API

Lecture 86 2-Add data to db by using axios

Lecture 87 3-getElementById() and change color

Lecture 88 4-Get and Change inner HTML

Lecture 89 5-Create an element and use appendChild

Lecture 90 6-addEventListener and change style

Lecture 91 7-classList , add and remove class

Lecture 92 8-explain the coding challenge

Lecture 93 9-solve the coding challenge

Section 10: 10-WebSocket and create a real-time database with MySQL database

Lecture 94 1-What is websocket

Lecture 95 2-Use public websocket

Lecture 96 3-onopen Event Listener

Lecture 97 4-onmessage Event Listener

Lecture 98 5-onclose Event Listener

Lecture 99 6-Send a message to websocket

Lecture 100 7-create a custom websocket with ratchet

Lecture 101 8-explain the coding challenge

Lecture 102 9-solve the coding challenge

Section 11: 11-create a simple chat application in PHP

Lecture 103 1-explain the project

Lecture 104 2-create database and tables

Lecture 105 3-create user

Lecture 106 4-add data into picture profile table

Lecture 107 5-check for correct email and password

Lecture 108 6-use JWT to create a token

Lecture 109 7-create logout page

Lecture 110 8-get data from token

Lecture 111 9-update username

Lecture 112 10-update password

Lecture 113 11-update picture profile

Lecture 114 12-install ratchet and send data by websocket

Lecture 115 13-insert message into db

Lecture 116 14-get messages from db and print it

Lecture 117 15-show message in DOM

Lecture 118 16-show message in your secren

Lecture 119 17-show pic profile

Lecture 120 18-change date format

Lecture 121 19-add condition for input field

Beginner php developer,backend developer,real time database developer,web developer