This is the refine search and pagination I have in ASP.NET website 
<div class="main-detail-con" style="width:700px;">
<div style="width:700px; padding-left: 0px;" class="listing-center-numbers">
<div style="width:<%=width %>px; font-size:12px; line-height:12px; float:left; text-align:right; padding:7px 11px 0px 0px;">
<%
if (pg_enablePrevious)
{
%>
<a href="<%=pg_postingUrl + "&index=" + (((pg_currentIndex - 1) * pg_resultPerPage) - 1) %>" style="vertical-align:top;">Previous</a>
<%
}
else
{
%>
<a style="cursor: default; text-decoration: none; padding-left: 5px; vertical-align: top;" href="javascript:void(0);">Previous</a>
<%
}
%>
</div>
<div class="scroll-pane ui-widget ui-widget-header ui-corner-all" style="overflow: hidden;">
<div class="scroll-content" style="margin-left:0px;">
<%
for (int i = 1; i <= pg_totalPages; i++)
{
if (i != pg_currentIndex)
{
if (i == pg_totalPages)
{
%>
<div class="in-active scroll-content-item" style="margin:3px 4px 3px 2px;"><a href="<%= pg_postingUrl + "&index=" + ((i * pg_resultPerPage) - 1) %>"><span><%=i%></span></a></div>
<%
}
else
{
%>
<div class="in-active scroll-content-item" style="margin:3px 4px 3px 2px;"><a href="<%= pg_postingUrl + "&index=" + ((i * pg_resultPerPage) - 1) %>"><span><%=i%></span></a></div>
<%
}
}
else
{%>
<div class="active scroll-content-item" style="margin:3px 4px 3px 2px;"><a href="javascript:void(0);"><span><%=i%></span></a></div>
<%
}
}
%>
</div>
<div class="scroll-bar-wrap ui-widget-content ui-corner-bottom">
<div class="scroll-bar"></div>
</div>
<div class="dot" style="cursor:pointer;position:relative;left:5px;"></div>
</div>
<div style="font-size:12px; line-height:12px; float: left; padding:7px 0px 0px 4px; text-align: left;">
<% if (pg_enableNext)
{
%>
<a href="<%=pg_postingUrl + "&index=" + (((pg_currentIndex + 1) * pg_resultPerPage) - 1) %>" style="vertical-align:top;">Next</a>
<%
}
else
{
%>
<a href="javascript:void(0);" style="cursor:default;text-decoration:none; vertical-align:top;">Next</a>
<%
}
%>
</div>
</div>
</div>
This is the pagination I’m getting by using CLinkPager in my view file
<div class="main-detail-con" style="width:700px;">
<div style="width:700px; padding-left: 0px;" class="listing-center-numbers">
<?php $this->widget('CLinkPager', array(
'currentPage'=>$pages->getCurrentPage(),
'itemCount'=>$resultCount,
'pageSize'=> 10,
'header'=>'',
)) ?>
</div>
</div>
<div class="clear"></div>
In my controller I have
$searchresult = Yii::app()->db->createCommand()->select('unitlistings.*')
->from('unitlistings')
->where($whereClause)
->queryall();
$resultCount = count($searchresult);
$pages=new CPagination($resultCount);
$pages->pageSize=10;
‘pageSize’=> 10, is not limiting to 10 results per page. I’m getting all records on the page using foreach.
I haven’t implemented refine search yet. How can I make the refine search functionality in Yii and the pagination to look and behave similar to the one in .NET ?