如何使用以下特定的准备和执行来显示PDO
的错误:
try
{
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $pdo->prepare("SELECT ZZZZZZ, nomepostazimiele FROM postazimiele");
$stmt->execute();
while ($row_postazimiele = $stmt->fetch(PDO::FETCH_ASSOC))
{
$idnomepostazi = $row_postazimiele['idpostazi'];
$nomepostazimiele = $row_postazimiele['nomepostazimiele'];
echo "<option value="$nomepostazimiele">$nomepostazimiele</option>";
}
}
catch (pdoException $e)
{
echo 'Attenzione: ' . $e->getMessage();
$output = "Impossibile collegarsi al Data Base, Utente o Password errati"
. "<br>" . "<br>" . "prego riprovare" . $e
. "<br>" . "<br>" . "<a href='miele.php'>Clicca QUI per ritornare alla pagina principale</a>";
include 'errore.html.php';
exit();
}
如果我在类似SELECT
的up中出错,则不会出现任何错误。为什么?
有人能帮我吗?
您需要获得execute的输出,您希望显示错误而不是异常。
if($stmt->execute()){
echo "Error: ".$stmt->errorInfo();
}