那个,初来乍到,想问问有没有大佬帮忙瞅瞅这个,pdo代码看上去是正确的,但是没办法运行,有没有事那地帮忙指点一下,麻烦了!
<?php
$dbms='mysql';
$user='root';
$pwd='';
$dbName='san';
$host="localhost";
$dsn = "$dbms:host=$host;dbname=$dbName";
try {
$pdo= new PDO($dsn,$user,$pwd);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ATTR_ERRMODE_WARNING);
$query-"select*from tb_pdo_mysqls";
$result=$pdo->prepare($query);
$result->execute();
while ($res=$result->fetch(PDO::ATTR_FETCH_ASSOC)){
?>
<tr>
<td height="22" align="center" valign="middle"><?php echo $res['id'];?></td>
<td align="center" valign="middle"><?php echo $res["pdo_type"];?></td>
<td align="center" valign="middle"><?php echo $res["database_name"];?></td>
<td align="center" valign="middle"><?php echo $res["dates"];?></td>
</tr>
<?php
}
}catch (PDOException $e){
"Error!: " . $e->getMessage() . "<br/>";
die();
}
?>