Example #1
0
                die(print_r(sqlsrv_errors(), true));
            } elseif ($rowsReturned == 0) {
                echo "No rows returned.";
                exit;
            } else {
                $numOfPages = ceil($rowsReturned / $rowsPerPage);
            }
            $pageNum = isset($_GET['pageNum']) ? $_GET['pageNum'] : 1;
            $page = Pagination::getPage($stmt, $pageNum, $rowsPerPage);
            foreach ($page as $row) {
                $studentPageLink = "/Admin/Archive/Students/ViewStudent/?studentID={$row['5']}";
                echo "<tr><td>{$row['0']}</td><td><a href='{$studentPageLink}'>{$row['1']}</a></td><td>{$row['2']}</td><td>{$row['3']}</td><td>{$row['4']}</td></tr>";
            }
            echo "</tbody></table>";
            $modulator = 3;
            Pagination::pageLinksArchiveWorksheet($numOfPages, $pageNum, $rowsPerPage, $rowsReturned, $modulator, $courseID, $worksheetNum);
            ?>

                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
            <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
            <!-- Include all compiled plugins (below), or include individual files as needed -->
            <script src="/js/bootstrap.min.js"></script>
            <script>
            $("#menu-toggle").click(function(e) {