How to convert object of stdClass to array in Laravel

Question

I am getting the next error when trying to display a view in Laravel :

"Cannot use object of type stdClass as array (View: C:\xampp\htdocs\mysite\resources\views\cms\contactus.blade.php)".

My Controller:

public function contactus(){ 

    ContactUS::get_content(self::$data);
    return view('cms.contactus', self::$data); 

}

My Model:

class ContactUS extends Model
{

public $table = 'contactus';

public $fillable = ['name','email','message']; 

static public function get_content(&$data){ 


        $sql = "SELECT cu.*,name,email,message FROM contactus cu "
            . "ORDER BY cu.created_at DESC ";

        $data['contactusd'] = DB::select($sql); 

     }

}

My view:

@extends ('cms.cms_master') 
@section('cms_content')
<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
    <h1 class="page-header">Contact us form information</h1>
    @if($contactusd) 
    <br><br>
    <table class="table table-bordered">  
        <thead>
            <tr>  
                <th>Name</th> 
                <th>Email</th> 
                <th>Message</th> 
            </tr>
        </thead> 
        @foreach($contactusd as $item)  
        <tr>
            <td>{{ $item['name']}}</td> 
            <td>
                <ul>

                    <li> Email: {{ $item['email']}}, Massage: {{$item['message'] }}</li>
                    @endforeach
                </ul>
            </td> 
            <td>{{ $item[created_at]}}</td> 
        </tr>

    </table> 
    @else 
    <p style="font-size: 18px">No information...</p>
    @endif
</div> 

@endsection

Well, you can use it as an object instead (`$item->email`), or convert it to an array `@foreach($contactusd as (array)$item)` — aynber, Sep 07 '17 at 12:28
Possible duplicate of [How do I convert an object to an array?](https://stackoverflow.com/questions/2476876/how-do-i-convert-an-object-to-an-array) — aynber, Sep 07 '17 at 12:28
nah he is asking for laravel and however you should prefer eloquent instead of Raw Queries. — , Sep 07 '17 at 12:39

score 7 · Answer 1 · answered Sep 07 '17 at 12:53

7

To convert an object to array (as is your question) use $array = (array) $object;

answered Sep 07 '17 at 12:53

Quezler

2,376
14
29

score 1 · Answer 2 · answered Sep 07 '17 at 12:29

1

Try this..

$sql = "SELECT cu.*,name,email,message FROM contactus cu "
            . "ORDER BY cu.created_at DESC ";

$data['contactusd'] = DB::select($sql)->get()->toArray();

answered Sep 07 '17 at 12:29

Rahul Dhande

483
5
9

score 1 · Accepted Answer · answered Sep 07 '17 at 12:35

you have hell lot of mistake in your blade file

@if($contactusd) 
    <br><br>
    <table class="table table-bordered">  
        <thead>
            <tr>  
                <th>Name</th> 
                <th>Email</th> 
                <th>Message</th> 
            </tr>
        </thead> 
        @foreach($contactusd as $item)  
        <tr>
            <td>{{ $item->name }}</td> 
            <td>
                <ul>

                    <li> Email: {{ $item->email}}, Massage: {{$item->message }}</li>

                </ul>
            </td> 
            <td>{{ $item->created_at}}</td> 
        </tr>
        @endforeach
    </table> 
    @else 
    <p style="font-size: 18px">No information...</p>
    @endif

or

$contactusd = ContactUS::get_content(self::$data)->toArray();
return view('cms.contactus', $contactusd);

score 1 · Answer 4 · edited Sep 07 '17 at 13:34

1

If you getting data is in std class , you can write like this in view page {{ $item->name }}

If you getting data is in std class , you can write like this in view page {{$item['message']}}

backside write like this

$sql = "SELECT cu.*,name,email,message FROM contactus cu "
            . "ORDER BY cu.created_at DESC ";

$data['contactusd'] = DB::select($sql)->get()->toArray();

edited Sep 07 '17 at 13:34

Ramzan Mahmood

1,881
2
21
46

answered Sep 07 '17 at 12:36

Kalyan Tullimelli

11
2

score 0 · Answer 5 · answered Sep 07 '17 at 12:30

0

use like this

$data = ContactUS::get_content(self::$data)->toArray();
return view('cms.contactus', $data);

answered Sep 07 '17 at 12:30

How to convert object of stdClass to array in Laravel

5 Answers5