table_functions.php

//returns datatable from database result set with params.:database query, table id, css class, and dabase class
function render_datatable($data_query, $id, $class, $database) {
$pdo = $database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = $pdo->prepare($data_query);
$query->execute();
$tableheader = false;
echo '<table id="'.$id.'" class="'.$class.'" style = "margin: 0 !important; width:100% !important" >';
foreach ($query->fetchAll(PDO::FETCH_ASSOC) as $row) {
if($tableheader === false) {
render_tablehead($row);
// render_tablefoot($row);
$tableheader = true;
}
render_tablebody($row);
}
echo "</tbody></table>";
$database::disconnect();
}
//returns table header
function render_tablehead($row){
echo '<thead><tr>';
foreach($row as $key => $val) {
echo "<th>$key</th>";
}
echo '</tr></thead>';
}
//returns table body
function render_tablebody($row){
echo "<tr>";
foreach($row as $value) { echo "<td>$value</td>"; }
echo "</tr>";
}
//returns table foot
function render_tablefoot($row){
echo '<tfoot ><tr>';
foreach($row as $key => $val) {
echo "<th>$key</th>";
}
echo '</tr></tfoot>';
echo '<tbody>';
}