Тестовое подключение к MySQL из PHP

<?php
header('Content-Type: text/html; charset=utf-8');
$mysqli = new mysqli(
    'specialistoff.net',
    'specialistoff_user',
    'AhKeebaemai0eMe',
    'specialistoff_db'
);

if ($mysqli->connect_error) {
    die('Error connection (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
}
echo '<p>The connection is established... ' . $mysqli->host_info . "</p>";
$result = $mysqli->query("SHOW TABLES;");
while ($row = $result->fetch_row()) {
    echo "<p>Table: {$row[0]}</p>";
}
echo 'MYSQL version: ' . $mysqli->server_info . "\n";
$mysqli->close();
?>

<?php
header('Content-Type: text/html; charset=utf-8');

$host = "specialistoff.net";
$db = "specialistoff_db";
$user = "specialistoff_user";
$upas = "AhKeebaemai0eMe";
$dsn = "mysql:host=".$host.";dbname=".$db.";charset=utf8";

$testString = "SpecialistOff.NET";

$opt = array(
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
);

$pdo = new PDO($dsn, $user, $upas, $opt);

$pdo->query('CREATE TABLE foo (col1 VARCHAR(50));');

$pdo->query('INSERT INTO foo (col1) VALUES("'.$testString.'");');

$result = $pdo->query('SELECT * from foo;');

foreach ($result as $row) {
    echo '<p>Строка из базы данных: '.$row['col1'].'</p>';
}

$pdo->query('DROP TABLE foo;');
?>