fetching null value in php framework, laravel query builder

Question

I need laravel query builder to fetch '' as gdate to do union of another query.

example below:

$unionquery = DB::table('mt_task_category')
->whereIn('role_id', [1])
->select('null as gdate', 'null as user_id', 
         'category_id', 'category_name', 
         'null AS timeSum', 'null AS gdfullname', 
         'null AS id', 'null AS pmfullname', 'null AS role_name');

linktoahref · Accepted Answer · 2017-07-26 09:43:41Z

1

You could make use of DB::raw()

$unionquery = DB::table('mt_task_category')
                ->select(DB::raw('null AS gdate', 'null AS user_id', 
                        'category_id', 'category_name', 
                        'null AS timeSum' , 'null AS gdfullname', 
                        'null AS id', 'null AS pmfullname', 
                        'null AS role_name'));
                ->whereIn('role_id', [1])
                ->get();

answered Jul 26, 2017 at 9:43

linktoahref

8,0273 gold badges32 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

fetching null value in php framework, laravel query builder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related