Mysql save PHP array as each value in new field

Question

I have a PHP array like

array("Saab", "Volvo", "BMW", "Toyota");

I need to store this in a MySQL database in a way that each value is inserted into a new field and not in a same field. It can be achieved by using foreach statement and running the query inside foreach statement. But I need a more efficient way to do it in a single query.

I am trying to avoid loop to speed up the process. Because this array might contain more number of values in it. — vasanth.v, Jun 07 '11 at 05:29

score 6 · Accepted Answer · answered Jun 07 '11 at 05:18

6

Pack multiple records in your INSERT query - produce single one in a loop and then execute it at the end.

INSERT INTO tbl (is, name)
VALUES
(0, 'Ford'),
(1, 'BMW'),
(2, 'Volvo)

answered Jun 07 '11 at 05:18

Tomasz Kowalczyk

10,472
6
52
68

score 1 · Answer 2 · answered Jun 07 '11 at 05:18

1

you can try it using implode

insert into tablename (field1, field2, field3, field4) values('".implode("'", array(...))."');

it will produce like:

insert into tablename (field1, field2, field3, field4) values('Saab', 'Volvo', 'BMW', 'Toyota');

answered Jun 07 '11 at 05:18

KoolKabin

17,157
35
107
145

score 0 · Answer 3 · edited May 23 '17 at 11:55

0

You can insert multiple records with one SQL query. Read following article:

Speed of INSERT Statements

Also discussed on SO before:

Speeding up large numbers of mysql updates and inserts

edited May 23 '17 at 11:55

Community

1
1

answered Jun 07 '11 at 05:19

Naveed

41,517
32
98
131

Mysql save PHP array as each value in new field

3 Answers3