jobo: PDO - wie herausbekommen, dass uniquer Datensatz doppelt

Beitrag lesen

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