function dbGetDataTable($devName, $limit, $page, $links) { $conn = dbConnect(); $query = "SELECT devTableName,devNumOfFields FROM devices WHERE devName='" . $devName . "'"; $result = mysqli_query($conn, $query) or die("impossible to do query1 - getDataTable: " . $query); $devMainInfo = mysqli_fetch_assoc($result); $query = "SELECT * FROM " . $devMainInfo['devTableName'] . " ORDER BY tableLogId DESC"; $paginator = new paginator($conn, $query); $query = $paginator->getPaginatorQuery($limit, $page); $result = mysqli_query($conn, $query) or die("impossible to do query2 - getDataTable: " . $query); if (mysqli_num_rows($result) > 0) { for ($i = 0; $i < mysqli_num_rows($result); $i++) { $dataTableRow = mysqli_fetch_array($result); $myRow['logId'] = $dataTableRow['tableLogId']; $myRow['logDate'] = $dataTableRow['logDate']; $myRow['logTime'] = $dataTableRow['logTime']; $data = array(); for ($j = 0; $j < $devMainInfo['devNumOfFields']; $j++) { $data[] = $dataTableRow[$j + 3]; } $myRow['data'] = $data; $table[] = $myRow; } } else { $conn->close(); return false; } // ['logId'] ['devName']['logDate']['logTime'] ['data'] //table[][] = {logId(tbaleName+tableLogId), devName, logDate, logTime, (array)data} $extraGetParams = "&devName=" . $devName; $table['links'] = $paginator->createLinks($links, 'pagination pagination-sm', $extraGetParams); $conn->close(); return $table; }