Create an associative array using values fetched from method calls while looping

Question

I'm trying to generate an array that will look like this:

Array ( [123 Smith St, Begora] => L1234 [55 Crumble Road, Mosmana] => L2456 [99 Jones Ave, Gestana] => L3456 )

which will ultimately be used for a select menu on an html form.

I'm retrieving a list of records and propertyID numbers from a database as follows:

foreach($records as $record) {
    $propertyID = $record->getField('propertyID');
    $property = $record->getField('propertyAddress');  
        
    echo $propertyID.'<br>'; 
    echo $property.'<br>';              
}

which displays like this when I retrieve 3 records:

L1234 123 Smith St, Begora L2456 55 Crumble Road, Mosmana L3456 99 Jones Ave, Gestana

I just can't work out how to convert this into an Array which I can then use later on in my page for generating a select menu.

It is generally considered bad practice to have spaces etc in key names. Especially as you could start getting addresses with apostrophes etc in them — Anigel
– Anigel, Commented May 15, 2013 at 16:19
Hi - not sure what you're referring to here by "spaces in key names"? Can you clarify - thanks. — user982124
– user982124, Commented May 15, 2013 at 16:23
In the example you gave above you would have an array with the key name [123 Smith St, Begora] it would be much better for this to be the value rather than the key where an array is made up of array("key"=>"value") — Anigel
– Anigel, Commented May 15, 2013 at 16:25

fullybaked · Accepted Answer · 2013-05-15 16:16:31Z

2

Just do

foreach($records as $record) {
    $propertyID = $record->getField('propertyID');
    $property = $record->getField('propertyAddress');  

    $addresses[$property] = $propertyID;
}

answered May 15, 2013 at 16:16

fullybaked

4,1271 gold badge26 silver badges37 bronze badges

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

3 Comments

aynber Over a year ago

I'd probably use $propertyID for the array index, since it's shorter and easier to sort.

Anigel Over a year ago

It is also less likely to include non alpha chars

fullybaked Over a year ago

aynber and Anigel yeah i would too, but I was trying to produce output to match OP's requirements in the question :)

evuez · Accepted Answer · 2013-05-15 16:18:15Z

1

Something like this:

$array = array();
foreach($records as $record) {
        $array[$record->getField('propertyAddress')] = $record->getField('propertyID');            
}

answered May 15, 2013 at 16:18

evuez

3,4074 gold badges31 silver badges46 bronze badges

Collectives™ on Stack Overflow

Create an associative array using values fetched from method calls while looping

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related