Doesn't insert if row exists

Question

I do an insert to database using this and this example, but I've got an error message: Call to a member function execute() on a non-object. If I do INSERT INTO participants(email) VALUES ('$email') evrething is OK. Where is my mistake?

$pdo = new PDO('sqlite:participants.db');
$insert = $pdo->prepare("INSERT INTO participants(email) SELECT $email WHERE NOT EXISTS(SELECT 1 FROM participants WHERE email = $email);");
$insert->execute();

UPD:

This is what var_dump($insert) gives:

object(PDOStatement)#2 (1) {
  ["queryString"]=>
  string(65) "INSERT INTO participants (email) VALUES ('paekov@gmail.com')"
}

You could use sqlite feature `INSERT OR IGNORE INTO participants(email) VALUES ('$email');` — sectus, Feb 08 '15 at 10:19
possible duplicate of [Reference - What does this error mean in PHP?](http://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php) — sectus, Feb 08 '15 at 10:22

score 1 · Accepted Answer · answered Feb 08 '15 at 10:42

Looks like your query needs some modification.

$pdo = new PDO('sqlite:participants.db');
$insert = $pdo->prepare("INSERT INTO participants(email) SELECT :email WHERE NOT EXISTS(SELECT 1 FROM participants WHERE email = :email)");
$insert->execute(array(':email' => $email));

Doesn't insert if row exists

1 Answers1