Real-time fetch of data using PHP & MYSQL, AJAX and BOOTSTRAP

link of xampp
www.apachefrie...
link of sublime text2
www.sublimetex...
Bootstrap 4
www.bootstrapc...
XMLhttprequest
www.w3schools....
Source Code:
drive.google.c...

[@phpBasics]

There are 2 problems here - 1) Each visitor to your page will be querying your database every second with no caching. This will significantly impact the performance of your server. 2) It will take 1 second for your data to populate when the page first loads.

[@matiastika1329]

so is it possible to use MYSQL real time?

[@votum6595]

But as of mysql version 8.0 ( I think ) they have removed the cache system completely and I wonder is it because its not up to date anymore? Aren't there other ways to increase query performance for the mysql database?

[@Theventuredkings]

How can I reward you for this video? Thank you very much man. Firebase was so complicated to get real time data, but from this your video, a bug I have been trying to fix about 5 days ago is now working 100%.

[@tradingfomosapien3651]

no subtitle or voice instructions, but this is just all what i need, tks alot

[@raymondmoundzele4907]

Thank you very much

[@arjunghawad9895]

what a video bro thanks alot... now it is supper easy for me. you got one more suscriber man you earn it you deserv it

[@TechnicalYarana]

thank you so much for makong this video also like your all videos

[@loikimthanh8701]

Don't use setterval because it will cause constant server load and crash the server

[@DnKZone]

you earned a subscriber my man!☺️ and you are my type of php programmer ❤️

[@truongnguyenhuunhat583]

thank you so much, this is a thing I'm findding a long time

[@polareda687]

thanks and more love

[@melaniemurday3138]

works great. thank you

[@MightyFake]

Thanks

[@TechnicalYarana]

you are grate man

[@developer1107]

Great work

[@Rocket365]

great great great ttthhx bro

[@avijeetkumar7092]

great work !!

[@swastikjainsj]

I have 2 tables ? how to search it ?UNIOns is not working ?

[@covid19vietnames97]

Thank you !

[@EagleTube1337]

thanks for sharing

[@roblox254r]

It is not actually real time, there is 1 second loop time, but great work!

[@safikkhalifa7689]

how to add link in text?

[@diockman718]

Nice one!

[@jamesrobfunc2026]

aylabya😊

[@swastikjainsj]

I got answer 🤣😂🤣😂🤣 myself 1) How to find data from 2 tables Ans : copy paste the php code down and change table name and rows name 😂🤣😂👻 game over in backend bcoz UNION is not working

[@Enterate12]

No es eficiente tu aplicación