Error with foreign key?

Question

PHP

I have an error

insert or update on table \"email\" violates foreign key constraint \"email_contact_id_fkey\"\nDETAIL:  Key (contact_id)=(166) is not present in table \"contact\"

There is no contact with id 166 in the contact table.
Is it possible to throw an exception in PHP instead of this error?

Answer 1

Well, catch it and process it as you like. Through try...catch.

Answer 2

In development of Lander's answer

<?php
function saveEmail($contactId, $email){
  global $pdo;
  try {
    $stmt = $pdo->prepare("
      INSERT INTO emails(contact_id, email) 
      VALUES (:contact_id, :email)");
    $stmt-> bindValue(':contact_id', $contactId);
    $stmt-> bindValue(':email', $email);
    return $stmt-> execute();
  } catch (PDOException $Exception ) {
    print_r($Exception);
    return false;
  }
}

saveEmail(166, '[email protected]');

Test PHP & SQL code online