Проблем със странициране

niko_nik

Registered
От около една седмица се опитвам да страницирам следния код но не успях нямам много знание по пхп ако някой ми помогне ще съм му много благодарен опитах всеки код за странициране в сайта но без успех това е кода който извежда новините


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<link rel="stylesheet" type="text/css" href="stil.css" />

<title></title>

</head>
<body>



<?php

session_start();

require ('system.php');
$sql = mysql_query("SELECT * FROM `news` ORDER BY `id` DESC") or die(mysql_error());
?> <center><h1><b>Новини</b></h1></center> <?php
while ($n = mysql_fetch_assoc($sql)) {
?>
<div><a href="article.php?topic=<?php echo $n['id']; ?>"><b><?php echo $n['title']; ?></b></a></div><br />

<table>

<tr><td><b>Добавил</b></td><td><i><?php echo $n['user']; ?></i></td></tr>
<tr><td><b>Информация</b></td><td><a href="article.php?topic=<?php echo $n['id']; ?>"><i><?php echo $n['info']; ?></i></a></td></tr>
<tr><td><b>Добавена на</b></td><td><i><?php echo $n['date']; ?></i></td></tr>
<tr><td><b>Преглеждания</b></td><td><i><?php echo $n['num']; ?></i></td></tr>
<?php
if ($_SESSION['name'] == $n['user']) {
?>
<tr><td><b>Опции</b></td><td><a href="settings.php?select=edit&id=<?php echo $id; ?>"><i>Редактирай</i></a> | <a href="settings.php?select=delete&id=<?php echo $id; ?>"><i>Премахни</i></a></td></tr>

<?php
}
?>


</table>


<hr>

<?php
}

?>



</body>
</html>
 
Код:
		<?php
    		if($_GET['page']){
				$page = (int)$_GET['page'];
    		} else {
        		$page = 1;
			}
		
			$end = 1;
			$max = 5;
			$table = "news";
				
				

					$plink = "article.php?topic=".$_GET['id']."";
					$where = "WHERE id";

		
			$cur = (($page * $max) - $max);
		
			$getdata = mysql_query("SELECT * FROM $table $where ORDER BY id DESC LIMIT $cur, $max");
			$counttotal = mysql_query("SELECT * FROM $table $where");      
			$counttotal = mysql_num_rows($counttotal);

			$total_pages = ceil($counttotal / $max);
		    if(mysql_num_rows($getdata) > 0){
			while($r = mysql_fetch_array($getdata)){
		?>
<center><h1><b>Новини</b></h1></center> 
<div><a href="article.php?topic=<?php echo $r['id']; ?>"><b><?php echo $r['title']; ?></b></a></div><br />

 <table>

 <tr><td><b>Добавил</b></td><td><i><?php echo $r['user']; ?></i></td></tr>
 <tr><td><b>Информация</b></td><td><a href="article.php?topic=<?php echo $r['id']; ?>"><i><?php echo $r['info']; ?></i></a></td></tr>
 <tr><td><b>Добавена на</b></td><td><i><?php echo $r['date']; ?></i></td></tr>
 <tr><td><b>Преглеждания</b></td><td><i><?php echo $r['num']; ?></i></td></tr>
 <?php
 if ($_SESSION['name'] == $r['user']) {
 ?>
 <tr><td><b>Опции</b></td><td><a href="settings.php?select=edit&id=<?php echo $id; ?>"><i>Редактирай</i></a> | <a href="settings.php?select=delete&id=<?php echo $id; ?>"><i>Премахни</i></a></td></tr>
		<?php
		$end ++;
			}
			}
			else
			{
			echo "Няма добавени новини";
			}
		?>
	</div>
<div align="center">
<?php		
if($counttotal > $max){
			echo "";		
        $adjacents = "2"; 

    	$page = ($page == 0 ? 1 : $page);  
    	$start = ($page - 1) * $max;								
		
    	$prev = $page - 1;							
    	$next = $page + 1;
    	$last = $page - 1;		
        $lastpage = ceil($counttotal / $max);
    	$lpm1 = $lastpage - 1;
    	
    	$pagination = "";
    	if($lastpage > 1)
    	{
    		$pagination .= "<ul class='pagination'>";
                   // $pagination .= "<li class='details'>Страница $page от $lastpage</li>";
				   		    
					
    		if ($page > $counter = 1){ 
                $pagination.= "<li><a href='".$plink."&page=1'>Първа</a></li>";			
    			$pagination.= "<li class='prevPage'><a href='".$plink."&page=$last'>«</a></li>";
    		}else{
                $pagination.= "<li><a class='current'>Първа</a></li>";			
    			$pagination.= "<li class='prevPage'><a class='current'>«</a></li>";
            }
			
    		if ($lastpage < 7 + ($adjacents * 2))
    		{	
    			for ($counter = 1; $counter <= $lastpage; $counter++)
    			{
    				if ($counter == $page)
    					$pagination.= "<li><a class='current'>$counter</a></li>";
    				else
    					$pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";					
    			}
    		}
    		elseif($lastpage > 5 + ($adjacents * 2))
    		{
    			if($page < 1 + ($adjacents * 2))		
    			{
    				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<li><a class='current'>$counter</a></li>";
    					else
    						$pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";					
    				}
    				$pagination.= "<li class='dot'>...</li>";
    				$pagination.= "<li><a href='".$plink."&page=$lpm1'>$lpm1</a></li>";
    				$pagination.= "<li><a href='".$plink."&page=$lastpage'>$lastpage</a></li>";		
    			}
    			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
    			{
    				$pagination.= "<li><a href='".$plink."&page=1'>1</a></li>";
    				$pagination.= "<li><a href='".$plink."&page=2'>2</a></li>";
    				$pagination.= "<li class='dot'>...</li>";
    				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<li><a class='current'>$counter</a></li>";
    					else
    						$pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";					
    				}
    				$pagination.= "<li class='dot'>..</li>";
    				$pagination.= "<li><a href='".$plink."&page=$lpm1'>$lpm1</a></li>";
    				$pagination.= "<li><a href='".$plink."&page=$lastpage'>$lastpage</a></li>";		
    			}
    			else
    			{
    				$pagination.= "<li><a href='".$plink."&page=1'>1</a></li>";
    				$pagination.= "<li><a href='".$plink."&page=2'>2</a></li>";
    				$pagination.= "<li class='dot'>..</li>";
    				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<li><a class='current'>$counter</a></li>";
    					else
    						$pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";					
    				}
    			}
    		}
    		
    		if ($page < $counter - 1){ 
    			$pagination.= "<li class='nextPage'><a href='".$plink."&page=$next'>»</a></li>";
                $pagination.= "<li><a href='".$plink."&page=$lastpage'>Последна</a></li>";
    		}else{
    			$pagination.= "<li class='prevPage'><a class='current'>»</a></li>";
                $pagination.= "<li><a class='current'>Последна</a></li>";
            }

    		$pagination.= "</ul>\n";		
    	}
    
        $pagination .= "<ul class='pagination'><li class='details'>Страница $page от $lastpage общо $max радиостанций на страница</li></ul>";
        print $pagination;
    	
 }
// echo "<b align=\"right\">Общо ".$total_pages." страници по ".$max." клипа на страница</b>";		




    
?>
 
Parse error: syntax error, unexpected 'else' (T_ELSE) in C:\xampp\htdocs\project\news.php on line 59


моля ви помогнете не мога да се оправя
 
Готово, беше пропуснал едно " } " :)


PHP:
 <?php
          if($_GET['page']){
            $page = (int)$_GET['page'];
          } else {
              $page = 1;
         }
      
         $end = 1;
         $max = 5;
         $table = "news";
            
            

               $plink = "article.php?topic=".$_GET['id']."";
               $where = "WHERE id";

      
         $cur = (($page * $max) - $max);
      
         $getdata = mysql_query("SELECT * FROM $table $where ORDER BY id DESC LIMIT $cur, $max");
         $counttotal = mysql_query("SELECT * FROM $table $where");     
         $counttotal = mysql_num_rows($counttotal);

         $total_pages = ceil($counttotal / $max);
          if(mysql_num_rows($getdata) > 0){
         while($r = mysql_fetch_array($getdata)){
      ?>
<center><h1><b>Новини</b></h1></center>
<div><a href="article.php?topic=<?php echo $r['id']; ?>"><b><?php echo $r['title']; ?></b></a></div><br />

 <table>

 <tr><td><b>Добавил</b></td><td><i><?php echo $r['user']; ?></i></td></tr>
 <tr><td><b>Информация</b></td><td><a href="article.php?topic=<?php echo $r['id']; ?>"><i><?php echo $r['info']; ?></i></a></td></tr>
 <tr><td><b>Добавена на</b></td><td><i><?php echo $r['date']; ?></i></td></tr>
 <tr><td><b>Преглеждания</b></td><td><i><?php echo $r['num']; ?></i></td></tr>
 <?php
 if ($_SESSION['name'] == $r['user']) {
 ?>
 <tr><td><b>Опции</b></td><td><a href="settings.php?select=edit&id=<?php echo $id; ?>"><i>Редактирай</i></a> | <a href="settings.php?select=delete&id=<?php echo $id; ?>"><i>Премахни</i></a></td></tr>
      <?php
      $end ++;
         }
         }
		  }
         else
         { echo "Няма добавени новини"; }
      ?>
   </div>
<div align="center">
<?php      
if($counttotal > $max){
         echo "";      
        $adjacents = "2";

       $page = ($page == 0 ? 1 : $page); 
       $start = ($page - 1) * $max;                        
      
       $prev = $page - 1;                     
       $next = $page + 1;
       $last = $page - 1;      
        $lastpage = ceil($counttotal / $max);
       $lpm1 = $lastpage - 1;
       
       $pagination = "";
       if($lastpage > 1)
       {
          $pagination .= "<ul class='pagination'>";
                   // $pagination .= "<li class='details'>Страница $page от $lastpage</li>";
                        
               
          if ($page > $counter = 1){
                $pagination.= "<li><a href='".$plink."&page=1'>Първа</a></li>";         
             $pagination.= "<li class='prevPage'><a href='".$plink."&page=$last'>«</a></li>";
          }else{
                $pagination.= "<li><a class='current'>Първа</a></li>";         
             $pagination.= "<li class='prevPage'><a class='current'>«</a></li>";
            }
         
          if ($lastpage < 7 + ($adjacents * 2))
          {   
             for ($counter = 1; $counter <= $lastpage; $counter++)
             {
                if ($counter == $page)
                   $pagination.= "<li><a class='current'>$counter</a></li>";
                else
                   $pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";               
             }
          }
          elseif($lastpage > 5 + ($adjacents * 2))
          {
             if($page < 1 + ($adjacents * 2))      
             {
                for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
                {
                   if ($counter == $page)
                      $pagination.= "<li><a class='current'>$counter</a></li>";
                   else
                      $pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";               
                }
                $pagination.= "<li class='dot'>...</li>";
                $pagination.= "<li><a href='".$plink."&page=$lpm1'>$lpm1</a></li>";
                $pagination.= "<li><a href='".$plink."&page=$lastpage'>$lastpage</a></li>";      
             }
             elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
             {
                $pagination.= "<li><a href='".$plink."&page=1'>1</a></li>";
                $pagination.= "<li><a href='".$plink."&page=2'>2</a></li>";
                $pagination.= "<li class='dot'>...</li>";
                for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
                {
                   if ($counter == $page)
                      $pagination.= "<li><a class='current'>$counter</a></li>";
                   else
                      $pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";               
                }
                $pagination.= "<li class='dot'>..</li>";
                $pagination.= "<li><a href='".$plink."&page=$lpm1'>$lpm1</a></li>";
                $pagination.= "<li><a href='".$plink."&page=$lastpage'>$lastpage</a></li>";      
             }
             else
             {
                $pagination.= "<li><a href='".$plink."&page=1'>1</a></li>";
                $pagination.= "<li><a href='".$plink."&page=2'>2</a></li>";
                $pagination.= "<li class='dot'>..</li>";
                for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
                {
                   if ($counter == $page)
                      $pagination.= "<li><a class='current'>$counter</a></li>";
                   else
                      $pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";               
                }
             }
          }
          
          if ($page < $counter - 1){
             $pagination.= "<li class='nextPage'><a href='".$plink."&page=$next'>»</a></li>";
                $pagination.= "<li><a href='".$plink."&page=$lastpage'>Последна</a></li>";
          }else{
             $pagination.= "<li class='prevPage'><a class='current'>»</a></li>";
                $pagination.= "<li><a class='current'>Последна</a></li>";
            }

          $pagination.= "</ul>\n";      
       }
   
        $pagination .= "<ul class='pagination'><li class='details'>Страница $page от $lastpage общо $max радиостанций на страница</li></ul>";
        print $pagination;
       
 }
// echo "<b align=\"right\">Общо ".$total_pages." страници по ".$max." клипа на страница</b>";      

?>
 
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\project\news.php on line 29

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\project\news.php on line 32
Няма добавени новини
 
Msecurity каза:
Готово, беше пропуснал едно " } " :)


PHP:
 <?php
          if($_GET['page']){
            $page = (int)$_GET['page'];
          } else {
              $page = 1;
         }
      
         $end = 1;
         $max = 5;
         $table = "news";
            
            

               $plink = "article.php?topic=".$_GET['id']."";
               $where = "WHERE id";

      
         $cur = (($page * $max) - $max);
      
         $getdata = mysql_query("SELECT * FROM $table $where ORDER BY id DESC LIMIT $cur, $max");
         $counttotal = mysql_query("SELECT * FROM $table $where");     
         $counttotal = mysql_num_rows($counttotal);

         $total_pages = ceil($counttotal / $max);
          if(mysql_num_rows($getdata) > 0){
         while($r = mysql_fetch_array($getdata)){
      ?>
<center><h1><b>Новини</b></h1></center>
<div><a href="article.php?topic=<?php echo $r['id']; ?>"><b><?php echo $r['title']; ?></b></a></div><br />

 <table>

 <tr><td><b>Добавил</b></td><td><i><?php echo $r['user']; ?></i></td></tr>
 <tr><td><b>Информация</b></td><td><a href="article.php?topic=<?php echo $r['id']; ?>"><i><?php echo $r['info']; ?></i></a></td></tr>
 <tr><td><b>Добавена на</b></td><td><i><?php echo $r['date']; ?></i></td></tr>
 <tr><td><b>Преглеждания</b></td><td><i><?php echo $r['num']; ?></i></td></tr>
 <?php
 if ($_SESSION['name'] == $r['user']) {
 ?>
 <tr><td><b>Опции</b></td><td><a href="settings.php?select=edit&id=<?php echo $id; ?>"><i>Редактирай</i></a> | <a href="settings.php?select=delete&id=<?php echo $id; ?>"><i>Премахни</i></a></td></tr>
      <?php
      $end ++;
         }
         }
		  }
         else
         { echo "Няма добавени новини"; }
      ?>
   </div>
<div align="center">
<?php      
if($counttotal > $max){
         echo "";      
        $adjacents = "2";

       $page = ($page == 0 ? 1 : $page); 
       $start = ($page - 1) * $max;                        
      
       $prev = $page - 1;                     
       $next = $page + 1;
       $last = $page - 1;      
        $lastpage = ceil($counttotal / $max);
       $lpm1 = $lastpage - 1;
       
       $pagination = "";
       if($lastpage > 1)
       {
          $pagination .= "<ul class='pagination'>";
                   // $pagination .= "<li class='details'>Страница $page от $lastpage</li>";
                        
               
          if ($page > $counter = 1){
                $pagination.= "<li><a href='".$plink."&page=1'>Първа</a></li>";         
             $pagination.= "<li class='prevPage'><a href='".$plink."&page=$last'>«</a></li>";
          }else{
                $pagination.= "<li><a class='current'>Първа</a></li>";         
             $pagination.= "<li class='prevPage'><a class='current'>«</a></li>";
            }
         
          if ($lastpage < 7 + ($adjacents * 2))
          {   
             for ($counter = 1; $counter <= $lastpage; $counter++)
             {
                if ($counter == $page)
                   $pagination.= "<li><a class='current'>$counter</a></li>";
                else
                   $pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";               
             }
          }
          elseif($lastpage > 5 + ($adjacents * 2))
          {
             if($page < 1 + ($adjacents * 2))      
             {
                for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
                {
                   if ($counter == $page)
                      $pagination.= "<li><a class='current'>$counter</a></li>";
                   else
                      $pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";               
                }
                $pagination.= "<li class='dot'>...</li>";
                $pagination.= "<li><a href='".$plink."&page=$lpm1'>$lpm1</a></li>";
                $pagination.= "<li><a href='".$plink."&page=$lastpage'>$lastpage</a></li>";      
             }
             elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
             {
                $pagination.= "<li><a href='".$plink."&page=1'>1</a></li>";
                $pagination.= "<li><a href='".$plink."&page=2'>2</a></li>";
                $pagination.= "<li class='dot'>...</li>";
                for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
                {
                   if ($counter == $page)
                      $pagination.= "<li><a class='current'>$counter</a></li>";
                   else
                      $pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";               
                }
                $pagination.= "<li class='dot'>..</li>";
                $pagination.= "<li><a href='".$plink."&page=$lpm1'>$lpm1</a></li>";
                $pagination.= "<li><a href='".$plink."&page=$lastpage'>$lastpage</a></li>";      
             }
             else
             {
                $pagination.= "<li><a href='".$plink."&page=1'>1</a></li>";
                $pagination.= "<li><a href='".$plink."&page=2'>2</a></li>";
                $pagination.= "<li class='dot'>..</li>";
                for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
                {
                   if ($counter == $page)
                      $pagination.= "<li><a class='current'>$counter</a></li>";
                   else
                      $pagination.= "<li><a href='".$plink."&page=$counter'>$counter</a></li>";               
                }
             }
          }
          
          if ($page < $counter - 1){
             $pagination.= "<li class='nextPage'><a href='".$plink."&page=$next'>»</a></li>";
                $pagination.= "<li><a href='".$plink."&page=$lastpage'>Последна</a></li>";
          }else{
             $pagination.= "<li class='prevPage'><a class='current'>»</a></li>";
                $pagination.= "<li><a class='current'>Последна</a></li>";
            }

          $pagination.= "</ul>\n";      
       }
   
        $pagination .= "<ul class='pagination'><li class='details'>Страница $page от $lastpage общо $max радиостанций на страница</li></ul>";
        print $pagination;
       
 }
// echo "<b align="right">Общо ".$total_pages." страници по ".$max." клипа на страница</b>";      

?>
:?:
 
не се получава изписва следната грешка

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\project\news.php on line 29

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\project\news.php on line 32
Няма добавени новини
 

Back
Горе