PDO：数据库中有数据但是查询不出数据

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

$dbms = "mysql";
$dbName = "test";
$user = "root";
$pwd = "111111111";
$host = "127.0.0.1";
$dsn = "$dbms:host=$host;dbName=$dbName";
try {	
	$pdo = new PDO($dsn, $user, $pwd);
	$query = "SELECT * FROM login";
	echo "链接！<br/>";

	$res = $pdo ->prepare($query);
 
	$res ->execute();


	$view  = "<table border = \"1\" width =\"500\">";
	$view .= '
	 <tr>

            <td height="22" align="center" valign="middle">id</td>

            <td height="22" align="center" valign="middle">用户名</td>

            <td height="22" align="center" valign="middle">密码</td>

        </tr>
	';
	$result = $res -> fetchAll(PDO::FETCH_ASSOC);
    var_dump($result);
	foreach ($result as $key => $value) {

		$view .= '<tr>';
		$view .= '<td height="22" align="center" valign="middle">'. $value['id'] . '</td>';
		$view .= '</tr>';
	}
	$view .="</table>";
	echo $view;
} catch(Exception $e) {
	echo $e -> getMessage().'<br/>';
}

原代码中有一处代码写错导致查询不出数据，但是执行的时候也没有任何报错，所以有点迷茫，后面仔细检查后发现『dbName』应该是小写的，故解决方法是：

//$dsn = "$dbms:host=$host;dbName=$dbName"; 

//修改成下列

$dsn = "$dbms:host=$host;dbname=$dbName";