|
|
|
<?
/* B-Z stand for be Zen */
function BZ_splitbar ( $total , $actual , $step , $file )
{
$thebar="" ; // the string to be output
$last = $total- ($total % $step) ; // the last step
if( $total > $step ) { // i have to do one bar
if ( ereg ( "&split" , $file ) ) { // does i have a &split= something ?
$anArr = explode ( "&" , $file );
$steptr = $anArr[count( $anArr)-1] ;
$file = ereg_replace( "&".$steptr , "" ,$file ); } ; // delete it
if ($actual ==0 ) { $thebar= "." ;} else { $thebar= " <a href='$file&split=0'>B</a> " ; }
for( $i = $step ; $i < ($total-$step) ; $i += $step )
{ if ($i==$actual ) {$thebar .= "." ;} else { $thebar .= "<a href='$file&split=$i'>z</a> " ; } }
if ($actual ==$last ) {$thebar .= "." ;} else { $thebar .= "<a href='$file&split=$last'>E</a>" ;
}} return $thebar ; } /// done
/**************************************************
code fragment from http://www.1to1center.com/geo/
-----BEGIN FRAGMENT
has it is really used :
$mysql_result = mysql_query( $query) ; // original query
$numRows = mysql_numrows($mysql_result );
if ( $split =="" )
{
$thebar = BZ_splitbar ( $numRows ,0 , 10 , $REQUEST_URI ) ;
$theLimit = "LIMIT 0 , 10 " ;
}
else
{
$thebar = BZ_splitbar ( $numRows , $split ,10 , $REQUEST_URI ) ;
$theLimit = "LIMIT $split , 10 " ;
}
$query = $query.$theLimit ;
$mysql_result = mysql_query( $query) ; // do the query with LIMIT
-----END FRAGMENT
/// do you stufff ...BZ_split will take care of the bad stuff
/// just echo $thebar where you want :)))
*/
|
|
| A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Browse a MySQL database & draw a tree view & load final items into a template page. Categories : MySQL, Complete Programs, Algorithms, PHP, Databases | | | Paginating the mySQL data Categories : PHP, Algorithms, Databases, MySQL, HTML and PHP | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | Displaying records of database in more than one page (paging) Categories : Databases, MySQL, PHP | | | Message of the Day - Random Message (Needs MySQL!) Categories : Databases, HTML and PHP, PHP, MySQL | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs. Categories : Databases, PHP, MySQL, Complete Programs | | | Cut your MySQL Connections to 1 line of code Categories : PHP, Beginner Guides, Databases, MySQL | | | phpAds, a complete banner and ad management system with detailled tracking and stats. Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | | | Point and Click Interface ala MS Access for creating SQL statements. Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | Automatically printing the contents of an sql table in MySQL. Categories : MySQL, PHP, HTML and PHP, Databases | | | Email a user with out exposing email address Categories : PHP, Databases, MySQL, Email | | | Tropicalm Genetree Family (MySQL based family tree) Categories : PHP, Interfaces, Databases, MySQL, Complete Programs | | | Report Generation in Microsoft Access from a MYSQL database Categories : PHP, MySQL, Databases, MS Access | |
|
|
|