How to send a query in a variable using laravel?

Question

I have this function to register my users

protected function validator(array $data)
{
    return Validator::make($data, [
        'name' => ['required', 'string', 'max:255'],
        'apellido' => ['required', 'string', 'max:255'],
        'idop' => ['required', 'string', 'max:6', 'unique:users'],
        'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
        'password' => ['required', 'string', 'min:8', 'confirmed'],
        'cedula' => ['required', 'int'],
        'fecha_nacimiento' => ['required', 'date'],
        'fecha_ingreso' => ['required', 'date'],
        'extension' => ['required', 'int'],
        'movil' => ['required', 'int'],
        'tel_hab' => ['required', 'int']
    ]);

}

I would like to send this query in a variable ($generos) to make a select

$generos = DB::table('tbl_lista_generos')
            ->select('id','genero')
            ->get();

How could I do that?

I don't have an error... I don't know how to send the query to the view for make my select — Oscar
– Oscar, Commented Mar 4, 2020 at 14:43

Sehdev · Accepted Answer · 2020-03-04 15:14:35Z

2

You can pass the variable from controller to view using below ways:

Way1

$generos = DB::table('tbl_lista_generos')
            ->select('id','genero')
            ->get();
return view("index", compact("generos "));

Way2

 $generos = DB::table('tbl_lista_generos')
                ->select('id','genero')
                ->get();
 return view("index", ["generos" => $generos]);

Way3

 $generos = DB::table('tbl_lista_generos')
                ->select('id','genero')
                ->get();
 return view("index")->with(["generos" => $generos]);

On your view file::

 <select name="genero">
  <option value=''>select</option>
   @foreach ($generos as $genero)
     <option value="{{ $genero->id }}">{{ $genero->name}}</option>
   @enforeach
</select>

answered Mar 4, 2020 at 15:14

Sehdev

5,7123 gold badges14 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Oscar Over a year ago

thanks! this works with another pages... but I need the name of the route view from register in laravel.. do you know which is? instead of index what should I put? I'm working in the view of register in laravel

Sehdev Over a year ago

You can use view("register")->with(["generos" => $generos]);

Oscar Over a year ago

where do I have to put this function? in my function validator? or I have to create another function to put on it

Sehdev Over a year ago

What is the name of your view where you want to send the variable?

Oscar Over a year ago

I'm working on the view of register in laravel... so I didn't create the view... the view is in the framework

|

helderneves91 · Accepted Answer · 2020-03-04 14:52:12Z

0

by the comments, you want to send the result of the query to the view. So,

In your controller function do:

return view('generos.index', [
      'generos' => DB::table('tbl_lista_generos')->select('id','genero')->get()
]);

In the view:

<select class='' name='select_form_generos'>
<option value=''>select genero</option>
@foreach ($generos as $genero)
     <option value='{{ $genero->id }}'>{{ $genero->genero}}</option>
@enforeach
</select>

Hope it helped!

answered Mar 4, 2020 at 14:52

helderneves91

9751 gold badge10 silver badges26 bronze badges

2 Comments

Oscar Over a year ago

I got an error with this............. syntax error, unexpected end of file, expecting elseif (T_ELSEIF) or else (T_ELSE) or endif (T_ENDIF) (View: C:\laragon\www\bduproject\resources\views\auth\register.blade.php)

Oscar Over a year ago

I modified the "@enforeach" for "@endforeach".. because but nothing

Collectives™ on Stack Overflow

How to send a query in a variable using laravel?

2 Answers 2

9 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related