create php multidimensional array using while loop

Question

i have two tables category and images.i want create a multidimensional array like

$headings = ['heading 1', 'heading 2', 'heading 3'];
$images = [
    'heading 1' => ['image 1', 'image 2', 'image 3', 'image 4', 'image 5'],
    'heading 2' => ['image 1', 'image 2', 'image 3'],
    'heading 3' => ['image 1']
];

So how can i do that using php.

Images table

category table

what have you tried? It seems like you want us to develop the whole system for you stackoverflow.com/questions/39804655/… — RST
– RST, Commented Oct 1, 2016 at 10:37

Moslem_mh · Accepted Answer · 2016-10-01 11:27:16Z

2

$sql = "select category.name,group_concat(images.image_name) from category inner join images on (category.id = images.category_id) group by category.name";
$table = mysql_query($sql);
$arr = array();
while($row = mysql_fetch_row($table))
{
    $row['image_name'] = explode(",", $row['image_name']);
    $arr[] = $row;
}

answered Oct 1, 2016 at 11:27

Moslem_mh

1891 silver badge8 bronze badges

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

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

The tool code you will need: mysqli. Now suppose you know it.

Solution 1

The slowest. Just fetch all the lines you need, then use a for loop to make it what you want.

Solution 2

Use GROUP_BY + GROUP_CONCAT function in sql.

I am in a hurry. So which do you like best, and do you need a further example?

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Oct 1, 2016 at 10:40

ch271828n

17.9k5 gold badges71 silver badges108 bronze badges

Collectives™ on Stack Overflow

create php multidimensional array using while loop

2 Answers 2

Comments

Solution 1

Solution 2

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Solution 1

Solution 2

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related