Greeenone

Solved! My vue script was in wrong place

Hello,

I'm learning Vue.JS for laravel and.. I have my first issue :( I'm watching watching course about CRUD using vue.js. I did exactly as in the course but my code doesn't work correctly.

My component display correctly the HTML code but not data from database.

TasksController.php

... public function index() { // $tasks = Auth::user()->tasks; return response()->json([ 'tasks'=>$tasks ], 200); } ...

Works perfectly. Display data from DB

app.js

... Vue.component('task-component', require('./components/TaskComponent.vue').default); ...

Also works perfectly

TaskComponent.vue

...

<button type="button" name="button">Add task</button>

<table class="table" v-if="tasks">
  <thead>
    <th>Name</th>
    <th>Content</th>
    <th>Edit</th>
  </thead>
  <tbody>
    <tr v-for="(task, index) in tasks">
      <td>{{index + 1}}</td>
      <td>{{task.name}}</td>
      <td>{{task.body}}</td>
      <td><button type="button" name="button">Edit</button>
        <button type="button" name="button">Deletes</button></td>
      </tr>
    </tbody>
  </table>
</div>

export default {

  data(){
    
    return {
      
      task:{
        name: '',
        body: ''
      },
      
      tasks: [],
      uri: 'http://127.0.0.1:8000/tasks'
      
    }
    
  },
  
  methods:{
    
    loadTasks(){
      axios.get(this.uri).then(response=>{
        
        this.tasks = response.data.tasks
        
      });
    }
    
  },
  
  mounted() {
    
    this.loadTasks();
    console.log('test');
  }
}

....

Yes !

Models:

ManagementFiles.php

class ManagementFiles extends Model { public function folders(){ return $this->BelongsTo('App\ManagementFolders'); } }

ManagementFolders.php

class ManagementFolders extends Model { public function files(){ return $this->hasMany('App\ManagementFiles', 'folder_id'); } }

====================================================================

Migration:

management_files

ID - PK AI file_name folder_id

management_folder ID - PK AI reference folder_name

=======================================================================

In controller I tried everything posted here

Still invalid argument :'( I think I will leave and use a simple query

$files = ManagementFiles::where('folder_id", $id)->get();

It's correct or it's better to use this frustrating oneToMany ?

I have this error now:

Invalid argument supplied for foreach()

I added second file and when I use dd, I see it.

#relations: array:1 [▼ "files" => Collection {#244 ▼ #items: array:2 [▼ 0 => ManagementFiles {#247 ▼ #connection: "mysql" #table: "management_files" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:9 [▶] #original: array:9 [▶] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #hidden: [] #visible: [] #fillable: [] #guarded: array:1 [▶] } 1 => ManagementFiles {#248 ▶} ] } ]

ManagementFolders {#239 ▼ #connection: "mysql" #table: "management_Folders" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:21 [▶] #original: array:21 [▶] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: array:1 [▼ "Files" => Collection {#249 ▼ #items: array:1 [▼ 0 => ManagementFiles {#246 ▼ #connection: "mysql" #table: "management_Files" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:9 [▶] #original: array:9 [▶] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #hidden: [] #visible: [] #fillable: [] #guarded: array:1 [▶] } ] } ] #touches: [] +timestamps: true #hidden: [] #visible: [] #fillable: [] #guarded: array:1 [▼ 0 => "*" ] }

@RONB1985 - It's work. Thanks you ! :)

Oh still don't work.. When I add "with", return give me information about folder and files inside but loop still doesn't work :/

@SAURABHD - Works but I get the name of this folder. I want to display all files belongs to this folder.

Still not working. When I use Get, everwing works great.

@saurabhd Thanks for your help!

I have this error now:

Trying to get property 'name' of non-object

@RonB1985

ManagementFolders {#238 ▼ #connection: "mysql" #table: "management_folders" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:21 [▶] #original: array:21 [▶] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #hidden: [] #visible: [] #fillable: [] #guarded: array:1 [▶] }

Thanks for reply !

Sure !

public function index($reference){

$folders = Folders::where('reference', $reference)->first();
//
foreach($folders->files as $file){
  echo $file->name;
}

}

//Folder model

public function files() { return $this->hasMany('App\Folders'); }

//File model

public function folders() { return $this->BelongsTo('App\Files'); }

And my Error

Invalid argument supplied for foreach()

Hello !

I'm learning laravel since 2 weeks and I have some issues with my HasMany relation.

I have one folder and multiple files. Files belongs to one folder and on folder has many files.

I want to display all files inside in folder.

I get the ID from url and I "send" it to query

$folder = ManagementFolders::where('reference', $reference)->first();

After that, I want to display all files inside but my foreach doesn't work.

Property [file] does not exist on this collection instance.