#!/bin/bash

php <<EOF
<?php
\$servername = "mysql:host=localhost;dbname=mysql";
\$username = "foo";
\$password = "bar";

// Create connection
\$conn = new PDO(\$servername, \$username, \$password);

echo "Connected successfully\n";

\$query = \$conn->query("select count(*) from user where User=\"\$username\";");
if (\$query == false)
{
    var_dump(\$conn->errorInfo());
    exit();
}
var_dump(\$query->fetch());
?>
EOF