Laravel 5 passing database query from controller to view

Question

I'm new to Laravel 5 and MVC frameworks in general. I having trouble getting results from a database query and passing it to my blade view. Here is what I have for a controller function ...

public function show(Project $project)
{
$technologies = DB::select('select * from technologies where id = ?', [$project->technology_id]);
return view('projects.show', compact('project','technologies'));
}

and my view is ...

@section('content')
   <h2>{{ $project->name }}</h2>

    @if ( !technologies() )
        no technologies.
    @else
        <ul>
            @foreach( $technologies as $technology )
                <li><a href="#">{{ $technology->slug }}</a></li>
            @endforeach
        </ul>
    @endif
@endsection

Thanks for your help

Have you tried return View::make('projects.show')->with(compact('project'))->with(compact('technologies')); ? — Sulthan Allaudeen
– Sulthan Allaudeen, Commented May 31, 2015 at 9:26
Thanks for the suggestion but I still get a totally blank page in response even when looking at the source. — Scudder Stevens
– Scudder Stevens, Commented Jun 3, 2015 at 12:42

haakym · Accepted Answer · 2015-05-31 09:43:51Z

3

controller

public function show(Project $project)
{
    $technologies = DB::table('technologies')
        ->select('*')
        ->where('id', $project->technology_id)
        ->get(); // you were missing the get method

    return view('projects.show', compact('project', 'technologies'));
}

View

This will not work in your view: @if ( !technologies() )

@section('content')

<h2>{{ $project->name }}</h2>
    @if($technologies)
        <ul>
            @foreach($technologies as $technology)
                <li><a href="#">{{ $technology->slug }}</a></li>
            @endforeach
        </ul>
    @else
        <p>no technologies.</p>
    @endif
@stop

Also, if you're interested in a cleaner way to loop through your data or show a 'no data' warning using blade check out this article which uses blade's @each https://laravel-news.com/2014/09/laravel-blade/

edited May 31, 2015 at 9:43

answered May 31, 2015 at 9:35

haakym

12.4k12 gold badges72 silver badges101 bronze badges

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

9 Comments

Scudder Stevens Over a year ago

Thanks for the helpful suggestions but I'm still getting a blank page in response. The correct url just nothing, even when I look at the source code. I'll double check that my DB seeds are working ... ? Maybe the view is the problem?

haakym Over a year ago

@Scudder Stevens - How is your route for the url set up in routes.php? Also, have you checked your error log after visiting the URL? You could also just remove everything from the view and try outputting <p>hello</p> just to check it's returning the view perhaps?

Scudder Stevens Over a year ago

routes.php = 'Route::model('projects', 'Project'); Route::model('technologies', 'Technology'); Route::bind('projects', function($value, $route) { return App\Project::whereSlug($value)->first(); }); Route::resource('projects', 'ProjectsController');'

Scudder Stevens Over a year ago

when I remove the $technologies = DB call from the controller and the for each loop from the view, leaving 'return view('projects.show', compact('project', 'technologies')); and <h2>{{ $project->name }}</h2>' I do get the project name. When I add the DB call back in to the controller it returns a blank page again.

Scudder Stevens Over a year ago

I'll check into it. I get errors sometimes and when I do they are usually long ... : ) thanks again

|

Mohammed Safeer · Accepted Answer · 2015-05-31 09:31:39Z

0

rewrite your query as,

$technologies = DB::table('technologies')->where('id',$project->technology_id)->get();

answered May 31, 2015 at 9:31

Mohammed Safeer

21.6k8 gold badges79 silver badges81 bronze badges

1 Comment

Scudder Stevens Over a year ago

Thanks for the suggestion but I still get a totally blank page in response even when looking at the source.

Collectives™ on Stack Overflow

Laravel 5 passing database query from controller to view

2 Answers 2

9 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related