Implement searchMore using PHP

The following sample code will search for a customer record. The search result could be a thousand records and not ideal to display all the result in one request.

The searchMore method was created to handle pagination. We can limit the data to be display when using search method and use searchMore to get the next set of results.

Pagination breaks up a large number of records that are part of a search result set into smaller pages. You then have the ability to retrieve these pages of records one at a time. Pagination is used mainly to make processing large result sets earier and more manageable.

1. Create a new PHP file and add the following HTML code in the body section. Save the PHP file as searchCust.php.

<div> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <div> <form id="form" name="form" action="searchCust.php" method="post" > <input id="customerSearchString" name="customerSearchString" type="text" /> <input id="submit" name="submit" type="submit" value="Search" /> </form> </div> </td> </tr> </table></div>

2. Here's a sample PHP script:

<?phprequire_once 'PHPtoolkit.php';require_once 'login_info.php';global $myNSclient;# SEARCH Customers# ===============// Set search preferences; 5 item per page$myNSclient->setSearchPreferences(false, 5);//read values from POST and GET$customerSearchString = $_POST['customerSearchString'];$searchId = $_GET['searchId'];if ($customerSearchString != "") { $customerSearchParam = new nsComplexObject('SearchStringField'); $customerSearchParam->setFields(array( 'searchValue' => $customerSearchString, 'operator' => 'contains' )); $customerSearchBasic = new nsComplexObject("CustomerSearchBasic"); $customerSearchBasic->setFields(array( 'companyName' => $customerSearchParam )); $searchResponse = $myNSclient->search($customerSearchBasic); if ($searchResponse->isSuccess) { //this is a simple example we will only get the entityId and companyName of the customer records and display in a table. echo "<table>"; echo "<tr>"; echo "<td>Entity Id</td>"; echo "<td>Company Name</td>"; echo "</tr>"; foreach ($searchResponse->recordList as $record) { $entityId = $record->getField("entityId"); $companyName = $record->getField("companyName"); echo "<tr>"; echo "<td>" . $entityId . "</td>"; echo "<td>" . $companyName . "</td>"; echo "</tr>"; } echo "</table>"; $searchId = $searchResponse->searchId; $currentPage = $searchResponse->pageIndex; $pageSize = $searchResponse->pageSize; $totalRecords = $searchResponse->totalRecords; $resultsOne = (($currentPage - 1) * $pageSize) + 1; $resultsTwo = $totalRecords < ($pageSize * $currentPage) ? $totalRecords : ($pageSize * $currentPage); echo ""; if ($totalRecords > 0) { echo "Results $resultsOne - $resultsTwo of $totalRecords"; if ($resultsOne != "1") echo "<a href='javascript:history.go(-1)' >Prev</a>"; if ($resultsTwo < $totalRecords) echo "<a href='searchCust.php?page=" . ($currentPage + 1) . "&searchId=$searchId'>Next</a>"; //use href='javascript:history.go(1)' instead of performing a search again when clicking Next } else { //zero results echo "No records found."; } echo "</div>"; } else { echo "Failed"; }} elseif (!is_null($searchId)) { //this would be the second time the page will be call, a searchId is already pass on the GET header, we will now use searchMore. $page = $_GET['page']; $searchResponse = $myNSclient->searchMore($page); echo "<table>"; echo "<tr>"; echo "<td>Entity Id</td>"; echo "<td>Company Name</td>"; echo "</tr>"; foreach ($searchResponse->recordList as $record) { $entityId = $record->getField("entityId"); $companyName = $record->getField("companyName"); echo "<tr>"; echo "<td>" . $entityId . "</td>"; echo "<td>" . $companyName . "</td>"; echo "</tr>"; } echo "</table>"; $searchId = $searchResponse->searchId; $currentPage = $searchResponse->pageIndex; $pageSize = $searchResponse->pageSize; $totalRecords = $searchResponse->totalRecords; $resultsOne = (($currentPage - 1) * $pageSize) + 1; $resultsTwo = $totalRecords < ($pageSize * $currentPage) ? $totalRecords : ($pageSize * $currentPage); echo ""; if ($totalRecords > 0) { echo "Results $resultsOne - $resultsTwo of $totalRecords"; if ($resultsOne != "1") echo "<a href='javascript:history.go(-1)'>Prev</a>"; if ($resultsTwo < $totalRecords) echo "<a href='searchCust.php?page=" . ($currentPage + 1) . "&searchId=$searchId'>Next</a>"; } else { echo "No records found."; } echo "</div>";}