demo.php

<?php

function demo(\PDO $pdo): void
{
    // ---------- result-set type inference ----------
    $stmt = $pdo->query('SELECT email, adaid FROM ada', PDO::FETCH_ASSOC);

    foreach ($stmt as $row) {
        parse_str($row['adaid'], $x);
        if ($row['email'] + 25) {
            $x = $row['doesnotexit'];
        }
    }

    // ---------- query plan analysis ----------

    $pdo->query("SELECT * FROM `ada` WHERE email = 'test@example.com';");

    // ---------- in-depth query analysis ----------

	$pdo->query('SELECT * FROM unknownTable', PDO::FETCH_ASSOC);

	$pdo->query('SELECT email adaid WHERE gesperrt freigabe1u1 FROM ada', PDO::FETCH_ASSOC);

	$pdo->query('SELECT doesNotExist, adaid, gesperrt, freigabe1u1 FROM ada', PDO::FETCH_ASSOC);

	$stmt = $pdo->prepare('SELECT email, adaid FROM ada WHERE adaid = :adaid');
	$stmt->execute([':wrongParamName' => 1]);

	$stmt = $pdo->prepare('SELECT email, adaid FROM ada WHERE adaid = :adaid');
	$stmt->execute();

	$stmt = $pdo->prepare('SELECT email, adaid FROM ada WHERE adaid = ? and email = ?');
	$stmt->execute([1]);

	$stmt = $pdo->prepare('SELECT email, adaid FROM ada WHERE adaid = :adaid and email = :email');
	$stmt->execute(['adaid' => 1]);

	$stmt = $pdo->prepare('SELECT email, adaid FROM ada WHERE adaid = :adaid and email = :email');
	$stmt->execute([':email' => 'email@example.org']);
}