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');

}
}
}

}
Labels:

Comments

Post a Comment

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...
53 comments
Read more

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...
25 comments
Read more

A Guide to UTF-8 for PHP and MySQL

Data Encoding: A Guide to UTF-8 for PHP and MySQL As a MySQL or PHP developer, once you step beyond the comfortable confines of English-only character sets, you quickly find yourself entangled in the wonderfully wacky world of UTF-8. On a previous job, we began running into data encoding issues when displaying bios of artists from all over the world. It soon became apparent that there were problems with the stored data, as sometimes the data was correctly encoded and sometimes it was not. This led programmers to implement a hodge-podge of patches, sometimes with JavaScript, sometimes with HTML charset meta tags, sometimes with PHP, and soon. Soon, we ended up with a list of 600,000 artist bios with double- or triple encoded information, with data being stored in different ways depending on who programmed the feature or implemented the patch. A classical technical rat’s nest.Indeed, navigating through UTF-8 related data encoding issues can be a frustrating and hair-pul...
Post a Comment
Read more