PHP array to HTML table

Question

I'm struggling to create a code that can help me create a table from the below php array. The array name is $associative_array1

array(
'Objective' => array(0 => 'Conversions', 1 => 'Lead Generation', ),
'Gender' => array(0 => 'Male (17.99% cheaper )', 
                  1 => 'Male (6.46% cheaper )  Male (16% cheaper )', ),
'Age' => array(0 => '45-54 (17.99% cheaper )', 
               1 => '45-54 (6.46% cheaper )35-44 (16% cheaper )', ),
'Placement' => array(0 => 'Mobile Feed (30.8% cheaper) right_hand (46.81% cheaper)', 
                     1 => 'Mobile Feed (12.56% cheaper)', ),
'Device' => array(0 => 'Android (30.8% cheaper) Desktop (46.81% cheaper)',
                  1 => 'iPhone (12.56% cheaper)', ),
)

Expected Output:

Headings can be taken as constant.

I tried creating code, however that is so bad that it wasn't worth sharing here. Basically, the code did nothing. Sorry, I'm a noob in it and need help from peers.

PHP code

 function generateTable2($associative_array,$associative_array1){
    echo '<table width="620" class="optimization_table" border="1"  cellspacing="0" cellpadding="0"><thead><tr><th colspan=2>';
    echo implode('</th><th colspan=2>', array_keys(current($associative_array)));
    echo '</th></tr></thead><tbody>';
    foreach ($associative_array1 as $row=>$value){
    echo "<td>";
    if(is_array($value))
        foreach ($value as $key =>$value2) {
            print_r($value2[$key]);
            foreach ($value2 as $value3) {

            }

            # code...
        }

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

can you do a var_export of your PHP array, it will be easier for us to help you then - php.net/var_export .. then edit your post with that array instead of what you originally posted. — Clay
– Clay, Commented Jan 8, 2016 at 7:50
This can be taken as constant.. I'm actually importing that as from other array.. if you look at the generate table, it has two arrays passed as arguments. one array is used for creating the table name, and other is for data. I won't mind, if I hard code them as well — user4943236
– user4943236, Commented Jan 8, 2016 at 8:00
You seem to have lost the newlines in your strings in your latest edit. — Barmar
– Barmar, Commented Jan 8, 2016 at 8:01
Is the array you showed $associative_array or $associative_array1? — Barmar
– Barmar, Commented Jan 8, 2016 at 8:02

Barmar · Accepted Answer · 2016-01-08 08:17:12Z

2

You can't use a nested foreach loop like that, because your HTML table is pivoted from the orientation of the PHP arrays. Each row contains the same index of all the sub-arrays, so you need to do something like this to display the data rows of the table.

$keys = array_keys($associative_array1);
$count = count($associative_array1[$keys[0]]);
for ($i = 0; $i < $count; $i++) {
    echo "<tr>";
    foreach ($keys as $key) {
        echo "<td>" . nl2br($associative_array1[$key][$i]) . "</td>";
    }
    echo "</tr>";
}

DEMO

edited Jan 8, 2016 at 8:17

answered Jan 8, 2016 at 8:11

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

2 Comments

user4943236 Over a year ago

its saying undefined offset. Moreover, its creating multiple rows under one column 1.error is at this line echo "<td>" . nl2br($associative_array1[$key][$i]) . "</td>";

user4943236 Over a year ago

I don't know what I'm doing wrong. it says Notice: Undefined offset: 0, Notice: Undefined offset: 1 until ``Notice: Undefined offset: 4`

Clay · Accepted Answer · 2016-01-08 08:30:44Z

1

The data is in an unusual format. Usually you want the data already in a row-like format.

Here is what I came up with:

<?php        
$data = array ( 
    'Objective' => array ( 0 => 'Conversions', 1 => 'Lead Generation', ),
    'Gender' => array ( 0 => 'Male (17.99% cheaper )', 1 => 'Male (6.46% cheaper )  Male (16% cheaper )', ), 
    'Age' => array ( 0 => '45-54 (17.99% cheaper )', 1 => '45-54 (6.46% cheaper )35-44 (16% cheaper )', ), 
    'Placement' => array ( 0 => 'Mobile Feed (30.8% cheaper) right_hand (46.81% cheaper)', 1 => 'Mobile Feed (12.56% cheaper)', ), 
    'Device' => array ( 0 => 'Android (30.8% cheaper) Desktop (46.81% cheaper)', 1 => 'iPhone (12.56% cheaper)', ),
);

function generateTable2($associative_array,$associative_array1){
    echo '<table width="620" class="optimization_table" border="1"  cellspacing="0" cellpadding="0"><thead><tr><th colspan=1>';
    echo implode('</th><th colspan=2>',$associative_array);
    echo '</th></tr></thead><tbody>';

    $rowCount = count( current( $associative_array1 ) );
    for ($x=0; $x<$rowCount; $x++) {
        echo "<tr>";
        foreach ($associative_array1 as $key => $data){
            echo "<td>".$data[ $x ]."</td>";
        }
        echo "</tr>\n";
    }

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

generateTable2(['Objective', 'Top Performing Targeting Group', 'Top Performing Placement'], $data);

edited Jan 8, 2016 at 8:30

answered Jan 8, 2016 at 8:15

Clay

4,7703 gold badges37 silver badges49 bronze badges

8 Comments

user4943236 Over a year ago

let me check this.I understand, data is in unusual format, but this is the best I could send the data. the other arrays were so bad that it was taking so many nested arrays to create the html.

user4943236 Over a year ago

this is not working, moreover, just 5 rows are being printed

Clay Over a year ago

just "5 rows" of what is being printed out?

Clay Over a year ago

Do you mean the column headers?

Clay Over a year ago

Yeah well it looks fine to me: imgur.com/frq3iJc -- are you sure you associative array is the same as what you posted? please post how you are calling generateTable2

|

Collectives™ on Stack Overflow

PHP array to HTML table

2 Answers 2

2 Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related