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