<?php
$db_hostname = "localhost";
$db_database = "cms";
$db_username = "root";
$db_password = "";
$options = array(
      PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
      PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
  );
try {
    $pdo = new PDO('mysql:host=localhost;dbname=cms;charset=UTF8', $db_username, $db_password,$options);
  global $pdo;
  $stmt = $pdo->query('SELECT * FROM users');
  $data = $stmt->fetchAll();
 	echo "<pre>";
    print_r($data);
    echo "</pre>";
    echo "<table>";
foreach($data as $key=>$value)
{
 echo "<tr>";
 echo '<td>' . $value['name'] . '</td>';
 echo '<td>' . $value['lastname'] . '</td>';
 echo "</tr>";
}
	echo "</table>";

} catch (PDOException $e) {
    print "Ошибка!: " . $e->getMessage() . "<br/>";
    die();
}
?>