Laravel Eloquent inner join with multiple conditions

Question

I have a question about inner joins with multiple on values  I did build my code like this in laravel   public function scopeShops  query        return  query- gt join  kg shops   function  join                 join- gt on  kg shops id         kg feeds shop id                join- gt on  kg shops active         1       WRONG            EDITED ON 28-04-2014          join- gt on  kg shops active        DB  raw  1                  Only problem is  it gives this outcome   Column not found  1054 Unknown column  1  in  on clause   SQL  select  kg feeds    from  kg feeds  inner join  kg shops  on  kg shops   id     kg      feeds   shop id  and  kg shops   active     1    Bindings  array                                                                                                As you can see  the multiple conditions in the join go fine  but it thinks the 1 is a column instead of a string  Is this even possible  or do I have to fix it in the where   Thanks in advance

User · Answer

You can see the following code to solved the problem

return $query->join('kg_shops', function($join)
{
    $join->on('kg_shops.id', '=', 'kg_feeds.shop_id');
    $join->where('kg_shops.active','=', 1);
});

Or another way to solved it

 return $query->join('kg_shops', function($join)
{
    $join->on('kg_shops.id', '=', 'kg_feeds.shop_id');
    $join->on('kg_shops.active','=', DB::raw('1'));
});

User · Answer

This is not politically correct but works     - gt leftJoin  players as p   n item id        DB  raw  p id player and n type  player

User · Answer

You can simply add multiple conditions by adding them as where   inside the join closure  - gt leftJoin  table2 AS b   function  join            join- gt on  a field1         b field2           - gt where  b field3        true          - gt where  b field4         1

User · Answer

You may use this example  Might be help you      user   User  select  users     items id as itemId   jobs id as jobId           - gt join  items   items user id       users id           - gt join  jobs  function  join                join- gt on  jobs user id       users id                   - gt on  jobs item id       items id                       - gt get    print r  user

User · Answer

return  query- gt join  kg shops   function  join         join- gt on  kg shops id         kg feeds shop id          - gt select  required column names     - gt where  kg shops active   1   - gt get

User · Answer

More with where in  list of items         linkIds    user- gt links  - gt pluck  id  - gt toArray          tags   Tag  query           - gt join  link tag   function  JoinClause  join  use   linkIds                 joinClause    join- gt on  tags id         link tag tag id                 joinClause- gt on  link tag link id    in    linkIds     -1    and   true                      - gt groupBy  link tag tag id           - gt get         return  tags    Hope it helpful

User · Answer

Because you did it in such a way that it thinks both are join conditions in your code given below   public function scopeShops  query        return  query- gt join  kg shops   function  join                 join- gt on  kg shops id         kg feeds shop id             join- gt on  kg shops active         1                So you should remove the second line   return  query- gt join  kg shops   function  join         join- gt on  kg shops id         kg feeds shop id          Now  you should add a where clause and it should be like this   return  query- gt join  kg shops   function  join       join- gt on  kg shops id         kg feeds shop id  - gt where  kg shops active   1     - gt get

[php] Laravel Eloquent inner join with multiple conditions

Examples related to php

Examples related to laravel

Examples related to eloquent