PHP Intermediate Database

PDO ERRMODE_EXCEPTION

Why set PDO error mode to exceptions?

Fail loudly in try/catch.

<?php
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
try {
  $pdo->query('SELECT * FROM missing_table');
} catch (PDOException $e) {
  echo 'DB error';
}

Notes

Avoid silent failures during development.

Keywords: pdo · exception · errmode · debug

PHP

Embed PHP inside HTML

How do I mix PHP and HTML?

SQL

CREATE DATABASE

How do I create a MySQL database?

PHP

PHP comments

How do I write comments in PHP?

SQL

ALTER TABLE add column

How do I add a column to an existing table?

PHP

PHP variable rules

What are the rules for PHP variables?

SQL

Foreign key relationship

How do I relate posts to users?