sorting a foreach function loop result

Question

I have a MySQL query that gets the result of the entire MySQL database into a php array called $parents

then I have a foreach function loop that display result from that array

the function:

 function subtree($id, $parents) { 
 if (isset($parents[$id]))
 foreach ($parents[$id] as $child) 
 {
 subtree($child, $parents);
 }
 }

I need to sort the array result of this function, or to get the result into a new_sub_array then sort it and display result

any way to modify the function to do what i need?

possible duplicate of Order multidimensional array recursively at each level in PHP — chx
– chx, Commented Dec 30, 2013 at 22:46

Michael · Accepted Answer · 2013-12-30 22:43:37Z

0

Change your condition

if (is_array($parents[$id]))

If Value is array then look for next sub tree

else

otherwise write value.

If you want to sort an array - just use one of this function at the beginning of subtree()

Good idea is to don't use recursion, instead of this you can use iteration and well prepared sql query instead of sorting in PHP ;)

Your function could look like this, I am not sure if I understand you, but it should be ok.

function subtree($parents) 
{
    if (is_array($parents))
    {
        sort($parents);
        foreach ($parents as $key => $value) 
        {
            subtree($value);
        }
    }
    else
    {
        echo $parents;
    }
}

The $id argument is unnecessary.

edited Dec 30, 2013 at 22:43

answered Dec 30, 2013 at 22:16

Michael

12 bronze badges

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

3 Comments

user3117183 Over a year ago

can you modify the function ? been trying that with no luck

user3117183 Over a year ago

the $id is the parent id that i need to get the child of. the array is like parent-LeftChild1,RightChild1 Parent(LeftChild1)-Leftchild2,RightChild2 ,, then the function should print each child of the main parents and childs of childs and so on, i just need to sort the result of the function

Michael Over a year ago

So if you want get child of specific parent id, then put to function as argument something like this $parent[$specific_id]. Did your array looks like this pastebin.com/JXdDRL5A ?

CuriousCabbage · Accepted Answer · 2013-12-30 21:56:57Z

-1

You'd sort the values when you call them from the database. So if you sorted them in descending order of date, for example:

SELECT * FROM values WHERE :id=$id ORDER BY date DESC

Basically, ORDER BY is your friend. This helped me a lot.

answered Dec 30, 2013 at 21:56

CuriousCabbage

4341 gold badge5 silver badges10 bronze badges

3 Comments

user3117183 Over a year ago

need to sort from the function and not the query

CuriousCabbage Over a year ago

Then this link is definitely what you want to be using. Loads of functions for sorting arrays.

user3117183 Over a year ago

the problem is that i can't get to find a way to sort it inside the function., the result is always unsorted

Collectives™ on Stack Overflow

sorting a foreach function loop result

2 Answers 2

Good idea is to don't use recursion, instead of this you can use iteration and well prepared sql query instead of sorting in PHP ;)

3 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Good idea is to don't use recursion, instead of this you can use iteration and well prepared sql query instead of sorting in PHP ;)

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related