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
– vasanth.v, Commented Jun 7, 2011 at 5:29

Tomasz Kowalczyk · Accepted Answer · 2011-06-07 05:18:11Z

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 7, 2011 at 5:18

Tomasz Kowalczyk

10.5k6 gold badges56 silver badges70 bronze badges

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

Comments

KoolKabin · Accepted Answer · 2011-06-07 05:18:33Z

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 7, 2011 at 5:18

KoolKabin

17.8k37 gold badges113 silver badges145 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:55:37Z

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, 2017 at 11:55

CommunityBot

11 silver badge

answered Jun 7, 2011 at 5:19

Naveed

42.3k31 gold badges101 silver badges132 bronze badges

Collectives™ on Stack Overflow

Mysql save PHP array as each value in new field

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related