How to add SQL query by variable in DB::Select() in Laravel

Question

I have a DB::select() query where I want to add dynamic SQL by variable.

This is what I'm trying to do but it returns SQL syntax error.

$restaurantSql = "";
$restaurantIds = [6,43,51];

if ($someOtherVariable) {
    $restaurantSql = "AND orders.restaurant_ids IN (".implode(",", $restaurantIds).")";
}

$result = DB::select(
    "SELECT *
    FROM orders
    JOIN restaurants ON orders.restauant_id = restaurants.id
    WHERE orders.status = 'complete' :restaurant_sql AND
    orders.created_at >= :start_date",
    ["restaurant_sql" => $restaurantSql, "start_date" => $startDate]
);

The start_date works as per the documentation from Laravel but the restaurant_sql is not working. Any idea how I can achieve this?

Tirdad Abbasi · Accepted Answer · 2021-02-24 02:51:09Z

1

I think your problem is here

$result = DB::select(
    "SELECT *
    FROM orders
    JOIN restaurants ON orders.restauant_id = restaurants.id
    WHERE orders.status = 'complete'". $restaurantSql. "AND
    orders.created_at >= :start_date",
    ["restaurant_sql" => $restaurantSql, "start_date" => $startDate]
);

edited Feb 24, 2021 at 2:51

answered Feb 24, 2021 at 2:31

Tirdad Abbasi

7575 silver badges18 bronze badges

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

3 Comments

Rifat Bin Reza Over a year ago

I don't want to add the restaurant ids, I want to add the whole SQL dynamically.

Tirdad Abbasi Over a year ago

Ok, I got it, I changed the code. please check it again

Rifat Bin Reza Over a year ago

Didn't know it can work like that. Thank you sm

Collectives™ on Stack Overflow

How to add SQL query by variable in DB::Select() in Laravel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related