<?php
error_reporting(-1);

$tmp = "";
if (isset($_GET['tmp'])) {
  $tmp="/tmp/";
}

$dsn = "sqlite:{$tmp}pdo.sqlite";
unlink("{$tmp}pdo.sqlite");

echo "<pre>Creating database $dsn\n";
try {
  $db = new PDO($dsn);
  $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
  echo "Failed to connect to the database using DSN:<br>$dsn<br>";
  throw $e;
}
echo "Setting timeout\n";
var_dump($db->setAttribute(PDO::ATTR_TIMEOUT, 10));


#echo "timeout\n";
#echo $db->getAttribute(PDO::ATTR_TIMEOUT);

echo "Creating table\n";
$sql = "create table a (a int);";

echo " preparing\n";
$stmt = $db->prepare($sql);

echo " executin\n";
$stmt->execute();

$sql = "select * from a;";

echo "Selecting from database\n";
echo " preparing\n";
$stmt = $db->prepare($sql);

echo " executing\n";
$stmt->execute();