Menu
Community /Pin to ProfileBookmark
@NogDogSep 20.2010 — #It's hard to tell for sure without details on the data hierarchy, and also if you need to deal with a "childless father". In general, though, I might consider building up an array with the necessary data, something like:
Then in your HTML that defines your <table>, you could loop through that array to output the table cells, something like:
dynamic table
Hi!
I need to create a dynamic html table with php function but I’m in trouble.
I have a table in my db with some records, some og them are father and other are children: for children I have parent_id field that indicate father id.
Html table is characterize by a first line with <td> tag (many as father), and a second line with children at the same <td> tag of father.
Something like this:
FATHER1 FATHER2 FATHER3
CHILD1_1 CHILD2_1 CHILD3_1
CHILD1_2 CHILD2_2 CHILD3_2
I create query to get father, but I can’t manage cycle to obtain my result, can you help me please?
Thanks!
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogSep 20.2010 — #It's hard to tell for sure without details on the data hierarchy, and also if you need to deal with a "childless father". In general, though, I might consider building up an array with the necessary data, something like:[code=php]
$data = array(
$father_id_1 => array(
'name' => 'Father_1',
'children' => array(
$child_id_1_1 => 'Child_1_1',
$child_id_1_2 => 'Child_1_2'
)
),
$father_id_2 => array(
'name' => 'Father_2',
'children' => array(
$child_id_2_1 => 'Child_2_1',
$child_id_2_2 => 'Child_2_2'
)
)
);
[/code]Then in your HTML that defines your <table>, you could loop through that array to output the table cells, something like:
[code=php]
foreach($data as $father) {
echo "<td>";
echo "<p class='father'>{$father['name']}</p>n";
foreach($father['children'] as $child) {
echo "<p class='child'>$child</p>n";
}
echo "</td>n";
}
[/code]