Example #1
0
$rows_per_page = 10;
$self = $_SERVER["PHP_SELF"];
$total_rows = 0;
try {
    $db = new rdb("", "", "", true);
} catch (Exception $e) {
    $messages = $e->getMessage();
    if (empty($messages) === false) {
        die(sprintf(HTML_LAYOUT, $self, $messages));
    }
}
try {
    $records = $db->read(SQL_SELECT_RECORDS_ALL);
    $total_rows = count($records);
    $paginator = new Pagination($page, $row, $rows_per_page, $total_rows, $self);
    $paginator->get_arguments();
    $data = array(":" . KEY_BEGIN => $paginator->current_row, ":" . KEY_END => $paginator->rows_per_page);
    $records = $db->read(SQL_SELECT_RECORDS_PAGINATED, $data);
    $content = sprintf(HTML_PAGE_HEADER, $paginator->current_page, $paginator->last_page);
    $table_headers = sprintf(HTML_TABLE_TH_RIGHT, KEY_ID);
    $table_headers .= sprintf(HTML_TABLE_TH_RIGHT, KEY_NUMBER_DECIMAL);
    $table_headers .= sprintf(HTML_TABLE_TH_RIGHT, KEY_NUMBER_INTEGER);
    $table_headers .= sprintf(HTML_TABLE_TH, KEY_STRING_SIXTYFOUR);
    $table_headers = sprintf(HTML_TABLE_TR, $table_headers);
    $table_rows = "";
    if (empty($records) === false) {
        foreach ($records as $index => $record) {
            $table_row = sprintf(HTML_TABLE_TD_RIGHT, $record[KEY_ID]);
            $table_row .= sprintf(HTML_TABLE_TD_RIGHT, $record[KEY_NUMBER_DECIMAL]);
            $table_row .= sprintf(HTML_TABLE_TD_RIGHT, $record[KEY_NUMBER_INTEGER]);
            $table_row .= sprintf(HTML_TABLE_TD, $record[KEY_STRING_SIXTYFOUR]);