laravel eloquent Array to string conversion

Question

I building a helper in laravel to return a single field from eloquent.

class Helper {

    public static function getAddress($id) {
        //intval($id);
        $result = DB::table('tableaddress')
            ->where('id',$id)
            ->pluck('address');

        //dd($result);
        return $result;

    }
}

In the view i'm calling it via {!! Helper::getAddress(112233) !!} but getting an error of Array to string conversion.

Here is if the result of dd

How do I get the address to return a string. Thanks

Alexey Mezenin · Accepted Answer · 2016-12-25 15:01:27Z

5

You need to get first result from an array, so use this:

->pluck('address')[0];

edited Dec 25, 2016 at 15:01

answered Dec 25, 2016 at 14:53

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

12 Comments

Shafiq Mustapa Over a year ago

yeah, i need to return as a string. but your solutions return Call to a member function first() on array

Alexey Mezenin Over a year ago

Use [0] The first() method will also work if you'll use Eloquent instead of Query Builder.

Jaykumar Patil Over a year ago

Well @Shafiq which laravel you are using. Because I checked in Laravel 5 dd($result); gives string output.

Jaykumar Patil Over a year ago

So the conclusion is that your code is correct, right ?

Shafiq Mustapa Over a year ago

yes the solutions is correct. i'm using local db which is not updated. after some git push, the code work fine. thanks

|

Amit Gupta · Accepted Answer · 2016-12-25 14:51:08Z

2

You can try it as:

{!! Helper::getAddress(112233)->first() !!}

Or add first directly in your helper function as:

$result = DB::table('tableaddress')
           ->where('id',$id)
           ->pluck('address')
           ->first();

answered Dec 25, 2016 at 14:51

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

2 Comments

Shafiq Mustapa Over a year ago

error return Call to a member function first() on array

Amit Gupta Over a year ago

If it's an array then try with [0].

Bara' ayyash · Accepted Answer · 2016-12-25 14:52:29Z

0

You need to loop through the returned result from Helper::getAddress(112233)

answered Dec 25, 2016 at 14:52

Bara' ayyash

1,9211 gold badge17 silver badges26 bronze badges

Collectives™ on Stack Overflow

laravel eloquent Array to string conversion

3 Answers 3

12 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

12 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related