Skip to content

WebCheatSheet

The easy way to know

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

Why a Web Page Works on localhost but Not from a File

Sergey KornilovNovember 7, 2026

Use a local HTTP server when modules, fetch requests, PHP, or browser origin rules make a page fail under a file URL.

SQL

Store ISO 8601 Offsets Correctly in MySQL

Sergey KornilovNovember 7, 2026

Use TIMESTAMP for instants, include a supported numeric offset, and set the session time zone explicitly when storing ISO 8601 values.

PHP

Recover from a phpMyAdmin LoginCookieValidity TypeError

Sergey KornilovNovember 7, 2026

Remove the invalid saved LoginCookieValidity preference, restore a positive configured value, and verify phpMyAdmin configuration storage.

SQL

Bound MySQL Connector/J Connection Setup Time

Sergey KornilovNovember 7, 2026

Set both connectTimeout and socketTimeout, then enforce a pool-level acquisition deadline so MySQL connection initialization cannot wait forever.

PHP

Discard Doctrine OCI8 Connections After a Rejected Commit

Sergey KornilovNovember 6, 2026

Treat an Oracle commit failure as connection-fatal, close the Doctrine DBAL connection, and retry the complete unit of work on a clean connection.

PHP

Verify Symfony S/MIME Signatures After Email Transport

Sergey KornilovNovember 6, 2026

Preserve the signed MIME bytes, capture the delivered message, and verify S/MIME after the same transport path recipients use.

PHP

Use Last-Modified Correctly in Symfony Responses

Sergey KornilovNovember 6, 2026

Compute Last-Modified from every dependency in the representation, evaluate conditional requests, and avoid validators on time-dependent output.

PHP

Understand phpMyAdmin MySQL Connection Compression

Sergey KornilovNovember 6, 2026

The phpMyAdmin compress option affects only the MySQL client/server protocol; enable it only for measured network savings.

SQL

Verify In-Memory OLTP Support on SQL Server Express

Sergey KornilovNovember 6, 2026

Check the edition, architecture, and XTP support flag before creating a memory-optimized filegroup or table on SQL Server Express.

SQL

Discard MySQL Async Connections After Query Cancellation

Sergey KornilovNovember 5, 2026

Treat cancellation during an in-flight MySQL query as connection-fatal, close the connection, and let the pool create a clean replacement.

Posts navigation

Older posts

Recent Posts

  • Why a Web Page Works on localhost but Not from a File
  • Store ISO 8601 Offsets Correctly in MySQL
  • Recover from a phpMyAdmin LoginCookieValidity TypeError
  • Bound MySQL Connector/J Connection Setup Time
  • Discard Doctrine OCI8 Connections After a Rejected Commit

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.