PHP foreach loop SQL insert

Question

Is something like this possible? For each item in array make an insert into database? How should I do it, because clearly this doesn't work. At the moment it takes last item from the array and inserts its data.

    foreach ($properties as $prop): 
       $productProp = new ProductProperty();

       $productProp->product_id = $product->ID;
       $productProp->properties_id = $property->ID;
       $productProp->set_properties_id = $set_property->ID;
    endforeach;

$productProp->save(); //inserts into database

Currently you are resetting the properties on each iteration. Move the save() call inside the loop. — Matt Rink
– Matt Rink, Commented Sep 29, 2017 at 15:32
Haha, this is awkward. I think i need a little break from my project. Thanks anyways everyone... — user5877800
– user5877800, Commented Sep 29, 2017 at 15:42

Oussama Ben Ghorbel · Accepted Answer · 2017-09-29 15:40:05Z

1

You have to write in the database for each object.

Create the object
Set the object's attributes to certain values
Insert the object in the database

And repeat while your array still have entries (objects).

Code:

foreach ($properties as $prop): 
   //Create a new object 
   $productProp = new ProductProperty();
   //Set the attributes 
   $productProp->product_id = $product->ID;
   $productProp->properties_id = $property->ID;
   $productProp->set_properties_id = $set_property->ID;
   //Insert it in the database 
   $productProp->save();
endforeach;

answered Sep 29, 2017 at 15:40

Oussama Ben Ghorbel

2,1494 gold badges20 silver badges38 bronze badges

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

3 Comments

user5877800 Over a year ago

I will go and rethink my life now. Thanks!

Oussama Ben Ghorbel Over a year ago

It is okay friend, we all do mistakes. I'm certain I have done a smiliar mistake in the past and someone out there helped me. One advice: just try reading your code line by line like its someone else's code so you can track the logic flaw.

user5877800 Over a year ago

This is just so silly mistake, but yeah things like this happen. Thanks anyways :)

Collectives™ on Stack Overflow

PHP foreach loop SQL insert

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related