Using Laravel Query Builder returns Undefined property: stdClass error

Question

I have a query that works before using laravel eloquent method

$products = Product::where('category', 'ILIKE', '%'.$conditionTxt.'%')
                            ->orderBy('created_at', 'desc')
                            ->get();

But after using query builder approach

$products = DB::table('products')
                      ->where('category', 'ILIKE', '%'.$conditionTxt.'%')
                      ->orderBy('created_at', 'desc')
                      ->get();

It returns this error:

Undefined property: stdClass::$inventory

Here is my model and portion of the view where it points the error.

Model

public function inventory(){
    return $this->hasMany('App\InventoryRecord\InventoryRecord');
}

View:

<td>
    <?php 
    for($i = 0; $i < count($val->inventory); $i++){
        if( $val->inventory[$i]->total_qty <= 50 )  { ?>
            <span style="color:#C00"><?php echo $val->inventory[$i]->total_qty.' -'; ?></span>
        <?php  }else{ ?>
            <span style="color:#25A602"><?php echo $val->inventory[$i]->total_qty.' -'; ?></span>
        <?php
        }
    }
    ?>
</td>

Can somebody help me with this please? :(

Eli
– Eli

2016-12-24 02:54:58 +00:00
Commented Dec 24, 2016 at 2:54 — Eli
– Eli, Commented Dec 24, 2016 at 2:54

Amit Gupta · Accepted Answer · 2016-12-24 06:17:29Z

1

When you use query builder approach it returns an Illuminate\Support\Collection containing the results where each result is an instance of the PHP StdClass object (not a model object). You may access each column's value by accessing the column as a property of the object.

But you can't access the Model relations because you have PHP StdClass object.

I would suggest you, stick to Laravel eloquent.

answered Dec 24, 2016 at 6:17

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

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

Comments

patricus · Accepted Answer · 2016-12-24 09:49:03Z

1

You are mixing up two different pieces of functionality. Laravel provides a data access layer, which is the Query Builder. Laravel also provides an ORM called Eloquent, which is built on top of the Query Builder.

When you use Eloquent to query the database, you will get instances of your Eloquent Models back.

When you use the Query Builder to query the database, you will get instances of stdClass back.

The query builder doesn't, and shouldn't, know anything about your Eloquent models. If you need Eloquent functionality (like accessing your inventory relationship), then you need to use Eloquent to query the database.

answered Dec 24, 2016 at 9:49

patricus

62.9k15 gold badges157 silver badges154 bronze badges

Collectives™ on Stack Overflow

Using Laravel Query Builder returns Undefined property: stdClass error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related