[Resolved] ARRAY Tricky Combining/replacing

stratguitar

Hi! I'm pretty sure this can be done, but after 48 hours of trying, I'm asking for suggestions... but think it better to explain the process, so no one asks me 'why are you doing this?" :😁:

I EITHER NEED TO DO THIS, OR get a new approach from someone:

I have one array with 81 values, with keys 1 thru 81 and values of individual names

I have a second array with x values input by user (but never as many as 81, always less.) and KEYS are some of the VALUES of the first array.

Like this
from query of mySQL

$array1: (sort by value)
KEY VALUE
1 Bertha
2 Fred
3 David
4 Joshua
5 Mary
6 Matt
7 Nathaniel
etc, etc.
81 Zach

Array2: (number of values (in this case, 3) and value itself is derived from user input, key is derived from a loop.)

KEY VALUE
Fred 350
Mary 220
Zach 15

Obviously, the KEY of the smaller second array is the VALUE of the larger first array.

IS THIS AN APPROACH?
I'm thinking the first step is to flip($array1) - I think - so that the keys are now the values, and the values the keys. That I know how to do..

THIS, I DO NOT
Any way, once that's done, that I can DUMP the values in that new, flipped array, and leave the KEY with blank values, so I can MERGE the 2?

The end result should be ALL 81 KEYS, with blank values EXCEPT for the KEYS that had values in array2 --- i.e. the new array should look like this

KEY VALUE
Bertha

Fred 350
David
Joshua
Mary 220
Matt
Nathaniel
etc, etc.
Zach 15

Please be reassured if you're thinking "Why does she need those blank fields?" Trust me, I do, so any other approach suggestions will be useless... :😁:

I'd be grateful for help from some of you crafty and clever array manipulators out there.... :😄:

Thanks
Strat

Anarchyh

This code will return all of the values of the first array, as keys in the output array and assigns the value from array2 with the matching key or "" if there is no matching key.

I think that is what you wanted ....

$array1[1] = "Bertha";
$array1[2] = "Fred";
$array1[3] = "David";
$array1[4] = "Joshua";
$array1[5] = "Mary";
$array1[6] = "Matt";
$array1[7] = "Nathaniel";

$array2['Fred'] = 350;
$array2['Mary'] = 220;
$array2['David'] = 15;

//here is the bit you want
foreach($array1 as $key=>$val)
    $outArray[$val] = (isset($array2[$val])) ? ($array2[$val]) : ("");
//end

print_r($outArray);

this outputs

Array
(
    [Bertha] =>
    [Fred] => 350
    [David] => 15
    [Joshua] =>
    [Mary] => 220
    [Matt] =>
    [Nathaniel] => 
)

stratguitar

Thanks so much! Works perfectly!

I hate to push, when I've been so fortunate as to receive a reply that works well, and that reply is so timely, but....

Could you please also explain what's happening here, so I understand it rather than just use the code?

I understand the foreach loop settings and the variables for the key and value, but after that...

$outArray[$val] = (isset($array2[$val])) ? ($array2[$val]) : ("");

$outArray is the new array, right?
isset is checking for array2? is that necessary, if I've already accepted the $_POST and set a variable name? because I have, at the top of the script. (And it DOES exist, and is set with proper values.)

i.e.

if (isset($_POST['array2'] {
$array2=$_POST['array2'];

After that, I have no idea what your code is saying in English. :😄:

I'm being greedy, I know ::smile again::, but understanding new concepts is the $key=>$val to my increased capabilities in PHP. LOL

Thanks so much, again!!!

Strat

Anarchyh

$outArray[$val] = (isset($array2[$val])) ? ($array2[$val]) : ("");

Yes, $outArray is the new array.
Yes this is necessary because its actually checking to see if the value from array1 exists as a key in array2.
I should probably explain that the line of code that you arent sure about is actually very similar to an if else structure. I cant remember the name of it but i think its some thing like a tertiary statement or something stupid alike.

The above line could be equally written as

if(isset($array2[$val]))
{
    $outArray[$val] = $array2[$val];
}
else
{
    $outArray[$val] = "";
}

The basic syntax of the statement is :
(conditional) ? (return this if true) : (return this if false)

Hope this clears it up for you 🙂

stratguitar

Thanks for explaining! I actually now find I have one more issue - because there's a fairly complicated loop that follows, which depends on the KEY from carrier_name rather than the value.

So, once the new array has been declared by comparing the fname value to the key of the second(small) array - the outArray NOW really needs to have the KEYS from the original array1 that coincided with the original keys from array1.

i.e.
$array1: (sort by value)
KEY VALUE
1 Bertha
2 Fred
3 David
4 Joshua
5 Mary
6 Matt
7 Nathaniel
etc, etc.
81 Zach

original array2
KEY VALUE
Fred 350
Mary 220
Zach 15

Your resulting outArray
[Bertha] =>
[Fred] => 350
[David] => 15
[Joshua] =>
[Mary] => 220
[Matt] =>
[Nathaniel] =>

now, what I need is the final result, i.e.

[1] =>
[2] => 350
[3] => 15
[4] =>
[5] =>220
[6] =>
[7] =>

and the KEYS from the final array need to be the EXACT correlation from array 1 (i.e. Fred's 350 needs to match to Fred's original array key 2, and so forth.)

Am I asking too much??? I tried array_combine, but it fatal'ed on me

reset(array1);
$userval=array_combine($array1, $outArray)

so, could I achieve that by saying the following? (I'm at another location, so cannot try this at the moment, but am guessing it will work:

if(isset($array2[$val]))
{
$outArray[$key]=$array1[$key];
$outArray[$val] = $array2[$val];
}
else
{
$outArray[$key]=$array1[$key];
$outArray[$val] = "";
}

(or the shorthand equivalent per your above code?)

Thanks, for the third time...

Strat

Anarchyh

Pretty much yeah except you may want to split the arrays and output two arrays instead of having all of the data in one array.
However, if you need the two in the same array simply change the "$outArray1" to "$outArray"

Modified sample to do what i think you want it to...

$array1[1] = "Bertha";
$array1[2] = "Fred";
$array1[3] = "David";
$array1[4] = "Joshua";
$array1[5] = "Mary";
$array1[6] = "Matt";
$array1[7] = "Nathaniel";

$array2['Fred'] = 350;
$array2['Mary'] = 220;
$array2['David'] = 15;

//here is the bit you want
foreach($array1 as $key=>$val)
{
    $outArray[$val] = (isset($array2[$val])) ? ($array2[$val]) : ("");
    $outArray1[$key] = (isset($array2[$val])) ? ($array2[$val]) : ("");
}
//end
print_r($outArray);
echo "\n\n";
print_r($outArray1);

This now outputs :

Array
(
    [Bertha] =>
    [Fred] => 350
    [David] => 15
    [Joshua] =>
    [Mary] => 220
    [Matt] =>
    [Nathaniel] => 
)


Array
(
    [1] => 
    [2] => 350
    [3] => 15
    [4] => 
    [5] => 220
    [6] =>
    [7] =>
)

Happy to help and good luck with whatever masterful little app you are making 🙂

stratguitar

hoo, HAH! 😃

Works like a charm! (I actually only needed the final array with numeric keys and the values or "".)

Stunning responses, Anarchyh!!!

Gratefully -
Strat