dongshushi5579 2019-02-15 03:48
浏览 505
已采纳

使用Joins在laravel视图中显示Json数据

I'm trying to retrieve data from database to laravel blade view with join associate table.

in my case I have two tables called interesting_courses and courses. here some student can have many interesting courses. Therefore courses_id stored as json array in database as follows.

["1","11","15","16"] 

but I need to join the courses table to get the associate course name as follows.

["Hospitality","Business Management","Auto Mobile","Health Care"]

Below is my controller

$intresting_courses = DB::table('intresting_courses')
                            ->join('courses','courses.id','=','intresting_courses.courses_id')
                            ->where('intresting_courses.youth_id',$id)
                            ->first();

How can I join the tables.

  • 写回答

1条回答 默认 最新

  • dqyat62284 2019-02-15 04:28
    关注

    There is no way you can join it in query natively.

    The solution is to write two queries

    select * from intresting_courses where youth_id = ? limit 1
    
    select * from courses where id in (1, 2, 3, 4, 5, ...)
    

    that way you can get courses that student intresting.

    Here the laravel code for thoses queries.

    $intresting_courses = DB::table('intresting_courses')
                            ->where('intresting_courses.youth_id', $id)
                            ->first();
    
    $courses = DB::table('courses')
                 ->whereIn('id', json_decode($intresting_courses->courses_id))
                 ->get();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 u盘问题:盘符不显示 无媒体
  • ¥50 R语言读取nc按月均值转为tif
  • ¥30 智能车串级pid调参
  • ¥15 visual studio code翻译老是错误
  • ¥20 卫星测高数据的高程转换
  • ¥15 爬取招聘网站数据信息
  • ¥15 安装完tensorflow,import tensorflow as tf后报错,如何解决?
  • ¥15 ultralytics库导出onnx模型,模型失去预测能力
  • ¥15 linux下点对点协议连接2个USB串口的硬件流量控制问题
  • ¥15 SQL数据自动生成问题