Problem with php paginating - Please help

Discussion in 'PHP' started by gjkalaj, Nov 22, 2009.

0
  1. #1
    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[/SIZE]

    <?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> &#8364";
    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>"."&nbsp;");
    }else{
    echo ("");
    }
    if($nextpage){
    echo ("&nbsp;"."<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>

    .
    .
    </html>
     
    gjkalaj, Nov 22, 2009 IP