Comparing 2 arrays and display same part of the same values

lipton_tea

Hi guys,
I wanted to ask you to help me with (I believe it will be) short code where I need to compare 2 existing arrays I'm filling from the CSV files.

let's imagine 2 arrays:
$a = array('name|john', 'street|new street', 'city|washington', 'country|usa')
$b = array('new street', 'usa')

As you can see $b contains some of the values that are present in $a.

So now I would say I should use something like in_array or maybe foreach to compare $b with $a and the expected result is to get all the values from $a that are also in $b, but only the part in from of "|".

So the expected output based on the info above should be:
street
country

Hope this make sense.

Thanks a lot for your help
LT

Bonesnap

lipton_tea;11020781 wrote:
let's imagine 2 arrays:
$a = array('name|john', 'street|new street', 'city|washington', 'country|usa')
$b = array('new street', 'usa')

As you can see $b contains some of the values that are present in $a.

$b actually contains no values that are present in $a. For example, 'usa' != 'country|usa'.

How are you importing these CSV files? I think there's a fundamental error here. CSV files have fixed columns; you shouldn't need to import the columns when you import your data. For example the CSV file might have name as the first column, street as the second, and so on. Then as the import is going on, you know that the second value is always the street value. If not then there's a problem with the CSV file because it doesn't match the expected input.

Anyway, assuming $a didn't have the column names, then you should take a look into the function [man]array_intersect[/man].

lipton_tea

Hi Bonesnap, thanks for your reply.
here is the way how I filling arrays with the values in my script:

$arr1 = split("\n", file_get_contents('existing_fields.csv'));
$arr2 = split("\n", file_get_contents('new_ones.csv'));

So $a = $arr1 and $b = $aar2

And I understand that: 'usa' != 'country|usa' but for me the word 'usa' is part of the row in the file so I think I need to somehow search between $a and $b for matches.

Also the structure of the existing_fields.csv file is:
name|john
street|new street
city|washington
country|usa

And the structure of the new_ones.csv file is:
new street
usa

Thanks
LT

Derokorian

You could start by remapping $a to be a key value pair in the array instead of in the string, then use a foreach loop to go through that array and spit out the keys whose values are in array $b. Simple example:

$a = array('name|john', 'street|new street', 'city|washington', 'country|usa');
$b = array('new street', 'usa');

$newa = array();
foreach( $a as $val ) {
   $val = explode('|',$val);
   $newa[$val[0]] = $val[1];
}

foreach( $newa as $k => $v ) {
   if( in_array($v, $b) ) {
      echo "$k found!<br>";
   }
}

Weedpacket

lipton_tea wrote:
Hi Bonesnap, thanks for your reply.
here is the way how I filling arrays with the values in my script:

$arr1 = split("\n", file_get_contents('existing_fields.csv'));
$arr2 = split("\n", file_get_contents('new_ones.csv'));

Have a look at using [man]fgetcsv[/man], which is designed for getting the contents of CSV files.

(PS: while I'm quoting your use of it, see the deprecation Warning and Notes regarding [man]split[/man].)

Bonesnap

lipton_tea;11020791 wrote:
Also the structure of the existing_fields.csv file is:
name|john
street|new street
city|washington
country|usa

And the structure of the new_ones.csv file is:
new street
usa

Thanks
LT

I think this is the issue here. CSV files are essentially a database; they are a table with fixed columns and multiple rows of data. Each row is a single entry. Every row is the same in terms of what data to expect. For example, the second column in each row will always be the street value, or whatever the structure may be.

From what I am interpreting, it appears your CSV file is a single column with multiple rows that are all actually part of the same entry. That's not how CSV files are supposed to be structured.

lipton_tea

Hi Bonesnap,
actually you helpep me with my problem. I have chosen differen approach how to load the file into array and now it works as I expected. Still need some help with the other stuff, but I will open separate post for it.

Thanks much!
LT

Bonesnap

lipton_tea;11020907 wrote:
Hi Bonesnap,
actually you helpep me with my problem. I have chosen differen approach how to load the file into array and now it works as I expected. Still need some help with the other stuff, but I will open separate post for it.

Thanks much!
LT

If you're still looking for help on finding the same values in both arrays, see my first reply in this thread.