Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Consegui um script para paginação de resultado, mas só que tá dando erro
PHP
[*]<?php
[*]
[*]//paste these above your sql query
[*]$page_count = 10; //results per page
[*]$cut_off = 10; //pages displayed at once
[*]if(!isset($start))$start = 0; //don't touch this
[*]
[*]//this is a dummy query and will need to be updated
[*]$result = mysql_query("SELECT * FROM contatos DESC LIMIT $start, $page_count");
[*]$num = mysql_num_rows($result);
[*]
[*]//paste these below your sql query
[*]function pagination($page_count,$num,$start,$PHP_SELF,$cut_off){
[*]
[*]$newnum = $num / $page_count;
[*]$newnum = ceil($newnum);
[*]if(!isset($page))$page = 1;
[*]
[*]if($newnum >= 2){
[*]echo "
[*]<table border=\"0\" cellpadding=\"3\" cellspacing=\"0\" bgcolor=\"#eeeeee\" align=\"center\">
[*]<tr>
[*]<td style=\"border: 1px solid #999999; font-family: Verdana; font-size: 11px;\" nowrap>
[*]";
[*]
[*]if(isset($start) && $start != 0){
[*]echo "« <a href=\"$PHP_SELF?start="; echo $start - $page_count; echo "\">back</a> ";
[*]}
[*]else{
[*]echo "« back ";
[*]}
[*]
[*]$total_pages = $newnum;
[*]if($newnum > $cut_off)$newnum = $cut_off;
[*]
[*]$cur_page = ($start + $page_count) / $page_count;
[*]
[*]if($cur_page > $cut_off)$page = $cur_page - $cut_off + 1;
[*]
[*]if($cur_page > $cut_off){
[*]$start_page = $page * $page_count - $page_count;
[*]}
[*]else{
[*]$start_page = 0;
[*]}
[*]
[*]for($i=0; $i<$newnum;$i++){
[] if($start == ($page $page_count) - $page_count){
[*] echo "<b><font size=\"3\" color=\"#666666\">$page</font></b> ";
[*] }
[*] else{
[*] echo "<a href=\"$PHP_SELF?start=$start_page\">$page</a> ";
[*] }
[*]$page++;
[*]$start_page = $start_page + $page_count;
[*]}
[*]
[*]if($newnum >= 2 && $cur_page < $newnum && $cur_page <= $total_pages){
[*]echo " <a href=\"$PHP_SELF?start="; echo $start + $page_count; echo "\">next</a> »";
[*]}
[*]elseif($cur_page >= $total_pages){
[*]echo " next »";
[*]}
[*]else{
[*]echo " <a href=\"$PHP_SELF?start="; echo $start + $page_count; echo "\">next</a> »";
[*]}
[*]
[*]echo "
[*]</td>
[*]</tr>
[*]</table>
[*]<br /><div align=\"center\" style=\"font-family: Verdana; font-size: 11px; color: #666666;\">Page $cur_page of $total_pages<div>
[*]";
[*]}//if any results at top
[*]}//function
[*]
[*]pagination($page_count,$num,$start,$PHP_SELF,$cut_off);//place this where you would like the pagination to display
[*]?>
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/primeviashow/www/cadastro/admin/ver_teste.php on line 105
O que pode está acontecendo? :wacko:
Carregando comentários...