It means that there's no row return in $categories. Also you're returning all() caregories, that will return a collection. You only want to edit one category. it should be Category::find($id)
Feb 12, 2017
8
Level 1
No query results for model [App\Category].
I am getting this error when simply trying to view a page, all the controller does is return a view with some seeded information.
web.php
// ADMIN -------------
Route::group(['namespace' => 'Admin', 'middleware' => ['auth'], 'prefix' => 'admin'], function()
{
Route::get('home', function(){
return view('admin.home');
});
Route::resource('category', 'CategoryController');
Route::resource('products', 'ProductController');
Route::resource('user', 'UserController');
Route::get('orders', [
'as' => 'admin.order.index',
'uses' => 'OrderController@index'
]);
Route::post('order/get-items', [
'as' => 'admin.order.getItems',
'uses' => 'OrderController@getItems'
]);
Route::get('order/{id}', [
'as' => 'admin.order.destroy',
'uses' => 'OrderController@destroy'
]);
Route::get('category/create', [
'as' => 'admin.category.create',
'uses' => 'CategoryController@create'
]);
Route::get('category/store', [
'as' => 'admin.category.store',
'uses' => 'CategoryController@store'
]);
Route::get('category/index', [
'as' => 'admin.category.index',
'uses' => 'CategoryController@index'
]);
Route::get('category/edit', [
'as' => 'admin.category.edit',
'uses' => 'CategoryController@edit'
]);
});
The functions on Categorycontrollers;
public function index()
{
$categories = Category::all();
//dd($categories);
return view('admin.category.index', compact('categories'));
}
public function create()
{
return view('admin.category.create');
}
public function store(Request $request)
{
//return $request->all();
$this->validate($request, [
'name' => 'required|unique:categories|max:255',
]);
$category = category::create([
'name' => $request->get('name'),
'slug' => str_slug($request->get('name')),
'description' => $request->get('description'),
]);
$message = $category ? 'Categoría agregada correctamente!' : 'La Categoría NO pudo agregarse!';
return redirect()->route('admin.category.index')->with('message', $message);
}
public function show(Category $category)
{
return $category;
}
public function edit(Category $category)
{
return view('admin.category.edit', compact('category'));
}
The errors;
in Handler.php line 131
at Handler->prepareException(object(ModelNotFoundException)) in Handler.php line 109
at Handler->render(object(Request), object(ModelNotFoundException)) in Handler.php line 47
at Handler->render(object(Request), object(ModelNotFoundException)) in Pipeline.php line 82
at Pipeline->handleException(object(Request), object(ModelNotFoundException)) in Pipeline.php line 55
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Authenticate.php line 43
at Authenticate->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 102
at Pipeline->then(object(Closure)) in Router.php line 561
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 520
at Router->dispatchToRoute(object(Request)) in Router.php line 498
at Router->dispatch(object(Request)) in Kernel.php line 174
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 102
at Pipeline->then(object(Closure)) in Kernel.php line 149
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 116
at Kernel->handle(object(Request)) in index.php line 53
at require_once('/home/niverd/Escritorio/laravel/jackfer/public/index.php') in server.php line 21
edit.blade
Form::model($category, array('route' => array('category.update', $category->id)))
index.blade
<a href="{{ route('admin.category.edit',['id' => $category->id]) }}" class="btn btn-primary"><i class="fa fa-pencil-square"></i></a>
When I give it to edit, I redirect to that address;
http://127.0.0.1:8000/admin/category/edit?id=1
but I get the error.
Level 10
I dont understand why you double category routes with resourse and Route::get('category/edit', [ 'as' => 'admin.category.edit', 'uses' => 'CategoryController@edit' ]);
But you can try add id param to route:
Route::get('category/edit/{id}', [
'as' => 'admin.category.edit',
'uses' => 'CategoryController@edit'
]);
Please or to participate in this conversation.