Turėtų būti kažkas tokio, pasitvarkyk dar pagal save.
<?php
// Connects to MySQL server & selects database
$cfg['mysql_connect'] = mysql_connect("127.0.0.1", "#", "#") or die(mysql_error());
mysql_select_db("#", $cfg['mysql_connect']) or die(mysql_error());
// Configuration
$cfg['rows_per_page'] = 15;
$tmp['page'] = 1;
if (isset($_GET['page'])) {
$tmp['page'] = $_GET['page'];
}
$tmp['offset'] = ($tmp['page'] - 1) * $cfg['rows_per_page'];
// Shows data from MySQL
$tmp['mysql_query'] = mysql_query("SELECT * FROM lentele ORDER BY kiek_atsisiunte DESC LIMIT ". $tmp['offset'] .", ". $cfg['rows_per_page'] ."", $cfg['mysql_connect']) or die(mysql_error());;
while ($tmp['data'] = mysql_fetch_array($tmp['mysql_query'])) {
echo "<a href=\"http://www.bestelectro.lt/daina.php?i=&dainos_id=". $tmp['data']['download_url'] ."\">". $tmp['data']['pavadinimas'] ." (Atsisiųsta: ". $tmp['data']['kiek_atsisiunte'] .")</a><br />";
}
// Shows links to pages
$tmp['mysql_query'] = mysql_query("SELECT * FROM lentele", $cfg['mysql_connect']) or die(mysql_error());
$tmp['number_of_rows'] = mysql_num_rows($tmp['mysql_query']);
$tmp['pages'] = ceil($tmp['number_of_rows'] / $cfg['rows_per_page']);
if ($tmp['page'] > 1) {
$tmp['page_fl'] = $tmp['page'] - 1;
echo "<a href=\"". $_SERVER['PHP_SELF'] ."?page=1\">[First]</a>";
echo "<a href=\"". $_SERVER['PHP_SELF'] ."?page=". $tmp['page_fl'] ."\">[Previous]</a>";
}
if ($tmp['page'] < $tmp['pages']) {
$tmp['page_fl'] = $tmp['page'] + 1;
echo "<a href=\"". $_SERVER['PHP_SELF'] ."?page=". $tmp['page_fl'] ."\">[Next]</a>";
echo "<a href=\"". $_SERVER['PHP_SELF'] ."?page=". $tmp['pages'] ."\">[Last]</a>";
}
// Closes MySQL connection
mysql_close($cfg['mysql_connect']);
?>
Bestelectro sureagavo į Unstoppable Sukurkit koda