Laravel gurus I need your help on a project am currently working on. Am trying to create a tree-like categories structure where each child will be listed under its parent. Am being able to create and save these categories in the database but now am finding it difficult to loop through the categories and display them. I want the categories to be rendered as below:
Fashion Accessories
- Bags
- Cloths
Mobile Phones
- Tablets
- Smartphones

Maybe this will work nested for each.
give the sample of the data structure, this will aid more contribution from our nairaland e-family

 for each($something as $something) {
    for each() {}
}

  @if($categories->any)
      @foreach($categories as $category)
          <h3>$category</h3>
           <ul>
           @foreach($category as $aCategory)
              <li>$aCategory->item</li>
           @endforeach
          </ul>
       @endforeach
  @endif

I presume you are using the blade templating engine. And that you also have categories and items tables linked together by foreign keys and the relationships properly defined in your models.

Sorry for not providing codes before.
My Controller:

public function index()
{
$categories = Category::with('children')->get();

return view('backend.categories.index')->with('categories', $categories);
}

My Category Model :

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Category extends Model
{
protected $guarded = ['id'];

public function parent()
{
return $this->belongsTo('App\Category', 'parent_id');
}

public function children()
{
return $this->hasMany('App\Category', 'parent_id');
}
}

My View:

<table class="table table-bordered table-hover">
<thead>
<tr>
<th>Name</th>
<th>Description</th>
<th>Slug</th>
<th>Action</th>
</tr>
</thead>
<tbody>
@foreach ($categories as $category)
{{--@foreach ($category->children as $children)--}}
<tr>
<td>{{ $category->name }}</td>
<td>{{ $category->description }}</td>
<td>{{ $category->slug }}</td>
<td><a class="edit" href="{!! action('Admin\CategoriesController@edit', $category->id) !!}" title="Edit"><i class="fa fa-pencil-square-o"></a></i> <a class="delete" href="{!! action('Admin\CategoriesController@destroy', $category->id) !!}" title="Are you sure you want to delete?"><i class="fa fa-trash-o"></i></a></td>
@foreach ($category->children as $children)
<tr>
<td>{{ $children->name }}</td>
<td>{{ $children->description }}</td>
<td>{{ $children->slug }}</td>
<td></td>
</tr>
@endforeach
</tr>
</tbody>
{{--@endforeach--}}
@endforeach
</table>

Yes I have a categories table with the following structure:

+-------------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | NULL | |
| slug | varchar(255) | NO | | NULL | |
| parent_id | int(11) | YES | | NULL | |
| description | text | NO | | NULL | |
| created_at | timestamp | NO | | 0000-00-00 00:00:00 | |
| updated_at | timestamp | NO | | 0000-00-00 00:00:00 | |
+-------------+------------------+------+-----+---------------------+----------------+

Make things simple for yourself... it won't hurt creating another Model for CategoryItem



Category

namespace App;

use Illuminate\Database\Eloquent\Model;

class Category extends Model
{
	protected $guarded = ['id'];

	public static $table = 'categories';

	public function children()
	{
		return $this->hasMany('App\CategoryItem', 'parent_id');
	}
}

CategoryItem

namespace App;

use Illuminate\Database\Eloquent\Model;

class CategoryItem extends Model
{
	protected $guarded = ['id'];
	public static $table = 'categoryitems';

	public function pareet()
	{
		return $this>belongsTo('App\CategoryItem', 'parent_id');
	}
}

Migratations

<?php

class Create_Categories_Table {

	/**
	 * Make changes to the database.
	 *
	 * @return void
	 */
	public function up()
	{
		//

		Schema::table("categories", function($table){
			$table->create();
			$table->increments('id');
			$table->string('name', 255);
			$table->timestamps();
		});

	}

	/**
	 * Revert the changes to the database.
	 *
	 * @return void
	 */
	public function down()
	{
		//
		Schema::drop("categories";
	}

}

<?php

class Create_CategoryItems_Table {

	/**
	 * Make changes to the database.
	 *
	 * @return void
	 */
	public function up()
	{
		//

		Schema::table("categoryitems", function($table){
			$table->create();
			$table->increments('id');
			$table->increments('parent_id');
			$table->string('name', 255);
			$table->string('slug', 255);
			$table->timestamps();
			$table->foreign('parent_id')->references('id')->on('categories');
		});

	}

	/**
	 * Revert the changes to the database.
	 *
	 * @return void
	 */
	public function down()
	{
		//
		Schema::drop("categoryitems";
	}

}

The Above Might not run but should explain the logic

check out adjacency model - http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/
- dhtml18

MuhammaduBuhari:
check out adjacency model - http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/
- dhtml18

Egbon, that one na sql wahala.... He's looking for the Laravel 5 approach

Me no get time to dey read full posts o jare. No time to check time, am outa here.
- troll

MuhammaduBuhari:
Me no get time to dey read full posts o jare. No time to check time, am outa here.
- troll

lol... Ok

use Baum laravel package I always us it for unlimited category

chiwex:
use Baum laravel package I always us it for unlimited category

An Over-Kill, to me, for the simple task... Baum\Node? , phewww

baum is easy

you can

CREATE
ADD
UPDATE
DELETED
MOVE UP AND DOWN UR CATEGORIES

without steers

remember after implementing the package using a controller you can reuse it for any project

chiwex:
baum is easy

you can

CREATE
ADD
UPDATE
DELETED
MOVE UP AND DOWN UR CATEGORIES

without steers

remember after implementing the package using a controller you can reuse it for any project

and those can't be done implementing "vanilla" Eloquent ....

jacob05:


An Over-Kill, to me, for the simple task... Baum\Node? , phewww

Thats my take on Baum too.
have being able to loop and display the categories the way I wanted.
But am now faced with another problem. I created an edit link on each categories passing it category id, but I got this error:

ErrorException in 775837465f5ab64876c1dc1677878595 line 46: Trying to get property of non-object (View: /resources/views/backend/categories/edit.blade.php)

My controller

public function edit($id)
{
$categories = Category::find($id);
//print_r($categories);
return view('backend.categories.edit')->with('categories', $categories);
}

I will post my own codes tomorrow

maekhel:

Thats my take on Baum too.
have being able to loop and display the categories the way I wanted.
But am now faced with another problem. I created an edit link on each categories passing it category id, but I got this error:


My controller

It's most likely that $categories = Category::find($id); found nothing but passed as null and the view is trying to access it's property

jacob05:

It's most likely that $categories = Category::find($id); found nothing but passed as null and the view is trying to access it's property

It actually found something, cos if I comment out looping thru the categories to create select menu it works. But that does give the options to select from other categories in the database.
Hope you got wat I mean?

maekhel:

It actually found something, cos if I comment out looping thru the categories to create select menu it works. But that does give the options to select from other categories in the database.
Hope you got wat I mean?

Let's see how you implemented the Models and the Views

Thanks guys for your help, working as expected now.

Thank God for the great programmers on nairaland.
No mind me, na old-school troll i be thinking that laravel is the same as SQL.

MuhammaduBuhari:
Thank God for the great programmers on nairaland.
No mind me, na old-school troll i be thinking that laravel is the same as SQL.

Lol

maekhel:

Lol

Na olodo i be, so you fit laff.

maekhel:
Thanks guys for your help, working as expected now.

Good

So many laravel folks here. I wonder how many zend users we have on nairaland

CRAZYMADMAN:
So many laravel folks here. I wonder how many zend users we have on nairaland

We need to do a census one day. I am surprised that we have so much laravel folks as well.

MuhammaduBuhari:

We need to do a census one day. I am surprised that we have so much laravel folks as well.

Yea.. Laravel Rocks !!!

Eya pele come to Yii2 we got that covered. I don't really like L5 , haven't seen any spectacular reason to jump board.

CRAZYMADMAN:
So many laravel folks here. I wonder how many zend users we have on nairaland

Zend is for masochists. Too complex

pcguru1:
Eya pele come to Yii2 we got that covered. I don't really like L5 , haven't seen any spectacular reason to jump board.

You don't know what you are missing out on. Try it, I assure you, you won't regret it.

danvery2k6:



You don't know what you are missing out on. Try it, I assure you, you won't regret it.

Don't get me wrong, I know it's awesome but for me i just feel comfortable with Yii2 and it's clean API and all. got nothing against L5 but i will try it our for a project to test, but am not one willing to pick another templating language when PHP template works.

Guys, I need your help in another thread
https://www.nairaland.com/2559716/populating-select-menu-model-user

Did you get the answer to this

working to something related
want to list just like this

Fashion Accessories
- Bags
- Cloths
Mobile Phones
- Tablets
- Smartphones

I am using laravel 5.3 now