PHP pageLinks Examples

Example #1

File: function.php Project: noikiy/zays

/**
 * 按指定参数以分页的模式的读取数据 
 * */
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>&nbsp;&nbsp;&nbsp;&nbsp;第&nbsp;';
        for ($i = $a; $i <= $b; $i++) {
            if ($i == $page_now) {
                $str .= '&nbsp;<strong style="color: rgb(189, 0, 0);">' . $i . '</strong>&nbsp;';
            } else {
                $str .= '&nbsp;<a href="' . $page_url . $i . '">' . $i . '</a>&nbsp;';
            }
        }
        $str .= '&nbsp;页&nbsp;&nbsp;共1' . $page_num . '页&nbsp;&nbsp;<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);
}

Example #2

File: ajax_filterbrokers.php Project: rajasegar/brokerarena

    }
    // 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.";
    }
}

Example #3

File: admin_events.php Project: rocafuerte/opus

<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&ouml;reg&aring;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&auml;sta </a>';
}
//paging
echo '<p>Sidor: ' . pageLinks($totalpages, $currentpage, $pagesize, "recordstart", $date, $place, $city, $artist) . '</p>';
include "admin_footer.php";

Example #4

File: admin_upload_thumb.php Project: rocafuerte/opus

$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&ouml;r att f&aring; ut id fr&aring;n visitor

Example #5

File: brokers.php Project: rajasegar/brokerarena

" 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>

Example #6

File: parser.php Project: kamalspalace/_CORE

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;
}

Example #7

File: admin_song_edit_popup.php Project: rocafuerte/opus

    $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'];
    ?>

Example #8

File: admin_upload_songs.php Project: rocafuerte/opus

?>
">
                        
                        <?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&auml;lj mp3-l&aring;t (max 8000kb):</td>
    <td><input name="userfile" type="file"/></td>
  </tr>
    <tr>
    <td>Titel</td>
    <td><input name="title"  type="text"/></td>

Example #9

File: demos.php Project: googlecode-mirror/globalban-spanish

            <?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)
{

Example #10

File: banlist.php Project: googlecode-mirror/globalban-spanish

            </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">

Example #11

File: ipbanlist.php Project: googlecode-mirror/globalban-spanish

          </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">