Meaning in CI

[eluser]Shaileen[/eluser]
Can you please tell me the meaning of this line in CI...


The line is written in perl/cgi..

WHERE lower($searchField) LIKE lower('%$searchText%') $groupSearch

[eluser]Jan_1[/eluser]
see userguide

Code:

$this->db->like('title', 'match');
// Produces: WHERE title LIKE '%match%'

Does that help you?

[eluser]Shaileen[/eluser]
Nop..

I didnt get the meaning of lower($searchField)
and $groupsearch..

LIKE lower(%Searchtext%) - i got the meaning of this..

[eluser]Shaileen[/eluser]
I replaced that with :

$array = array('searchField' => $searchText, 'groupSearch' => $searchtext);
$this->db->like($array);

is this correct any idea???

[eluser]danmontgomery[/eluser]
lower() is just converting the string to lowercase, php's equivalent is strtolower(). It's unnecessary in this case, because like searches are case-insensitive.