Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:102:\"Declaration of views_plugin_style_default::options() should be compatible with views_object::options()\";s:5:\"%file\";s:102:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/views/plugins/views_plugin_style_default.inc\";s:5:\"%line\";i:24;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:151:\"Declaration of calendar_plugin_display_page::options_submit() should be compatible with views_plugin_display_page::options_submit(&$form, &$form_state)\";s:5:\"%file\";s:108:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/includes/calendar_plugin_display_page.inc\";s:5:\"%line\";i:297;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:104:\"Declaration of calendar_plugin_display_page::options() should be compatible with views_object::options()\";s:5:\"%file\";s:108:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/includes/calendar_plugin_display_page.inc\";s:5:\"%line\";i:297;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:105:\"Declaration of calendar_plugin_display_block::options() should be compatible with views_object::options()\";s:5:\"%file\";s:109:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/includes/calendar_plugin_display_block.inc\";s:5:\"%line\";i:78;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:163:\"Declaration of calendar_plugin_display_attachment::options_submit() should be compatible with views_plugin_display_attachment::options_submit(&$form, &$form_state)\";s:5:\"%file\";s:114:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/includes/calendar_plugin_display_attachment.inc\";s:5:\"%line\";i:242;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:110:\"Declaration of calendar_plugin_display_attachment::options() should be compatible with views_object::options()\";s:5:\"%file\";s:114:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/includes/calendar_plugin_display_attachment.inc\";s:5:\"%line\";i:242;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:151:\"Declaration of calendar_plugin_display_ical::options_submit() should be compatible with views_plugin_display_page::options_submit(&$form, &$form_state)\";s:5:\"%file\";s:113:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/calendar_ical/calendar_plugin_display_ical.inc\";s:5:\"%line\";i:217;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:134:\"Declaration of date_handler_field_multiple::pre_render() should be compatible with content_handler_field_multiple::pre_render($values)\";s:5:\"%file\";s:99:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/date/date/date_handler_field_multiple.inc\";s:5:\"%line\";i:185;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:102:\"Declaration of calendar_view_plugin_style::options() should be compatible with views_object::options()\";s:5:\"%file\";s:106:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/includes/calendar_view_plugin_style.inc\";s:5:\"%line\";i:173;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:136:\"Declaration of calendar_plugin_style_ical::init() should be compatible with views_plugin_style::init(&$view, &$display, $options = NULL)\";s:5:\"%file\";s:111:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/calendar_ical/calendar_plugin_style_ical.inc\";s:5:\"%line\";i:254;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135

Warning: INSERT command denied to user 'o4077762'@'infong892.perfora.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:102:\"Declaration of calendar_plugin_style_ical::options() should be compatible with views_object::options()\";s:5:\"%file\";s:111:\"/homepages/27/d313962189/htdocs/poon.co/sites/all/modules/calendar/calendar_ical/calendar_plugin_style_ical.inc\";s:5:\"%line\";i:254;}', 3, '', 'http://poon.co/node/2185', '', '18.208.126.232', 1660307783) in /homepages/27/d313962189/htdocs/poon.co/includes/database.mysql.inc on line 135
Displaying data in table | Lawrence Poon

Displaying data in table

Printer-friendly versionPDF version

Displaying data in a table is a very frequent task for a programmer. I just wrote a very simple function called array_to_table to handle data. If you found it useful, please feel free to use it.

<style>
body {
}
input {
font-size:1.1em;
}
table.gridtable {
        font-family: verdana,arial,sans-serif;
        font-size:14px;
        color:#333333;
        border-width: 1px;
        border-color: #666666;
        border-collapse: collapse;
}
table.gridtable th {
        border-width: 1px;
        padding: 8px;
        border-style: solid;
        border-color: #666666;
        background-color: #dedede;
}
table.gridtable td {
        border-width: 1px;
        padding: 8px;
        border-style: solid;
        border-color: #666666;
        background-color: #ffffff;
}
</style>
<?php

// the data is array of assoicative arrays

$data = array(
  array(
'id'=>'1','email' =>'lawrence@test'),
  array(
'id'=>'2','email' => 'ivan@test'),
array(
'id'=>'3','email' =>'la@test'),
  array(
'id'=>'4','email' => 'ivan33@test')

);

echo
array_to_table($data);


function
array_to_table  ($data){

  if(!
$data || !is_array($data)){

      return
null;

    }


 
$is_first_row = 'yes' ;
 
$table = '<table class="gridtable">' ;

  foreach (
$data as $row){

    if(
$is_first_row=='yes'){

       
$header = array_keys($row);
       
$table .= '<tr bgcolor="#f0f0f0">' ;

        foreach(
$header as $k){

          
$table .= '<th>'.strtoupper($k).'</th>' ;
        }
// foreach
      
$table .='</tr>' ;

       
$is_first_row ='no';

    }
// if is first row



 
$table .= '<tr>' ;

  foreach(
$row as $k =>$v){

     
$table .= '<td>'.$v.'</td>';
  }
//foreach

 
$table .= '</tr>' ;

}

 
$table .= '</table>';
  return
$table;
}
// function display

?>