How to insert comma separated string into MySQL table while each part in new row?

Question

Possible Duplicate:
Add new row in MYSQL from Comma Separated text in textbox
Insert comma separated records in table

$words = 'word1,word2,word3';

How do i get this data into following structure:

MySQL table:

id    value
 1    word1
 2    word2
 3    word3

What i am thinking of:

$separated = explode(",",$words);
//do some kind of loop
INSERT INTO table (value) VALUES ('$something');

I guess i suck at loops :/

Thanks

If you know you need a loop, write one and see what happens. If it doesn't work show us what you've got and we can help you with it. But *at least try*. — John Conde, Jan 28 '13 at 02:01
do the freakin loop. If you `suck at loops` open freakin manual at loop page, read, use it and you gonna be loop master — Peter, Jan 28 '13 at 02:01
Seems like a duplicate: http://stackoverflow.com/a/8135264/1073631 — sgeddes, Jan 28 '13 at 02:06

Kermit · Answer 1 · 2013-01-28T02:08:54.470

2

$wordArray = explode(",", $words);

$stmt = "INSERT INTO table (column) VALUES ('" . implode("'), ('", $wordArray) . "')";

This will produce:

INSERT INTO table (column) VALUES ('word1'), ('word2'), ('word3')

edited Jan 28 '13 at 02:08

answered Jan 28 '13 at 02:03

Kermit

boruch · Answer 2 · 2013-01-28T02:06:57.050

0

Do a simple loop, as such:

foreach($separated as $seperate){
    $sql .= "INSERT INTO table (value) VALUES ('$seperate')";
}

edited Jan 28 '13 at 02:06

answered Jan 28 '13 at 02:04

boruch

This is inefficient; you should send them in one statement. See [this](http://stackoverflow.com/questions/8635818/multiple-insert-statements-vs-single-insert-with-multiple-values). – Kermit Jan 28 '13 at 02:04
Yep, something quick to whip up – boruch Jan 28 '13 at 02:05
1

Don't use `@` to suppress errors. It makes debugging difficult. – John Conde Jan 28 '13 at 02:05
@JohnConde not sure why the post was edited to add @. also added quotes... – boruch Jan 28 '13 at 02:07
@njk it's not always possible to use a single statement only added as a stub – boruch Jan 28 '13 at 02:08

2 Answers2