4

here is my Query

$RecipientList = Employees::select(DB::Raw('CONCAT(first_name," ",last_name) as employee_name'),'email')->pluck('employee_name','email');

which give me the proper result as i want,

but after i execute query i have 1 more key => value pair to push in the result array.

If i print the current result , its something like this .

Illuminate\Support\Collection Object
(
    [items:protected] => Array
        (
            [punit@*****.com] => Punit Gajjar
            [milan@*****.com] => Milan Gajjar
            [pritesh@*****.com] => Pritesh Modi
            [pratik@*****.com] => Pratik Modi
            [jyoti@*****.com] => Jyotiranjan J..
        )

)

Bit if i try to push my Key=>valye pair into this array it dosn't work.

array_push(array("All"=>"All"),$RecipientList);

Need Output something like

Illuminate\Support\Collection Object
    (
        [items:protected] => Array
            (
                [All] => All
                [milan@*****.com] => Milan Gajjar
                [milan@*****.com] => Milan Gajjar
                [pritesh@*****.com] => Pritesh Modi
                [pratik@*****.com] => Pratik Modi
                [jyoti@*****.com] => Jyotiranjan J..
            )

    )

2 Answers 2

6

It is because $RecipientList is Collection and not the Array.

Try this

RecipientList = Employees::select(DB::Raw('CONCAT(first_name," ",last_name) as employee_name'),'email')->pluck('employee_name','email')->toArray();

If this does not work, try below code

RecipientList = Employees::select(DB::Raw('CONCAT(first_name," ",last_name) as employee_name'),'email')->get()->pluck('employee_name','email')->toArray();

Hope this will help you.

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

Comments

4

You have Illuminate\Support\Collection object not array. You can do

$RecipientList->push(["All"=>"All"]);

UPD: There is prependmethod

$RecipientList->prepend('All', 'All');

2 Comments

Nope.. My result is Illuminate\Support\Collection Object ( [items:protected] => Array ( [punit@*****.com] => Punit Gajjar [milan@*****.com] => Milan Gajjar [pritesh@*****.com] => Pritesh Modi [pratik@*****.com] => Pratik Modi [jyoti@*****.com] => Jyotiranjan J.. [0] => Array ( [All] => All ) ) ) after using your solution.
@PunitGajjar How about prepend method? $RecipientList->prepend('All', 'All');

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.