php - CodeIgniter 3 Query ESCAPE '!' Ignoring the WHERE statement? -

-

i building site search select boxes categories & regions. if selected including in query, reason, using ignoring section of query!?!? why or doing wrong?

when echo query built codeigniter fololowing: (note escape '!')

query echo:

      select sql_calc_found_rows null rows, ads.id id, location, provlabel, text,    adcat.id catid, ads.subcatid subcatid, ads.province r_rand, r_option, addate,    adcat.name catname, adsubcat.name subname, f_value, adtitle, ads.area, regionlabel,    adlink    `ads`    join `search_town` on `search_town`.`townid`=`ads`.`townid`    join `search_region` on `search_region`.`regionid`=`ads`.`area`    join `search_prov` on `search_prov`.`provid`=`ads`.`province`    join `adcat` on `adcat`.`id`=`ads`.`catid`    join `adsubcat` on `adsubcat`.`id`=`ads`.`subcatid`    left join `adfields` on `adfields`.`ad_id`=`ads`.`id`    `ads`.`catid` != 8 , `ads`.`adactive` = 1 , `scam` =0 , `ads`.`province` = '1'    , `ads`.`catid` = '3' , `text` '%nissan%' escape '!'    or `f_value` '%nissan%' escape '!'    group `ads`.`id`    order `addate` desc    limit 10

here actual query in controller:

        public function get_search($fsearch, $fcategory, $fprovince, $farea, $limit, $start)     {        if($fcategory >=1){       $incl_cat=" , ads.catid='$fcategory'";        }else{       $incl_cat='';       }       if($fprovince>=1){       $incl_prov=" , ads.province='$fprovince'";       }else{       $incl_prov='';       }       if($farea >= 1){       $incl_area=" , ads.area='$farea'";       }else{       $incl_area='';       }                                     $this->db->select('sql_calc_found_rows null rows, ads.id id, location, provlabel, text, adcat.id catid, ads.subcatid subcatid,ads.province         r_rand, r_option, addate, adcat.name catname, adsubcat.name subname, f_value, adtitle, ads.area, regionlabel,       adlink', false);        $this->db->from('ads');        $this->db->join('search_town', 'search_town.townid=ads.townid');        $this->db->join('search_region', 'search_region.regionid=ads.area');        $this->db->join('search_prov', 'search_prov.provid=ads.province');        $this->db->join('adcat', 'adcat.id=ads.catid');        $this->db->join('adsubcat', 'adsubcat.id=ads.subcatid');        $this->db->join('adfields', 'adfields.ad_id=ads.id', 'left');        $where = "ads.catid!=8 , ads.adactive=1 , scam=0 $incl_prov $incl_cat $incl_area";        $this->db->where($where);        $this->db->like('text', $fsearch);        $this->db->or_like('f_value', $fsearch);        $this->db->group_by("ads.id");        $this->db->order_by('addate', 'desc');        $this->db->limit($limit, $start);        $query = $this->db->get();        $return = $query->result_array();        echo $this->db->last_query();        $total_results=$this->db->query('select found_rows() count;')->row()->count;        $this->session->set_userdata('tot_search', $total_results);        return $return;      }

your condition 

a , b , c , d , ... , x or y

if y true whole condition true.

perhaps mean:

a , b , c , d , ... , (x or y)

the escape character defaults \, looks codeigniter has changed ! (presumably because \ escape in php, need multiples , can confusing).

currently irrelevant query. used if need match % or _ !% or !_ (default \% or \_).


Comments

Post a Comment

Popular posts from this blog

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require...
Read more

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u...
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork...
Read more