get function returning empty array laravel

Question

I need some help getting my user_id from my pdf_files table, but for some reason it keep giving me an empty array when I try using $request = all() --> return me {} and dd($downloads) return me this Collection {#233 ▼ #items: [] }. Do I have to use with statement or anything? I saw some people using it but do I really need it? Thanks for helping

Code:

Controller:

public function downfunc(Request $request){
//  $downloads = new pdfFile;
$downloads=pdfFile::where('user_id', $request->user_id)->get();
//$downloads=DB::table('pdf_files')->get(); --> this code return results
//dd($downloads);
//return $request->all();
return view('download.viewfile',compact('downloads'));

}

download.blade.php

<table class="table table-bordered">
                    <thead>
                        <th>Name of File</th>
                        <th>Action</th>
                    </thead>

                    <tbody>

                    @foreach($downloads as $down)
                        <tr>
                            <td>{{$down->file_name}}</td>
                            <td>
                            <a href="download/{{$down->file_name}}" download="{{$down->file_name}}">
                                <button type="button" class="btn btn-primary">
                                <i class="glyphicon glyphicon-download">
                                    Download
                                </i>
                                </button>
                            </a>
                            </td>
                        </tr>
                    @endforeach
                    </tbody>
                </table>

pdfFile model:

protected $fillable = array('file_name','file_size','user_id');

public function personal_infos() {
    return $this->belongsTo('App\personal_info', 'user_id', 'id');
}

I just tried using count() but it doesn't work also

Dkna
– Dkna

2017-10-27 02:49:31 +00:00
Commented Oct 27, 2017 at 2:49 — Dkna
– Dkna, Commented Oct 27, 2017 at 2:49

haidang · Accepted Answer · 2017-10-27 03:27:24Z

1

Please make sure your $request->user_id is valid

You can check by run sql manually.

answered Oct 27, 2017 at 3:27

haidang

3321 silver badge8 bronze badges

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

3 Comments

Dkna Over a year ago

It return me null, but in my database i have the data inside, how did i even get null?

haidang Over a year ago

You need to check your request (from your view or url), and your routes config.

Dkna Over a year ago

Oh I found my problem it was in the route, thank you so much for helping me

Collectives™ on Stack Overflow

get function returning empty array laravel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related