download201401 2019-04-07 11:39 采纳率: 0%
浏览 239

使用PHP Laravel从MySQL中的多个表中搜索数据

I'm currently trying to implement a search data from multiple table in my mysql database.

Education table data is CSE, HSC, Diploma and JobCircular table data is BSc in CSE.

now i try to searching match CSE

my code is

$profileId = Auth::guard('company')->user()->id;
$user_id = Applyer::
           where('com_id','=',$profileId)
           ->where('circular_id','=',$id)
           ->pluck('user_id')[0];

$examination = Education::selectRaw('subject')->where('user_id','=',$user_id)->orderBy('id','desc')->get();

   foreach ($examination as $exam => $sub) {     
      $exam_list = JobCircular::where('education_requirements','LIKE', "% 
                  {$sub}%")->get();
      }

echo "<pre>";
print_r([$exam_list]);

when job circular education requirements BSc in CSE I expect the result is education table data CSE

  • 写回答

1条回答

  • dongmeng1402 2019-04-07 12:09
    关注
    $needed_exam_ids = [ ];
    
        $examination = 
        Education::where('user_id','=',$user_id)- 
        >orderBy('id','desc')->get();
    
       Foreach ($examination as $data) {     
            $exam_list = 
      JobCircular::where('education_requirements','LIKE', "% 
                      {$data->subject}%")->count();
           if($count > 0)
           {
               // get exam id if 'cse' exist
               array_push($needed_exam_ids,$data->id);
           }
          }
    
    // the result you want.
    $education_data = Education::whereIn('id',$needed_exam_ids)->get(); 
    
    评论

报告相同问题?

悬赏问题

  • ¥15 数学的三元一次方程求解
  • ¥20 iqoo11 如何下载安装工程模式
  • ¥15 本题的答案是不是有问题
  • ¥15 关于#r语言#的问题:(svydesign)为什么在一个大的数据集中抽取了一个小数据集
  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 蓝桥杯单片机第十三届第一场,整点继电器吸合,5s后断开出现了问题