Functions

Function Library

Reusable pure PHP functions for everyday application and LAMP stack work.

Code

Database Backup Manifest

Creates a manifest of tables, row counts, checksums, and dump metadata.

Open Function

Code

Restore Preflight Checker

Checks target database compatibility before importing a dump.

Open Function

Code

Auto Increment Auditor

Checks whether auto-increment values are aligned after imports.

Open Function

Code

Index Recommendation Reporter

Analyzes common filters/sorts and suggests useful indexes.

Open Function

Code

Safe Delete Planner

Plans deletes with dependency checks, confirmation text, and preview counts.

Open Function

Code

Soft Delete Filter Builder

Adds consistent active/deleted filters to read queries.

Open Function

Code

Duplicate Row Finder

Finds duplicate database rows by one or more natural-key fields.

Open Function

Code

Lookup Cache Builder

Loads small lookup tables into keyed arrays for fast repeated reads.

Open Function

Code

Database Health Summary

Summarizes table counts, engine/collation status, index presence, and known risk flags.

Open Function

Code

Safe Table Exporter

Exports selected table rows with column allowlists and streaming options.

Open Function

Code

Directory Size Scanner

Calculates directory size and file counts while respecting depth and exclusion rules.

Open Function

Code

Safe Directory Cleaner

Deletes old temporary files according to extension, age, and path safety rules.

Open Function