Count search results

[zzz]

I need to break page by number or results per page.
The problem is that I do n

How can I calculate the number of results found when I make search on my table?

Here's how I search:

$sql  = "SELECT * FROM myTbl WHERE 1 = 1";
$sql .= empty($_POST['q']) ? NULL : " AND var1 LIKE '%".$_POST['q']."%'";
$sql .= empty($_POST['q']) ? NULL : " AND var2 LIKE '%".$_POST['q']."%'";


if($searchResults = $db->get_results($sql)) {
				    foreach ( $searchResults as $search )
		            {
						echo "RESULTS OUTPUT HERE";					
					}
} else {
	echo "Nothing found";
}

I need to find TOTAL results found...

[vaaaska]

It looks like it's right there in front of you...but you'll need this...

COUNT()

[zzz]

I thought I was right in front of me but wasn't sure where?

count($searchResults)

Thanks for the pointer.

[zzz]

OK, now that I've counted results I am faced with another aged problem: What was first -chicken or the egg?

Here's what I'm talking about. In order for me to break results per page I need to add this code:

// paging results >>

$total = count ($searchResults); 

$pager  = Pager::getPagerData($total, $limit, $page); 
$offset = $pager->offset; 
$limit  = $pager->limit; 
$page   = $pager->page; 

if ($total > $limit) { 
   if ($page != 1) // this is the first page - there is no previous page 
       echo "<a href='?mypage&page=".($page - 1)."'>previous</a> |"; 
   for ($i = 1; $i <= $pager->numPages; $i++) {   

       if ($i == $pager->page)   

           if ($i == $pager->numPages) { 
            echo " $i"; 
        } else { 
            echo " $i |"; 
        } 
       else   

           echo " <a href='?mypage&page=$i'>$i</a> |";   

   }  

   if ($page != $pager->numPages) // this is the last page - there is no next page 
       echo " <a href='?mypage&page=".($page + 1)."'>next</a>"; 
}

// paging results <<

Now, how can I combine the previous code with this one? Lost deep in the woods!

[vaaaska]

I'm not sure how the two relate...but maybe this is what you want?

$total = count($searchResults);

[zzz]

That is correct, this is exactly how I got total count.

Now, I have two pieces of code, consisting of search query and results output and results paging (below). In order for them both to work I must include this into QUERY string - LIMIT $offset, $limit

// search logic and data output >>

$sql  = "SELECT * FROM myTbl WHERE 1 = 1"; 
$sql .= empty($_POST['q']) ? NULL : " AND var1 LIKE '%".$_POST['q']."%'"; 
$sql .= empty($_POST['q']) ? NULL : " AND var2 LIKE '%".$_POST['q']."%'"; 


if($searchResults = $db->get_results($sql)) { 
                    foreach ( $searchResults as $search ) 
                    { 
                        echo "RESULTS OUTPUT HERE";                     

                    } 
} else { 
    echo "Nothing found"; 
}

// search logic and data output <<

// paging results >>

$total = count ($searchResults); 

$pager  = Pager::getPagerData($total, $limit, $page); 
$offset = $pager->offset; 
$limit  = $pager->limit; 
$page   = $pager->page; 

if ($total > $limit) { 
   if ($page != 1) // this is the first page - there is no previous page 
       echo "<a href='?mypage&page=".($page - 1)."'>previous</a> |"; 
   for ($i = 1; $i <= $pager->numPages; $i++) {   

       if ($i == $pager->page)   

           if ($i == $pager->numPages) { 
            echo " $i"; 
        } else { 
            echo " $i |"; 
        } 
       else   

           echo " <a href='?mypage&page=$i'>$i</a> |";   

   }  

   if ($page != $pager->numPages) // this is the last page - there is no next page 
       echo " <a href='?mypage&page=".($page + 1)."'>next</a>"; 
}

// paging results <<

Since the actual place where I get $total is beneath QUERY string, I guess I'm at a loss how to pass it back up to make it work...

[zzz]

It just dawned on me - I'm wasting my time. This will never work. This paging class works well on output from a table where I can count results and break them accordingly. In this particular case I do not have a table with results. I match sometimes one sometimes more tables against my search parameter and get it output from various places.

So, what are my options at this point?

Do i need to write all the found results into some temp table first and then output? Gee, that sure sounds like a lot of extra work for the server.

Help. Need some help here!!!!