/** * 按指定参数以分页的模式的读取数据 * */ function readTable($page_now, $page_per, $page_url, $from_where, $order_by = '', $fd_list = '*') { function pageLinks($page_num, $page_now, $page_url, $link_num = 5) { if ($page_num <= 1) { return ''; } $page_url .= strpos($page_url, '?') ? '&page=' : '?page='; $page_prev = $page_now > 1 ? $page_now - 1 : 1; $page_next = $page_now < $page_num ? $page_now + 1 : $page_num; $a = $page_now - ceil($link_num / 2); if ($a < 1) { $a = 1; } $b = $a + $link_num > $page_num ? $page_num : $a + $link_num; $a = $b - $link_num; if ($a < 1) { $a = 1; } //数据显示 $str = '<li class="pages"><a href="' . $page_url . $page_prev . '">上一页</a> 第 '; for ($i = $a; $i <= $b; $i++) { if ($i == $page_now) { $str .= ' <strong style="color: rgb(189, 0, 0);">' . $i . '</strong> '; } else { $str .= ' <a href="' . $page_url . $i . '">' . $i . '</a> '; } } $str .= ' 页 共1' . $page_num . '页 <a href="' . $page_url . $page_next . '">下一页</a>'; return $str; } $from_where = str_replace('{prefix}', $GLOBALS['dbTablePre'], $from_where); //分页 $tmp = $GLOBALS['_MooClass']['MooMySQL']->getOne('SELECT COUNT(*) N ' . $from_where); $item_num = $tmp['N']; $page_num = ceil($item_num / $page_per); if ($page_now > $page_num) { $page_now = $page_num; } if ($page_now < 1) { $page_now = 1; } $page_links = pageLinks($page_num, $page_now, $page_url); //读数据 $start = ($page_now - 1) * $page_per; $sql = "SELECT {$fd_list} {$from_where} {$order_by} LIMIT {$start}, {$page_per}"; $question_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql); return array('count' => $item_num, 'page_links' => $page_links, 'list' => $question_list); }
} // For determining total no of rows $where .= " 1=1 "; $_SESSION['filter_query'] = $where; $db->select('tbl_brokermaster', $where); $totalrows = $db->getnumRows(); // Now for pagination $recordstart = 0; $pagesize = isset($_SESSION['pagesize']) ? $_SESSION['pagesize'] : 5; $orderby = isset($_SESSION['orderby']) ? $_SESSION['orderby'] : "order by sBrokerName"; $where .= " {$orderby} limit {$recordstart} ,{$pagesize} "; $brokers = $db->select('tbl_brokermaster', $where); $totalpages = ceil($totalrows / $pagesize); $currentpage = $recordstart / $pagesize + 1; if (!($db->getnumRows() == 1)) { foreach ($brokers as $broker) { $html .= $userTools->renderBroker($broker); } } else { $html .= $userTools->renderBroker($brokers); } // Now for pagination links if ($brokers) { $html .= '<div class="pagination">'; $html .= pageLinks($totalpages, $currentpage, $pagesize, "recordstart", "brokers.php"); $html .= "</div>"; echo $html; } else { echo "No Brokers Found."; } }
<td bgcolor="' . $color . '"><a href="admin_events_edit.php?spelning=' . $row['rowid'] . '">' . $row['artist'] . '</a></td> <td bgcolor="' . $color . '"><a href="admin_events_edit.php?spelning=' . $row['rowid'] . '">' . $row['lokal'] . '</a></td> <td bgcolor="' . $color . '"><a href="admin_events_edit.php?spelning=' . $row['rowid'] . '">' . $row['stad'] . '</a></td> <td bgcolor="' . $color . '"><a href="admin_events_action.php?action=remove&id=' . $row['rowid'] . '"><img src="graphics/remove.jpg" alt="Ta bort" border="0" width="10"/></a></td> </tr>'; $rad++; } ?> </table> </form> <br /> <?php //alla aktuella $query_all = "select * from spelningar WHERE stad LiKE '" . $city . "' AND artist LIKE '" . $artist . "' AND lokal LIKE '" . $place . "' AND datum LIKE '" . $date . "' "; $result_all = mysql_query($query_all); $totalrows = mysql_num_rows($result_all); $totalpages = ceil($totalrows / $pagesize); $currentpage = $recordstart / $pagesize + 1; if ($recordstart > 0) { $prev = $recordstart - $pagesize; $url = $_SERVER['PHP_SELF'] . "?recordstart={$prev}&date={$date}&city={$city}&place={$place}&artist={$artist}"; echo '<a href="' . $url . '"> Föregående</a> '; } if ($totalrows > $recordstart + $pagesize) { $next = $recordstart + $pagesize; $url = $_SERVER['PHP_SELF'] . "?recordstart={$next}&date={$date}&city={$city}&place={$place}&artist={$artist}"; echo ' <a href="' . $url . '">Nästa </a>'; } //paging echo '<p>Sidor: ' . pageLinks($totalpages, $currentpage, $pagesize, "recordstart", $date, $place, $city, $artist) . '</p>'; include "admin_footer.php";
$result_all = mysql_query($query_all); $totalrows = mysql_num_rows($result_all); $totalpages = ceil($totalrows / $pagesize); $currentpage = $recordstart / $pagesize + 1; if ($recordstart > 0) { $prev = $recordstart - $pagesize; $url = $_SERVER['PHP_SELF'] . "?recordstart={$prev}&category={$category}"; echo '<a href="' . $url . '">Previous page</a> '; } if ($totalrows > $recordstart + $pagesize) { $next = $recordstart + $pagesize; $url = $_SERVER['PHP_SELF'] . "?recordstart={$next}&category={$category}"; echo ' <a href="' . $url . '">Next page</a>'; } //paging echo '<p>Pages: ' . pageLinks($totalpages, $currentpage, $pagesize, "recordstart", $category) . '</p>'; ?> </div> <?php if (isset($_GET['id'])) { ?> <div id="info"> <table > <tr> <td><?php $query = "select * from bilder where id='" . $_GET['id'] . "'"; $result = mysql_query($query); while ($rad = mysql_fetch_assoc($result)) { // för att få ut id från visitor
" class="button medium blue">Find out more</a> </span> </div> <div class="clearfix"></div> </div> <?php } else { foreach ($brokers as $broker) { //$broker_id = $broker['nBrokerID']; echo $userTools->renderBroker($broker); } } ?> <div class="pagination pagination-centered"> <?php echo pageLinks($totalpages, $currentpage, $pagesize, "recordstart"); ?> </div> </div> <div class="alert alert-warning"><i class="icon icon-warning-sign"></i> <strong>Disclaimer.</strong> We can not guarantee that the information on this page is 100% correct. If you think that any information for the brokers is wrong or missing, please <a href="contact_us.php">contact us</a>. <br/>Some company and product names, logos on this site may be trademarks or registered trademarks of individual companies and are respectfully acknowledged.</div> </div> <div id="side_wrap" class="span2"> <form action="" method="post"> <div class="controls"> <p><a href="compare.php" class="btn btn-primary">COMPARE</a></p> View Brokers: <select name="lstPageSize" id="lstPageSize"> <option value="5">5 per page</option>
function get_paged_footer($href, $entriesperpage, $pageCount, $pagenumbers) { $field = "\t\t\t</div>\n\t\t\t\t\t\t<div id='shipon_pages'>\n\t\t\t\t\t\t\t<span id='shipon_prev_links'>" . prevPageLink($href, $entriesperpage, $pageCount) . "</span>\n\t\t\t\t\t\t\t<span id='shipon_page_links'>" . pageLinks($href, $pagenumbers, $entriesperpage, $pageCount) . "</span>\n\t\t\t\t\t\t\t<span id='shipon_next_links'>" . nextPageLink($href, $entriesperpage, $pageCount) . "</span>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t</div>"; return $field; }
$result_all = mysql_query($query_all) or die(mysql_error()); $totalrows = mysql_num_rows($result_all); $totalpages = ceil($totalrows / $pagesize); $currentpage = $recordstart / $pagesize + 1; if ($recordstart > 0) { $prev = $recordstart - $pagesize; $url = $_SERVER['PHP_SELF'] . "?recordstart_thumb={$prev}&song_id=" . $_GET['song_id'] . ""; echo '<a href="' . $url . '">Previous page</a> '; } if ($totalrows > $recordstart + $pagesize) { $next = $recordstart + $pagesize; $url = $_SERVER['PHP_SELF'] . "?recordstart_thumb={$next}&song_id=" . $_GET['song_id'] . ""; echo ' <a href="' . $url . '">Next page</a>'; } //paging echo '<p>Pages: ' . pageLinks($totalpages, $currentpage, $pagesize, "recordstart_thumb", $_GET['song_id']) . '</p>'; ?> <td> </tr> </table></td> </tr> </tr> <tr> <td><input type="submit" value="update" name="action"/> </td> <td><input type="submit" value="remove" name="action"/></td> </tr> </table> <input name="song_id" type="hidden" value="<?php echo $_GET['song_id']; ?>
?> "> <?php if ($recordstart > 0) { $prev = $recordstart - $pagesize; $url = $_SERVER['PHP_SELF'] . "?recordstart_thumb={$prev}"; echo '<a href="' . $url . '">Previous page</a> '; } if ($totalrows > $recordstart + $pagesize) { $next = $recordstart + $pagesize; $url = $_SERVER['PHP_SELF'] . "?recordstart_thumb={$next}"; echo ' <a href="' . $url . '">Next page</a>'; } //paging echo '<p>Pages: ' . pageLinks($totalpages, $currentpage, $pagesize, "recordstart_thumb", $author) . '</p>'; ?> Ingen <input name="thumbnail" type="radio" value="" /> <td> </tr> </table> </td> </tr> <tr> <td>Välj mp3-låt (max 8000kb):</td> <td><input name="userfile" type="file"/></td> </tr> <tr> <td>Titel</td> <td><input name="title" type="text"/></td>
<?php } ?> </td> </tr> <?php } // End for loop ?> </table> </div> <div id="tableBottom"> <div> <?php pageLinks($config, $startRange, $demoCount, $sortDirection, $sortBy); ?> </div> </div> </div> <?php } // End demolist count if ?> </body> </html> <?php function uploadFile($filename, $tempName, $config, $demoQueries) {
</form> </td> <?php } ?> </tr> <?php } // End for loop ?> </table> </div> <div id="tableBottom"> <div> <?php pageLinks($config, $startRange, $banCount, $sortDirection, $sortBy, $searchText, $bansFilter, $bansReason_id, $bansAdmin, $LANGUAGE, $LAN_BANLIST_056, $LAN_BANLIST_057); ?> </div> </div> </div> <h5><?php echo $LAN_BANLIST_042; ?> </h5> <br/> <?php $banCountVigentes = $banQueries->getNumberOfBans($member, $admin, $banManager, $fullPower, "", "4", "", ""); ?> <div class="tborder"> <div id="tableHead">
</td> <?php } ?> </tr> <?php } // End for loop ?> </table> </div> <div id="tableBottom"> <div> <?php pageLinks($config, $startRange, $ipCount); ?> </div> </div> </div> <h5><img src="images/bullet_star.png" /> <?php echo $LANIPBAN_006; ?> </h5> <br/> <?php // Only display if there are bans if (count($bannedIps) > 0) { ?> <div class="tborder"> <div id="tableHead">