Store array in while loop to use outside

Question

I would like to store value from while loop but not in multidimensional way :

 $movies_id = array();

 while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                $id = $row['id'];
                $title_id = $row['title_id'];
                    $movies_id[] = [$id => $title_id];
     }

print_r($movies_id);

I am not getting the way, how to do it, if i just write $movies_id = [$id => $title_id]; it only shows the last value.

Thank you by advance.

$movies_id[] will add a element to array, it doesn't work?

Marco Mura
– Marco Mura

2014-11-26 08:26:11 +00:00
Commented Nov 26, 2014 at 8:26 — Marco Mura
– Marco Mura, Commented Nov 26, 2014 at 8:26
which version of php are you using??

Manish Jangir
– Manish Jangir

2014-11-26 08:29:36 +00:00
Commented Nov 26, 2014 at 8:29 — Manish Jangir
– Manish Jangir, Commented Nov 26, 2014 at 8:29

Grzegorz · Accepted Answer · 2014-11-26 08:28:14Z

8

You need to set value properly.

            $movies_id = array();

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                $id = $row['id'];
                $title_id = $row['title_id'];
                    $movies_id[$id] = $title_id; // The proper way
                    //$movies_id[] = [$id => $title_id];
            }

            print_r($movies_id);

The more readable code would be:

            $movies_id = array();

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                    $movies_id[$row['id']] = $row['title_id'];
            }
            print_r($movies_id);

And would result in

array (
    1 => 'Title 1',
    2 => 'Title 2',
    4 => 'Title 4',
    8 => 'Title 8',
)

And key-less soulution would be:

            $movies_id = array();

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                    $movies_id[] = $row['title_id'];
            }
            print_r($movies_id);

And would result in

array (
    0 => 'Title 1',
    1 => 'Title 2',
    2 => 'Title 4',
    3 => 'Title 8',
)

answered Nov 26, 2014 at 8:28

Grzegorz

3,6084 gold badges31 silver badges48 bronze badges

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

4 Comments

Grzegorz Over a year ago

Indeed are. But may be usable later if wanted to retrive ID of a movie.

Marco Mura Over a year ago

there are a lot of ways but saying "you need" seems to be not optionals ;) that's for my downvote

Marco Mura Over a year ago

Thanks, better be clear on what is optional and what it isn't =) so upvoted

Grzegorz Over a year ago

Indeed. [$id => $title_id] led me to this mistake. By need i more meant he needs to do this that way if he wnats to store IDs as keys.

MBaas · Accepted Answer · 2014-11-26 08:34:01Z

0

I may have misunderstood what you're aiming for, but this might do it:

replace

$movies_id[] = [$id => $title_id];

with

 $movies_id[$id] = $title_id;

answered Nov 26, 2014 at 8:34

MBaas

7,5318 gold badges50 silver badges66 bronze badges

Comments

Manish Jangir · Accepted Answer · 2014-11-26 08:34:12Z

0

Your code would not work in case of PHP version less than 5.4. In that case you can use the following.

        $movies_id = array();

        while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
            $id = $row['id'];
            $title_id = $row['title_id'];
            $movies_id[] = array($id => $title_id);
        }

        print_r($movies_id);

answered Nov 26, 2014 at 8:34

Manish Jangir

5,4576 gold badges49 silver badges79 bronze badges

Comments

Hayk Aghabekyan · Accepted Answer · 2014-11-26 08:37:41Z

0

Instead of this line

$movies_id[] = [$id => $title_id];

Use the following

$movies_id[$id] = $title_id;

answered Nov 26, 2014 at 8:37

Hayk Aghabekyan

1,08710 silver badges19 bronze badges

6 Comments

Hayk Aghabekyan Over a year ago

It will work, but it will make multidimensional array. In the question user don't want multidimensional.

Manish Jangir Over a year ago

But the user does not want it to be multidimensional array. Have you read the question properly?

Manish Jangir Over a year ago

You have changed your comment just a minute ago.

Manish Jangir Over a year ago

See, SO is not for debating on a particular thing, It's about providing a beneficial solution to the question.

Hayk Aghabekyan Over a year ago

I changed the word "comment" to "question".

|

Collectives™ on Stack Overflow

Store array in while loop to use outside

4 Answers 4

4 Comments

Comments

Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related