Add additional element to array

Question

If I have an array $MovieDetails = array(); and it is populated by the query below with a foreach loop (5 elements; id, movie_year, genre, image, movie_name), how do I add another element (movie_rating) to the end of the array

$AllMovies = $con ->query
("
    SELECT id, movie_year, genre, image, movie_name FROM movies; 
");

 while($row = $AllMovies->fetch_object())  {
        $MovieDetails[] = $row;
    }

add it to $row with $row['movie_rating'] before you add it to movieDetails — Weltschmerz
– Weltschmerz, Commented Apr 9, 2015 at 16:32
You could also make it easier to add it later, by changing it to $MovieDetails[$row['id']] = $row;. Then if you know the movie id, you can do $MovieDetails[$id]['movie_rating'] = $rating; — Sean
– Sean, Commented Apr 9, 2015 at 16:36
You're fetching the results as an StdClass object. You'll need to change to fetch_array() in order to let the posted answers work — DarkBee
– DarkBee, Commented Apr 9, 2015 at 17:56

pavel · Accepted Answer · 2015-04-12 05:59:07Z

3

Add movie rating into $row.

If you work with that as object, it's $row->movie_rating = 1.5

while($row = $AllMovies->fetch_object())  {
    $row->movie_rating = 1.5;
    $MovieDetails[] = $row;
}

If you work with that as array, use fetch_assoc() and $row['movie_rating'] = 1.5

while($row = $AllMovies->fetch_assoc())  {
    $row['movie_rating'] = 1.5;
    $MovieDetails[] = $row;
}

edited Apr 12, 2015 at 5:59

answered Apr 9, 2015 at 16:34

pavel

27.3k11 gold badges47 silver badges63 bronze badges

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

4 Comments

McNoodles Over a year ago

I get back error ` Cannot use object of type stdClass as array`

DarkBee Over a year ago

should be fetch_array()

pavel Over a year ago

@McNoodles: If you work with that as object, there should be $row->movie_rating = 1.5. If you want array, change fetch_object for fetch_array.

DarkBee Over a year ago

@panther you should reflect this in your answer because your answer is incorrect at this point...

makallio85 · Accepted Answer · 2015-04-09 17:59:01Z

1

This way your row is an object

$AllMovies = $con->query("SELECT id, movie_year, genre, image, movie_name FROM movies;");
while($row = $AllMovies->fetch_object())  {
   $row->movie_rating = 'movieRating'; 
   $MovieDetails[] = $row;
}

If you want each row to be array, you should do:

while($row = $AllMovies->fetch_array())  {
   $row['movie_rating'] = 'movieRating'; 
   $MovieDetails[] = $row;
}

edited Apr 9, 2015 at 17:59

answered Apr 9, 2015 at 17:35

makallio85

1,3562 gold badges14 silver badges29 bronze badges

1 Comment

DarkBee Over a year ago

should be fetch_array()

user3094403 · Accepted Answer · 2015-04-09 17:32:12Z

0

$MovieDetails['movie_rating'] = $movie_rating;

edited Apr 9, 2015 at 17:32

user3094403

6,39011 gold badges50 silver badges56 bronze badges

answered Apr 9, 2015 at 17:30

McNoodles

231 silver badge9 bronze badges

Collectives™ on Stack Overflow

Add additional element to array

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related