SQL - Handing errors in PHP (Duplicate Entry)

Question

   <input type="text" name="CODE" size="25" placeholder="Insert code..." />

   <input type="text" name="NAME" size="25" placeholder="Insert name..." />

  if(isset($_POST['CODE'], $_POST['NAME'])){

         $querystring='INSERT INTO Company (Name, Code) VALUES(:Name,:Code);';

         $stmt = $pdo->prepare($querystring);
         $stmt->bindParam(':Name', $_POST['NAME']);
         $stmt->bindParam(':Code', $_POST['Code']);
         $stmt->execute();

}

Hey!

The problem I'm having is displaying SQL Errors in a nicer way in PHP. Let's say I insert a Company with Code '123' and Name 'ABC'. And then after insert a Company with Code '123' I will obviously get an error that there is a duplicate entry of that Code.

The error that I'm getting is

Warning: PDOStatement::execute(): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

I wan't to simply be able to replace this error or warning with a message telling the user that the code he's trying to insert already exists.

Hope I manage to explain, Thanks!

Faizan Khan · Accepted Answer · 2013-10-03 12:14:46Z

1

try to handle tour query like this hope it will work for you

try{
    $pdo->query("INSERT INTO `table`(`name`,`value`)`VALUES('name','value')");
}
catch (PDOException $e) {
    if($e->errorInfo[0] == '23000' && $e->errorInfo[1] == '1062'){
        throw new CustomException("Bla bla already exists");
    } 
    else {
    throw $e;
    }
}

answered Oct 3, 2013 at 12:14

Faizan Khan

6286 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

SQL - Handing errors in PHP (Duplicate Entry)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related