array_merge(): Argument #1 is not an array in laravel 5.5

Question

I am facing some issue and this about array_merge in laravel My Controller code method:

    public function isConnectedMA()
{
    $user_id = Auth::user()->id;
    if(!empty($user_id)) {
        $isConnectedM = DB::table('user_mlc_mailchimp')->where('user_id', $user_id)->get();
        $isConnectedA = DB::table('user_mlc_aweber')->where('user_id', $user_id)->get();
    }
        $MergeArray = array_merge($isConnectedM,$isConnectedA);
    $resultArray = ['status' => 1, 'message' => 'Template uploaded!', 'dataArray' => $MergeArray];
    return Response::json($resultArray,200);

}

the error i am facing is

array_merge(): Argument #1 is not an array

i dont know where i am wrong any help will be highly appreciated !

Solution 1

Use toArray() to convert collections to array

$isConnectedM = DB::table('user_mlc_mailchimp')->where('user_id', $user_id)->get()->toArray();
$isConnectedA = DB::table('user_mlc_aweber')->where('user_id', $user_id)->get()->toArray();

Solution 2

In laravel ->get(); returns the collection object, you should user ->toArray() here.

Comments

[The fourth bird]

You could check var_dump($isConnectedM); and var_dump($isConnectedA);

[shahzad1122]

ok i have solved my problem but here is i am facing one more issue

[shahzad1122]

You can see i put a condition if(!empty) and after that i want to check if this is empty and show some kind of message but i am trying to do this but i am getting unreachable statement.

[shahzad1122]

ok i have solved my problem but here is i am facing one more issue

[shahzad1122]

You can see i put a condition if(!empty) and after that i want to check if this is empty and show some kind of message but i am trying to do this but i am getting unreachable statement.

[fumi]

i dont inderstand enough. ` if(!empty) ` collection object .is ... → if($isConnectedM->isEmpty()) or if($isConnectedM->count() > 0)

[Sohel0415]

@shahzad1122 yes, go on, explain your new problem

[shahzad1122]

its not going on if(empty($user_id) condition

[bharadwaja Gummadi]

@shahzad1122, then print/debug what is the value of $user_id. and check in the database whether is there a record with the given id or not. Before merging the two arrays, check what is the output of these - $isConnectedM = DB::table('user_mlc_mailchimp')->where('user_id', $user_id)->get()