Laravel 5-Execute sql statement in string

Question

I am using Laravel 5. I need to save some sql statements in a field of a table of the database (these statements are used to get some results). I want to get these statements in my controller and execute them using Laravel, but the statements are only strings, Let's suppose the following

$statement = Table::where('ID', 1);
$statement = $statement->STATEMENT;

In $statement I have a string like this

$statement = 'SELECT SUM(VAL) FROM TABLE';

What I need to know is how to execute in the database the statement saved in my string var $statement I finally want to have something like

$result = 10 (the result of executing 'SELECT SUM(VAL) FROM TABLE', which was in $statement)

Thanks!

So do you know how read the statement but dont how execute it? — Juan Carlos Oropeza
– Juan Carlos Oropeza, Commented Sep 15, 2015 at 19:35
Yeah, that is. I don't know how to execute my $statement :-) — user4839009
– user4839009, Commented Sep 15, 2015 at 19:37

Peyman.H · Accepted Answer · 2015-09-15 19:59:36Z

3

This is called raw queries in laravel. For example:

DB::select(DB::raw('select * from users''));

So in your case(if You've already got $statement):

DB::select(DB::raw($statement));

edited Sep 15, 2015 at 19:59

answered Sep 15, 2015 at 19:52

Peyman.H

1,9521 gold badge17 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Laravel 5-Execute sql statement in string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related