<?php
    /**
    * This an example script that uses the datagrid and shows it off, with the slight difference that this
    * example shows code separation so that it can be easily reused (ie the CSS that
    * defines how the datagrid will look is its own file).
    */
    
    /**
    * Include the datagrid code
    */
    require_once('Datagrid.php');
    
    $params['hostname'] = 'localhost';
    $params['username'] = 'root';
    $params['password'] = '';
    $params['database'] = 'phpguru';

    $sql = "SELECT cm_id,
                   ne_title,
                   cm_author,
                   cm_datetime,
                   cm_status,
                   cm_neid
              FROM comments,
                   news
             WHERE cm_status = 'ACTIVE'
               AND cm_neid = ne_id
          ORDER BY cm_id DESC";

    /**
    * Create the datagrid with the connection parameters and SQL query
    * defined above. You don't have to specify an ORDER BY
    * clause - if not then ordering will be disabled.
    */
    $grid = DataGrid::Create($params, $sql);

    /**
    * Disable sorting
    */
    $grid->allowSorting = false;
    
    /**
    * Set the underlying tables cellpadding/spacing
    */
    #$grid->cellpadding = 5;
    #$grid->cellspacing = 5;

    /**
    * Turn the column headers off/on (they're on by default)
    */
    $grid->showHeaders = true;

    /**
    * Sets nice(r) display names instead of the raw column names
    */
    $grid->SetDisplayNames(array('cm_id'       => 'ID',
                                 'ne_title'    => 'Title',
                                 'cm_author'   => 'Author',
                                 'cm_email'    => 'Email',
                                 'cm_datetime' => 'Date & time',
                                 'cm_status'   => 'Status'));

    /**
    * This simply sets the specified columns not to be passed through htmlspecialchars()
    * Generally any column that shows HTML
    */
    $grid->NoSpecialChars('ne_title', 'status', 'actions');
    
    /**
    * Hide the cm_neid column as they're only used for linking purposes
    */
    $grid->HideColumn('cm_neid', 'cm_status');
    
    /**
    * Here just for show. This function sets the number of rows to set per page.
    * The default is 20 so this really is unnecessary.
    */
    $grid->SetPerPage(20);
    
    /**
    * The callback function that adds the extra column
    */
    $grid->AddCallback('RowCallback');

    function RowCallback(&$row)
    {
        $row['actions'] = sprintf('<a href="http://www.phpguru.org/article.php/%d#comment_%d" target="_blank">View</a>', $row['cm_neid'], $row['cm_id']);

        $length = 25;
        if (strlen($row['ne_title']) > $length) {
            $row['ne_title'] = substr($row['ne_title'],0, 25) . '...';
        }

        $row['ne_title'] = sprintf('<a href="/article.php/%d" target="_blank" title="%s">%s</a>', $row['cm_neid'], $row['ne_title'], $row['ne_title']);
    }
    
    /**
    * The HTML. The appearance can be customised using CSS. Naturally you would (should) put
    * all of the datagrid styling in a central CSS file that can be <link>ed to by all of
    * your websites' pages. That way:
    *  o All of your datagrids will look the same
    *  o Changes to the appearance will affect all of your datagrids across your
    *    entire website. You might not want this necessarily, but might.
    *
    * eg. <link rel="stylesheet" type="text/css" media="screen" href="/css/datagrid.css" />
    */
    require('example8.html');
?>