Skip to main content

Searching with Ajax pagination Cakephp

Searching with Ajax pagination Cakephp

Step 1 : View File


<script>
$(document).ready(function(){
$(".pagination a, .header a").on('click',function(){
$('#content').load(unescape($(this).attr("href")),function(){
});
return false;
  });
});
</script>
<div id="content">
<?php
echo $this->Form->create('User',array('type'=>'GET'));
echo $this->Form->input('User.name',array('id'=>'name','error'=>array('class'=>'error'),
                    'required'=>false,'value'=>@$_GET['data']['User']['name']));
echo $this->Form->input('User.email',array('id'=>'email','error'=>array('class'=>'error'),
                    'required'=>false,'value'=>@$_GET['data']['User']['email']));
echo $this->Form->input('User.message',array('id'=>'message','error'=>array('class'=>'error'),
                'required'=>false,'value'=>@$_GET['data']['User']['message']));
echo $this->Form->end('Search');
?>
<table>
<?php foreach($userDetail as $admins){?>
<tr>
<td><?php echo $admins['User']['name'];?></td>
<td><?php echo $admins['User']['email'];?></td>
<td><?php echo $admins['User']['message'];?></td>
</tr>
<?php } ?>
      </table>
<div class="pagination">
<?php echo $this->Paginator->prev('Prev');?>
<?php echo $this->Paginator->numbers(array('separator' => false));?>                
<?php echo $this->Paginator->next('Next');?>
</div>
</div> 

Controller function

public function index()
{

$this->loadModel('User');
$conditions = array();
if($_GET)
{
$data = $_GET;
if(isset($data['name']) && !empty($data['name']))
{
  $conditions = array_merge($conditions,array('User.name LIKE'=>'%'.trim($data['name']).'%'));
}
if(isset($data['email']) && !empty($data['email']))
{
  $conditions = array_merge($conditions,array('User.email LIKE'=>'%'.trim($data['email']).'%'));
}
if(isset($data['message']) && !empty($data['message']))
{
  $conditions = array_merge($conditions,array('User.message LIKE'=>'%'.trim($data['message']).'%'));
}
}
if(!empty($conditions)){
$this->paginate = array('limit'=>1,'order'=>'User.id desc');
$userDetail = $this->paginate('User',$conditions);
$this->set('userDetail',$userDetail);
if($this->RequestHandler->isAjax()){
$this->layout = '';
$this->autoRender = false;
$this->render('index');

}
}
}

}

Comments

Popular posts from this blog

Generate XML file in Cakephp

Steps to Generate XML file using CakePHP: Step-1 Enable to parse xml extension in config route.php file.     Router::parseExtensions('xml'); Step-2 Add Request Handler Component to the Controller    var $components = array(‘RequestHandler’); Step-3 Add controller Action For XML Generation in Post Controller     function generateXMLFile()     {         if ($this->RequestHandler->isXml()) { // check request type             $this->layout = 'empty'; // create an empty layout in app/views/layouts/empty.ctp              }        }  Add header code in empty layout <?php header('Content-type: text/xml');?> <?php echo $this->Xml->header(); ?> <?php echo $content_for_layout; ?> Step-4 Set up View To generate XML Create xml folder inside Posts vi...

Simple JavaScript Object and Class Examples

In JavaScript, most things are objects. An object is a collection of related data and/or functionality Namespace: Everything you create in JavaScript is by default global. In JavaScript namespace is Global object . How to create a namespace in JavaScript? Create one global object, and all variables, methods, and functions become properties of that object. Example:  // global namespace var MYAPP = MYAPP || {}; Explaination: Here we first checked whether MYAPP is already defined.If yes, then use the existing MYAPP global object, otherwise create an empty object called MYAPP How to create sub namespaces? // sub namespace MYAPP.event = {}; Class JavaScript is a prototype-based language and contains no class statement.JavaScript classes create simple objects and deal with inheritance. Example: var Person = function () {}; Explaination: Here we define a new class called Person with an empty constructor. Use the class keyword class Calculation {}; A class expr...

How to Add Next Previous links to The Event Calendar

Add Next/Previous links to The Event Calendar Wordpress Plugin Add code to your child theme’s functions.php file /**  * Allows visitors to page forward/backwards in any direction within month view */ if ( class_exists( 'Tribe__Events__Main' ) ) { class ContinualMonthViewPagination {     public function __construct() {         add_filter( 'tribe_events_the_next_month_link', array( $this, 'next_month' ) );         add_filter( 'tribe_events_the_previous_month_link', array( $this, 'previous_month' ) );     }     public function next_month() {         $url = tribe_get_next_month_link();         $text = tribe_get_next_month_text();         $date = Tribe__Events__Main::instance()->nextMonth( tribe_get_month_view_date() );         return '<a data-month="' . $date . '" href="' . $url . '" rel="next"...