laravel raw join查询

Question

I have a function that accepts raw where conditions and joins:

query('data',['fieldA','fieldB'], 'fieldA > 10 AND fieldB < 20', 'LEFT JOIN users ON data.user_id = users.id');

function query($table, $keys = [], $where = '', $joins = '') {
   $query = DB::table($table)->select($keys);
   if(!empty($where)) {
      $query=$query->whereRaw($where);
   }
   if(!empty($joins)) {
      $query=$query->?????????????
   }
   return $query->get();
}

How do I use the raw join with the query builder the way I can use whereRaw for the where condition?

Answer 1

Don't bother with the query builder if you're just using raw expressions on everything.

Option 1: Utilize PDO

PDO is the underlying driver used by Laravel. To get the PDO object, run:

$pdo = DB::connection()->getPdo();

Option 2: Run raw queries

You can run entire selects through Laravel without "building" a query:

DB::select("SELECT * FROM table WHERE ..");

This even allows parameter binding when you need it.

https://laravel.com/docs/5.5/database