paging an array of records

Discussion in 'PHP' started by gilgalbiblewheel, Aug 6, 2008.

0
  1. #1
    The original script is found on:
    http://www.sitepoint.com/article/perfect-php-pagination

    <?php
require_once "Paginated.php";
require_once "DoubleBarLayout.php";
?>
<html>
<head>
<title>Pagination</title>

<!-- Just a little style formatting. Has no bearing on example -->
<style type="text/css">
	body {
		font-family: Verdana;
		font-size: 13px;
	}
	
	a {
		text-decoration: none;
	}
	
	a:hover {
		text-decoration: underline;
	}
</style>
<!-- End style formatting -->
</head>

<body>

	<?php
	//create an array of names in alphabetic order. A database call could have retrieved these items
	$names = array("Andrew", "Bernard", "Castello", "Dennis", "Ernie", "Frank", "Greg", "Henry", "Isac", "Jax", "Kester", "Leonard", "Matthew", "Nigel", "Oscar");
	
	$page = $_GET['page'];
	
	//constructor takes three parameters
	//1. array to be paged
	//2. number of results per page (optional parameter. Default is 10)
	//3. the current page (optional parameter. Default  is 1)
	$pagedResults = new Paginated($names, 10, $page);
	
	echo "<ul>";

	while($row = $pagedResults->fetchPagedRow()) {	//when $row is false loop terminates
		echo "<li>{$row}</li>";
	}
	
	echo "</ul>";
	
	//important to set the strategy to be used before a call to fetchPagedNavigation
	$pagedResults->setLayout(new DoubleBarLayout());
	echo $pagedResults->fetchPagedNavigation();
	?>
</body>
</html>
    PHP:
    It consists an array of 15 names.
    WHat I needed to do is have a query and set the result into an array and replace the $names above. I replaced it with a function. And within the function called getQuery($bigWords) I placed both the query and the while loop of $results.
    See next posting.
     
    gilgalbiblewheel, Aug 6, 2008 IP
  2. gilgalbiblewheel

    gilgalbiblewheel Well-Known Member

    Messages:
    435
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #2
    $bigWords is an array of words > 4 letters. The rest of the words have previously sorted out.
    function getQuery($bigWords){

		$query="SELECT * FROM bible WHERE 1=1 AND";
	
		//to sort out all words with length less than 4 like AND, OR, BUT...
		for ($i=0; $i < count($bigWords); $i++){
			if($bigWords[$i]!=""){
				$query.=" CASE WHEN text_data LIKE '%" .$bigWords[$i]. "%' THEN 1 ELSE 0 END\n";
				if($i!=count($bigWords)-1){
					$query.=" +";
					}else{
					//removes the OR from the last line and replaces with the following
					//for results of words > 3
					$query.= " > 3";
					}
				}
			}
		$query .= " ORDER BY id";
		$theresult = array();
		//$theresult[] = "";
		//$theresult[] = $query;
		$result = mysql_query($query);

	while($row = mysql_fetch_assoc($result)){
		$strText = $row['text_data'];
		$COLORS = array('red','Teal','blue','Magenta','green','PaleGreen','orange','purple','Pink','YellowGreen','Sienna','aqua','Gray','LightBlue','MediumTurquoise','DarkRed');
		for($m=0; $m < count($bigWords); $m++){
			$strText = preg_replace("/(".$bigWords[$m].")/i", "<span class=\"\" id=\"\" style=\"color:".$COLORS[$m]."; font-weight:bold;\">$1</span>", $strText);
			}
		$theresult[] = "<br />\n<span class=\"goToBookChapter\" style=\"font-weight: bold;\">".$row['book_title']." ".$row['chapter'].":".$row['verse']."</span><br />\n".$strText;
		}
		return $theresult;
		echo "<br /><br />".$query."<br />";
}
    PHP:
     
    gilgalbiblewheel, Aug 6, 2008 IP
  3. gilgalbiblewheel

    gilgalbiblewheel Well-Known Member

    Messages:
    435
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #3
    I forgot to mention the problem. The pagination of 10 records per page is not happening.
    I've been having problems in this for WEEKS!!! With no one to help me.
    I don't understand how the while loop for paging should be set. This is what I have so far:
    while($row = $pagedResults->fetchPagedRow()){
		echo "<span style='color: red;'>".$c."</span><br />";
		//echo "{$row}";
		print(getQuery($bigWords));
		//echo getQuery($bigWords);
		//echo "hi";
		$c++;
		}
    PHP:
    I get:
    1
Array2
Array3
Array4
Array5
Array6
Array7
Array8
Array9
Array10
Array
    Code (markup):
    HEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEELP!!!!!
     
    gilgalbiblewheel, Aug 6, 2008 IP