How do I make an array with a key/value array?

Question

I am optimizing some code. Some code I can change, some I can't. I am querying the database and checking it against a json_decode() array that is the new data. I find the differences and add or delete from the database as needed.

UPDATE: This is my query:

$sQuery = "SELECT column1, column2 FROM my_table WHERE id=my_id;

UPDATE2:

OK, so my query goes into a custom query function that I cannot change and this is what comes out:

    mysqli_result Object
    (
        [current_field] => 0
        [field_count] => 2
        [lengths] => 
        [num_rows] => 2
        [type] => 0
    )

I want to parse the result in such a way that is organized like this:

Array 
(
    [0] => Array
           (
               [column1] => value
           )
    [1] => Array
           (
               [column2] => value
           )
)

// end Update 2

I'm banging my head feeling stupid trying to parse the first array to match the organization of the second array. Help please?

Here is what I've tried:

while ($aRows = $aResults->fetch_assoc()) {
    foreach ($aRows as $iKey => $sValue) {

        if ($iKey % 2 == 0)
            $aPreviousList[$iKey][] = $sValue;

        if ($iKey % 2 == 1)
            $aPreviousList[$iKey][] = $sValue;
    }
}

But it comes out like this:

Array
(
    [ixfChangeMethod] => Array
        (
            [0] => 16
            [1] => 11
        )

    [sDetails] => Array
        (
            [0] => some details about 16
            [1] => some details about 11
        )

)

Am I going about this all wrong or is there another way I can parse both arrays that I can check the differences better?

fetch_assoc() should return a row where each member of the array is the name of the column... what does your query look like? — brazilianldsjaguar
– brazilianldsjaguar, Commented Jan 23, 2015 at 20:53
If you know you'll always have an even number of rows returned, you can just get a second row inside your loop; the first row will contain your key and the second your value. — jeroen
– jeroen, Commented Jan 23, 2015 at 20:54
How is that possible? Then you'll end up with a key without a value at the end. — jeroen
– jeroen, Commented Jan 23, 2015 at 20:58

Bart Haalstra · Accepted Answer · 2015-01-23 21:26:31Z

6

I've changed the code, is this better?

while ($aRow = $aResults->fetch_row()) {
    $aPreviousList[] = array($aRow[0] => $aRow[1]);
}

edited Jan 23, 2015 at 21:26

answered Jan 23, 2015 at 20:53

Bart Haalstra

1,0626 silver badges11 bronze badges

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

3 Comments

Maggie S. Over a year ago

I double checked to make sure I changed all the variables to the correct variables in my code, but this returned an empty array. :-/

Maggie S. Over a year ago

This just makes an array with an array containing only the 'details' column.

Array (     [0] => Array         (             [16] => some details         )      [1] => Array         (             [11] => asdfasdfasdasd         )  )

Bart Haalstra Over a year ago

Ok, i've rolled back my last change

Siguza · Accepted Answer · 2015-01-23 20:55:30Z

1

fetch_assoc returns an associative array.
fetch_row returns a numeric array.

So just use fetch_row instead of fetch_assoc.

answered Jan 23, 2015 at 20:55

Siguza

24.7k6 gold badges58 silver badges105 bronze badges

Comments

Shaiful Islam · Accepted Answer · 2015-01-23 21:27:34Z

1

You can try this

while ($aRows = $aResults->fetch_assoc()) 
{
    $aPreviousList[]=array($aRows['column1']=>$aRows['column2']);
}

print_r($aPreviousList);

edited Jan 23, 2015 at 21:27

answered Jan 23, 2015 at 21:08

Shaiful Islam

7,12612 gold badges41 silver badges59 bronze badges

Collectives™ on Stack Overflow

How do I make an array with a key/value array?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related