Hallo,
http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html
Error: 1022 SQLSTATE: 23000 (ER_DUP_KEY)
Message: Can't write; duplicate key in table '%s'
$stmt = $dbh->prepare("INSERT INTO fotos
(id, filename,timestamp,day,hour,minute)
VALUES
(:id, :filename, :timestamp, :day, :hour, :minute)");
$stmt->bindParam(':id', $id);
$stmt->bindParam(':filename', $filename);
$stmt->bindParam(':timestamp', $timestamp);
$stmt->bindParam(':day', $day);
$stmt->bindParam(':hour', $hour);
$stmt->bindParam(':minute', $minute);
$id = NULL;
$filename = "test9.jpg";
$timestamp = time();
$day = date("D",time());
$hour = date("H",time());
$minute = date("m",time());
$stmt_res = $stmt->execute();
echo "stmt_res exec\n";
var_dump($stmt_res);
if (!$stmt_res) {
var_dump($dbh->errorCode());
var_dump($stmt->errorCode());
}
}
bringt dann bei var_dump($stmt->errorCode) eben string(5) "23000"
Gruß
jobo