strpos() expects parameter 1 to be string, object given laravel 5.5

Question

This is my code:

public function getLists(Request $request)
{
    $user = $request->user()->id;
    $apikey = DB::table('apikey')->where('api_key', '=', $user);

    if($apikey){
    $mc = new MailChimp($apikey);
    $mailchimp_ping = $mc->get('lists',['fields' => 
        'lists.id,lists.name']);
    return Response::json($mailchimp_ping, 200);
    }
    else
    {        
        $errorResponse = [
            'message' => 'Lists not found!',
            'error' => '401'
        ];
        return Response::json( $errorResponse);
    }
}

I am trying to get mailchimp list based on logged in user id where i am doing wrong? is my where clause expects something else? Any help would be highly appreciated!

Answer 1

Use the value() method to execute the query and get the key. For example, if a column with key is called apikey:

$apikey = DB::table('apikey')->where('api_key', $user)->value('apikey');

Answer 2

In my case this error came up when changed this:

 Route::view('/report', '/main_pages/orders_parts/report')->name('guzorishi_order_1');

to

Route::get('/report/{order_id}', function ($order_id) {... })->name('guzorishi_order_1');

but forgot Route::view one rename to Route::get