How remove duplicate value in PHP [duplicate]

Question

I have a some data stored in $cache[], there are some number in it. How do I remove duplicate values in a printed output? :

<?

#mysql connect
mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($name) or die(mysql_error());

function get_numerics ($str) {
    preg_match_all('/\d+/', $str, $matches);
    return $matches[0];
}


function validatecard($number) {
//preg_match_all('/^[6-9][0-9]{9}$/', $number, $found);
preg_match_all('/^[0-9]{4}$/',$number, $found);

//print_r($found);
return $found[0];

 }


$query = mysql_query("SELECT * FROM client WHERE status = 1 ORDER BY id") 
         or die(mysql_error());

while ($raw = mysql_fetch_array($query)) 

{

$name = $raw["postdata"];
$id = $raw["id"];
$cache = [];


  for($i=0;$i<=count(get_numerics($name));$i++){
    $ccv = get_numerics($name);
    $num = $ccv[$i];
    if (is_numeric($num)) {
    $cc = validatecard($num);
    if (!in_array($cc, $cache)){
        $cache[] = $cc;
}   
}
}



print_r($cache);

}

?>

i have use some function like :array unique and convert it to json or serialize... and not work.

array_unique(array_values($cache));

Dale
– Dale

2018-03-21 13:06:38 +00:00
Commented Mar 21, 2018 at 13:06 — Dale
– Dale, Commented Mar 21, 2018 at 13:06
I tried to apply it on my code is not working

Zimo
– Zimo

2018-03-21 13:44:07 +00:00
Commented Mar 21, 2018 at 13:44 — Zimo
– Zimo, Commented Mar 21, 2018 at 13:44

Lilian Barraud · Accepted Answer · 2018-03-21 13:05:27Z

4

Use the array_unique($array) function.

It removes duplicate values of an array.

Please check this for more information :

http://php.net/manual/en/function.array-unique.php

answered Mar 21, 2018 at 13:05

Lilian Barraud

3371 silver badge11 bronze badges

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

1 Comment

Zimo Over a year ago

not work for me in the following code

Gourgandine · Accepted Answer · 2018-03-21 13:09:00Z

1

If $cache is multidimensionnal then array_unique will not work. You may want to use :

$input = array_map("unserialize", array_unique(array_map("serialize", $input)));

See : How to remove duplicate values from a multi-dimensional array in PHP

answered Mar 21, 2018 at 13:09

Gourgandine

1996 bronze badges

1 Comment

Zimo Over a year ago

I tried to apply it on my code is not working

Raymond Nijland · Accepted Answer · 2018-03-21 13:11:04Z

0

Or let the database handle the removing the duplication with DISTINCT

SELECT 
  DISTINCT
     id 
   , postdata
FROM 
 client 
WHERE 
 status = 1 
ORDER BY
 id ASC

answered Mar 21, 2018 at 13:11

Raymond Nijland

11.6k2 gold badges26 silver badges37 bronze badges

3 Comments

Zimo Over a year ago

postdata columns content mixed data not only number value

Raymond Nijland Over a year ago

So? DISTINCT also works on mixed data not only on numbers

Zimo Over a year ago

postdata columns content for example : id 1 postdata : xxx 123 | id 2 postdata : hello 123 | id 3 postdata : hey 123 | id 4 postdata : xxx 000 | i need get only 2 row 123 and 000 whitout duplicate

Collectives™ on Stack Overflow

How remove duplicate value in PHP [duplicate]

3 Answers 3

1 Comment

1 Comment

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

3 Comments

Linked

Related