Posted by sicapitan on 10/27/06 15:32

I'm trying to build some xml from an array with the help from another
array.

In one array I have

$cells

Array
(
[0] => CELL0
[6] => CELL2
)
...
etc

In another I have:

Array
(
[id] => 38
[form_id] => 3
[order] => 1
[type] => grid
[name] => CELL0
[value] => Period
)

Array
(
[id] => 39
[form_id] => 3
[order] => 1
[type] => grid
[name] => CELL0
[value] => type
)
.... continues..

Array
(
[id] => 47
[form_id] => 3
[order] => 2
[type] => grid
[name] => CELL2
[value] =>
)

Array
(
[id] => 48
[form_id] => 3
[order] => 2
[type] => grid
[name] => CELL2
[value] =>
)

What I want to do is for CELL0 for example, get all the data in the
other array pertaining to this value such that I have CELL0 data in
another new array and CELL1 data in another array. But when I am going
through the data, Ever 6 records I need to close the XML and reset the
count.

So the data string I want to build for CELL0:

<data>
<data>Value1</data>
<data>Value2</data>
<data>Value3</data>
<data>Value4</data>
<data>Value5</data>
<data>Value6</data>
</data>
....

In array form
[CELL0]
=> <data><data>Value1</data>.....</data>
[CELL1]
=> <data><data>Value1</data>....</data>

This is what I have so far:

foreach( $grid_cells as $key => $cell )
{
$colcount = 1;

foreach( $grids as $key => $form_record )
{
if ( $cell == $form_record['name'] )
{
if ( $colcount == 1) {
$grid_data[$form_record['name']] .= "<data>"; // Start of row
$grid_data[$form_record['name']] .= "<data>" .
$form_record['value'] . "</data>"; // middle of row
}
if ( $colcount <= $cols )
{
$grid_data[$form_record['name']] .= "<data>" .
$form_record['value'] . "</data>"; // middle of row
$colcount++;
}
if ($colcount > $cols) {
$grid_data[$form_record['name']] .= "</data>"; // end of row
$colcount = 1;
}

} // end if

}
}

$grid_cells contains :
Array
(
[0] => CELL0
[6] => CELL2
)
....etc

$grids contains :

Array
(
[id] => 37
[form_id] => 3
[order] => 1
[type] => grid
[name] => CELL0
[value] => Client Name
)

This produces:

Array
(
[CELL0] => <data><data>Client Name</data><data>Client
Name</data><data>Period</data><data>type</data><data>Description</data><data>23498</data><data></data></data>

[CELL2] =>
<data><data></data><data></data><data></data><data></data><data></data><data></data><data></data></data>
)

It's something simple, can anyone help?

[Back to original message]