StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POis there any way i could minimize the Mysql database trip for this piece of code?
text
Body
copied!<p>i have a table called <code>propAmenities</code> which holds two column <code>amenity_id</code> and <code>property_id</code> basically the table holds the foreign keys.</p> <p>now i have two insert data into this table, and while inserting data <code>property_id</code> column will have the same value for all rows that are to be inserted while <code>amentiy_id</code> value will vary, now for example the values may look like</p> <pre><code>INSERT INTO propAmenities(amenity_id, property_id) VALUES(1,1); INSERT INTO propAmenities(amenity_id, property_id) VALUES(2,1); INSERT INTO propAmenities(amenity_id, property_id) VALUES(3,1); INSERT INTO propAmenities(amenity_id, property_id) VALUES(4,1); INSERT INTO propAmenities(amenity_id, property_id) VALUES(5,1); </code></pre> <p>and the current code to insert the data i am using is:</p> <pre><code>public function savePropAmenities($amenityIds = array()) { if($this->validateRequired(array('propertyId'))) { foreach($amenityIds as $amenityId) { $sth = $this->dbh->prepare('INSERT INTO propAmenities (amenity_id, property_id) VALUES (:amenityId, :propertyId)'); $sth->bindParam(':amenityId', $amenityId); $sth->bindParam(':propertyId', $this->data['propertyId']); $sth->execute(); } } } </code></pre> <p>the above code will run a loop and will make a frequent trip to database to insert the records. is there anyway i could cut of the trip and minimize it to one?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload