katsarov – Web Development

.pages {
    padding: 1em;
    margin-top: 10px;
    margin-bottom: 10px;
    margin-left: 70px;
    clear: left;
    font-size: 85%;
} 
 
.pages a, .pages span {
    display: block;
    float: left;
    padding: 0.2em 0.5em;
    margin-right: 0.1em;
    border: 1px solid #fff;
    background: #fff;
} 
 
.pages span.current {
    border: 1px solid #2E6AB1;
    font-weight: bold;
    background: #2E6AB1;
    color: #fff;
} 
 
.pages a {
    border: 1px solid #9AAFE5;
    color: #2E6AB1;
    text-decoration: none;
}
.pages a:visited {
    color: #2E6AB1;
} 
 
.pages a:hover {
    border-color: #2E6AB1;
} 
 
.pages a.nextprev {
    font-weight: bold;
} 
 
.pages span.nextprev {
    color: #666666;
} 
 
.pages span.nextprev {
        border: 1px solid #dddddd;
        color: #999999;
}

$offset = $_GET['offset'];
/// Limit of the data displayed per page
$limit = 15;
// getting number of rows
$total = mysql_fetch_array(mysql_query('SELECT COUNT(id)
FROM countries AS total'));
 
?>

(!$offset ? $start = 0 : $start = $offset);
?>

$query = mysql_query("SELECT * FROM countries
ORDER BY id LIMIT $start, $limit ")
or die('Query failed: ' . mysql_error());
?>

while ($row = mysql_fetch_array($query)) {
    echo $row['country_name'];
    echo '';
}
?>

if ($total[0] > $limit) {
  $paginas = ceil(($total[0]/$limit));
 
?>

if($offset <= '0'){
    ?>
    <span class="nextprev">« Previous</span>
    } else {
//else if we have previous pages show link 'Previous'
    echo '<a href="http://katsarov.seloto.net/wp-admin/?offset=%27%20.%20%28$offset%20-%20$limit%29%20.%20%27">
« Previous</a>';
} ?&gt;

for ($i = 0; $i < ($paginas); $i++) {
  if ($i+1 == (($offset/$limit)+1) ) {
  //if its current page don't show link
      ?>
 
        } else {
  //else if its not current page show link
  ?>
   <a href="http://katsarov.seloto.net/wp-admin/?offset=%3C?php%20echo%20$i%20*%20$limit;%20?%3E"></a>
  } ?&gt;

if($offset >= ($total['0'] - $limit)){
    ?>
    <span class="nextprev">Next »</span>
    } else {
//else if we have next pages show 'Next' with link
    echo '<a href="http://katsarov.seloto.net/wp-admin/?offset=%27%20.%20%28$offset%20+%20$limit%29%20.%20%27">
Next »</a>';
} ?&gt;

// Database Connection Config
$dbhost = "localhost"; // database host
$dbuser = "root"; // database user
$dbpass = "dbpass"; // database pass
$dbname = "dbname"; // database name 
 
// Database Connection
$db_connect = mysql_connect($dbhost, $dbuser, $dbpass);
if (!$db_connect) {
    die('Could not connect: ' . mysql_error());
}
else {
    mysql_select_db($dbname);
}
$offset = $_GET['offset'];
/// Limit of the data displayed per page
$limit = 15;
// getting number of rows
$total = mysql_fetch_array(mysql_query('SELECT
COUNT(id) FROM countries AS total')); 
 
(!$offset ? $start = 0 : $start = $offset);
// database query
$query = mysql_query("SELECT * FROM countries
ORDER BY id LIMIT $start, $limit ")
or die('Query failed: ' . mysql_error());
//showng query in circle
while ($row = mysql_fetch_array($query)) {
    echo $row['country_name'];
    echo '';
}
//end showing query
if ($total[0] > $limit) {
  $paginas = ceil(($total[0]/$limit)); 
 
  if (!$offset) {
   $comeco = 0;
  } else {
   $comeco = $offset;
  }
?>
<p class="pages">//if we don't have previous pages show only style without link
if($offset &lt;= '0'){
    ?&gt;
    <span class="nextprev">« Previous</span>
    } else {
//else if we have previous pages show link 'Previous'
    echo '<a href="http://katsarov.seloto.net/wp-admin/?offset=%27%20.%20%28$offset%20-%20$limit%29%20.%20%27">
« Previous</a>';
}
//circle that shows pages
  for ($i = 0; $i &lt; ($paginas); $i++) {
  if ($i+1 == (($offset/$limit)+1) ) {
  //if its current page don't show link
      ?&gt;
 
        } else {
  //else if its not current page show link
  ?&gt;
   <a href="http://katsarov.seloto.net/wp-admin/?offset=%3C?php%20echo%20$i%20*%20$limit;%20?%3E"></a>
  }
}
//if we don't have next pages show only 'Next' without link
if($offset &gt;= ($total['0'] - $limit)){
    ?&gt;
    <span class="nextprev">Next »</span>
    } else {
//else if we have next pages show 'Next' with link
    echo '<a href="http://katsarov.seloto.net/wp-admin/?offset=%27%20.%20%28$offset%20+%20$limit%29%20.%20%27">
Next »</a>';
}
?&gt;
 
?&gt;