Split Multi Dimensional array into single array :PHP

VishnuKumar Pv

I have an array (From mysql),

Array ( 
    [0] => Array ( 
        [heading] => Page Name change 
        [name] => Page_Name_change 
        [menu] => online 
    ) 
    [1] => Array ( 
        [heading] => Lorem ipsum dolor 
        [name] => Lorem_ipsum_dolor_ 
        [menu] => akshaya 
    ) 
    [2] => Array ( 
        [heading] => fgdfgfdgdfgdf 
        [name] => fgdfgfdgdfgdf 
        [menu] => akshaya 
    ) 
)

I need to split it into separate arrays, basis on [menu], check this php

function getpage() {
    $query = "SELECT heading,name,menu FROM pages";
    $res = $this->_conn->query($query);
    while ($row = mysqli_fetch_assoc($res)) {
        $result[] = $row;
    }
    for ($i=0; $i < count($result); $i++) {
        if (strcmp($result[$i]['menu'],'akshaya') == 0) {
            for ($j=0; $j < count($result[$i]) ; $j++)
                $menu = $result[$i][$j];
        }
    }
    //if(strcmp($row['menu'],'akshaya')==0) { }
    return $menu;
}

The expected result is the array where each menu segment has the list of the elements from the initial array, like that:

[
    'online' => [
        [
            'heading' => '...',
            'name' => '...',
        ],
    ],
    'akshaya' => [
        [...], 
        [...],
    ],
]

MySql Data base

its for display an Navigation Menu & Submenu,

enter image description here

Alexander Guz
function getpage() {
    $query = "SELECT heading,name,menu FROM pages";
    $res = $this->_conn->query($query);
    while ($row = mysqli_fetch_assoc($res)) {
        $result[] = $row;
    }

    $menu = [];
    foreach ($result as $menuItem) {
        $menu[$menuItem['menu']][] = $menuItem;
    }

    return $menu;
}

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Check contents of multi-dimensional array against a single array

Convert two single dimension array into one multi dimensional array

Multi dimensional php array not working

Reduce multi-dimensional array of objects into a single array of object

Converting multi dimensional array to single dimensional array using Dataweave

Laravel Collection Split into multi-dimensional array

How to convert a deep multi dimensional array to a single dimensional array - Javascript

Empty currently filled multi dimensional array in PHP

Convert Multi dimensional array PHP

PHP array unique on multi dimensional array/object

PHP create multi dimensional array

modifying multi dimensional array in PHP

Convert multi-dimensional array into single array (Javascript)

Multi-dimensional array indexing using a single dimensional array in Python

PHP Search Multi Dimensional Array

How to parse a multi dimensional array to PHP

PHP How to split multi dimensional array into single array?

How to convert multi dimensional array to single dimensional array in php ?

Transform multi dimensional array to single array

how to multiply array in multi dimensional array in php

split multi-dimensional array in ruby

PHP remove value from multi dimensional array

Multi dimensional associative array in php

Split Multi-dimensional Array Into Multiple Arrays

How to convert two single dimensional arrays into one multi-dimensional array - PHP

Convert a json to multi-dimensional PHP array

Consolidate single multi-dimensional array by individual key of nested array PHP

php how to convert multi-dimensional array to single array

Sort multi dimensional array in php