How to apply Cake php ajax pagination?
Answer / facebittu
class ReviewsController extends AppController {
var $name = 'Reviews';
var $uses = array('Review','Country','School','User');
var $components = array('RequestHandler');
var $helpers =
array('Html','Form','Javascript','Ajax','Fck');
var $paginate_limit_front = '10';
var $paginate = "";
function beforeFilter() {
parent::beforeFilter();
$this->Auth->allow('*');
}
##########################functions for paging in review
results####################################
function searchresults($page_no = ''){
$this->layout='default1';
$this->set("page_no", $page_no);
}// ef
function search_ajax( $search_srting='') {
$this->set_paginate_limit_search($search_srting); //
Setting Paginate Limit
$this->layout=null;
Configure::write('debug', 0);
$data = $this->paginate();
$countRecords=count($data);
$this->set("serchResultsReviews", $data);
$this->set("paginate_limit", $this->paginate_limit_front);
// Finding Page No (for Sr. No.)
$page_no_arr = explode(":", $_REQUEST['url']);
$this->set("page_no", $page_no_arr[1]);
$this->set("search_srting", $search_srting);
$this->set("total_records", $countRecords);
}
function set_paginate_limit_search( $search_srting = '' )
{
if( $search_srting == '' ){
$this->paginate
=array('conditions'=>array('Review.status'=>1),
'order'=>array('Review.id desc'), 'limit' =>
$this->paginate_limit_front);
}
else
{
$this->paginate =array('conditions' =>array('or'=> array(
'Review.title LIKE' => '%'.$search_srting.'%',
'Review.rating LIKE' => '%'.$search_srting.'%',
'Review.description LIKE' =>
'%'.$search_srting.'%',
'School.name LIKE' => '%'.$search_srting.'%'
)
),
'fields' =>
array('Review.id','Review.title','Review.type','Review.rating','Review.description','School.id','School.name','School.image_url','User.firstname','User.email'),
'limit' => $this->paginate_limit_front
);
} // else ends here
} // ef
###############################################################
}
###################action page################
<script type="text/javascript">
function loadPiece(href,divName) {
// Loading Image....
//$('#imageList').fadeOut('slow');
document.getElementById('imageList').innerHTML =
'<br/><img src="<?php e($html->url('/img/ajax-loader.gif'));
?>" />';//+document.getElementById('imageList').innerHTML;
$(divName).load(href, {}, function(a,b){
//alert(a);
var divPaginationLinks = divName+" #pagination a";
$(divPaginationLinks).click(function() {
var thisHref = $(this).attr("href");
loadPiece(thisHref,divName);
$('#imageList').fadeIn('slow');
return false;
});
});
}
$(document).ready(function() {
<?php $searchText = $this->data['Review']['search']; ?>
loadPiece("<?php echo
$html->url(array('controller'=>'reviews','action'=>'search_ajax/'.$searchText));?>","#imageList");
});
</script>
<div id="imageList" style="text-align:center;">
</div>
#########################ajax ctp################3
<div class="content">
<div id="blueBox">
<div class="top">
<span class="left"><?php echo
$html->image('blue-border-box-top-left.gif',array('alt'=>''));?></span>
<span class="right"><?php echo
$html->image('blue-border-box-top-right.gif',array('alt'=>''));?></span>
<div class="clear"></div>
</div>
<?php
$total=count($serchResultsReviews);
if($total){ ?>
<h3><?php echo $total; ?> displayed from Total <?php echo
$total_records; ?> </h3>
<?php for($i=0;$i<$total;$i++){
if($serchResultsReviews[$i]['School']['image_url']==""){$serchResultsReviews[$i]['School']['image_url']="noImage.jpg";}
?>
<div class="content">
<div style="width:700px; margin:auto">
<div class="userProfileimage">
<?php echo
$html->image('files/users/'.$serchResultsReviews[$i]['School']['image_url'].'',array('alt'=>'','height'=>'150','width'=>'150'));?>
</div>
<div class="userDetails"><strong>Title :</strong><a
href="textreview/<?php echo
$serchResultsReviews[$i]['Review']['id'] ;?>"><?php echo
$serchResultsReviews[$i]['Review']['title'] ; ?></a></div>
<div class="userDetails"><strong>Rating :</strong><?php
echo
$html->image('star-'.$serchResultsReviews[$i]['Review']['rating'].'.gif',array('alt'=>''));?></div>
<div class="userDetails"><strong>Description
:</strong><?php echo
$showIntro=substr($serchResultsReviews[$i]['Review']['description'],0,50);
?>...</div>
<div class="userDetails"><strong>School name :</strong><a
href="<?php
e($html->url('/schools/detail/'.$serchResultsReviews[$i]['School']['id'].''));
?>"><?php echo $serchResultsReviews[$i]['School']['name'] ;
?></a></div>
</div>
</div>
<div class="clear"></div>
<?php }
}
else {
echo "<h3>Sorry no users Profiles found</h3>";
}
?>
<div class="bottom">
<span class="left"><?php echo
$html->image('blue-border-box-bottom-left.gif',array('alt'=>''));?></span>
<span class="right"><?php echo
$html->image('blue-border-box-bottom-right.gif',array('alt'=>''));?></span>
<div class="clear"></div>
</div>
</div>
</div>
<div id="pagination">
<div >
<?php
echo $paginator->first("<<",
array('class'=>'footer_nav','url'=>$search_srting));
echo ' ';
//echo $paginator->prev("<",
array('class'=>'footer_nav'));
echo ' ';
echo $paginator->numbers(array('separator'=>' |
','url'=>$search_srting));
echo ' ';
//echo $paginator->next(">",
array('class'=>'footer_nav'));
echo ' ';
echo $paginator->last(">>",
array('class'=>'footer_nav','url'=>$search_srting));
?>
</div>
</div>
Is This Answer Correct ? | 9 Yes | 0 No |
What are the different opening and closing tags available in PHP?
Difference between mysql_connect and mysql_pconnect?
How to convert a json string to an array in php?
Does it possible to compile php with mysql without having mysql sources?
What type of headers have to add in the mail function in which file a attached?
can anyone explain oops concept in php or give website to learn this concept clearly?
How to enable error reporting in php?
What is the purpose of break and continue statement?
Applications written to provide a GUI shell for Unix and Linux are called
What is the special meaning of __sleep and __wakeup?
Does php need a closing tag?
What is a query in a database?