{"id":1214,"date":"2018-01-19T19:22:34","date_gmt":"2018-01-19T19:22:34","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/using-pears-html_table-class-page-2\/"},"modified":"2018-01-19T19:24:37","modified_gmt":"2018-01-19T19:24:37","slug":"using-pears-html_table-class-page-2","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/using-pears-html_table-class-page-2\/","title":{"rendered":"Using PEAR’s HTML_Table Class Page 2"},"content":{"rendered":"
\n
\n
By Andy Nortrup<\/div>\n
on August 18, 2003<\/div>\n<\/p><\/div>\n
\n

So How do I Use This Thing?<\/h2>\n
To show you the advantages of the HTML_Table class let’s recreate the table we used before, this time using the HTML_Table class.<\/div>\n

<?php
<\/span>\/\/get\u00a0our\u00a0query
<\/span>$connection\u00a0<\/span>=\u00a0<\/span>mysql_connect<\/span>(<\/span>\"localhost\"<\/span>,\u00a0<\/span>\"me\"<\/span>,\u00a0<\/span>\"password\"<\/span>);
<\/span>$sql\u00a0<\/span>=\u00a0<\/span>\"SELECT\u00a0*\u00a0FROM\u00a0users\"<\/span>;
<\/span>$result\u00a0<\/span>=\u00a0<\/span>mysql_query<\/span>(<\/span>$sql<\/span>,\u00a0<\/span>$connection<\/span>); <\/p>\n

<\/span>\/\/include\u00a0the\u00a0class
<\/span>require_once(<\/span>\"\/HTML\/Table.php\"<\/span>); <\/p>\n

<\/span>\/\/set\u00a0table\u00a0attributes
<\/span>$attributes\u00a0<\/span>=\u00a0array(<\/span>\"width\"<\/span>=><\/span>\"100%\"<\/span>,
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\"border\"<\/span>=><\/span>\"1\"<\/span>); <\/p>\n

<\/span>\/\/create\u00a0the\u00a0table\u00a0class
<\/span>$table\u00a0<\/span>=\u00a0new\u00a0<\/span>HTML_Table<\/span>(<\/span>$attributes<\/span>); <\/p>\n

<\/span>\/\/build\u00a0our\u00a0first\u00a0row
<\/span>$contents\u00a0<\/span>=\u00a0array(<\/span>\"Name\"<\/span>,\u00a0<\/span>\"E-Mail\"<\/span>,\u00a0<\/span>\"Phone\u00a0Number\"<\/span>);
<\/span>$attributes\u00a0<\/span>=\u00a0array(<\/span>\"bgcolor\"<\/span>=<\/span>\"#336699\"<\/span>);
<\/span>$table<\/span>-><\/span>addRow<\/span>(<\/span>$contents<\/span>,\u00a0<\/span>$attributes<\/span>,\u00a0<\/span>\"TH\"<\/span>); <\/p>\n

<\/span>\/\/loop\u00a0through\u00a0and\u00a0add\u00a0our\u00a0data
<\/span>$attributes\u00a0<\/span>=\u00a0array(<\/span>\"bgcolor\"<\/span>=<\/span>\"#COCOCO\"<\/span>) <\/p>\n

while(<\/span>$row\u00a0<\/span>=\u00a0<\/span>mysql_fetch_array<\/span>(<\/span>$result<\/span>))\u00a0{
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$contents\u00a0<\/span>=\u00a0array(<\/span>$row<\/span>[<\/span>'name'<\/span>],\u00a0<\/span>$row<\/span>[<\/span>'email'<\/span>],\u00a0<\/span>$row<\/span>[<\/span>'phone'<\/span>]);
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$table<\/span>-><\/span>addRow<\/span>(<\/span>$contents<\/span>,\u00a0<\/span>$attributes<\/span>);
} <\/p>\n

<\/span>$table<\/span>-><\/span>display<\/span>();
<\/span>?>
<\/span> <\/span> <\/code><\/span><\/div>\n

As we can clearly see this approach is much cleaner and more efficient. So lets take a walk through the code and see how it works.<\/div>\n
The first part of the code, which retrieves our database results, remains the same. Next we have a require_once statement to include the Table Class into our current document.<\/div>\n
Next we define the attributes of our table. This can be done by either creating a string of attributes, or creating an associative array of the attributes and values.<\/div>\n

<?php
$attributes\u00a0<\/span>=\u00a0<\/span>\"width=\"100%\"\u00a0border=\"1\"\"<\/span>;\u00a0<\/span>\/\/string\u00a0of\u00a0attributes
<\/span>$attributes\u00a0<\/span>=\u00a0array(<\/span>\"width\"<\/span>=><\/span>\"100%\"<\/span>,\u00a0<\/span>\"border\"<\/span>=><\/span>\"1\"<\/span>);\u00a0<\/span>\/\/array\u00a0of\u00a0attributes
<\/span>?>
<\/span> <\/span> <\/code><\/span><\/div>\n
Now that we have defined the way that we want the table to look we create an instance of the class with our attributes as an argument.<\/div>\n
In the next several lines we create the first line of our table. First we define the contents in an array with each element representing a different cell of the table. Next we define the attributes of that row. Then we use the addRow function to add the row to the table. Note that we use the third argument to set the cell type to be a header. The addRow function has the following attributes:<\/div>\n

<?php
addRow<\/span>(<\/span>$contents\u00a0<\/span>=\u00a0<\/span>null<\/span>,\u00a0<\/span>$attributes\u00a0<\/span>=\u00a0<\/span>null<\/span>,\u00a0<\/span>$type\u00a0<\/span>=\u00a0<\/span>'TD'<\/span>,\u00a0<\/span>$inTR\u00a0<\/span>=\u00a0<\/span>false<\/span>)
<\/span>?>
<\/span> <\/span> <\/code><\/span><\/div>\n
Now that we have a header row, we loop through our database results and add a row to the table for each row of the results.<\/div>\n
Lastly we add use the display() function to output our table.<\/div>\n<\/div>\n

<\/p>\n

\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

Within the current incarnation of (X)HTML tables are the building blocks to well organized and attractive designs. They allow the developer an<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1214","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1214"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1214\/revisions"}],"predecessor-version":[{"id":3118,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1214\/revisions\/3118"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}