Looping array and inserting into database Laravel

Question

I want to loop through the array and insert them into the database. When i check dd($request->users), it displays "NULL" but if i put dd($request->all()), the data array appears. Plus the code for controller below doesn't insert the data into the database. Thanks

Script

<script>
export default {
    data(){
      return{  
            users: [{
                username:'',
                password:'',
                phone:'',
                email:''
            }]
      }
    },
    methods:{
        addMoreData(){
            this.users.push({
                username: '', 
                password: '' , 
                email: '',
                phone:''
                });
        },
        deleteData(index){
            this.users.splice(index,1)  
        },
        submitData(){
         axios.post('/api/user', this.users)
      }
    },
    mounted() {
        console.log('Component mounted.')
    }
}

Controller

    public function store(Request $request)
{   
    for ($i = 1; $i < count($request->all()); $i++) {
        data::create([
                'username'=>$request->username[$i],
                'password'=>$request->password[$i],
                'phone'=>$request->phone[$i],
                'email'=>$request->email[$i]
            ]);
    }
}

Edited

Result for dd(request->all()

Result for dd(request->users

First you need to variable for creating user. Like $user = User::create([..]). Can you write dd($request->all()) and display result here? — mare96
– mare96, Commented Jun 2, 2019 at 9:14

mare96 · Accepted Answer · 2019-06-02 09:37:50Z

1

This should work in your case i think.

public function store(Request $request)
{ 
   foreach($request->all() as $user){
      $u = User::create([
             'username'=>$user['username'],
             'password'=>$user['password'],
             'phone'=>$user['phone'],
             'email'=>$user['email']
      ])
     return ...
   }
}

But if you want to send users from frontend you will need to place users in new array named users. Good luck.

edited Jun 2, 2019 at 9:37

answered Jun 2, 2019 at 9:29

mare96

3,8541 gold badge22 silver badges32 bronze badges

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

1 Comment

stalwart1014 Over a year ago

i got this error "message: "Trying to get property 'username' of non-object "

Natvarsinh Parmar - bapu · Accepted Answer · 2019-06-03 05:00:40Z

0

If your data in this format as per your this image

In controller:

public function store(Request $request){   

    $users = $request->all();

    if(!empty($users)){
        foreach($users as $user){
           data::create($user);
        }
    }
}

answered Jun 3, 2019 at 5:00

Natvarsinh Parmar - bapu

1,1381 gold badge8 silver badges8 bronze badges

Collectives™ on Stack Overflow

Looping array and inserting into database Laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related