Php – simple Search in cakephp 2.0

cakephpPHPsearch

I am trying to build a simple phonebook in cakephp 2.0 that stores & retrieves information.

currently i have a table named contacts, with the following fields in it.
– Name
– Phone no.
– email
– Location

I would like to integrate a simple search feature that lists contacts matching to the query. since its a very basic simple app, I wanna keep this as simple as possible.

any suggestions?

Best Answer

<?php
$keyword=$this->params->query['keyword']; //get keyword from querystring//
//used simpme or condition with singe value checking
//replace ModelName with actual name of your Appmodel
$cond=array('OR'=>array("ModelName.phone LIKE '%$keyword%'","ModelName.name LIKE '%$keyword%'", "ModelName.email LIKE '%$keyword%'")  );

$list = $this->ModelName->find('all',array('conditions')=>$cond);


?>

Related Solutions

How to do case insensitive search in Vim

You can use the \c escape sequence anywhere in the pattern. For example:

/\ccopyright or /copyright\c or even /copyri\cght

To do the inverse (case sensitive matching), use \C (capital C) instead.

Python list of dictionaries search

You can use a generator expression:

>>> dicts = [
...     { "name": "Tom", "age": 10 },
...     { "name": "Mark", "age": 5 },
...     { "name": "Pam", "age": 7 },
...     { "name": "Dick", "age": 12 }
... ]

>>> next(item for item in dicts if item["name"] == "Pam")
{'age': 7, 'name': 'Pam'}

If you need to handle the item not being there, then you can do what user Matt suggested in his comment and provide a default using a slightly different API:

next((item for item in dicts if item["name"] == "Pam"), None)

And to find the index of the item, rather than the item itself, you can enumerate() the list:

next((i for i, item in enumerate(dicts) if item["name"] == "Pam"), None)

Best Answer

Related Solutions

How to do case insensitive search in Vim

Python list of dictionaries search

Related Topic