Simple gift to share it in the presentation about PDO and DB patterns

pdo.php

<?php

$connection = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);

$statement = $connection->prepare("INSERT INTO table (col1, col2, col3) VALUES (?, ?, ?)");

$statement->bindParam(1, "value1");
$statement->bindParam(2, "value2");
$statement->bindParam(3, "value3");

// OR
$statement->execute("value1", "value2", "value3");