Building a custom array from a MySQL result set

Question

I have the following table with images for a blog post:

+----+---------+------------------------+-----------+-----------+-------+
| id | id_post | imagine                | descriere | tip       | sters |
+----+---------+------------------------+-----------+-----------+-------+
|  1 |       4 | asdasdsadasdasdasd.jpg | NULL      | thumbnail |     0 |
|  2 |       4 | asdasdsadasdasdasd.jpg | NULL      | full      |     0 |
|  3 |       4 | asdasdsadasdasdasd.jpg | NULL      | thumbnail |     0 |
|  4 |       4 | asdasdsadasdasdasd.jpg | NULL      | full      |     0 |
+----+---------+------------------------+-----------+-----------+-------+

In this table there's a column named "tip" (or type, in english) which represents the image type: full screen, or thumbnail. When someone uploads an image, there will always be a pair of "full" and "thumbnail" entries.

What I'm trying to do is to get all the images for a post and store them into an array, but with a single entry for each image like this: Array ( [0] => Array ( [thumbnail] => "1.jpg", [full] => "11.jpg")...

how do you know that image X is the thumb image Y (so that you can group them) ? — Oussama Jilal
– Oussama Jilal, Commented Aug 6, 2012 at 11:20

Peon · Accepted Answer · 2012-08-06 11:29:05Z

1

Well, 1st, you need some kind of variable, that binds the full image with the thumbnail image. Currenty there is no way telling witch thumbnail goes to witch image. Add a field like full_id or just combine the entries into one line, like:

+----+---------+--------------+---------------+-----------+-------+
| id | id_post | imagine_full | imagine_thumb | descriere | sters |
+----+---------+--------------+---------------+-----------+-------+

After that, use a loop to go through your values like @voodoo417 showed:

$items = array();

while ( $row = mysql_fetch_array( $result ) ) {
    $items[] = array( 
                 'thumbnail' => $row['imagine_thumb'],
                 'full' => $row['imagine_full']
            );
}

answered Aug 6, 2012 at 11:29

Peon

8,0417 gold badges63 silver badges104 bronze badges

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

1 Comment

Waygood Over a year ago

+1 As there is always a thumb and full image, storing them together is a good idea. And watch out for the witches LOL

Vinay · Accepted Answer · 2012-08-06 11:35:10Z

1

Select your table and follow this code,

$array[]= array();
while($row = mysql_fetch_assoc($result))
{
    //using 2-d array
    $array[$row[id]][$row[tip]]= $row[imagine];
}

Now when you want to retrieve images for specific post, you can use

$array[$post_id]['full']
$array[$post_id]['thumbnail']

edited Aug 6, 2012 at 11:35

answered Aug 6, 2012 at 11:24

Vinay

2,5944 gold badges27 silver badges35 bronze badges

Comments

voodoo417 · Accepted Answer · 2012-08-06 11:20:09Z

0

try like this

$items = array();
while ($row=mysql_fetch_array(RESOURSE)){
 $items[] = array( 'thumbnail'=>$row['thumbnail'], 'full' =>$row['full'] );
}

answered Aug 6, 2012 at 11:20

voodoo417

12.2k3 gold badges39 silver badges43 bronze badges

1 Comment

Waygood Over a year ago

thumbnail and full are on separate rows! so this will not work

Collectives™ on Stack Overflow

Building a custom array from a MySQL result set

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related