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 is the role of the .htaccess file in php?
when ever the user logged in the database table the current registered date will be appeared
Tell me how can we automatically escape incoming data?
What are the differences between session and cookie?
What is polymorphism?
How can you encrypt password using php?
Do I need apache for php?
at present am learning lamp course sir ..i want to know the carrer prospectus in php ...is there any companies recruiting freshers in chennai ..for freshers how much can i demand as a fresher in php ....?i finished my mca ..please sugggest me to face interview in php asking salary details and all please suggest me how much can i ask as a fresher in php ? and also tel is there any openings in chennai for recruting php freshers send their emails and company info please ? please send ur valuable suggestions to kiranpulsar2007@gmail.com i hope u wil reply to my question thank u guys bye take care see u soon all the best to everyone
How to retrieve values out of an array?
Why php was called as personal home page?
What are getters and setters and why are they important?
Explain about a search-friendly site looks like?