Insert data only if record does not exist

Question

I want to insert data in a table only if the record with a given CatalogID does not exist.

 $userId = $_POST['userId'];
 $catalogID = $_POST['catalogID'];
 $content_AddedTime = $_POST['content_AddedTime'];

 $query = ("INSERT INTO LibraryMaster (UserID,CatalogID,ContentAddedDateTime)
      VALUES ('$userId','$catalogID','$content_AddedTime')");
 mysql_query($query,$con);
 printf("Records inserted: %d\n", mysql_affected_rows());
 echo($user_Name)

Ignacio Vazquez-Abrams · Accepted Answer · 2013-06-18 07:39:05Z

2

Create a UNIQUE index on CatalogID.

answered Jun 18, 2013 at 7:39

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

4 Comments

Jaw Ali Over a year ago

in table structuer i may create but i want that if this is already then it should return me YES. also so

Ignacio Vazquez-Abrams Over a year ago

Then check for failure of the INSERT query.

Jaw Ali Over a year ago

how to check this can you please help me out in this

Dave Chen Over a year ago

+1, hits the database once, you can check for errors via mysql_error I would recommend using PDO or MySQLi.

geeksal · Accepted Answer · 2015-05-11 15:22:01Z

0

$query="INSERT INTO LibraryMaster (UserID,CatalogID,ContentAddedDateTime)
SELECT * FROM (SELECT '".$userId."', '".$catalogID."', '".$content_AddedTime."') AS tmp
WHERE NOT EXISTS (
  SELECT CatalogID FROM LibraryMaster WHERE CatalogID = '".$catalogID."t'
 ) LIMIT 1";

answered May 11, 2015 at 15:22

geeksal

5,0163 gold badges27 silver badges49 bronze badges

Comments

Desire · Accepted Answer · 2013-06-18 07:49:58Z

-1

You could use this sort of function

public function Checkrecord($catalogID )
    {
        $query="Select * from table_name where catalog_id=$catalogID ";
                  mysql_query($query,$con);
        if(mysql_num_rows($query)>0)
        {
            //report error
        }
        else
        {
            //insertQuery
        }
    }

edited Jun 18, 2013 at 7:49

answered Jun 18, 2013 at 7:48

Desire

12 bronze badges

Collectives™ on Stack Overflow

Insert data only if record does not exist

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related