How to loop through an array and store its values in Laravel

Question

I have the following array :

$catprefs = $request['catpref'];

Vardump :

array(5) { [0]=> string(1) "1" [1]=> string(2) "11" [2]=> string(1) "2" [3]=> string(1) "3" [4]=> string(1) "4" }

I need to loop this array and store each one of the values in a new row as follows :

foreach ($catprefs as $save_catp) {
      $save_catp = new Cpref();
      $save_catp->user_id = $user_id;
      $save_catp->qatype = ????? ; // need to put the array value here
      $save_catp->type = 1;

      $save_catp->save();
}

How can I store each value of the array in the above insert ?

What's currently not working?

mighty_dev
– mighty_dev

2019-09-27 07:05:54 +00:00
Commented Sep 27, 2019 at 7:05 — mighty_dev
– mighty_dev, Commented Sep 27, 2019 at 7:05

Yasin Patel · Accepted Answer · 2019-09-27 07:18:42Z

4

You can also use bulk insert as below :

$data = [];
foreach($catprefs as $key => $val){
  $data[] =[
    'user_id' => $user_id,
    'qatype' => $val,
    'type' => 1
   ]
}

Cpref::insert($data);

edited Sep 27, 2019 at 7:18

answered Sep 27, 2019 at 7:12

Yasin Patel

5,7818 gold badges37 silver badges57 bronze badges

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

Comments

Dilip Hirapara · Accepted Answer · 2019-09-27 07:09:43Z

2

Try this.

foreach($catprefs as $save_catp){

      $cpref= new Cpref();
      $cpref->user_id = $user_id;
      $cpref->qatype = $save_catp; // need to put the array value here
      $cpref->type = 1;
      $cpref->save();

}

If you use $key => $value

foreach($catprefs as $key => $value){

      $cpref= new Cpref();
      $cpref->user_id = $user_id;
      $cpref->qatype = $value; // need to put the array value here
      $cpref->type = 1;
      $cpref->save();

}

edited Sep 27, 2019 at 7:09

answered Sep 27, 2019 at 7:03

Dilip Hirapara

15.4k3 gold badges34 silver badges56 bronze badges

5 Comments

Abdallah Sakre Over a year ago

I receive this error : Method App\Cpref::__toString() must return a string value

Abdallah Sakre Over a year ago

The field in the database is smallint

Dilip Hirapara Over a year ago

Edited answer please try now.

Shubham Pokhriyal Over a year ago

is it possible to create the object new Cpref(); only once outside the loop?

Dilip Hirapara Over a year ago

Yes, @Yasin Patel given the answer below the answer. Cpref::insert($data); with array you can do it.

Jithesh Jose · Accepted Answer · 2019-09-27 07:10:14Z

2

if(!empty($catprefs))
{
 foreach($catprefs as $key => $row)
 {
   $save_catp = new Cpref();
   $save_catp->user_id = $user_id;
   $save_catp->qatype = $row ; // need to put the array value here
   $save_catp->type = 1;
   $save_catp->save();
 } 
}

answered Sep 27, 2019 at 7:10

Jithesh Jose

1,8241 gold badge8 silver badges17 bronze badges

Comments

Pragnesh Chauhan · Accepted Answer · 2019-09-27 07:12:33Z

1

foreach($catprefs as $save_catp){
$save_catp = new Cpref();

you are using $save_catp in for loop and Cpref object, you need to change one of the variables.

if(!empty($catprefs)){
  foreach($catprefs as $key => $val){

  $save_catp = new Cpref();
  $save_catp->user_id = $user_id;
  $save_catp->qatype = $val; // array value goes here
  $save_catp->type = 1;


  $save_catp->save();

 } 
}

edited Sep 27, 2019 at 7:12

answered Sep 27, 2019 at 7:06

Pragnesh Chauhan

8,49410 gold badges46 silver badges58 bronze badges

Collectives™ on Stack Overflow

How to loop through an array and store its values in Laravel

4 Answers 4

Comments

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related