PHP List Hierarchy

[theforumdrunk]

Can you suggest how I output these to an expanding/collapsing hierarchy?

Example: http://jqueryui.com/demos/accordion/
Although the accordian is great, it wont work unless I output the html correctly which i'm finding very hard to do.

Here is the page with my current code: http://filewi.re/releases.php

And the code itself: http://code.google.com/p/filewire/so...s/releases.php

This is hours of mental torture so it's a lil messy. Thanks.

theforumdrunk Reviewed by theforumdrunk on 23rd Dec 2010. PHP List Hierarchy http://lulzimg.com/i02/13ed837b.png Can you suggest how I output these to an expanding/collapsing hierarchy? Example: http://jqueryui.com/demos/accordion/ Although the accordian is great, it wont work unless I output the html correctly which i'm finding very hard to do. Here is the page with my current code: http://filewi.re/releases.php And the code itself: http://code.google.com/p/filewire/source/browse/trunk/includes/releases.php Rating: 5

[Whoo]

First of all you have your query above the table:

$get = mysql_query("SELECT * FROM releases ORDER BY whateveryouwant"); 

To be honest you should just put the table structure in plain HTML, and then within the <table> where you normally put each <tr> you just add something like this:

<table>
// Head of the table like ID, name, etc goes here
<?php
while($row = mysql_fetch_object($get)){
?>
<tr>
<td><?php echo $row->id; ?></td>
<td><?php echo $row->name; ?></td>
...
</tr>
<?php 
}
?>
</table>

Remember, try and keep as much HTML as you can, keep the design separated from the functionality. No need to go and display HTML in within a PHP echo function , just the stuff you need

[theforumdrunk]

Thanks whoo, no problem with that. It's more the actual process of finding who belongs to whos parent (check db pic). Then displaying them in the right higherarchy.

[Whoo]

It's just a matter of thinking:

First you have to select all the parents, then for each parent, you print it, grab the children and print them too...

And after that you just do like I told you:

<table>
// Head of the table like ID, name, etc goes here
<?php
$get = mysql_query("SELECT * FROM tablename WHERE parent = 0 ORDER BY whateveryouwant");
while($parent = mysql_fetch_object($get)){
  $get2  = mysql_query("SELECT * FROM tablename WHERE parent = $parent->id ORDER BY whateveryouwant");
?>
<tr>
<td><?php echo $parent->id; ?></td>
<td><?php echo $parent->name; ?></td>
</tr>
<?php
  while($child = mysql_fetch_object($get2)) {
?>
<tr>
<td><?php echo $child->id; ?></td>
<td><?php echo $child->name; ?></td>
...
</tr>
<?php 
}
?>
</table>

This should display

-Parent1
--Child
--Child
--Child
-Parent2
--Child
--Child
--Child


Hope this helped

[theforumdrunk]

This is SO much cleaner.
Reckon you could post an example for a third level? That is a "Grandchild".

[Whoo]

Sure, just name how many children you want, this script is horny

<table>
// Head of the table like ID, name, etc goes here
<?php
$get = mysql_query("SELECT * FROM tablename WHERE parent = 0 ORDER BY whateveryouwant");
while($parent = mysql_fetch_object($get)){
  $get2  = mysql_query("SELECT * FROM tablename WHERE parent = $parent->id ORDER BY whateveryouwant");
?>
<tr>
<td><?php echo $parent->id; ?></td>
<td><?php echo $parent->name; ?></td>
</tr>
<?php
  while($child = mysql_fetch_object($get2)) {
    $get3 = mysql_query("SELECT FROM tablename WHERE parent = $child->id ORDER BY whateveryouwant");
?>
<tr>
<td><?php echo $child->id; ?></td>
<td><?php echo $child->name; ?></td>
...
</tr>
<?php
while($grandchild = mysql_fetch_object($get3)){
?>
<tr>
<td><?php echo $grandchild->id; ?></td>
<td><?php echo $grandchild->name; ?></td>
...
</tr>
<?php } ?>
<?php 
}
?>
</table>

I hope you get how this works now

[theforumdrunk]

DOH! Why didn't I think of this

Thanks bro, you're a legend!

[Whoo]

DOH! Why didn't I think of this

Thanks bro, you're a legend!

It was a pleasure...

I wish you good luck and don't forget that perseverance is the key to success when coding something

[theforumdrunk]

Saves making another thread.
The code is updated and looks as it should. http://code.google.com/p/filewire/so...s/releases.php

If the function in that class is called it should be outputting nothing as I clear the buffer at the end but save it to a variable. However, it has no effect and outputs everything: http://filewi.re/releases.php (You should be seeing a blank page)

Please tell me how this is possible

[dermechove]

use ob_get_contents() instead.
ob_get_flush outputs to the browser the saved buffer+ save it to a sting.