try{
$dsn = "mysql:host=127.0.0.1;dbname = test";
$username = "root";
$password = "";
$pdo = new PDO($dsn,$username,$password,array( PDO::ATTR_PERSISTENT => true,PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''));
echo "数据库连接成功!<br>";
}catch (PDOException $e){
die("数据库连接失败".$e->getMessage())."<br>" ;
}
try{
$sql = "select * from test.user"; //这行我这么写可以运行没问题
// $sql = "select * from user"; 但是这么写 query就会返回false 我在创建pdo实例的时候不是应该已经传入dbname了吗 为什么这里还要写出来
$stmt = $pdo->query($sql);
$list = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($list as $var){
echo $var['id'].'------'.$var['name'].'<br>';
}
exit;
}catch (PDOException $e){
echo $e->getMessage();
}
?>
问题见注释
$dsn = "mysql:host=127.0.0.1;dbname = test";
$username = "root";
$password = "";
$pdo = new PDO($dsn,$username,$password,array( PDO::ATTR_PERSISTENT => true,PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''));
echo "数据库连接成功!<br>";
}catch (PDOException $e){
die("数据库连接失败".$e->getMessage())."<br>" ;
}
try{
$sql = "select * from test.user"; //这行我这么写可以运行没问题
// $sql = "select * from user"; 但是这么写 query就会返回false 我在创建pdo实例的时候不是应该已经传入dbname了吗 为什么这里还要写出来
$stmt = $pdo->query($sql);
$list = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($list as $var){
echo $var['id'].'------'.$var['name'].'<br>';
}
exit;
}catch (PDOException $e){
echo $e->getMessage();
}
?>
问题见注释
