mysql 加逗号_在mysql中插入多行（用逗号分隔的项目）

I have a small problem :) I was searching the web but didn't find any solutions.

I have a value like this (got it from $_GET[])

tag1, tag2, tag3, tag4

and all I want to do is insert it into MySql (via PHP) like this:

+---------+-------------+

| id | tag |

+---------+-------------+

| 33 | tag1 |

| 33 | tag2 |

| 33 | tag3 |

| 33 | tag4 |

+---------+-------------+

I found many articles about this on Stack Overflow but the biggest problem here is that I don't know how many values I'm gonna get each time (I did not find that answer).

I will appreciate any help I get.

解决方案

Hi greetings from UK :)

Can't you just loop through the querystring fields and add one row to the database at a time?

e.g.

$id = 33;

$value_list = 'tag1,tag2,tag3,tag4';

$values = explode(',', $value_list);

foreach ($values as $value)

{

$sql = "INSERT INTO table (id, value) VALUES ($id, '$value');";

//.. execute SQL now

echo '

' . $sql . '

';

}

?>

I uploaded this to http://cyba.co/test.php so you can see the output.