3 dimensional array result print in html table

Question

I am trying to print results in HTML table. Please help me to resolve.

<?php global $wpdb;

$result1=$wpdb->get_results("select name from table1");

$result2=$wpdb->get_results("select name from table2");

$result3=$wpdb->get_results("select name from table3");


$result_one = array();
$result_two = array();
$result_three = array();

//putting values in array

foreach ($result1 as $result) {
    $result_one[] = $result
}

foreach ($result2 as $result) {
    $result_two[] = $result

    foreach ($result3 as $result) {
        $result_three[] = $result


        $results = array(
            $result_one,
            $result_two,
            $result_three,
        );
        $array_length = count($result_one);
   ?>

Next i want to print $results in HTML table.

Example

------------------------------
   Name1  |  Name2   |  Name3
------------------------------
   Row1      Row1       Row1       
   Row2      Row2       Row2
   Row3      Row3       Row3
   Row4      Row4       Row4
   Row5      Row5       Row5

Thanks for support.

Bhupendra Tiwari · Accepted Answer · 2013-08-13 05:23:19Z

1

<?php
$result1=array('ROW1','ROW1','ROW1');
$result2=array('ROW2','ROW2','ROW2');
$result3=array('ROW3','ROW3','ROW3');
$result_one = array(); 
$result_two = array(); 
$result_three = array(); 
//putting values in array 
foreach ($result1 as $result) { 
$result_one[] = $result; 
} 
foreach ($result2 as $result) 
{ 
$result_two[] = $result;
}   
foreach ($result3 as $result) { 
$result_three[] = $result;
} 
$results = array( $result_one, $result_two, $result_three);
?>
<table border=1>
<tr><td>Name1</td><td>Name2</td><td>Name3</td></tr>
<?php foreach($results as $row){ ?>
<tr>
<?php foreach($row as $val){?>
<td><?php echo $val;?> </td>
<?php } ?>
</tr>
<?php }?>
</table>

answered Aug 13, 2013 at 5:23

Bhupendra Tiwari

592 bronze badges

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

Comments

Expedito · Accepted Answer · 2013-08-13 05:21:19Z

0

You can simplify your code a lot by removing the loops and just creating your array like this:

$result1=$wpdb->get_results("select name from table1");
$result2=$wpdb->get_results("select name from table2");
$result3=$wpdb->get_results("select name from table3");
$results = array(NULL, $result1, $result2, $result3);
$results = call_user_func_array('array_map', $results);
$table = "<table cellpadding='0' cellspacing='0' border='0'>\n";
$table .= "\t<tr><td>Name1</td><td>Name2</td><td>Name3</td></tr>\n";
foreach ($results as $key => $value){
    $table .= "\t<tr>\n\t\t";
    foreach ($value as $key2 => $value2){
        $table .= "<td>".$value2."</td>";
    }
    $table .= "\n\t</tr>\n";
}
$table .= "</table>\n";
echo $table;

edited Aug 13, 2013 at 5:21

answered Aug 13, 2013 at 5:08

Expedito

7,8095 gold badges32 silver badges45 bronze badges

6 Comments

Hansa Over a year ago

Thanks,how can i print this in html table?

Expedito Over a year ago

@Hansa - Do you have data in your database?

Hansa Over a year ago

Yes,i am trying something like this @ pastebin.com/RRMMvabt But not able to get result help me.

Expedito Over a year ago

@Hansa - The code you have at pastebin doesn't look anything like what I posted. And how are you going to do a query in pastebin with: $result1=$wpdb->get_results("select name from table1");? You're not even trying to make this work.

Hansa Over a year ago

All 3 results i took in $results 3 dimensional array.

|

Collectives™ on Stack Overflow

3 dimensional array result print in html table

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related