I have problem with paginating in one website, so my paginating works separately but together with my website doesn work. Here is the code as follows
albumi.php
<?php
function PregledAlbuma(){
$limit = 5;
$pageno = $_GET['pageno'];
if(!$pageno || $pageno == 1){
$start = 0;
$pageno=1;
}else{
$offset = $pageno-1;
$start = ($offset * $limit);
}
$upit="SELECT * FROM album LIMIT $start,$limit";
$rezultat=upitUBazu($upit);
echo '<table style="max-width:478px;" border="2" bordercolor="blue" cellpadding="5" width="478" max-width="478">';
while ($red=vratiJedanRed($rezultat)) {
echo '<tr><td >';
$televizor= $red['naziv_albuma'] ;
$cije=$red['ime_aut'];
$vel=$red['godina_izdavanja'];
$slika=$red['slika'];
$slika1="$slika.jpg";
echo "<a>$televizor</a>";
echo '</td><td width="80">';
echo "<img src=\"images/$slika1\" alt=\"dsfs\" width=\"80\" height=\"60\" /> <br />";
echo '</td><td>';
echo "$vel cm";
echo '</td><td width="70">';
echo "<a> $cije </a> €";
echo '</td></tr>';
}
echo '</table>';
if($pageno > 1){
$prevpage = $pageno - 1;
}
$currentend = $start + 5;
if(mysql_num_rows(mysql_query("SELECT * FROM album"))>$currentend)
{
if(!$pageno){
$nextpage = 2;
}else{
$nextpage = $pageno + 1;
}
}
echo "<br />";
if ($prevpage || $nextpage) {
if($prevpage){
echo ("<a href=\"{$SERVER['PHP_SELF']}?pageno=".$prevpage."\">PRETHODNA</a>"." ");
}else{
echo ("");
}
if($nextpage){
echo (" "."<a href=\"{$SERVER['PHP_SELF']}?pageno=".$nextpage."\">SLEDECA</a>");
}else{
echo ("");
}
}
}
?>
and index.php is
|
|
\/
<?php
session_start();
include ('albumi.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Free Alpha Studio Web Templates</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="language" content="en" />
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
....
....
....
<div id="menu">
<ul>
<li><a href="index.php?akcija=home">Ballina</a><br /></li>
<li><a href="index.php?akcija=album">albumi</a><br /></li>
</ul>
</div>
.
.
.
.
<div id="right">
<?php
$id=$_GET['id'];
PregledPjesama2($id);
$akcija=$_GET['akcija'];
$akcija=isset($_GET['akcija'])||isset($_GET['id'])?$_GET['akcija']:'home';
switch ($akcija) {
case 'home':
require('home.php');
break;
case 'album':
PregledAlbuma();
break;
default: echo "";
}
?>
</div>
