Jump to content

Archived

This topic is now archived and is closed to further replies.

sonoton345

Searching by keyword in CakePHP

Recommended Posts

I just started learning cakePHP framework and need help in doing a quick search like having a table of jobs and I want to search by keyword say "web designer".

This is what I tried but it's just returning everything from the table. Thanks..

<?php

if (!empty($this->data))
        {
              $title = $this ->Sanitize->paranoid($this->data['title']); //retrieve keyword from view form
                         
                          
                $result = $this->Postjob->findAll("Postjob.title LIKE '%".$title."%'");
                
                $this->set('result', $result);    
                    
                
                
          }

?> 

Share this post


Link to post
Share on other sites

From what I understand with cake, there are two ways to do a query.

 

The cake way

http://book.cakephp.org/view/73/Retrieving-Your-Data

 

using the find command.

<?php
$result = $this->Postjob->find('list', array('conditions'=>array("Postjob.title LIKE'=>'%'.$title.'%')));
?>

 

The other method, which should not be used often in my opinion

http://book.cakephp.org/view/456/query

<?php
$result = $this->Postjob->query("SELECT * FROM WHERE Postjob.title LIKE '%".$title."%'");
?>

 

I hope this helps.

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.