php - Getting the results of a query, depending on results of first query

I have 2 tables. 1 namedtasks that has the rows[id, event_id, title] and the other table is namedtask_items with the rows[id, task_id, description, ...].

I am trying to run a query to retrieve all tasks with anevent_id of x, then all task_items that match theid of any result from the previous query. I currently have 2 standalone queries, but don't know how to join them to work in-tandem. The current code that I have show alltask_items associated with the event, but they aren't corresponding with each task. Task 0 in my database has 0task_items, but my code is displaying thetask_items for task 0 under task 1.

This is my query code:

$tasks = DB::table('tasks')->where('event_id', $request->route('id'))->get();
    foreach($tasks as $task)
    {
        $taskItemID[] = $task->id;
    }
    $taskItems = DB::table('task_items')->whereIn('task_id', $taskItemID)->get();
Copy code

This is my foreach loop:

@foreach($tasks as $task)
                    <div><b>Task # {{$task->id}}:</b> {{$task->title}}</div>
                    <div style="float:right;">mark as completed</div>
                  </div>
                  <div class="row" style="border: 1px solid #efefef;padding: 20px;">
                    @foreach($taskItems as $taskItem)
                      <li>{{$taskItem->description}}</li>
                    @endforeach
                      @endforeach
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.