php create table vertically from array [closed]

Question

Hi I found this question here , but it doesnt do exactly what i'm looking for.

I would like the table to be displayed like this instead:

   **     | array1         | array2 
           -------------------------------
 logtime   | 1305732210     | 1305732216
           -------------------------------
 useragent | Mozilla        | Mozilla
           -------------------------------

Edited:

my bad for not posting code, but here is what i'm stuck on.

i have this query that outputs an array of data from mysql

SELECT s.*, m.id AS wmMake
                                  FROM `table1` AS s
                                  JOIN `table2` AS m
                                  WHERE s.code = m.code
            AND (s.ic='123'
            OR s.ic='1234"

its output looks like this

Array ( [0] => PAS [cat] => PAS [1] => H4B12A [ic] => H4B12A [2] => SMALL [segment] => SMALL [3] => 6 [wmMake] => 6 ) 
Array ( [0] => PAS [cat] => PAS [1] => HUV12A [ic] => HUV12A [2] => SMALL [segment] => SMALL [3] => 6 [wmMake] => 6 )

Now on my php side i have this:

for ($i =0; $c = mysql_fetch_array($query); $i++)
{
   print_r($c); 
}

the for loop, loops through 1 row at a time, how do i loop through each row, and get the 1st value and, then each row again to get 2nd value of array and so on. My html output should look like this.

    **     | array1         | array2 
           -------------------------------
 cat       | PAS            | PAS
           -------------------------------
 ic        | H4B12A         | HUV12A
           -------------------------------
 segment   | SMALL          | SMALL
           -------------------------------
  wmMake   | 6              | 6

Mike de Klerk · Accepted Answer · 2013-02-02 19:11:31Z

4

Know how to construct a HTML table
Know how to use arrays and how they work with keys and values.
Know how to use for loops, or foreach loops on arrays.
Combine the knowledge above, and create what you want.

answered Feb 2, 2013 at 19:11

Mike de Klerk

12.5k9 gold badges61 silver badges82 bronze badges

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

1 Comment

Mike de Klerk Over a year ago

You can vote me down, but its really you, who is asking to do work, instead of wanting to learn what is necessary. Do you want me to add references to W3C definition of tables? And links to PHPs website on arrays and loops?

Ynhockey · Accepted Answer · 2013-02-02 19:15:35Z

1

Assuming you can know for sure that both/all the arrays have the exact same keys, you can do with with foreach:

foreach ($array1 as $key => $value)
{
   echo '<tr>';
   echo '<td>'.$key.'</td>';
   echo '<td>'.$array1[$key].'</td>';
   echo '<td>'.$array2[$key].'</td>';
   // ... etc
   echo '</tr>';
}

I will note however that Mike de Klerk's answer is relevant and should not be disregarded—StackOverflow is not for having code written for you or teaching you how to write code, it's for getting answers about specific things you're stuck on.

answered Feb 2, 2013 at 19:15

Ynhockey

3,9515 gold badges37 silver badges55 bronze badges

Comments

Kalpesh · Accepted Answer · 2013-02-02 19:26:26Z

0

Get the array keys first. And then loop through the keys and echo the values from both the arrays.

$keys = array_keys($arr1, $arr2);

echo "<table>";
foreach($keys as $k) {
    echo "<tr>";
    echo "<td>".$k."</td>";
    echo "<td>".$arr1[$k]."</td>";
    echo "<td>".$arr2[$k]."</td>";
    echo "</tr>";
}
echo "</table>";

edited Feb 2, 2013 at 19:26

answered Feb 2, 2013 at 19:20

Kalpesh

5,6952 gold badges25 silver badges39 bronze badges

3 Comments

Mike de Klerk Over a year ago

My guess is that user2035819 wants to have each record in the array viewed in a new column. As stackoverflow.com/questions/6047757/php-create-table-from-array does it per row. Though this isn't clearly asked in the question...

srakl Over a year ago

edited my question. sorry for the lack of info

Kalpesh Over a year ago

@user2035819 in your for loop, just make two arrays $arr1 and $arr2 that you want to display in vertical. Then ourside your for loop, run my above code, it will handle the rows and columns as you want.

Collectives™ on Stack Overflow

php create table vertically from array [closed]

3 Answers 3

1 Comment

Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

3 Comments

Linked

Related