Location: PHPKode > scripts > SplitResults > splitresults/split.class.php3
<?
class Split
{
	
	
        var $host="localhost";
        var $dbuser="sandeep";  //dbuser
        var $dbpasswd="secret"; //dbpassword 
        var $db="project";      //database
	
	var $totalrows; //total no ofrows returned by the query
	var $maxrow;  //total no of rows displayed in a page
        var $sql;	//the main query
        var $error;
        var $totalpages;

	function Split($sql,$maxrow)
	{
		
		$this->cid= mysql_pconnect($this->host, $this->dbuser, $this->dbpasswd)
			  or   die("Error: " . mysql_error());
		
		mysql_select_db($this->db,$this->cid);

		$this->sql=$sql;
		$this->maxrow=$maxrow;
		if($this->maxrow <=0)
		{
			$this->error="Max results in a page is not valid";
			return;
		}	
		$out=mysql_query($sql);
		if (!$out)
		{
		         $this->error="ERROR" . mysql_error();
		         return;
		}

		$this->totalrows=mysql_num_rows($out);
                //total rows=0
		if ($this->totalrows==0)
		{
		         $this->error="No Result returned";
		         return;
		}


		$this->totalpages=(int)(($this->totalrows-1)/$this->maxrow+1);
		// in the above line we initialize the total no of rows and the sql
	}	
        	



	function display($ppage)
	{

		//in this method only the present page to be displayed will be passed
		//if present page is null the first $maxrows will be printed
		if(($ppage=="")|| ($ppage <=0))
		{
			//if the ppage passed is null or zero or less than zero we
			//show the first page
			$min=0;
			//printf("ppage is null or 0 or less than 0<br>");
			
		}
		else
		{
			
			if($ppage > $this->totalpages)
			{
				//if the ppage passed is more than the total pages
				//we display the last page
				$min=$this->maxrow * ($this->totalpages-1);
				//printf("ppage is > total pages<br>");				
			}
			else
			{
			//if present page is passed the max and min limit is calculated
			//eg:-if ppage is 2 and maxrow=10 then records from 10 to 20 will be displayed.
			
			        //printf("ppage is is $ppage<br>");
				$ppage=$ppage-1;
				$min=$ppage*$this->maxrow;
				$max=$this->maxrow;
												
			}
		}
		$sqlimit = $this->sql ." "."limit"." ". $min . "," . $this->maxrow;
		//printf("<br>sql is $sqlimit<br>");	
		
		$outputdisplay=mysql_query($sqlimit)or die("ERROR" . mysql_error());		
		if(mysql_num_rows($outputdisplay)==0)
		{
			$this->error="No results";
			exit;
		}
		else
		{
			return $outputdisplay;
			
		}	
			
	}
	function total()
	{
		//printf("total no of rows is %s<br>",$this->totalrows);
		
		return $this->totalpages;
	}	
	
}	

?>
Return current item: SplitResults