The Ultimate
Snippet Library.

Add, Remove, or Toggle CSS Classes on an Element

Master dynamic styling by using JavaScript's `element.classList` API to add, remove, or toggle CSS classes, allowing for flexible and responsive UI changes.

Replace an Existing HTML Element in the DOM

Learn to swap out one HTML element for another dynamically using JavaScript's `parentNode.replaceChild()`, essential for updating UI components on the fly.

Insert an Element Before or After a Specific Sibling Element

Control precise element placement within the DOM by using JavaScript's `insertBefore()` or `insertAdjacentElement()` to add new content relative to an existing sibling.

Perform Atomic Upsert Operations with MySQL's `INSERT ... ON DUPLICATE KEY UPDATE`

Master MySQL's `INSERT ... ON DUPLICATE KEY UPDATE` to atomically insert a new row or update an existing one if a unique key constraint is violated, ensuring data integrity.

Calculate Running Totals Per Group using SQL Window Functions

Utilize SQL window functions with `SUM() OVER (PARTITION BY ... ORDER BY ...)` to efficiently compute cumulative sums or running totals for data within distinct categories or groups.

Transform Rows to Columns (Pivot Data) with SQL `CASE` Statements

Learn to dynamically pivot data in SQL, converting unique row values into distinct columns using conditional aggregation with `SUM()` and `CASE` statements for clearer reporting.

Construct and Query JSON Data in MySQL

Master MySQL's JSON functions like `JSON_OBJECT`, `JSON_ARRAYAGG`, and `JSON_EXTRACT` to dynamically create, manipulate, and query JSON data directly within your database tables.

Get and Set Custom Data Attributes on a DOM Element

Efficiently retrieve and update custom data attributes (data-*) on any HTML element in the DOM using JavaScript's dataset property for dynamic behavior.

Update Multiple Text Contents of Selected Elements

Learn to efficiently update the text content of multiple elements in the DOM using querySelectorAll and textContent, perfect for lists or repeated elements.

Smoothly Scroll to a Specific Element with JavaScript

Implement smooth scrolling to any target element on the page using JavaScript's scrollIntoView method for enhanced user navigation and experience.

Optimize Batch DOM Appends with DocumentFragment

Improve performance of adding many elements to the DOM by using DocumentFragment to minimize reflows and repaints with a single DOM insertion.

Fetching All Pages from a Paginated API in JavaScript

Learn how to programmatically fetch all available data from a paginated API endpoint using JavaScript's Fetch API, iterating through pages until complete.