check mysql db before inserting values using pdo in php

Question

$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO cinema (name, genre, year, oscar, watched) VALUES(?,?,?,?,?)";
$q = $pdo->prepare($sql);
$q->execute(array($name, $genre, $year, $oscar, $seen));
Database::disconnect();

"check mysql db before inserting values using pdo in php" - Query before to see if it exists. Oh, and check FOR what?. — Funk Forty Niner
– Funk Forty Niner, Commented Mar 15, 2015 at 16:22
@Rizier123 Mhm .. I am quite certain the table is badly configured (eg missing UNQIUE constraints), but the question is, what should happen after the table is queried before the INSERT. Either give an error (so the first query is useless anyway) or do an UPDATE (which has been asked&answered a ton of times as well) — kero
– kero, Commented Mar 15, 2015 at 16:23

Peter Bowers · Accepted Answer · 2015-03-15 16:31:50Z

0

Just do another query before you do the INSERT:

SELECT COUNT(*) as c FROM cinema WHERE name = ? and year = ?

Do the usual prepare/bind/fetch stuff and if ($row['c'] > 0) then you output your error message - otherwise you continue to your INSERT.

answered Mar 15, 2015 at 16:31

Peter Bowers

3,1031 gold badge13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

joe_black Over a year ago

can you plz share the prepare/bind/fetch stuff

Collectives™ on Stack Overflow

check mysql db before inserting values using pdo in php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related