Undefined Error Laravel When retriving Data From Database

Question

Hi I'm having trouble getting data from database after adding a new function inside my controller. Can anyone explain to me this error and what should I do?

I'm using this video as a reference and want to do something like his end result (see 1:09:28 of video), but I get this error:

public function manageCategory() {
  $this->authCheck();
  $all_category = DB::table('category')->get();
  $manage = view('admin.pages.manage_category')->with('data', $all_category);
  return view('admin.pages.manage_category')->with('main_content', $manage);
}

<tbody>
  @foreach($data as $vData)
  <tr>
    <td><a href="#">{{ $vData->category_id }}</a></td>
    <td class="hidden-phone">{{ $vData->category_name }}</td>
    <td>{{ $vData->category_description }} </td>
    <td><span class="label label-important label-mini">{{ $vData->category_published }}</span></td>
    <td>
      <button class="btn btn-success"><i class="icon-ok"></i></button>
      <button class="btn btn-primary"><i class="icon-pencil"></i></button>
      <button class="btn btn-danger"><i class="icon-trash "></i></button>
    </td>
  </tr>
  @endforeach
</tbody>

please add the error in detail

Sagar Gautam
– Sagar Gautam

2018-07-25 01:59:37 +00:00
Commented Jul 25, 2018 at 1:59 — Sagar Gautam
– Sagar Gautam, Commented Jul 25, 2018 at 1:59
I add Image On my Error...........Please Check It

Sabbir Ahmed
– Sabbir Ahmed

2018-07-25 02:05:21 +00:00
Commented Jul 25, 2018 at 2:05 — Sabbir Ahmed
– Sabbir Ahmed, Commented Jul 25, 2018 at 2:05

Mahdi Younesi · Accepted Answer · 2018-07-25 06:20:05Z

1

You should change your code to this

public function manageCategory() { 

   $this->authCheck();
   $all_category = DB::table('category')->get(); 

    return view('admin.pages.manage_category')->with('data',$all_category);
}

edited Jul 25, 2018 at 6:20

Mahdi Younesi

7,5592 gold badges23 silver badges54 bronze badges

answered Jul 25, 2018 at 2:19

Abdi

6186 silver badges16 bronze badges

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

Comments

Ts8060 · Accepted Answer · 2018-07-25 02:14:21Z

0

Try removing last line and move return keyword like this:

public function manageCategory() {
    $this->authCheck();
    $all_category = DB::table('category')
            ->get();
    return view('admin.pages.manage_category')
                ->with('data',$all_category);
}

I do not get why there have 2 views called. Maybe u or video maker did mistake

answered Jul 25, 2018 at 2:14

Ts8060

1,0688 silver badges19 bronze badges

Comments

Cruze · Accepted Answer · 2018-07-25 02:32:05Z

0

Your foreach should be like this

  @foreach($main_content['data'] as $vData)

this is because in your controller you $data contains the category but you have assign data to '$manage'. And again you assign manage to another variable main_content

 ->with('main_content', $manage);

answered Jul 25, 2018 at 2:32

Cruze

2206 silver badges19 bronze badges

1 Comment

Cruze Over a year ago

or just change your controller to this return view('admin.pages.manage_category')->with('data',$all_category);

Gautam Patadiya · Accepted Answer · 2018-07-25 03:41:14Z

0

I'm not sure what you are trying to do here but this code will help you to fix your an error.

public function manageCategory() {
    $this->authCheck();
    $all_category = DB::table('category')->get();

    view()->share('data',$all_category);
    view()->share('main_content',$manage);

    $manage = view('admin.pages.manage_category');
    return view('admin.pages.manage_category');
}

View class Share method will help you to share variable to view. Good Luck !!!

answered Jul 25, 2018 at 3:41

Gautam Patadiya

1,41214 silver badges19 bronze badges

Comments

hariGS · Accepted Answer · 2018-07-25 04:41:27Z

I think this code is suite for you..

public function manageCategory() {
    $this->authCheck();
    $data = DB::table('category')
            ->get();
    return view('admin.pages.manage_category')
                    ->with('data', $data);  //Directly pass data to view file
}

In your blade file ....

    @if(!empty($data)) // add if
       @foreach($data as $vData)

                <tr>
                    <td><a href="#">{{ $vData->category_id }}</a></td>
                    <td class="hidden-phone">{{ $vData->category_name }}</td>
                    <td>{{ $vData->category_description }} </td>
                    <td><span class="label label-important label-mini">{{ $vData->category_published }}</span></td>
                    <td>
                        <button class="btn btn-success"><i class="icon-ok"></i></button>
                        <button class="btn btn-primary"><i class="icon-pencil"></i></button>
                        <button class="btn btn-danger"><i class="icon-trash "></i></button>
                    </td>
                </tr>
                @endforeach
            </tbody>
  @endif  ////add end if

Collectives™ on Stack Overflow

Undefined Error Laravel When retriving Data From Database

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related