How To Create Live Table Editor Like Microsoft Excel And Google Sheets From Scratch - PHP MySQL JS
Hi Programmers, Welcome to gilgeekify, my name is Saeed Kohansal, and I hope you have a wonderful day, In this video, I will teach you how to create a Live Table Editor like Microsoft Excel and Google Sheets From Scratch Using HTML, CSS, Core PHP, Vanilla JavaScript, and MySQL Database, With my Live Table Editor You can edit your data in database directly from an HTML table in Real-Time without any page refresh, In the Client-Side, I will show you how to use JavaScript Fetch API to make network requests, and in the Server-Side, I'm gonna show you how to create PHP backend REST API to connect with database and handle your requests, It's a video about Full-Stack Web Development and Database. So We're going to connect Front-End To Back-End API. I'm using JSON data and REST architecture, JavaScript Object Notation (JSON) is a lightweight data-interchange format that is readable and easily parsed by machines. JSON is based on a subset of the JavaScript Programming Language. Representative State Transfer (REST) is a client-server architectural style that uses the HTTP protocol in a simple and effective way. Systems that adhere to REST practices are often referred to as RESTful interfaces. RESTful interfaces use the HTTP methods (GET, POST, PUT, DELETE), and so on, that web browsers use to access web pages.
------------------------------------
⭐ SPECIAL WORDS
------------------------------------
• JavaScript Object Notation (JSON)
• Representational State Transfer (REST)
• Application Programming Interface (API)
• Document Object Model (DOM)
• Hypertext Preprocessor (PHP)
• HyperText Markup Language (HTML)
• Cascading Style Sheets (CSS)
------------------------------------------
▶ TABLE OF CONTENTS
------------------------------------------
0:00 Introduction
0:25 Preview
0:50 What Is JSON?
1:04 What Is REST API (RESTful API)?
1:27 Project Explain (Frontend)
1:37 Project Explain (Backend)
1:48 Import Dummy Data
2:20 Create All Files
3:14 Connect To The Database
3:47 Start HTML Code
5:30 Start CSS Code
7:22 Start JavaScript Code
8:30 Get Data From API And Display It (JavaScript)
8:47 Start PHP Code
9:30 Define "GET" Request Actions (PHP)
11:26 Add Live Cell Editor Feature (JavaScript)
14:36 Define "POST" Request Actions (PHP)
16:02 Program Testing
--------------------------------
👨💻 SOURCE CODE
--------------------------------
https://github.com/saeedkohansal/Live...
--------------------------------
🔗 USEFUL LINKS
--------------------------------
https://github.com/saeedkohansal/PHP-...
https://getbootstrap.com/
https://fonts.google.com/
https://developers.google.com/fonts/d...
https://animate.style/
If You Enjoy My Content, Please Support Me 😍🙏
💙 PAYPAL DONATION
https://paypal.me/gilgeekify
❤️ PATREON
/ gilgeekify
💛 BUY ME A COFFEE
https://www.buymeacoffee.com/gilgeekify
🪙 My Public Address To Receive BTC • Bitcoin
bc1qerc5ev074cqknu9nz589w4vjf5ecmhuc2df83h
🥈 My Public Address To Receive ETH • Ethereum
0x566A47B9731209A5144336D274D44224bfb9C0ea
#php #javascript #webdevelopment #backend #frontend #fromscratch #fullstackwebdevelopment #webdesign #css #microsoft #google #microsoftexcel #googlesheets #livedata #realtimedata #live #realtime #education #educational #howto #webdeveloper #json #keyframes #cssanimation #cssanimations #web #websitedevelopment #website #html #html5 #htmltable #phptutorials #restapi #api #gilgeekify #geek #restfulapi #backenddevelopment #backenddeveloper #frontenddeveloper #frontenddev #frontenddevelopment #frontendwebdevelopment #excel #freecourses #freesourcecode #freeprogram #programmer #programming #programmers #coder #code #codewithme #dom #htmldom #database #mysql #mysqldatabase #mysqltutorials #tutorial #tutorials #bravebrowser #chromium #onlineclasses #learning #learn #webbased #webkit #chrome #firefox #webbrowser #css3 #animation #webanimation #notification #js #style #stylesheet #stylesheets #es6 #ecmascript #es7 #es5 #es8 #w3school #w3schools #gilgeekifyprogramming #designer #web2 #web3 #autoupdate #databasemanagementsystem #sql #sqlquery #sqlqueries #serverside #clientside #server #client #github #tricks #trick #trending #codes #coding #codinglife #trend #trendingvideo #freewebsites #learnonline #coolwebdevelopmenttricks #backendwebdevelopment #vanillajs #vanillajavascript #corephp #purephp #phpcore #purejs #purejavascript #bootstrap #bootstrap5 #animatecss #jsonapi #http #https #get #post #httpmethods #httpmethod #dummydata #sqlbackup #sqlbasics #tutorialyoutube #tutorialvideo
Watch video How To Create Live Table Editor Like Microsoft Excel And Google Sheets From Scratch - PHP MySQL JS online without registration, duration hours minute second in high quality. This video was added by user gilgeekify programming 31 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,08 once and liked it 3 people.