Select a record of an array in Laravel 5.3

Question

Select a record of an array in Laravel 5.3

Navigation

#1 by (3 votes)

0

Hi, I want to select a data that is stored in an array, for example the data I need is in position 1, but I do not know how to select it:

My controller is the following, I have minimized it for greater understanding:

public function listaAlumnos()
    {
        $alumnos = DB::table('alumno')
        ->select('idalumno')
        ->get();

        $pr = $alumnos->idalumno[1]; //Necesito que el registro en la posición 1 se guarde en $pr.
    }

If someone could help me, thank you in advance.

array laravel-5

asked by Anddy Cabrera Garcia 12.02.2017 в 07:13

source

1 answer

HTML tag, which can be used to make the box List data with SQL Prepared Statements

score 3 · Answer 1

When using get () you are recovering an array of students, so you should use a foreach ():

$alumnos = DB::table('alumno')->select('idalumno')->get();
foreach($alumnos as $alumno){
  $pr = $alumnos->idalumno;
}

If you expect to recover only one student you can use first ():

$alumnos = DB::table('alumno')->select('idalumno')->first();
$pr = $alumnos->idalumno;