Solved

check for duplicate value in input

Posted on 2011-09-18
2
304 Views
Last Modified: 2012-05-12
I have code that checks mysql for duplicate entries in a database and issues error through ajax. That works fine. My problem is that I have no way for checking duplicate entries in the form when the form is sent to php for processing. The inputs are created by a jquery change on a slider so there could many inputs created by the user from which they create unique codes. What I am trying to do is check that if a user enters the same number in the form then issue an error. Am I better doing this before it reaches php using jquery?  I hope someone can help with this. Thanks

$duplicates = array();

foreach ($boxnumber as $val)
{
if ( $val != "" )
 {
  mysql_select_db($database_logistor, $logistor);
  $sql = "SELECT custref FROM boxes WHERE custref='$val' and status = 'In'";
  $qry = mysql_query($sql) or die(mysql_error());

  if(mysql_num_rows($qry) < 1)
  {
  $duplicates[] = '[ '.$val.' ]';
  $flag=1;
  }
  
 }
}

Open in new window

0
Comment
Question by:peter_coop
2 Comments
 
LVL 10

Accepted Solution

by:
acbxyz earned 250 total points
Comment Utility
If you want to do this in PHP you can use array_unique()
$uniqueboxes = array_unique($boxnumber);
if (count($uniqueboxes) != count($boxnumber)) {
  // there are duplicate boxes typed in
  // if you want to know which:
  $dupinputs = array();
  foreach (array_count_values($boxnumber) as $box => $count) {
    if ($count > 1) {
      $dupinputs[] = $box;
    }
  }
  // since array_diff() ignores duplicate values on input array this doesn't work
  // $dupinputs = array_diff($boxnumber, $uniqueboxes);
}

Open in new window

0
 

Author Closing Comment

by:peter_coop
Comment Utility
perfect. thank you
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now