Snippets

Snippet Library

Practical pure PHP patterns that are easy to study, adapt and use.

Code

Foreign-Key-Safe Delete Preflight

Checks whether a parent row can be deleted by looking for child rows that reference it through live foreign-key metadata.

Open Snippet

Code

Live DB Schema Drift Detector

Compares expected column definitions against the live database table and reports missing, extra, and changed columns.

Open Snippet

Code

Slug Collision Repair Map

Builds a deterministic review map for duplicate slugs without changing the database automatically.

Open Snippet

Code

Orphaned Pivot Row Auditor

Finds pivot-table rows whose left or right foreign-key values no longer exist in their parent tables.

Open Snippet

Code

Auto-Increment Gap Review

Reviews the ID range, row count, and next auto-increment value for a table without attempting to resequence IDs.

Open Snippet

Code

Read-Only Import Dry Run

Validates incoming import rows and reports inserts, updates, duplicates, and errors without writing to the database.

Open Snippet

Code

Column Allowlist SQL Builder

Builds a prepared-statement SQL fragment only from columns approved by an explicit allowlist.

Open Snippet

Code

Fulltext Search Health Check

Checks whether a table has a FULLTEXT index covering the columns expected by the search feature.

Open Snippet

Code

Safe Bulk Update Planner

Creates a reviewed bulk-update plan that requires approved columns, a WHERE filter, and a maximum-row guard before execution.

Open Snippet

Code

Duplicate Slug Investigator

Queries a table for duplicate slug values and returns the affected IDs for review.

Open Snippet

Code

Admin CSRF Bulk Action Gate

Validates a POSTed CSRF token and a bulk-action selection before an admin controller performs a state-changing operation.

Open Snippet

Code

Session Fingerprint Drift Review

Compares a stored session fingerprint with the current request fingerprint and returns an explicit drift decision.

Open Snippet