<\/p>\n
Example if the database field has only 2 items (using the same script)<\/p>\n
| Item 1<\/td>\n | Item 2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/p>\n Or look at the visual example To fix this, simply add a table-layout CSS style and <col><\/p>\n |
I was doing some scripting in PHP to create tables with data drawn from a database. Drawing multiple fields using the same script caused the table layout to shift. This can be fixed using the\u00a0tag within the table. I thought it was kind of interesting, so I thought sharing it using an example.<\/p>\n
An example of a 3 column table setup would be something like this:<\/p>\n
<table width=\"400\" border=\"1\">\r\n <?php $table_count = 0; ?>\r\n <?php if(count($this->items) > 0): \/\/if there's content\r\n foreach($this->items as $content): \/\/loop through all content\r\n if( $table_count == 0 ): ?>\r\n <tr>\r\n <?php endif; ?>\r\n <td width=\"33%\"> \/\/to create 3 columns\r\n \/\/insert content here\r\n <\/td>\r\n <?php if( $table_count == 2 ): ?> \/\/3 columns, so table_count = 3 - 1 = 2\r\n <\/tr>\r\n <?php $table_count = 0; ?> \/\/column length reached, reset count\r\n <?php else: ?>\r\n <?php $table_count++; ?>\r\n <?php endif; ?>\r\n<\/table><\/pre>\nI was using the same script to parse multiple database fields onto 1 page. E.g. an employees page of a company. The page would display all the employees categorized in different positions within the company, so the number of people per position varies.<\/p>\n
The script shown above would be used for all the categories to create a 3 column table.
\nCreating the table works fine, if we parse content of 3 or more items from the database to PHP. But a problem occurs with the layout if there are less items than the number of columns within a category.<\/p>\nExample with enough items:<\/p>\n
| Item 1<\/td>\n | Item 2<\/td>\n | Item 3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/p>\n Example if the database field has only 2 items (using the same script)<\/p>\n
|
![\"\"](\"http:\/\/elwinlee.com\/blog\/wp-content\/uploads\/2011\/07\/php-table.jpg\" "\\"\\"")
<\/a><\/p>\n