I want to create a form with a drop down menu in which items from an oracle table. How can I do that? The connection with db, deendencies, csrf fields are all ok, but I'm a little bit stuck!
My controller excerpt with the query I want is this:
public function secondform()
{
$spoudes = DB::table('prog_title') -> select('pr_title')-> where('pr_index', '=', 1)->get();
return view ('kedivimform2', ['programmata' => $spoudes]);
and my blade (kedivimform2) below. How should I integrate $programmata as drop down into my form?
<form method='post' action="/kedivimtest2">
{{csrf_field()}
<label>
Lessons<font color="red">*</font> <br>
<input name='titlos' type='text' minlength="5" required> <!-- I want a drop menu here! -->
</label>
<input type='submit' value="OK!">
</form>