 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
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 ! *** A live example can be seen at http://tropicalm.free.fr/pub/world/gallery/gallery.php3 *** ******************************************************************************* 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"; ?> | |||||
| Related Code Examples | |||||
| User Comments | |||||
|
|||||
