[Class] MakeTable

• extract the files in the maketable.zip file to /assets/snippets/maketable/
• I used some make believe tables for this example, so you’ll need to create your own snippet based on the maketable.example.snippet.txt file that is included to query data from your own database tables
• don’t forget to include the call to your snippet and the placeholder you assign the output to (unless you decide to just return the value from your snippet) somewhere in your template/document content/TV’s, e.g.

...
[[MyTableSnippet]]
<div id="tableContainer">[+myTablePlaceholder+]</div>
...

• refer to the comments I’ve included in the example snippet and class files, and feel free to modify and use these however you want to

Comments and questions welcome.

... and ... an empty Webpage no result-table, hmmm... SQL checked by MySQLAdmin, where is the result?

« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table ’emanz_modx.subindustries’ doesn’t exist »
SQL: SELECT i.*, COUNT(DISTINCT aoe.id) AS area_count FROM modx_courses i LEFT JOIN subindustries si ON si.industry_id = i.id GROUP BY i.id ORDER BY id DESC LIMIT 0, 25

// execute the main table query with MakeTable sorting and paging features
$query= "SELECT i.*, COUNT(DISTINCT aoe.id) AS area_count " .
		"FROM modx_courses i " .
		"LEFT JOIN subindustries si ON si.industry_id = i.id " .
		"GROUP BY i.id" . $objTable->handleSorting() . $objTable->handlePaging();
if ($ds= $this->db->query($query)) {

Looks like a very useful class. Do you have any more examples of how it is used? I’d really like to see how the different functions are used. Good job!