我现在刚学用PDO操作数据库,但是呢,在连接数据库后,用query()来执行select查询语句,但是总是报错:未选择数据库,代码及报错信息如下:
<?php
header("content-type:text/html;charset=utf-8");
$dsn = 'mysql:dbname =pdo;host=localhost';
$user = 'root';
$pass= '086437';
$dbh = new PDO($dsn,$user,$pass);
$dbh->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$sql = 'select * from pdo';
$pdos = $dbh->query($sql);
?>
报错为:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[3D000]: Invalid catalog name: 1046 No database sele