dsghpgmay31938863 2017-12-19 11:01
浏览 69
已采纳

检索多个id的Laravel模态数据

I have an array,I want to find my modal data according to array value.My array looks like

$item = [5,3,4,1];

I used for find these items

$topSell = Product::find($item);

It returns data serialize like 1,3,4,5. But I want it will return exact same as my array serialization.

  • 写回答

1条回答 默认 最新

  • doujieju0397 2017-12-19 11:04
    关注

    If you are using Mysql with laravel you can use Field() in order by

    $topSell = Product::whereIn('id', $item)
        ->orderBy(DB::raw("FIELD(id,".join(',',$item).")"))
        ->get();
    

    Field() returns the index position of a comma-delimited list

    Reference

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Java与Hbase相关问题
  • ¥20 bash代码推送不上去 git fetch origin master #失败了
  • ¥15 LOL外服加入了反作弊系统,现在游戏录像rofl文件离线都无法打开
  • ¥45 工程软件单片机设计课题要求
  • ¥15 在centos7安装conda
  • ¥15 c#调用yolo3 dll文件获取的数据对不上
  • ¥20 WPF 如何实现多语言,label 和cs(live Charts)中是否都能翻译
  • ¥15 STM32F103上电短路问题
  • ¥15 打开软件提示错误:failed to get wglChoosePixelFormatARB
  • ¥15 (标签-python|关键词-char)