Svetoslav Dimitrov Svetoslav Dimitrov - 3 months ago 10
PHP Question

Laravel 5. Retrieve data from DB::select

Code:

$best_price = DB::select('Some SQL statement');

foreach($best_price as $best_price_id) {
$best_price_id->id;
};


$product->best_price_id = $best_price_id;

return $product->best_price_id;


Result:


The Response content must be a string or object implementing
__toString(), "object" given.


Definately I am retrieving information from the DB incorrectly. Please suggest better option.

Answer

The function to which return $product->best_price_id; is returning value is expecting string and you are supplying an object, You need to do

product->best_price_id = $best_price_id->id;

in place of product->best_price_id = $best_price_id;