Realtime fetching from normal MySQL DB | Realtime data in PHP MySQL

Опубликовано: 27 Февраль 2025
на канале: HA Codes
6,885
152

Hi, In this video, we will fetch data from MySQL databases in realtime with best efficiency without sending multiple requests in intervals with the help of SSE in JavaScript. SSE is Server-Sent Events, which accrues when data change on PHP file. If you are not able to use other realtime database services due to any reason, then try this trick once. We just write code for fetching. Other operations will be done using typical methods like insert, update and delete.
I create the full project including HTML & CSS. If you are not here to learn that then skip that part and go next. All the source code is given below to help you in creating the project. All your suggestion about this channel is appreciable.

Source Code:
https://drive.google.com/file/d/1sjI4...

Chapters:
0:00 Intro
1:50 Start PHP
2:19 DB Connection
2:36 Create Database and table
3:19 Remaining DB Connection
3:44 Remaining PHP
6:32 JavaScript
7:32 HTML
8:00 CSS
8:36 Remaining JS

––––––––––––––––––––––––––––––
Lights by Sappheiros   / sappheirosmusic  
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/LightsSappheiros
Music promoted by Audio Library    • Lights – Sappheiros (No Copyright Music)  
––––––––––––––––––––––––––––––