PHP Array Unique on exploded Keywords from MySQL problem

Question

I'm trying to echo keywords from a MySQL database, separated by colon, and remove (don't show) duplicates.

This is what I got.

Keywords in DB

Love:Sorrow:Death
Happiness:Love:Excitement
Excitement:Speed:Love

PHP

<?php
$myKeyArr = array();
while($rowKeyword = mysqli_fetch_array($sqlKeyword)){
  $myKeywords = explode(':', $rowKeyword['keywords']);
  $myKeyArr[] = $myKeywords;
}

foreach ($myKeyArr as $value) {
  $kw = array_unique($value);
  echo $kw['0'] . "<br>";
}
?>

I just want to echo the following

Love
Sorrow
Death
Happiness
Excitement
Speed

This is what's shown

Love
Sorrow
Death
Happiness
Love
Excitement
Excitement
Speed
Love

Muhammad Zahoor · Accepted Answer · 2021-12-14 11:19:15Z

0

update your code by following code.

    <?php
$referenceArray = array();
$myKeyArr = array();
while($rowKeyword = mysqli_fetch_array($sqlKeyword)){
  $myKeywords = explode(':', $rowKeyword['keywords']);
  $myKeyArr[] = $myKeywords;
}

foreach ($myKeyArr as $value) {
  $kw = array_unique($value);

/*
* checking refernceArray value..
* if vlaue find return empty otherwise it pusy value in array and print desire value
 */

  if (in_array($kw['0'], $referenceArray)){ 
  }
  else{
      array_push($referenceArray,$kw['0']);
      echo $kw['0'] . "<br>";
   }
}

?>

I hope it work perfectly.

answered Dec 14, 2021 at 11:19

Muhammad Zahoor

9010 bronze badges

That didn't work. Still showing duplicates. Maybe the keywords needs to be pushed into the array one by one, i some way? I'm not sure exploding them, in the db while loop, is the correct way?

Aknot
– Aknot

2021-12-14 14:57:47 +00:00
Commented Dec 14, 2021 at 14:57

Add a comment |

Stack Exchange Network

PHP Array Unique on exploded Keywords from MySQL problem

1 Answer 1

Your Answer

Hot Network Questions

PHP Array Unique on exploded Keywords from MySQL problem

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions