Posted By

kirik on 08/09/09

Tagged

Versions (?)

Last Edited at 08/09/09 04:32pm

Statistics

Viewed 953 times

Favorited by 1 user(s)

Related snippets

Function for putting data to the html table [two different ways]

/ Published in: PHP

This function is very helpfull when you need to put some data (that was gotten from database) to HTML table. You can choose vertical or horizontal types.

**Horizontal type:**

| 1 | 2 | 3 |

| 4 | 5 | 6 |

| 7 | 8 | 9 |

**Vertical type:**

| 1 | 4 | 7 |

| 2 | 5 | 8 |

| 3 | 6 | 9 |

* hope you will sort it out (:

Highlighted TextExpand

<?php
/**
 * @var $data (array)
 * 	array to put to the html table
 * @var $type (int)
 *	type of table (0 - horizontal, 1 - vertical)
 * @var $columns (int)
 *	numer of columns
 * @var $tabs (int)
 *	numer of tabs to decorate your html code. If you don't need - set this variable to false
**/
function drawTable($data, $type=1, $columns=10, $tabs=0)
{
    $tbl = null;

if($tabs === false)
    {
        $tr = $td = null;
    }
    else
    {
        $tr = "\n".str_repeat("\t", $tabs);
        $td = $tr."\t";
    }

if($type == 1)
    {
        $all_columns = array_chunk($data, ceil(count($data) / $columns));
        for($i = 0, $c = count($all_columns[0]); $i < $c; $i++)
        {
            $tbl .= $tr.'<tr>';

for($si = 0; $si < $columns; $si++)
            {
                $tbl .= $td.'<td>'.(isset($all_columns[$si][$i]) ? $all_columns[$si][$i] : '&nbsp;').'</td>';
            }

$tbl .= $tr.'</tr>';
        }
    }
    else
    {
        for($i = 0, $n = 1, $d = ceil(count($data) / $columns) * $columns; $i < $d; $i++, $n++)
        {
            if($n == 1)
                $tbl .= $tr.'<tr>';

$tbl .= $td.'<td>'.(isset($data[$i]) ? $data[$i] : '&nbsp;').'</td>';

if($n == $columns)
            {
                $n = 0;
                $tbl .= $tr.'</tr>';
            }
        }
    }

if($tabs !== false)
        $tbl .= "\n";

return $tbl;
}

/**
=== Example 1: numeric, horizontal, 3 columns, with 0 tabs ===
$data = range(1, 7);
echo '<table>'.drawTable($data, 0, 3, 0).'</table>';

--- Result 1 ---
| 1 | 2 | 3 |
| 4 | 5 | 6 |
| 7 |   |   |

--- Result in HTML 1 ---
<table>
<tr>
	<td>1</td>
	<td>2</td>
	<td>3</td>
</tr>
<tr>
	<td>4</td>
	<td>5</td>

<td>6</td>
</tr>
<tr>
	<td>7</td>
	<td>&nbsp;</td>
	<td>&nbsp;</td>
</tr>
</table>
**/

/**
=== Example 2: numeric, vertical, 3 columns, in one line ===
$data = range(1, 7);
echo '<table>'.drawTable($data, 1, 3, false).'</table>';

--- Result 2 ---
| 1 | 4 | 7 |
| 2 | 5 |   |
| 3 | 6 |   |

--- Result 2 in HTML ---
<table><tr><td>1</td><td>4</td><td>7</td></tr><tr><td>2</td><td>5</td><td>&nbsp;</td></tr><tr><td>3</td><td>6</td><td>&nbsp;</td></tr></table>
**/

/**
=== Example 3: data from MySQL, horizontal, 5 columns, in one line ===
$query = mysql_query('SELECT `column1`, `column2`, `column3`, `column4`, `column5` FROM `table` ORDER BY `field` DESC');
while($row = mysql_fetch_row($query))
{
    $data[] = $row;
}
mysql_free_result($query);
echo '<table>'.drawTable($data, 0, 5, false).'</table>';
**/

/**
=== Example 4: data from MySQL, vertical, 5 columns, in one line ===
$query = mysql_query('SELECT `column` FROM `table` ORDER BY `field` DESC');
while($row = mysql_fetch_row($query))
{
    $data[] = $row;
}
mysql_free_result($query);
echo '<table>'.drawTable($data, 1, 5, false).'</table>';
**/

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.