Skip to content

WebCheatSheet

The easy way to know

  • PHP
  • HTML
  • JavaScript
  • SQL
  • ASP
  • MS Access Functions
  • SaaS
  • Email
PHP

Parse Untrusted XML Safely with PHP XMLReader

Sergey KornilovNovember 13, 2026

Bound the input, disable network access, reject DTDs, and avoid entity-expansion flags when parsing untrusted XML with PHP XMLReader.

JavaScript

Validate API JSON before Reading Array Length

Sergey KornilovNovember 13, 2026

Check the HTTP response and JSON shape before reading length, then render an empty array separately from a malformed API response.

SQL

Remove SQL Server STX Characters before FOR XML

Sergey KornilovNovember 13, 2026

Locate the U+0002 STX character in archived SQL Server text and remove it in the export query without changing the source table.

PHP

Validate Symfony Integer and Boolean Query Parameters

Sergey KornilovNovember 13, 2026

Distinguish missing Symfony query parameters from empty or invalid values, apply ranges, and return a clear 400 response for bad input.

SaaS Architecture

Detect Hidden Document Text before LLM Ingestion

Sergey KornilovNovember 12, 2026

Compare extracted document text with OCR from rendered pages, quarantine mismatches, and keep untrusted files away from tool-enabled LLM agents.

PHP

Handle PHP zlib Warnings and Exceptions Consistently

Sergey KornilovNovember 12, 2026

Validate zlib options, bound decompression output, and convert operation warnings into a local exception without hiding unrelated PHP failures.

SQL

Store MySQL Dates beyond the 2038 TIMESTAMP Limit

Sergey KornilovNovember 12, 2026

Use DATETIME for future MySQL dates beyond 2038, store a defined UTC value, and keep time-zone conversion in a controlled application boundary.

PHP

Replace Curly-Brace String Offsets in PHP 8

Sergey KornilovNovember 12, 2026

Replace legacy $value{0} offset syntax with square brackets, then verify whether the code expects bytes, characters, or array elements.

JavaScript

Return Data from a Popup Window with postMessage

Sergey KornilovNovember 12, 2026

Send a small result from a popup to its opener with postMessage, while checking the exact origin, window source, and message shape.

PHP

Close PHP ZipArchive before Deleting Source Files

Sergey KornilovNovember 11, 2026

Call ZipArchive::close explicitly and check its result before deleting files added to the archive, because writing may be deferred until close.

Posts navigation

Older posts

Recent Posts

  • Parse Untrusted XML Safely with PHP XMLReader
  • Validate API JSON before Reading Array Length
  • Remove SQL Server STX Characters before FOR XML
  • Validate Symfony Integer and Boolean Query Parameters
  • Detect Hidden Document Text before LLM Ingestion

Recent Comments

  1. Build Accessible Tabs with JavaScript – WebCheatSheet on How to Control Tab Order in HTML
  2. Verify SQL Server Backups with CHECKSUM and VERIFYONLY – WebCheatSheet on Fix SQL Server ‘Insufficient Access Rights’ During Backup
  3. Get the Latest MySQL Value Before Two Dates – WebCheatSheet on SQL GROUP BY
  4. Count Duplicate Values in a JavaScript Array – WebCheatSheet on JavaScript Arrays
  5. Fix MySQL Error 1038 for Wide Rows and Filesort – WebCheatSheet on Determine the MySQL Version from the Command Line

Archives

  • November 2026
  • October 2026
  • September 2026
  • August 2026
  • October 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022

Categories

  • ASP
  • Email
  • HTML
  • JavaScript
  • MS Access Functions
  • PHP
  • SaaS Architecture
  • SQL
  • Uncategorized
Copyright © 2026 WebCheatSheetFresh News by Ascendoor | Powered by WordPress.