StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPagination-How to display the results per page?
primarykey
Id
19228799
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
8
CommunityOwnedDate
CreationDate
2013-10-07T15:31:54.943
FavoriteCount
0
LastActivityDate
2013-10-07T15:54:52.820
LastEditDate
2013-10-07T15:46:38.110
LastEditorUserId
2834404
OwnerUserId
2834404
ParentId
0
PostTypeId
1
Score
0
ViewCount
1162
LastEditorDisplayName
text
Body
<p>I have already done my scripting to display only 40 results per page,but I cant let the user to see the remaining results in the next page.I am getting the data using Curl operation.</p> <p>I am not posting the code because it is so lengthy. Please check this <a href="http://www.travelpunk.com/blog/result/?action=search&search_propertyid=&search_from_suggestion=0&searchkeywords=Melbourne,%20Australia&reset=1&search_type=dropdown&city=Melbourne&country=Australia&search_keywords=Or%20type%20a%20city%20or%20property%20name&propType%5B%5D=HOSTEL&propType%5B%5D=GUESTHOUSE&propType%5B%5D=HOTEL&propType%5B%5D=APARTMENT&propType%5B%5D=CAMPSITE&date_from=07%20Oct%202013&NumNights=3&guests=2&group_type=#" rel="nofollow">link</a></p> <p>So,How can I display the remaining results on the next page?</p> <p>Sorry,if there is any mistake in my Question. Thank you</p> <pre><code> if($search_results['api']['status']=="Success") { $inc= 1; $ert = $search_results['result']['Properties']; if($sortby=='Name'){ foreach ($ert as $name) { $names[] = $name['name']; } array_multisort($names, SORT_ASC, $ert); } if($sortby=='OverallRating'){ foreach ($ert as $name) { $names[] = $name['avgRating']; } array_multisort($names, SORT_NUMERIC,SORT_DESC, $ert); } if($sortby=='Price'){ foreach ($ert as $name) { $tuti = array_keys($name['bedPrices']['cheapestPrivate']); // echo $name['bedPrices']['cheapestPrivate'][$tuti[0]]; $names[] = $name['bedPrices']['cheapestPrivate'][$tuti[0]]; } array_multisort($names, SORT_NUMERIC,SORT_ASC, $ert); } // var_dump($ert['bedPrices']); foreach($ert as $hostels) { if($inc>$page_limit){ continue; } if(!((int)$hostels['avgRating'] >= (int)$min_rate && (int)$hostels['avgRating'] <= (int)$max_rate)) continue; if(!((int)$hostels['bedPrices']['cheapestPrivate']['USD'] >= (int)$min_pricing && (int)$hostels['bedPrices']['cheapestPrivate']['USD'] <= (int)$max_pricing)) continue; if(!(in_array($hostels['type'],$properties_zan_array))) continue; // var_dump($hostels); $arry_hostel = (array) $hostels; foreach ($arry_hostel['roomTypes'] as $hkey => $hvalue) { if(arrayInString($roomtype_zan_array,$hvalue['description'])){ echo $hostels[0]['ResultCount']; ?> <?php $propNum1 =$hostels['number']; ?> <div class="search_result"> <div class="se_img"> <div class="top_rated">Top Rated</div> <form action='hostel-details' method='GET'> <input type='hidden' name='hname' value='<?php echo $hostels['name'];?>'> <input type='hidden' name='city' value='<?php echo "$citi" ;?>'> <input type='hidden' name='date_st' value='<?php echo "$startdate" ;?>'> <input type='hidden' name='date_end' value='<?php echo "$enddate" ;?>'> <input type='hidden' name='num' value='<?php echo "$Num" ;?>'> <input type='hidden' name='propnum' value='<?php echo "$propNum1" ;?>'> <input type='hidden' name='guestnum' value='<?php echo $guests?>'> <a href='#' onclick='this.parentNode.submit()'> <img src="<?php echo $hostels['images']['0']['url'] ?>" height="80" width="120" class="search_img" title="<?php echo $hostels['name']; ?>" /> </a> <span><?php echo $hostels['type']; ?></span> </div> <div class="se_detail"> <form action='hostel-details' method='GET'> <input type='hidden' name='hname' value='<?php echo $hostels['name'];?>'> <input type='hidden' name='city' value='<?php echo "$citi" ;?>'> <input type='hidden' name='date_st' value='<?php echo "$startdate" ;?>'> <input type='hidden' name='date_end' value='<?php echo "$enddate" ;?>'> <input type='hidden' name='num' value='<?php echo "$Num" ;?>'> <input type='hidden' name='propnum' value='<?php echo "$propNum1" ;?>'> <input type='hidden' name='guestnum' value='<?php echo $guests?>'>  <a href="#"><button style="border: none;"><font style="color:blue"> <h2 class="se_title" ><?php echo $hostels['name']; ?></h2>  <div class="se_meta"><?php echo $hostels['address1'].", ".$hostels['address2'] ?></div></font></button></a></form> <?php $propNum =$hostels['number']; ?>  <div class="se_desc"><?php echo substr($hostels['shortDescription'],0,80)."..." ?>  <form action='hostel-details' method='GET'> <input type='hidden' name='hname' value='<?php echo $hostels['name'];?>'> <input type='hidden' name='city' value='<?php echo "$citi" ;?>'> <input type='hidden' name='date_st' value='<?php echo "$startdate" ;?>'> <input type='hidden' name='date_end' value='<?php echo "$enddate" ;?>'> <input type='hidden' name='num' value='<?php echo "$Num" ;?>'> <input type='hidden' name='propnum' value='<?php echo "$propNum" ;?>'> <input type='hidden' name='guestnum' value='<?php echo $guests?>'>  <a href='#' onclick='this.parentNode.submit()'>More Info</a> </form> </div> <div class="se_review"> <?php if($hostels['avgRating']==0) { echo '<span style="font-weight:bold;float:left;">No Rating</span>'; } else { echo '<div class="se_per">'.$hostels['avgRating']."%".'</div>'; } ?> <a href="#"> <?php if($hostels['starRating']!='None' &&$hostels['starRating']!=0) { echo $hostels['starRating']." Total Reviews"; } else echo '<span style="font-weight:bold;"> No Reviews</span>'; ?> </a> <div style="clear:both;"></div> </div> <div class="se_compare">  </div> </div> <div class="se_price"> <?php if(!empty($hostels['bedPrices'])) { if(isset($hostels['bedPrices']['cheapestDorm'])) { foreach($hostels['bedPrices']['cheapestDorm'] as $currency=>$price){ echo '<div class="do_form">Dorms From</div>'; echo '<div class="do_price">'.$currency.$price.'</div>'; } } if(isset($hostels['bedPrices']['cheapestPrivate'])) { foreach($hostels['bedPrices']['cheapestPrivate'] as $currency=>$price) { echo '<div class="do_form">Privates From</div> <div class="do_price">'.$currency.$price.'</div>'; } } } ?> <div class="book_btn"> <form action='hostel-details' method='GET'> <input type='hidden' name='hname' value='<?php echo $hostels['name'];?>'> <input type='hidden' name='city' value='<?php echo "$citi" ;?>'> <input type='hidden' name='date_st' value='<?php echo "$startdate" ;?>'> <input type='hidden' name='date_end' value='<?php echo "$enddate" ;?>'> <input type='hidden' name='num' value='<?php echo "$Num" ;?>'> <input type='hidden' name='propnum' value='<?php echo "$propNum" ;?>'> <input type='hidden' name='guestnum' value='<?php echo $guests?>'>  <a href='#' onclick='this.parentNode.submit()'>Book Now</a> </div> </div> <div style="clear:both;"></div> </div> <?php break; } } $inc++; } echo $inc; } </code></pre>
Tags
<php><jquery><pagination><search-engine>
Title
Pagination-How to display the results per page?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USManju
UserOwnerUserId
1. USManju
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POPagination-How to display the results per page?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.