Check for value before inserting

Asked Nov 18 '16 at 15:06

Active Nov 18 '16 at 15:06

Viewed 22 times

I'm trying to figure out how to check for a value before inserting into the table my code currently looks like this:

try {
     $stmt = $dbh->prepare("INSERT INTO test (firstname, lastname, email) VALUES (:firstname, :lastname, :email)");
     $stmt->bindValue(':firstname', $first_name, PDO::PARAM_STR);
     $stmt->bindValue(':lastname', $last_name, PDO::PARAM_STR);
     $stmt->bindValue(':email', $email_address, PDO::PARAM_STR);
     $stmt->execute();
        echo 'New record created successfully';
     } catch (PDOException $e) {
            echo $smtp . "<br/> " . $e->getMessage();
        }

asked Nov 18 '16 at 15:06

Kenny

You check by testing. Which variable did you want to test? – Jay Blanchard Nov 18 '16 at 15:09
1

What exactly do you mean by *check for a value*? – Manikiran Nov 18 '16 at 15:09
Perform a SELECT query and check num_rows to verify. – Manikiran Nov 18 '16 at 15:10
I want to test firstname to make sure it doesn't exist in the database before inserting – Kenny Nov 18 '16 at 15:11
Btw, there could be *n* users with same first and last name. All you need to worry about is the email address here. – Manikiran Nov 18 '16 at 15:12
And the simplest way out, is to make it UNIQUE in database structure. – Manikiran Nov 18 '16 at 15:12
That's a very good point I didn't' think of that actually – Kenny Nov 18 '16 at 15:13

Check for value before inserting

0 Answers0