The Ultimate
Snippet Library.

Filter an Array Based on a Custom Condition

Learn how to efficiently filter elements from a PHP array using a callback function with array_filter, keeping only items that meet specific criteria.

Transform Array Values Using array_map

Discover how to apply a callback function to every element in a PHP array, creating a new array with transformed values using `array_map`.

Sort Multi-dimensional Arrays by a Key

Learn to sort complex multi-dimensional PHP arrays efficiently by the values of a specific key using a custom comparison function with `usort`.

Aggregate Array Values Using array_reduce

Understand how to reduce a PHP array to a single value by iteratively applying a callback function to each element with `array_reduce`.

Flatten a Multi-dimensional Array

Learn to convert a nested or multi-dimensional PHP array into a single-dimensional flat array using a recursive function.

Querying and Extracting Data from JSON/JSONB Columns (PostgreSQL)

Learn to query JSON or JSONB columns in PostgreSQL, extracting specific values and filtering records based on nested JSON data. Essential for modern web applications.

Basic Case-Insensitive Full-Text Search (PostgreSQL)

Implement simple case-insensitive full-text search in PostgreSQL using the `ILIKE` operator for flexible data querying across multiple columns.

Traverse Hierarchical Data with Recursive CTE (PostgreSQL)

Learn to query hierarchical data structures like categories or comment threads using `WITH RECURSIVE` CTEs in PostgreSQL to find ancestors or descendants.

Conditional Aggregation for Dynamic Summary Reports

Generate powerful summary reports with conditional aggregation using `CASE` statements inside aggregate functions. Count or sum specific categories within a single query.

Find and Delete Duplicate Records (Non-Window Function Method)

Discover how to identify and remove duplicate rows in a table based on specific columns without relying on window functions. Preserve one unique record.

Validate an Email Address with Regular Expression

Learn how to use a regular expression in JavaScript to effectively validate email address formats, ensuring proper syntax for user input.

Validate Strong Passwords with Regex for Mixed Characters

Implement a JavaScript regular expression to enforce strong password policies, requiring at least one uppercase, lowercase, number, and special character.