Showing Search Form Results in Pagination

macintosh · #1 (**permalink**) 03-22-08, 05:54 PM

Hey..
I want to display the mysql results when someone uses the search form. Now im trying by this way

PHP Code:


			
if($_POST['search']){

$search = $_POST['searchBox'];



... and so on.  Here I want to display the results in Pagination.

}





<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">

<span style="vertical-align: middle; font-weight: bold;">Find:&nbsp;</span>

<input name="searchBox" class="searchBox" type="text" style="width: 433px" >

 <input type="submit" name="search" value="Search">

</form>

The problem i am facing is that, when i search something. It showing the paging nav.
but when i click on 2nd page or so on, the paging nav. disappears.
I think this is because i doing everything inside if $_POST condition.
If someone can suggest something about how to display search results in pagination.
Thank you very much for always help

job0107 · #2 (**permalink**) 03-22-08, 09:12 PM

You will need to post your code. This one form you are showing doesn't help much.

macintosh · #3 (**permalink**) 03-23-08, 01:22 PM

Here is complete code.. please have a look at it.

PHP Code:


			
<?php



if($_POST['search']){

$search = $_POST['searchBox'];



... and so on.  Here I want to display the results in Pagination.

$search = trim($search);

//Explode into seperate keywords and make all unique

$terms = array_unique(explode(' ',$search));



//Loop through all terms, and add text for query

foreach($terms as $k=>$v)

{

    //Check for empty values

    if($v=="") continue;

    $terms[$k]="`tags` LIKE '%$v%'";

}



//Implode each term back together with the OR in between them

$newsearch = implode(' OR ', $terms);





$tbl_name="";        //your table name

    // How many adjacent pages should be shown on each side?

    $adjacents = 3;

    

    /* 

       First get total number of rows in data table. 

       If you have a WHERE clause in your query, make sure you mirror it here.

    */

    $query = "SELECT COUNT(*) as id FROM upload";

    $total_pages = mysql_fetch_array(mysql_query($query));

    $total_pages = $total_pages[id];

    

    /* Setup vars for query. */

    //$targetpage = "test.php";     //your file name  (the name of this file)

    $limit = 1;                                 //how many items to show per page

    $page = $_GET['page'];

    if($page) 

        $start = ($page - 1) * $limit;             //first item to display on this page

    else

        $start = 0;                                //if no page var is given, set start to 0

    

    /* Get data. */

    $sql = "SELECT * FROM upload ORDER BY id DESC LIMIT $start, $limit";

    $result = mysql_query($sql);

    

    /* Setup page vars for display. */

    if ($page == 0) $page = 1;                    //if no page var is given, default to 1.

    $prev = $page - 1;                            //previous page is page - 1

    $next = $page + 1;                            //next page is page + 1

    $lastpage = ceil($total_pages/$limit);        //lastpage is = total pages / items per page, rounded up.

    $lpm1 = $lastpage - 1;                        //last page minus 1

    

    /* 

        Now we apply our rules and draw the pagination object. 

        We're actually saving the code to a variable in case we want to draw it more than once.

    */

    $pagination = "";

    if($lastpage > 1)

    {    

        $pagination .= "<div class=\"pagination\">";

        //previous button

        if ($page > 1) 

            $pagination.= "<a href=\"$targetpage?page=$prev\">&laquo; previous</a>";

        else

            $pagination.= "<span class=\"disabled\">&laquo; previous</span>";    

        

        //pages    

        if ($lastpage < 7 + ($adjacents * 2))    //not enough pages to bother breaking it up

        {    

            for ($counter = 1; $counter <= $lastpage; $counter++)

            {

                if ($counter == $page)

                    $pagination.= "<span class=\"current\">$counter</span>";

                else

                    $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    

            }

        }

        elseif($lastpage > 5 + ($adjacents * 2))    //enough pages to hide some

        {

            //close to beginning; only hide later pages

            if($page < 1 + ($adjacents * 2))        

            {

                for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)

                {

                    if ($counter == $page)

                        $pagination.= "<span class=\"current\">$counter</span>";

                    else

                        $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    

                }

                $pagination.= "...";

                $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";

                $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        

            }

            //in middle; hide some front and some back

            elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))

            {

                $pagination.= "<a href=\"$targetpage?page=1\">1</a>";

                $pagination.= "<a href=\"$targetpage?page=2\">2</a>";

                $pagination.= "...";

                for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)

                {

                    if ($counter == $page)

                        $pagination.= "<span class=\"current\">$counter</span>";

                    else

                        $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    

                }

                $pagination.= "...";

                $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";

                $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        

            }

            //close to end; only hide early pages

            else

            {

                $pagination.= "<a href=\"$targetpage?page=1\">1</a>";

                $pagination.= "<a href=\"$targetpage?page=2\">2</a>";

                $pagination.= "...";

                for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)

                {

                    if ($counter == $page)

                        $pagination.= "<span class=\"current\">$counter</span>";

                    else

                        $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    

                }

            }

        }

        

        //next button

        if ($page < $counter - 1) 

            $pagination.= "<a href=\"$targetpage?page=$next\">next &raquo</a>";

        else

            $pagination.= "<span class=\"disabled\">next &raquo</span>";

        $pagination.= "</div>\n";        

    }

?>



    <?php

        while($row = mysql_fetch_array($result))

        {

        ?>

        <div class="thumb">

                        <div class="image">

                <a href="image.php?id=<?=$row[id];?>" target='_blank'><img src="thumbs/<?=$row[name];?>"></a>            </div>

                      <div class="stars" id="stars5152">

                <img src="r4.gif" alt="design" width="16">                    

            </div>

                        <div class="links">

                <a href="http://link" >Link</a>            </div>

        </div>    

        

    <?

        // Your while loop here

    

        }

        

        echo $pagination;

}





<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">

<span style="vertical-align: middle; font-weight: bold;">Find:&nbsp;</span>

<input name="searchBox" class="searchBox" type="text" style="width: 433px" >

 <input type="submit" name="search" value="Search">

</form>

The problem seems to be carrying the $_POST variable to the next pages..thats why it doesnt show the pagination nav. on pages except first. i wish someone could have a look at above code and see wheres something wrong.

Jay6390 · #4 (**permalink**) 03-23-08, 04:09 PM

One thing I have noticed is that the following are wrong

PHP Code:


			
<?=$row[id];?>
#and
<?=$row[name];?>

#They should be
<?=$row['id'];?>
<?=$row['name'];?>

Jay

job0107 · #5 (**permalink**) 03-24-08, 06:11 AM

The problem is, the search form isn't being submitted when you use the navigation links. You will need to isolate the search form results from the pagination links. You could do this by storing the search form results in session variables.