
<?php
    /**
    * This an example script that uses the datagrid and shows it off
    */
    
    /**
    * Include the datagrid code
    */
    require_once('Datagrid.php');

    /**
    * Make sure errors are turned on
    */
    ini_set('display_errors', 1);
    error_reporting(E_ALL);

    
    $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 ne_id DESC";

    /**
    * Create the datagrid with the connection parameters and SQL query
    * defined above. You MUST specify an ORDER BY
    * clause (with ASC/DESC direction indicator) - if not then ordering
    * will be fubar. I will eventually fix this so that the headers
    * aren't clickable if you don't supply an ORDER BY, for the time
    * being just specify an ORDER BY clause (the one you specify will
    * be used by default).
    */
    $grid = DataGrid::Create($params, $sql);

    /**
    * Turn the column headers off/on
    */
    $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');
    
    /**
    * Hide the cm_neid column as it's 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.
    */
    $grid->SetPerPage(15);
    
    /**
    * This is the callback that colours the text red or green
    */
    $grid->AddCallback('RowCallback');

    function RowCallback(&$row) // The ampersand is so that any changes made are reflected in the final grid
    {
        $row['status']   = ($row['cm_status'] == 'ACTIVE' ? '<img src="/images/tick.gif" width="13" height="12" />' : '<img src="/images/cross.gif" width="13" height="12" />');
        $row['ne_title'] = sprintf('<a href="/article.php/%d" target="_blank">%s</a>', $row['cm_neid'], $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" />
    */
?>
<html>
<head>
    <title>Datagrid example</title>
    
    <style type="text/css">
    <!--
        .datagrid thead th {
            font-family: Monospace;
            text-align: left;
            padding-left: 5px;
            font-size: 10pt;
            border-top: 1px solid #666;
            border-bottom: 1px solid #666;
        }
        
        /**
        * Hide the footer - kinda pointless because the tfoot contains the page controls,
        * but it's just here as an example.
        */
        .datagrid tfoot {
            display: none;
        }
        
        .datagrid thead th.col_0 {
            border-left: 1px solid #666;
        }
        
        .datagrid thead th.col_3 {
            border-right: 1px solid #666;
        }
        
        .datagrid tbody td {
            padding-left: 5px;
            padding-right: 5px;
            font-family: Monospace;
        }
        
        .datagrid tfoot td {
            font-family: Monospace;
        }
        
        .datagrid tbody td a {
            text-decoration: none;
        }
        
        .datagrid tbody td.col_1,
        .datagrid tbody td.col_3,{
            background-color: #eee;
        }
        
        .datagrid thead th.col_0,
        .datagrid thead th.col_1,
        .datagrid thead th.col_2,
        .datagrid thead th.col_3,
        .datagrid thead th.col_4 {
            background-color: #FFAE1A;
            filter: progid:DXImageTransform.Microsoft.gradient(GradientType=0, startColorstr=#ffffff, endColorstr=orange);
        }
        
        .datagrid thead th a {
            text-decoration: none;
        }
    // -->
    </style>
</head>
<body>
    <h1>Example 3</h1>

    <p>
        In Firefox this datagrid will have orange headers, whilst in MSIE it will have graduated (white > orange) headers.
    </p>
    <?$grid->Display()?>
</body>
</html>