A complete guide to MySQL in PHP — PDO and MySQLi connections, prepared statements to prevent SQL injection, fetch modes, transactions, connection pooling, basic query builder patterns, schema migrations, query optimization with EXPLAIN, and testable repository patterns.
A complete guide to Microsoft SQL Server in PHP — the PDO_SQLSRV and SQLSRV drivers, connecting with Windows Authentication and SQL Server Authentication, prepared statements, fetch modes, transactions, MSSQL-specific data types, stored procedures, and deployment patterns on Linux.
A complete guide to Oracle Database in PHP — the OCI8 and PDO_OCI drivers, connecting with TNS and Easy Connect, prepared statements, bind variables, cursors, PL/SQL blocks, stored procedures and functions, LOB handling, sequences, and efficient Oracle usage patterns.
A complete guide to PostgreSQL in PHP — the PDO_PGSQL driver and pg_* functions, connections and connection strings, prepared statements, PostgreSQL's rich data types (JSONB, Arrays, UUID, ENUM), transactions with savepoints, LISTEN/NOTIFY, COPY for bulk inserts, and repository patterns.