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...

How To Create Shortcodes In WordPress

We can create own shortcode by using its predified hooks add_shortcode( 'hello-world', 'techsudhir_hello_world_shortcode' ); 1. Write the Shortcode Function Write a function with a unique name, which will execute the code you’d like the shortcode to trigger: function techsudhir_hello_world_shortcode() {    return 'Hello world!'; } Example: [hello-world] If we were to use this function normally, it would return Hello world! as a string 2. Shortcode function with parameters function techsudhir_hello_world_shortcode( $atts ) {    $a = shortcode_atts( array(       'name' => 'world'    ), $atts );    return 'Hello ' . $a['name'] . !'; } Example: [hello-world name="Sudhir"] You can also call shortcode function in PHP using do_shortcode function Example: do_shortcode('[hello-world]');

How to replace plain URLs with links

Here we will explain how to replace Urls with links from string Using PHP $string ='Rajiv Uttamchandani is an astrophysicist, human rights activist, and entrepreneur. Academy, a nonprofit organization dedicated to providing a robust technology-centered education program for refugee and displaced youth around the world.  CNN Interview - https://www.youtube.com/watch?v=EtTwGke6Jtg   CNN Interview - https://www.youtube.com/watch?v=g7pRTAppsCc&feature=youtu.be'; $string = preg_replace('@(https?://([-\w\.]+)+(:\d+)?(/([\w/_\.%-=#]*(\?\S+)?)?)?)@', '<a href="$1">$1</a>', $string); Using Javascript <script> function linkify(inputText) {     var replacedText, replacePattern1, replacePattern2, replacePattern3;     //URLs starting with http://, https://, or ftp://     replacePattern1 = /(\b(https?|ftp):\/\/[-A-Z0-9+&@#\/%?=~_|!:,.;]*[-A-Z0-9+&@#\/%=~_|])/gim;     replacedText = inputT...