Support/Comments for MakeTable

 features
if ($ds= $this->db->query($query)) {
	// if the query was successful, build our table array from the rows
	while ($row= $this->db->getRow($ds)) {
		$industries[]= array(
			'Code'=> stripslashes($row['Code']),
			'Start'=> stripslashes($row['Start']),
			'Start'=> stripslashes($row['Start']),
                        'End'=> stripslashes($row['End']),
                        'Course'=> stripslashes($row['Course']),
                        'Location'=> stripslashes($row['Location']),
		);
	}
}

// make sure our query of industries has returned rows
if (is_array($industries)) {
	// create the table header definition with each header providing a link to sort by that field
	$industryTableHeader= array(
		'Code'=> $objTable->prepareOrderByLink('Code', 'Code'),
		'Start'=> $objTable->prepareOrderByLink('Start', 'Start'),
		'End'=> $objTable->prepareOrderByLink('End', 'End'),
		'Course'=> $objTable->prepareOrderByLink('Course', 'Course'),
		'Location'=> $objTable->prepareOrderByLink('Location', 'Location'),
	);

/**
 * Example snippet using the MakeTable class.
 */

// Check if the class already exists (for multiple usage per page)
if (!class_exists('MakeTable')) {
	// load the MakeTable class
	include $modx->config['base_path'] . "assets/snippets/maketable/maketable.class.php";
}

// Check for number of records per page preferences and define global setting
// TODO: need to change this so you can use pagination with multiple instances per page
//  Currently, you can only use pagination and sorting with one instance per page
//  but you can present multiple instances without these options
if (is_numeric($_GET['pageSize'])) {
	setcookie("pageSize", $_GET['pageSize'], time() + 3600000);
	$maxPageSize= $_GET['pageSize'];
} else {
	if (is_numeric($_COOKIE['pageSize'])) {
		$maxPageSize= $_COOKIE['pageSize'];
	} else {
		$maxPageSize= 25;
	}
}
define('MAX_DISPLAY_RECORDS_NUM', $maxPageSize);

// Instantiate a new instance of the MakeTable class
$objTable= new MakeTable();

$industries= false;
 
// query the total number of possible records for the table
$query= "SELECT COUNT(id) FROM modx_courses";
$numRecords= $this->db->getValue($query);

// execute the main table query with MakeTable sorting and paging features
if ($ds= $this->db->query($query)) {
	// if the query was successful, build our table array from the rows
	while ($row= $this->db->getRow($ds)) {
		$industries[]= array(
			'Code'=> stripslashes($row['Code']),
			'Start'=> stripslashes($row['Start']),
			'Start'=> stripslashes($row['Start']),
                        'End'=> stripslashes($row['End']),
                        'Course'=> stripslashes($row['Course']),
                        'Location'=> stripslashes($row['Location']),
		);
	}
}

// make sure our query of industries has returned rows
if (is_array($industries)) {
	// create the table header definition with each header providing a link to sort by that field
	$industryTableHeader= array(
		'Code'=> $objTable->prepareOrderByLink('Code', 'Code'),
		'Start'=> $objTable->prepareOrderByLink('Start', 'Start'),
		'End'=> $objTable->prepareOrderByLink('End', 'End'),
		'Course'=> $objTable->prepareOrderByLink('Course', 'Course'),
		'Location'=> $objTable->prepareOrderByLink('Location', 'Location'),
	);
	
	// set the field to be appended as a query string parameter to cell/link actions
	$objTable->setActionFieldName('id');
	
	// set table styling options
	$objTable->setTableClass('industryTable');
	$objTable->setRowHeaderClass('headerRow');
	$objTable->setRowRegularClass('regRow');
	$objTable->setRowAlternateClass('altRow');
	
	// generate the paging navigation controls
	$objTable->createPagingNavigation($numRecords);
	
	// generate the table output and assign to a variable
	$industryTable = $objTable->create($industries, $industryTableHeader);
} else {
	// send a message that no results were found
	$industryTable = '<p>No industry records were found.</p>';
}

// output the table content to a placeholder
// NOTE: you could just as easily return $industryTable if you prefer
$modx->setPlaceholder('industryTable', $industryTable);

Code   Start    End   Course   Location
25 per page
Go to page: