Bring data and save to a variable in Controller - Laravel API

Question

public function getListaPresencial(Request $request, Presencial $Presencial)
{
    if ($Presencial->id) {
        return response()->json(['data' => $Presencial->toArray()]);
    }

    $query = Presencial::query();
    $tipo = 1;
    $query->select('id', 'nome_professor', 'nome_disciplina', 'nome_curso', 'nome_turma', 'data_inicio');
 // $query->where('id','=',1 );
    $query->where('tipo','=',$tipo );
    $query->whereDate('data_inicio', date('Y-m-d'));

    return response()->json($query->paginate($request->get('limit')));

}

I need to bring the result of the search in a variable:

Example:

$nomeprofessor = ?
$nomedisciplina = ?

so I can write in another table only this data.

Answer 1

I think if you only want a few fields, it would be better to select only by the desired fields:

$query->select('nomeprofessor');
$professores = $query->get();
$query->select('nomedisciplina');
$disciplinas = $query->get();

Answer 2

I took the opportunity to make a syntax improvement in your code, leaving more standardized.

You already have the result of your search on $query->paginate($request->get('limit')) but if you want to take all the search values without paging, you can do:

public function getListaPresencial(Request $request, Presencial $Presencial)
{
    if ($Presencial->id) {
        return response()->json(['data' => $Presencial->toArray()]);
    }

    $tipo = 1; // não entendi porque não colocou isso diretamente na query, ma vamos manter

    $query = Presencial::select('id', 'nome_professor', 'nome_disciplina', 'nome_curso', 'nome_turma', 'data_inicio')
        ->where('id', '=', $tipo)
        ->whereDate('data_inicio', today());

    $presenciais = $query->get();
    dd($presenciais);

    return response()->json($query->paginate($request->get('limit')));

}

Thus the variable $presenciais will get the values you need.

The method ->get() returns a Collection with all the values of the search then you can treat it as a Collection in the Laravel.

An example of using a Collection is:

$presenciais->each(static function ($presencial){
    $professor = $presencial->nome_professor;
    $disciplina = $presencial->nome_disciplina;
    // Agora você pode usar as variáveis "$professor" e "$disciplina" para salvar na outra tabela que você precisa

})