Cross-area library

Content Library

A single library for content items across the complete Content Area hierarchy. Content Areas and Categories define the structure;

261 results
261 resultsContent Area → Category
Guide

Connecting PHP to SQLite with PDO

Use sqlite: and a local database path for a lightweight relational store. File permissions and concurrent writes require attention; in-memory sqlite::memory: databases vanish with the conne…

1 views
Guide

Connecting to MySQL with PDO

PDO provides exception-driven database access through a MySQL DSN and prepared statements. Do not embed production passwords directly in scripts or interpolate user input into SQL.

1 views
Guide

Deleting Records with PDO

Use a bound primary key to remove exactly the intended record. rowCount reports affected rows, not guaranteed existence before deletion; never construct identifiers from request strings.

1 views
Guide

Escaping SQL Identifiers Safely in PHP

Dynamic table and column names must be validated against a fixed allowlist. Bound parameters cannot replace SQL identifiers, and escaping identifier text alone does not enforce authorizatio…

1 views
Guide

Executing MySQLi Transactions

Turn a group of MySQLi writes into a commit-or-rollback unit. Use exceptions and rollback on Throwable; transactional storage engines such as InnoDB are required.

1 views
Page 9 of 29 · 261 results