Reject NUL Bytes Before Saving PostgreSQL Text with PHP
Detect NUL bytes in PHP before inserting text into PostgreSQL, and use bytea when the value is truly binary data.
Month: October 2026
Fix Local PHP Asset 404 Errors by Setting the Document Root
Make local CSS, SVG, and image URLs match production by starting the PHP development server with the correct public document root.
Call a Server Route from an HTML Button with Fetch
Use an HTML button and the Fetch API to send an item ID to a server route instead of trying to call a Python or PHP function directly from onclick.
Fix “prompt() Is Not Supported” in JavaScript
Run window.prompt in an actual browser page or replace it with an HTML input when the JavaScript host does not support browser dialogs.
Back Up SQL Server to a Network Share Without Access Denied Errors
Grant the SQL Server Database Engine service identity access to a UNC share before running BACKUP DATABASE from SSMS or a maintenance plan.
Enable PHP Session Strict Mode and Regenerate IDs Safely
Enable PHP session strict mode, secure the session cookie, and regenerate the ID after authentication without accepting attacker-supplied IDs.
Reject Excessively Nested Query Strings in PHP
Turn PHP parse_str nesting warnings into a controlled 400 response and limit query-string complexity before malformed requests reach application code.
Calculate Daily Ticket Counts and Sales in One SQL Query
Use SQL Server conditional aggregation to return ticket counts and sales totals per day and point-of-sale terminal without a fragile PIVOT query.
Prevent SQL Server JDBC Connections from Hanging Forever
Set a finite SQL Server JDBC socket timeout and align pool validation settings so silently dropped network connections cannot consume application threads forever.
Keep PHP Image Uploads and Database Records in Sync
Coordinate PHP file moves with PDO transactions and compensating cleanup so failed product-image updates do not leave broken records or orphaned files.