Php > Databases

Html split bar used to split in multiple pages a database result

Html split bar used to split in multiple pages a database result

This module prints a common split href menu, like those used to   
display into several pages the results of a search engine.   

For example, you have a page results.php3 that prints a collection   
of results, and for more convenience you want to write several pages   
from this result, each grouping MAXHIT results. So you paste this code   
into a file split.php3, then you write in results.php3: include("[...]/split.php3");   
at the exact location where you want the split bar to display.   

Don't forget to modify your results page results.php3 to display   
only the results i to i+MAXHIT-1 !   

Code of split.php3:   

arguments: _maxelmt: number of elements in the collection   
  MAXHIT :  number of max hits for a page   
  p :  current page to be seen   
  cat (optional): optional parameters to send at return   

<?   
/*if MAXHIT=0 print a message error*/    

if(!$MAXHIT) {   
    print  "MAXHIT=0 : no split available!\n";   
}   

else {   
    if($res && $_maxelmt) {   
        $end=$p*$MAXHIT;   
    if($_maxelmt < $p*$MAXHIT)   
        $end=$_maxelmt;   
    
     print  "\t\t?Results ".(max(1,($p-1)*$MAXHIT+1)). '-'.$end. '??<br>'. "\n";   
     }   

     /*bypass if there's no more than one page*/    
    if ($_maxelmt> $MAXHIT) {   
             /* pattern: Results i'-i'+MAXHIT [<<Prev] | 1 --page+1 [2 --page+2 ...] | [Next>>] Page 
i of n */    

             /*<<Prev*/    
             /*if p > 1, Prev is active, otherwise it's not*/    
            print  "\t\t<font face='Arial' size='1'";   

            if (!($p-1)) {   
                print  " color='#646464'><<Prev?|?\n"; }  /*light gray*/    
            else {   
                 /*prev*/    
                $prevpage=$p-1;   
                $anurl =  "results.php3?_maxelmt=$_maxelmt&MAXHIT=$MAXHIT&p=$prevpage&$cat";   
                print  " color='#008000' ><a href=$anurl><<Prev</a>?|?\n"; }   
                print  "\t\t</font>". "\n";   
    
                     /*print a page number every MAXHIT*/    
                for($i=0;$i<$_maxelmt;$i+=$MAXHIT) {   
                 /*page number i+1*/    
                     $pi=($i/$MAXHIT)+1;   
    
                   /*don't activate current page's href*/    
                  if($pi==$p) {   
                      print  "<font face ='Arial' size='1' color=#646464>$pi?";   
                  }   
                else {   
                        $anurl =  "results.php3?_maxelmt=$_maxelmt&MAXHIT=$MAXHIT&p=$pi&$cat";   
                    print  "<font face ='Arial' size='1' color=#008000 >\n";   
                    print  "\t\t<a href=$anurl>".$pi. '?</a>'. "\n";   
                }   
                print  "\t\t</font>". "\n";   
            }   
          /*Next>>*/    
             /*if p*MAXHIT doesn't meet or exceed MAXHIT, Next is active, otherwise it's not*/    
            print  "\t\t<font face ='Arial' size='1'";   

            if (($_maxelmt-$p*$MAXHIT) <= 0) {   
                print  " color='#646464'>| Next>>\n"; }  /*light gray*/    
            else {   
                  /*next*/    
                 $nextpage=$p+1;   
                 $anurl =  "results.php3?_maxelmt=$_maxelmt&MAXHIT=$MAXHIT&p=$nextpage&$cat";   
                 print  ">|?<a href=$anurl>Next>></a>\n";}   
                print  '</font>';   
        }   

        if($_maxelmt) {   
            print  "\t\t<font face ='Arial' size='1' color='#008000' >?Page ".$p. ' of 
'.ceil($_maxelmt/$MAXHIT). '</font>'. 
"\n";   
        } 
    }  /*if ($_maxelmt> $MAXHIT) 
} /*end lse if(!$MAXHIT)*/ 
?>   
    

/*Example of use in results.php3: 9 hits maximum, in a 3*3 table   

Note: the colspans of <td> may not be correct as I adapted this example   
from another presentation **/   
<?   

/*place here your code to query MySQL database...*/    

/*get results*/    
if(strcmp($result, ''))   
    $number=mysql_numrows($result);   
else   
     $number=0;   

/*maximum number of hits*/    
$MAXHIT= 9;   

/*if more than MAXHIT results are found, split the results into several pages*/    
$i=$MAXHIT*$p;   

/* --> $p is initialized to 0 if results.php3 is 1st called, but then it gets its value   
from split.php3!*/    

print  " <table border='0'>\n";   
print  "   <tr>\n";   
print  "     <td>\n";   
   /*remind query or show a sorry message if no result was found:*/    
  print  "Your query: $qry.\n";   
print  "     </td>\n";   
print  "  </tr>\n";   

if($number) {   
    print  "\n\t  <tr>\n";   
    print  "\t    <td'>\n";   
    if($number>1) {   
           /*split header*/    
           $plural= 's';   
           $pluralbe= 'were';   
      }   
    else {   
         $plural= '';   
        $pluralbe= 'was';   
    }   
    
     /*displays details about results*/    
    
    print  "\t\t$number result$plural $pluralbe found for this query\n";   
    print  "\t\t<hr size='1'>\n";  print  "\t    </td>\n";  print  "\t  </tr>\n";   
    print  "\t  <tr>\n";   
    print  "\t    <td>\n";   

     /*category of result page to show when returning from split module*/    
    $cat= "[optional parameters]";   
    $urlinfo= "p=$p&_maxelmt=$number&MAXHIT=$MAXHIT&cat=".$cat;   
    
     /*calling split module*/    
      "http://[your path]/split.php3?$urlinfo&res=1";   

    print  "\t  <tr>\n";   
    print  "\t    <td>\n";   

    print  "\t\t<table border='0' cellspacing='1' cellpadding='1'>\n";   

     /*default recordset scanning is 0 to MAXHIT-1 (p=1)*/    
    $i=$MAXHIT*($p-1);   

    while ($i<$MAXHIT*$p && $i < $number) {   
        $mVar1=mysql_result($result,$i, "Var1");   
        $mVar2=mysql_result($result,$i, "Var2");   
            /*etc...*/    
    
        $index=$i+1;   
    
         /*format table*/    
        if (!($i % 3)) {   
            print  "\t\t  <tr>\n";   
        }   
        $mName= "$mVar1/$mVar2.html";  /*for instance...*/    

        print  "\t\t    <td>\n\t\t\t<a href='$mName'>\n";   
           print  "</a>\n\t\t    </td>\n";   

            if (($i % 3) == 2) {   
            print  "\t\t  </tr>\n";   
        }   
         /*next record*/    
        $i++;   
    }  /*end while*/    
    
     /*if table didn't end in a full row, append end of row*/    
    if ($i % 3) {   
                 print  "\t\t  </tr>\n";   
    }   
    print  "\t\t</table>\n";   
    
    print  "\t    </td>\n";   
    print  "\t  </tr>\n";   
}  /*end if $number*/    
    
else {   
    print  "\t  <tr>\n";   
    print  "\t    <td>\n";   
         /*sorry message*/    
        print  "\t\tSorry, no result was found in the database\n";   
    print  "\t    </td>\n";   
    print  "\t  </tr>\n";   
}   

print  " </table>\n";   
?>