dongzangchui2072 2019-03-07 11:05
浏览 197
已采纳

Eloquent WHERE IN使用原始查询/胶囊管理器

I want to write this query in eloquent using raw queries :

INSERT INTO table SELECT * FROM other_table WHERE other_table_id IN (1,2,3)

I've tried writing it like this :

use Illuminate\Database\Capsule\Manager as DB;
$insert_db = DB::select("SELECT products_id FROM products WHERE products_id IN (?)", [[265792,265787,265743]])

But this is giving me an empty array as a result.

What is the correct way of writing this using the capsule manager? (I absolutely need to do it using DB::select)

This question is asking the same thing, back in 2013. Back then it was not possible. So did that change today? Can we use WHERE IN (?) in the latest versions of eloquent? Knowing that I NEED to use ? for security, and not concatenate the string or it would be meaningless to use PDO at all.

EDIT :

The question is more about dynamic values. I can't use :

DB::select("SELECT products_id FROM products WHERE products_id IN (?, ?, ?)", [265792,265787,265743]);

Because the array [265792,265787,265743] is being built elsewhere. So imagine the following code

foreach($test as $k => $v) {
    $arr[] = $v['something']
}

DB::select("SELECT products_id FROM products WHERE products_id IN (?)", [[$arr]]);
  • 写回答

2条回答 默认 最新

  • doumiao0498 2019-03-07 11:53
    关注

    A cleaner approach to generate the ?, placeholders is to use str_repeat:

    $in = str_repeat('?,', count($arr) - 1) . '?';
    

    Edit #1

    To handle instances where you have zero items in your array, I came up with the following function:

    function in($arr)
    {
      return count($arr) > 0 ? str_repeat('?,', count($arr) - 1) . '?' : false;
    }
    

    Live Example

    Repl

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 MATLAB动图问题
  • ¥15 有段代码不知道怎么理解,const isToken = (config.headers || {}).isToken === false
  • ¥100 采用栈和深度优先算法对我的代码进行修改显示路径
  • ¥15 pointnet2包安装
  • ¥20 射频功率问题,解答者有酬谢!
  • ¥80 构建降雨和积水的预测模型
  • ¥15 #Qt Transform setTransform()在鼠标拖动移动视角是一致在原地不动,无法变换视角(细微观察似乎视图有在原地抖动),无法变换视角(细微观察似乎视图有在原地抖动)
  • ¥50 如何利用无人机拍摄的数码照片测量鸟卵的长短径
  • ¥100 github贡献者给与奖励
  • ¥15 使用DS18B20+ESP8266获取温度数据返回-127.00