php - Multiple joins with where, like and or_like CodeIgniter 3 Active Records -


i trying this:

        $location = 'a';         $this->db->select('l.id, d.guests, l.city, l.country');         $this->db->from('offers o');         $this->db->join('location l', 'l.id = o.id', 'left');         $this->db->join('desc d', 'd.offer_id = o.id', 'left');         $this->db->where('d.guests', $guests);         $this->db->where('o.completed', 1);         $this->db->where('l.country like', $location.'%');         $this->db->or_where('l.city like', $location.'%');         $this->db->limit(5);

and have offer 3 guests , country albania (1 row per table it). but, if $guests = 2; have result 1 row. same, if use like , or_like instead where , or_where. if comment line:

$this->db->or_where('l.city like', $location.'%');

all works fine, have no results if $guests != 3 , 1 row result if $guests = 3.

generated query $this-db->last_query() is:

select 'l'.'id', 'd'.'guests', 'l'.'city', 'l'.'country' 'offers' 'o' left join 'location' 'l' on 'l'.'id' = 'o'.'id' left join 'desc' 'd' on 'd'.'id' = 'o'.'id' 'd'.'guests' = 3 , 'o'.'completed' = 1 , 'l'.'country' 'a%' or 'l'.'city' 'a%' limit 5

how can make query ? select values completed = 1, guests = $guests , city or country $location.

try code 

$location = 'a'; $this->db->select('l.id, d.guests, l.city, l.country'); $this->db->from('offers o'); $this->db->join('location l', 'l.id = o.id', 'left'); $this->db->join('desc d', 'd.offer_id = o.id', 'left'); $this->db->where('d.guests', $guests); $this->db->where('o.completed', 1); $this->db->where("(l.country '".$location."%' or l.city '".$location."%')"); $this->db->limit(5);

-

Comments

Post a Comment

Popular posts from this blog

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more