<pre class="highlight">
&lt;?php
/**
* products.php
* Artzy page to show products
*
* @author Ed Parrish
* @version 1.1 05/09/08
*/
ob_start();
require(&quot;includes/db.php&quot;);

main(&quot;Artzy Products&quot;);

// Control the operation of a page
function main($title = &quot;&quot;) {
    include(&quot;includes/header.php&quot;);
    showContent($title);
    include(&quot;includes/footer.php&quot;);
}

// Display the content of a page
function showContent($title) {
    $db = new DB();
    $sql = &quot;
        SELECT ID, ProductName, ProductDescription, Path2Image, Price
        FROM products
        &quot;;
    $result = $db-&gt;query($sql);
    echo &quot;&lt;h1&gt;$title&lt;/h1&gt;\n&quot;;
    echo &quot;&lt;table width=\&quot;100%\&quot;&gt;\n&quot;;
    showCartLink();
    showHeading();
    while ($row = mysql_fetch_row($result)) {
        list($id, $prodName, $description, $imagePath, $price) = $row;
        $price = &quot;$&quot;.number_format($price, 2);
        showItem($id, $prodName, $description, $imagePath, $price);
    }
    showCartLink();
    echo &quot;&lt;/table&gt;\n&quot;;
}

// Display the table heading
function showHeading() {
    echo &lt;&lt;&lt;HTML
&lt;tr&gt;
  &lt;td bgcolor=&quot;blue&quot;&gt;
    &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;white&quot;&gt;
      &amp;nbsp;&lt;b&gt;Image&lt;/b&gt;&amp;nbsp;
    &lt;/font&gt;
  &lt;/td&gt;
  &lt;td bgcolor=&quot;blue&quot;&gt;
    &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;white&quot;&gt;
      &amp;nbsp;&lt;b&gt;Product&lt;/b&gt;
    &lt;/font&gt;
  &lt;/td&gt;
  &lt;td bgcolor=&quot;blue&quot;&gt;
    &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;white&quot;&gt;&amp;nbsp;&lt;b&gt;Price&lt;/b&gt;&amp;nbsp;&lt;/font&gt;
  &lt;/td&gt;
  &lt;td bgcolor=&quot;blue&quot;&gt;
    &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;white&quot;&gt;&amp;nbsp;&lt;b&gt;Description&lt;/b&gt;&lt;/font&gt;
  &lt;/td&gt;
  &lt;td bgcolor=&quot;blue&quot; width=&quot;150&quot;&gt;
    &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;white&quot;&gt;&amp;nbsp;&lt;b&gt;Buy&lt;/b&gt;&lt;/font&gt;
  &lt;/td&gt;
&lt;/tr&gt;

HTML;
}

// Display each table item
function showItem($id, $prodName, $description, $imagePath, $price) {
    echo &lt;&lt;&lt;HTML
&lt;tr&gt;
  &lt;td&gt;
    &lt;img src=&quot;images/$imagePath&quot; width=50 align=&quot;top&quot;&gt;
  &lt;/td&gt;
  &lt;td&gt;
    &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;black&quot;&gt;$prodName&lt;/font&gt;
  &lt;/td&gt;
  &lt;td&gt;
      &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;black&quot;&gt;$price&lt;/font&gt;
  &lt;/td&gt;
  &lt;td width=&quot;50%&quot; height=&quot;25&quot;&gt;
      &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;black&quot;&gt;$description&lt;/font&gt;
  &lt;/td&gt;
  &lt;td&gt;
      &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;black&quot;&gt;
          &lt;a href=&quot;cart.php?add=$id&amp;qty=1&quot;&gt;Add Item&lt;/a&gt;
      &lt;/font&gt;
  &lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
  &lt;td width=&quot;100%&quot; colspan=&quot;5&quot;&gt;
    &lt;hr size=&quot;1&quot; color=&quot;red&quot; noshade&gt;
  &lt;/td&gt;
&lt;/tr&gt;

HTML;
}

// Display a link to the shopping cart as a table item
function showCartLink() {
    echo &lt;&lt;&lt;HTML
&lt;tr&gt;
  &lt;td colspan=&quot;5&quot;&gt;
    &lt;font face=&quot;verdana&quot; size=&quot;2&quot; color=&quot;black&quot;&gt;
      &lt;a href=&quot;cart.php&quot;&gt;View Shopping Cart &amp;gt;&amp;gt;&lt;/a&gt;
    &lt;/font&gt;
  &lt;/td&gt;
&lt;/tr&gt;

HTML;
}

?&gt;
</pre>