0

Hello there.. I am currently working with the referral program and I have a page wherein it displays all the personal information of a person who referred by the user login.. I have 2 functions for displaying the records.. Number 1 is just displaying the records when you go to the view page and Number 2 is a search function so you can easily see specific person you wanted to see.
The problem I encounter is, when I type in the search box, definitely my function to search is the one who responsible for displaying some specific records.. I add pagination so that if the record is more than 10, User can still able to view the other records by clicking page 2 but the problem is when I click the page 2 or search result page pagination. The records didn't display on page 2 and its pagination change into the original once I click page2 or the next and previous button` Here is my forum for search

<!-- Here goes the Search Area -->
        <div class="twelve columns">
            <div class="search">
                <div class="searchbox">
                    <div id="form-container"> 
                            <div id="searchtext">
                            <form name="formSearch" method="GET" action="view_referral.php" >
                            <button class="gobtn">Search</button>
                            <input type = "text" id="s" name="searchField" size="25" placeholder="Search referrals...">
                            <input type ="submit" name="searchButton" value="Search" style="display:none;">


                        </form>
                            </div>
                    </div>
                </div>
            </div>
        </div>



<!-- Here the Main Content goes -->
            <div class="twelve columns">
                <div class="content">
                    <span class="referralstatus">
                        <div class="totalreferral">
                            Total referrals<p><?php include('../function/func_countTotalReferredLeads.php');?></p>
                        </div>
                        <div class="totalhires">
                            Total Hires<p><?php include('../function/func_countHiredReferrals.php');?></p>
                        </div>
                        <div class="failed">
                            Failed<p><?php include('../function/func_countFailedReferrals.php');?></p>
                        </div>
                    </span>

                    <span class="profile">
                            <div class="refereeprofile">
                            <p align="center" class="refereetitle">REFERRAL INFORMATION</p>
                                <div class="employeeinfo">
                                    <div class="empn">
                                        <p align="left" class="employeename"><strong>Employee ID:<span class="empnn"><?php echo $empid; ?></span></p>
                                    </div>
                                    <div class="empid">
                                        <p align="left" class="employeeid"><strong>Employee Name:<span class="empdd"><?php echo $firstname .' '. $lastname;?></span></p>
                                    </div>
                                </div>



                                <div class="accessinfo">
                                    <div class="accd">
                                        <p align="left" class="accessdate"><strong>Access Date:  <?php echo $current_date;?></p>
                                    </div>
                                    <div class="acct">
                                        <p align="left" class="accesstime"><strong>Access Time: <?php echo $current_time;?></p>
                                    </div>
                                </div>
                            </div>

                            <div class="referentprofile"> 
                                <p>List of Referrals</p>
                                <table class="u-full-width">
                                    <tr>
                                    <td><strong>Lead No.<strong></td>
                                    <td><strong>Referral Name</strong></td>
                                    <td><strong>Date Referred</strong></td>
                                    <td><strong>Mobile Number</strong></td>
                                    <td><strong>Email Address</strong></td>
                                    <td><strong>Call Status</strong></td>
                                    <td><strong>Application Status</strong></td>
                                    </tr>
                                <?php

                            $_SESSION['SESS_PAGE'] = $_SERVER['PHP_SELF'];

                            // Change this during actual system run
                            if (empty($_GET['searchField'])){
                            include('../function/func_testPopulateLeads.php');
                                    }
                                    else {
                                        include('../function/func_testSearchByName.php');
                                        } 

                            ?>

                        </table>
                                </div>
                            <center>
                            <div style="text-align: center;">
                        <?php 
                        include('../function/func_pagination_new.php'); 
                        ?>
                        <?=$pagination?>
                    </div>
                    </center>    
                    </span>
                </div>
            </div>

        <!-- Here the Reminder goes -->
        <center>
            <div class="recordshown">

                <div class="twelve columns"> 

                    <p align="justify">
                    <?php echo 'Total Records Shown: ' . $_POST['data_num_row']; ?>  *** If you know any information from above that needs to be corrected, please contact us.</p>
                    <?php

                    $total_rows = $_SESSION['SESS_QRYTOTALROWS'];   
                    $data_num = $_POST['data_num_row'];
                if($data_num == 0)
                    {
                    echo '<div id="result">Message: No Record/s Found!</div>';
                    }
                elseif ($total_rows != 0)
                    {
                    echo '<div id="result">End of Results from Current Query...</div>';
                    } 
                elseif($data_num != 0)
                    {
                    echo '<div id="result">End of Results from Current Query...</div>';
                }                                   
                elseif ($total_rows > 15)                   
                    {
                    echo $pager->renderFullNav();
                    }
                else
                    {
                    echo '<div id="result">Message: No Record/s Found!</div>';
                    echo '<div id="result">*End of Result...</div>';
                    }
                ?>

                </div>
            </div>
            </center>

Here is my pagination

<?php
/* 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 buttons
            if ($page > 1) 
                $pagination.= "<a class='buttons' href=\"$targetpage?page=$prev\">previous</a>";
            else
                //$pagination.= "<a class='disabled'><buttons disabled>previous</buttons></a>"; 
                $pagination.= "<a class='buttons'>previous</a>";

        //pages 
        if ($lastpage < 4 + ($adjacents * 2))    //not enough pages to bother breaking it up
        {   
            for ($counter = 1; $counter <= $lastpage; $counter++)
            {
                if ($counter == $page)
                    $pagination.= "<a class='current'><buttons style='background-color:#CEF6F5'>$counter</buttons></a>";
                else
                    $pagination.= "<a class='buttons' href=\"$targetpage?page=$counter\">$counter</a>";                   
            }
        }
        elseif($lastpage > 1 + ($adjacents * 2))    //enough pages to hide some
        {
            //close to beginning; only hide later pages
            if($page < 1 + ($adjacents * 2))     
            {
                for ($counter = 1; $counter < 3 + ($adjacents * 2); $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<a class='current'><buttons style='background-color:#CEF6F5'>$counter</buttons></a>";
                    else
                        $pagination.= "<a class='buttons' href=\"$targetpage?page=$counter\">$counter</a>";                   
                }
                $pagination.= "...";
                //$pagination.= "<a class='buttons' href=\"$targetpage?page=$lpm1\">$lpm1</a>";
                $pagination.= "<a class='buttons' href=\"$targetpage?page=$lastpage\">$lastpage</a>";     
            }
            //in middle; hide some front and some back
            elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
            {
                $pagination.= "<a class='buttons' href=\"$targetpage?page=1\"> 1 </a>";
                //$pagination.= "<a class='buttons' href=\"$targetpage?page=2\"> 2 </a>";
                $pagination.= "...";
                for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<a class='current'><buttons style='background-color:#CEF6F5'>$counter</buttons></a>";
                    else
                        $pagination.= "<a class='buttons' href=\"$targetpage?page=$counter\">$counter</a>";                   
                }
                $pagination.= "...";
                //$pagination.= "<a class='buttons' href=\"$targetpage?page=$lpm1\">$lpm1</a>";
                $pagination.= "<a class='buttons' href=\"$targetpage?page=$lastpage\">$lastpage</a>";     
            }
            //close to end; only hide early pages
            else
            {
                $pagination.= "<a class='buttons' href=\"$targetpage?page=1\">1</a>";
                //$pagination.= "<a class='buttons' href=\"$targetpage?page=2\">2</a>";
                $pagination.= "...";
                for ($counter = $lastpage - (2 + ($adjacents * 1)); $counter <= $lastpage; $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<a class='current'><buttons style='background-color:#CEF6F5'>$counter</buttons></a>";
                    else
                        $pagination.= "<a class='buttons' href=\"$targetpage?page=$counter\">$counter</a>";                   
                }
            }
        }

        //next buttons
        if ($page < $counter - 1) 
            $pagination.= "<a class='buttons' href=\"$targetpage?page=$next\">next</a>";
        else
            $pagination.= "<a class='buttons'>next</a>";
        $pagination.= "</div>\n";        
    }


    ?>

Here is my function searching specific name

<?php

        Place code to connect to your DB here.
    */
include('../include/dbconnection.php'); // include your code to connect to DB.


$firstname = $_SESSION['SESS_FIRSTNAME'];
$lastname = $_SESSION['SESS_LASTNAME'];
$bdate= $_SESSION['SESS_BDAY'];

$tbl_name="vtiger_leaddetails"; //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 1;

    /* 
       First get total number of rows in data table. 
       If you have a WHERE clause in your query, make sure you mirror it here.
    */
 $query1 = "SELECT COUNT(*) as num FROM $tbl_name INNER JOIN 
       vtiger_leadscf
       ON vtiger_leaddetails.leadid = vtiger_leadscf.leadid
       INNER JOIN vtiger_leadaddress
       ON vtiger_leadaddress.leadaddressid = vtiger_leadscf.leadid
       INNER JOIN vtiger_crmentity
       ON vtiger_crmentity.crmid = vtiger_leadaddress.leadaddressid
       WHERE 
      (CONCAT(vtiger_leaddetails.firstname, ' ', vtiger_leaddetails.lastname) LIKE '%" . $_GET['searchField'] ."%' 
        AND vtiger_leadscf.cf_823 = '".$firstname."'
        AND vtiger_leadscf.cf_825 = '".$lastname."'
        AND vtiger_leadscf.cf_1057 = '".$bdate."'
        AND vtiger_crmentity.deleted <> 1
        AND vtiger_leadscf.cf_1039 is null
        )
ORDER BY
    vtiger_leadscf.cf_831 DESC
    " ;

$total_pages = mysql_fetch_array(mysql_query($query1));
$total_pages = $total_pages[num];

 $_SESSION['SESS_QRYTOTALROWS']=$total_pages;

/* Setup vars for query. */
    $targetpage = $_SESSION['SESS_PAGE'];   //your file name  (the name of this file)
    $limit = 8;                                 //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;     

$query = 
"SELECT 
    vtiger_leaddetails.lead_no,
    vtiger_leaddetails.firstname,
    vtiger_leadscf.cf_779,
    vtiger_leaddetails.lastname,
    vtiger_leadscf.cf_831,
    vtiger_leadaddress.mobile,
    vtiger_leaddetails.email,
    vtiger_leadscf.cf_885,
    vtiger_leaddetails.leadstatus
FROM 
    vtiger_leaddetails 
INNER JOIN 
    vtiger_leadscf
ON 
    vtiger_leaddetails.leadid = vtiger_leadscf.leadid
INNER JOIN 
    vtiger_leadaddress
ON 
    vtiger_leadaddress.leadaddressid = vtiger_leadscf.leadid
INNER JOIN vtiger_crmentity
ON vtiger_crmentity.crmid = vtiger_leadaddress.leadaddressid
WHERE 

     (CONCAT(vtiger_leaddetails.firstname, ' ', vtiger_leaddetails.lastname) LIKE '%" . $_GET['searchField'] ."%' 
    AND vtiger_leadscf.cf_823 = '".$firstname."'
    AND vtiger_leadscf.cf_825 = '".$lastname."'
    AND vtiger_leadscf.cf_1057 = '".$bdate."'
    AND vtiger_crmentity.deleted <> 1
    AND vtiger_leadscf.cf_1039 is null

    )

ORDER BY
    vtiger_leadscf.cf_831 DESC

LIMIT $start, $limit
" ;


$result = mysql_query($query)or die(mysql_error());
$_POST['data_num_row']=  mysql_num_rows($result);
while($row = mysql_fetch_assoc($result)) {
    $td_leadno = $row['lead_no'];
    $td_reffname = $row['firstname'];
    $td_refmname = $row['cf_779'];
    $td_reflname= $row['lastname'];
    $td_dateref = $row['cf_831'];
    $td_mobile = $row['mobile'];
    $td_email = $row['email'];
    $td_callstatus = $row['cf_885'];
    $td_leadstatus = $row['leadstatus'];

    echo '
    <tbody>
    <td>'.$td_leadno.'</td>
    <td>'.$td_reffname.' '.$td_refmname.' '.$td_reflname.'</td>
    <td>'.$td_dateref.'</td>
    <td>'.$td_mobile.'</td>
    <td>'.$td_email.'</td>
    <td>'.$td_callstatus.'</td>
    <td>'.$td_leadstatus.'</td>
    </tbody>
    ';
}
    ?>

The problem occurs in pagination when I type some specific names in the search box and for example if this name has more than 10 records, it should definitely have a pagination.. Can someone help me why when I type in the search box and for example it has 50 records. When I click the page 2 or next button. The records won't display and the pagination change to original output of it

Edited by Mark Christian: Update

1
Contributor
1
Reply
19
Views
2 Years
Discussion Span
Last Post by Mark Christian
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.