• Post category:StudyBullet-9
  • Reading time:11 mins read


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

What you will 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

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


Get Instant Notification of New Courses on our Telegram channel.


  1. 1-Environment setup:in this section you will learn Environment setup for PHP and run PHP script
  2. Basic syntaxin this section you will learn PHP syntax
  3. OOPin this section you will learn what is OOP and create a class ,object, trait ,abstract class , interface and use method overriding
  4. super global variablein this section you will learn what is super global variable and how to use GLOBALS , SERVER ,GET ,POST ,SESSION ,COOKIE and REQUEST
  5. MySQL Database (PDO)in this section you will learn what is PDO and create CRUD app
  6. Form Handling and add condition for input fieldin this section you will learn create condition for input field
  7. File Uploading and Sending Emailsin this section you will learn what SMTP and how to use it and how to upload file
  8. create API and use JWTin this section you will learn what is API and create CRUD app
  9. learn 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 DOM
  10. WebSocket and create a real-time database with MySQL databasein this section you will learn what is WebSocket and how to create a WebSocket
  11. create 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

English
language

Content

1-Environment setup

1-install vscode and extension
2-install xampp
3-install composer
4-open localhost and phpmyadmin
5-create first php script
6-explain the coding challenge
7-solve the coding challenge

2-Basic syntax

1-PHP Syntax and echo
2-php comments
3-Double and Integer data type
4-NULL and Booleans data type
5-String and array data type
6-Constant
7-Comparison Operators
8-php datetime
9-if…else…elseif Statement
10-switch statement
11-while loop
12-do…while loop
13-for loop
14-foreach loop
15-Break and Continue
16-explain the coding challenge
17-solve the coding challenge

3-OOP

1-What is OOP
2-create first-class and constructor
3-create Methods and Properties
4-Private Access Modifiers and getter and setter
5-Inheritance
6-Overriding Inherited Methods
7-Abstract Classes and Methods
8-Interfaces
9-Traits
10-Static Methods
11-Static Properties
12-explain the coding challenge
13-solve the coding challenge

4-super global variable

1-$GLOBALS
2-$_SERVER
3-$_GET
4-$_POST
5-$_REQUEST
6-$_COOKIE
7-$_SESSION
8-explain the coding challenge
9-solve the coding challenge

5-MySQL Database (PDO)

1-MySQL Database
2-MySQLi and PDO
3-Create a DB and connected to PHP
4-Create table and relationship
5-Insert Data
6-Select Data
7-WHERE, ORDER BY, and LIMIT
8-Update Data
9-Delete Data
10-JOIN
11-explain the coding challenge
12-solve the coding challenge

6-Form Handling and add condition for input field

1-Form Handling
2-Form Handling with 2 page
3-Form Validation
4-explain the coding challenge
5-solve a coding challenge

7-File Uploading and Sending Emails

1-Create HTML form for uploading file
2-Create PHP script for uploading file
3-Check if File Already Exists
4-Limit File Type
5-Limit File Size
6-Create HTML form for sending email
7-Install php mailer 1
8-Create SMTP Server
9-Sending email by SMTP server
10-explain the coding challenge
11-solve the coding challenge

8-create API and use JWT

1-what is api
2-Install postman
3-Select data
4-Insert data
5-Update data
6-Delete data
7-Using JWT to authenticate users
8-How to Secure your API’s Routes with JWT
9-explain the coding challenge
10-solve the coding challenge

9-learn some basics of JS

1-Install Axios and get data from API
2-Add data to db by using axios
3-getElementById() and change color
4-Get and Change inner HTML
5-Create an element and use appendChild
6-addEventListener and change style
7-classList , add and remove class
8-explain the coding challenge
9-solve the coding challenge

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

1-What is websocket
2-Use public websocket
3-onopen Event Listener
4-onmessage Event Listener
5-onclose Event Listener
6-Send a message to websocket
7-create a custom websocket with ratchet
8-explain the coding challenge
9-solve the coding challenge

11-create a simple chat application in PHP

1-explain the project
2-create database and tables
3-create user
4-add data into picture profile table
5-check for correct email and password
6-use JWT to create a token
7-create logout page
8-get data from token
9-update username
10-update password
11-update picture profile
12-install ratchet and send data by websocket
13-insert message into db
14-get messages from db and print it
15-show message in DOM
16-show message in your secren
17-show pic profile
18-change date format
19-add condition for input field