Menu
Community /Pin to ProfileBookmark
@NogDogApr 10.2014 — #Well, the first thing I'd do is try to figure out how to do it all in one query if possible, as doing a separate query N number of times in a loop can be resource-intensive. For instance, you could build a single insert query from your array of data, since you can use this SQL format:
HOw to use foreach for MYSQL Query
Hey I have a php array adn for each value of array I want to run a query and get the result.
How I can use foreach here pls guide with some example.
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogApr 10.2014 — #Well, the first thing I'd do is try to figure out how to do it all in one query if possible, as doing a separate query N number of times in a loop can be resource-intensive. For instance, you could build a single insert query from your array of data, since you can use this SQL format:<i>
</i>INSERT INTO table_name (
col_1,
col_2,
col_3
)
VALUES
('row1_1', 'row1_2', 'row1_3'),
('row2_1', 'row2_2', 'row2_3'),
('row3_1', 'row3_2', 'row3_3')
;