Show multi array in table

lau87

I have the following array output:

Array
(
    [c-1103-5-pca-x-tra] => Array
        (
            [name] => C 110.3-5 PCA X-tra
            [2] => Array
                (
                    [specification] => Afmeting (L*B*H)
                    [value] => 240*240*660
                    [unit] => mm
                )

        [6] => Array
            (
                [specification] => Elektrische aansluitwaarde
                [value] => 230
                [unit] => Volt/50 Hz
            )

        [9] => Array
            (
                [specification] => Garantietermijn
                [value] => 5
                [unit] => jaar
            )

        [46] => Array
            (
                [specification] => Automatische start/stop
                [value] => Ja
                [unit] => 
            )

    )

[c-1103-5-pc-x-tra] => Array
    (
        [name] => C 110.3-5 PC X-TRA 
        [2] => Array
            (
                [specification] => Afmeting (L*B*H)
                [value] => 240x240x660
                [unit] => mm
            )

        [5] => Array
            (
                [specification] => Elektrische aansluitwaarde
                [value] => 1.4
                [unit] => kw
            )

        [9] => Array
            (
                [specification] => Garantietermijn
                [value] => 5
                [unit] => jaar
            )

        [40] => Array
            (
                [specification] => Watertoevoertemperatuur
                [value] => Maximaal 40
                [unit] => °C
            )

    )

)

The c-1103-5-pca-x-tra and c-1103-5-pc-x-tra are the selected 2 products as an example, because people are allowed to select max 3 products. The numbers following are the specification_id of that corresponding product.
As you can see, these 2 products has some identical specifications, but also different specification.

I want to put these arrays in a table to show users the comparison of the specification of the selected products.

I started with the code below to output at least the name:

echo '<table border="1">';
echo '<tr>';
echo '<th></th>';
foreach ( $aSpecsProduct as $aProduct )
{
    echo '<th>' . $aProduct['naam'] . '</th>';
}
echo '</tr>';
echo '</table>';

Now, I don't have a clue how to start with putting the arrays in a table, with on the leftside the specification (all specification of both products - of course without double specification if both products have the same specification).

dalecosp

You do know that you can do this?

foreach ($some_array as $key=>$value) {
   echo "The key is $key, and the value is $value<br />\n";
}

. Looping over multi-dimension arrays isn't tremendously difficult either; it's usually a matter of "nested loops"...

lau87

Yes, I do know that there is such way to do this:
I applied it with the following code:

echo '<table border="1">';
echo '<tr>';
echo '<th></th>';
foreach ( $aSpecsProduct as $aProduct )
{
    echo '<th>' . $aProduct['name'] . '</th>';
}
for ($key = 0; $key < 100; $key++)
{
    echo '<tr>';
	foreach( $aSpecsProduct as $aProduct )
	{
		echo '<td>';
		if ( isset( $aProduct[ $key ]['specification'] ) )
		{
			echo $aProduct[ $key ]['specification'];
		}
		echo '</td>';
		echo '<td>';
		if ( isset( $aProduct[ $key ]['value'] ) )
		{
			echo $aProduct[ $key ]['value'] .' '.$aProduct[ $key ]['unit'];
		}
		echo '</td>';
	}    

    echo '</tr>';
}
echo '</tr>';
echo '</table>';

But there are 2 problems:
1) I get double specification results where I want just 1 specification on the left of the table
2) There is a key running from 0 to 100, but this should depends on the amount of specifications each product has...

I stuck again with these problems..

Derokorian

Why not do foreach using the $key => $value notation as he suggested? You said "I applied it with the following code" however the code you show does not use the notation he suggested. Also the nesting of loops makes no sense really. Given your array:

echo '<table>';
foreach( $aSpecsProduct as $aProductKey => $aProduct ) {
   echo '<tr><th>'. $aProduct['name'] .' ('. $aProductKey .')</th></tr>';
   foreach( $aProduct as $aSpecKey => $aSpec ) {
      echo '<tr><td>('. $aSpecKey .') '. $aSpec['specification'] .'</td><td>'. $aSpec['value'] .' '. $aSpec['unit'] .'</td></tr>';
   }
}
echo '</table>';

See how much simpler that is than you are trying to make it?

lau87

Well, I think I am stupid.
However, I get the specifications and the values of each product on top of each other.

With the code Derokorian posted, I get the output:

C 110.3-5 PCA X-tra
(name) C	C C
(2) Afmeting (L*B*H)			|	240*240*660 mm
(6) Elektrische aansluitwaarde	|	230 Volt/50 Hz
(9) Garantietermijn				|	5 jaar
(46) Automatische start/stop	|	Ja

C 110.3-5 PC X-TRA Nu bij de hogedrukreinigerXpert
(name) C	C C
(2) Afmeting (L*B*H)			|	240x240x660 mm
(5) Elektrische aansluitwaarde	|	1.4 kw
(9) Garantietermijn				|	5 jaar
(40) Watertoevoertemperatuur	|	Maximaal 40 °C

I tried to transform it to the desired table in order to compare the values with eachother usin the specifications:

									C 110.3-5 PCA X-tra 		C 110.3-5 PC X-TRA 
(2) Afmeting (L*B*H)			|	240*240*660 mm			|	240x240x660 mm
(5) Elektrische aansluitwaarde	|	---						|	1.4 kw
(6) Elektrische aansluitwaarde	|	230 Volt/50 Hz			|	---
(9) Garantietermijn				|	5 jaar					|	5 jaar
(40) Watertoevoertemperatuur	|	---						|	Maximaal 40 °C
(46) Automatische start/stop	|	Ja						|	---

This transformation is a bottleneck and I can't manage to do this with the foreach

dalecosp

Ok, what if you call [man]array_merge/man on your 2 (or 3) main arrays before you do the output?

lau87

dalecosp;11002721 wrote:
Ok, what if you call [man]array_merge/man on your 2 (or 3) main arrays before you do the output?

How can I merge the 2 or 3 array's together?
I only have 1 array which is $aSpecsProduct or am I wrong? Because the products array doesn't have an arrayname...

lau87

I tried to apply array_merge() to the foreach:

echo '<table>';
$aSpecKeyAll = array();
foreach( $aSpecsProduct as $aProductKey => $aProduct ) {
   	echo '<tr><th>'. $aProduct['naam'] .' ('. $aProductKey .')</th></tr>';
   	foreach( $aProduct as $aSpecKey => $aSpec ) {
	$aSpecKeyAll = array_merge($aSpecKey);
      	echo '<tr><td>('. $aSpecKey .') '. $aSpec['specificatie'] .'</td><td>'. $aSpec['waarde'] .' '. $aSpec['eenheid'] .'</td></tr>';
   	}
}
echo '</table>'; 

echo '<pre>';
print_r($aSpecKeyAll);
echo '</pre>';

But it won't work, I get errors, since I missed the second array.

lau87

An update (I couldn't find the edit button):

$ids = array();
$keys = array();
foreach($aSpecsProduct as $aProductKey => $aProduct){
   $ids[] = $aProductKey;
   	foreach( $aProduct as $aSpecKey => $aSpec ) {
   		$keys[] = $aSpecKey;
   	}
}
echo '<pre>';
print_r(array_unique($keys));
echo '</pre>';

Now, it give me the unique keys, but I don't think this is the logical way to have all keys of both arrays....