Codeigniter LIKE with wildcard

Question

I have simple database query in codeigniter  however I cannot get search to work with wildcard  This is my code    this- gt db- gt like  film title     query      this- gt db- gt escape like str  query    res    this- gt db- gt get  film      If I remove wildcard    then search works fine  Also  query is just string with user input  Any help is appreciated

User · Answer

Searching multiple fields at once can be done like so     function search  search         sql    SELECT   FROM some table     WHERE UPPER a name  LIKE       OR     UPPER a full name  LIKE       OR     UPPER a city  LIKE       OR     UPPER a code  LIKE               arr   array map array  this  wrapLIKE   array  search   search   search   search         r    this- gt db- gt query  sql   arr       return  r     function wrapLIKE  string        return strtoupper    string

User · Answer

For Full like you can user      this- gt db- gt like  title   query     For   query you can use    this- gt db- gt like  title    query   before      and for  query  you can use    this- gt db- gt like  title    query   after

User · Answer

this- gt db- gt like    This method enables you to generate LIKE clauses  useful for doing searches    this- gt db- gt like  title    match     Produces  WHERE title LIKE   match    If you want to control where the wildcard     is placed  you can use an optional third argument  Your options are    before        after        none    and    both     which is the default     this- gt db- gt like  title    match    before     Produces  WHERE title LIKE   match    this- gt db- gt like  title    match    after        Produces  WHERE title LIKE  match     this- gt db- gt like  title    match    none     Produces  WHERE title LIKE  match    this- gt db- gt like  title    match    both     Produces  WHERE title LIKE   match

User · Answer

this- gt db- gt like  title    match    before         Produces  WHERE title LIKE   match      this- gt db- gt like  title    match    after        Produces  WHERE title LIKE  match      this- gt db- gt like  title    match    both        Produces  WHERE title LIKE   match

User · Answer

this- gt db- gt like   automatically adds the  s and escapes the string  So all you need is   this- gt db- gt like  title    query    res    this- gt db- gt get  film      See the CI documentation for reference  CI 2  CI 3  CI 4

User · Answer

I m using    this- gt db- gt query  SELECT   FROM film WHERE film title LIKE    query      for such purposes

User · Answer

If you do not want to use the wildcard     you can pass to the optional third argument the option  none     this- gt db- gt like  title    match    none        Produces  WHERE title LIKE  match

[mysql] Codeigniter LIKE with wildcard(%)

Examples related to mysql

Examples related to sql

Examples related to codeigniter

Examples related to activerecord