CODEWITHSUNDEEP
phpmysql
letsCode
letsCode

Reputation: 3044

Prevent Duplicate Entries in PHP MySQL

I have the following in my PHP.

$stmt = $conn->prepare("INSERT IGNORE INTO savesearch (user, searchedFor, sortOrder, buildURLString, aspectFilters, oneSignalId, totalEntries)
  VALUES (?, ?, ?, ?, ?, ?, ?)");
  $stmt->bind_param("sssssss", $user, $searchedFor, $sortOrder, $buildURLString, $aspectFilters, $oneSignalId, $totalEntries);

  // set parameters and execute
  $user = $_POST['user'];
  $searchedFor = $_POST["searchedFor"];
  $sortOrder = $_POST["sortOrder"];
  $buildURLString = $_POST["buildURLString"];
  $aspectFilters = $_POST["aspectFilters"];
  $oneSignalId = $_POST["oneSignalId"];
  $totalEntries = $_POST["totalEntries"];

  if ($stmt->execute()) {
    $output->success = true;
    echo json_encode($output);
  } else {
    $error->error = mysqli_error($conn);
    echo json_encode($error);
  }

However, IGNORE is not being picked up, it continues to add entries. Is there another good way to fix this?

Id like to see if the USER and the URL is the same, dont add, echo duplicate entry.

Upvotes: 0

Views: 379

Answers (1)

Martin
Martin

Reputation: 6697

IGNORE is actually mostly for the opposite of what you want here. Instead, you can amend your MySQL table something like:

ALTER TABLE savesearch ADD UNIQUE KEY(user, buildURLString)

Then remove your IGNORE keyword

Upvotes: 1

Related Questions