Problem:

I was setting up a database query using a PDOStatement, by looping through an array of values and binding each parameter seperately. But on executing the query, I got the following error:

Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: General error: 1452 Cannot add or update a child row: a foreign key constraint fails (`places/places`, CONSTRAINT `places_ibfk_3` FOREIGN KEY (`login_id`) REFERENCES `login` (`id`) ON DELETE CASCADE)’ in G:….

Solution:

Instead of seperately binding each parameter to a variable name with bindParam, as in the following code:

foreach ($columns as $col) {
    $stmt->bindParam(":$col", $value);
}

load all the bindings into an associative array, like this:

foreach ($columns as $col) {
    $bind[":$col"] = $value;
}

and pass the array to the execute function:

$result = $stmt->execute($bind);

You might also like :

• SQL Server (MSSQL) pre-connection setup in PHP
• Alter a foreign key in mySQL
• MySQL copy data from one database to another
• InnoDB fulltext search with ranking