Tips & Tutorials – Javascript

AJAX PHP MySQL Dependent Dropdown List (Step-By-Step Example)

Welcome to a tutorial on how to create a dependent dropdown list using AJAX, PHP, and MySQL. Loading dropdown options from the database is pretty easy, but how do we “link” many of these together? Let us walk through an example – Read on! ⓘ I have included a zip file with all the source …

AJAX PHP MySQL Dependent Dropdown List (Step-By-Step Example) Read More »

2 Ways To Show Loading Spinner Until Page Loads

Welcome to a quick tutorial on how to show a loading spinner until the page is fully loaded. This is a seemingly easy thing to do until you get your hands dirty… Some other tutorials online got me to facepalm with their “solution” involving the use of third-party libraries. No, we don’t need to load …

2 Ways To Show Loading Spinner Until Page Loads Read More »

Create Excel File In Javascript (Step-By-Step Example)

Welcome to a tutorial on how to create an Excel file in Javascript. Yes, you read that right. We are referring to “browser Javascript”, and not the server-side NodeJS. The dark days have passed and it is actually possible to generate Excel files using client-side Javascript – Read on for the example! ⓘ I have …

Create Excel File In Javascript (Step-By-Step Example) Read More »

Import Excel Into Database With NodeJS MySQL (Simple Example)

Welcome to a tutorial on how to import an Excel spreadsheet with MySQL and NodeJS. So want to “put an Excel file into the database”? Well, it’s actually a simple process of “read the Excel file” and “insert into database”. Read on for the example! ⓘ I have included a zip file with all the …

Import Excel Into Database With NodeJS MySQL (Simple Example) Read More »

3 Ways To Disable Scrolling In Javascript

Welcome to a tutorial on how to disable scrolling in Javascript. Need to disable scrolling on the page? Let the user fill something up before moving on? Sadly, there are no native implementations to disable scrolling in Javascript; We can only “simulate” a scroll lock using various alternatives. The common methods to disable scrolling in …

3 Ways To Disable Scrolling In Javascript Read More »