Laravel 5 fetching data from database using eloquent model

Question

I have written a member function like ::

public function details($article_seo){
        $articleDet = Articles::where(function($query) {
            $query->where('article-seo', '=', $article_seo);
            })
        ->get();
        dd($articleDet);
    }

and have used these at the beginning of laravel controller::

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Requests;
use App\articles;  /** this is the eloquent model **/

The problem is :: when ever i try to pass the $article_seo that I am receiving from the url data, it gives me an eror of ::: Undefined variable: article_seo

Being new to Laravel i have checked out lot of ways but unable to find one.Please help!!!!

Tommmm · Accepted Answer · 2016-06-01 13:36:20Z

2

When you want to use an outside variable inside of a closure, you have pass the variable into the closure using the use keyword.

public function details($article_seo){
        $articleDet = Articles::where(function($query) use ($article_seo) {
            $query->where('article-seo', '=', $article_seo);
            })
        ->get();
        dd($articleDet);
    }

You can get Articles match with your article-seo easily.

    public function details($article_seo){
        $articleDet = Articles::where('article-seo', '=', $article_seo)
        ->get();
        dd($articleDet);
    }

edited Jun 1, 2016 at 13:36

Tommmm

981 silver badge5 bronze badges

answered Jun 1, 2016 at 10:07

Md. Sahadat Hossain

3,2344 gold badges36 silver badges56 bronze badges

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

Comments

Tommmm · Accepted Answer · 2016-06-01 12:41:29Z

0

Closures aren't necessary here, you can simple use the model's where method to do what you are looking for.

$details = Articles::where('article-seo', '=', $article_seo)->get();

Cleaning that up a little bit, the where expression will use an equal sign by default, so we can omit that.

$details = Articles::where('article-seo', $article_seo)->get();

If your database values were snake cased (article_seo instead of article-seo), then you can simplify that expression even more

$details = Articles::whereArticleSeo($article_seo)->get();

That is a whole lot easier to read than the original closure based method!

answered Jun 1, 2016 at 12:41

Tommmm

981 silver badge5 bronze badges

1 Comment

angelDev Over a year ago

thank you too for the help, both the method were helpful, being new to Laravel it helped me explore both way functions

Collectives™ on Stack Overflow

Laravel 5 fetching data from database using eloquent model

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related