PHP/MySQL Implode into multiple rows?

Question

is it possible to implode a checkbox value into multiple values to insert into a database?

At current I have this:

$tags = implode(', ', $_POST['checkboxname']);

This gives me the value of "testtag1, testtag2"

How would I split this up so it would go into the database like:

Blog ID ¦ Tag
------------------
1       ¦ testtag1

1       ¦ testtag2

Not sure how to make the implode function seperate them as this:

$query2 = mysqli_query($myConnection, "INSERT INTO blogtags (blogid, tag) VALUES('$blogid','$tags')") or die (mysqli_error($myConnection));

just inserts the two values together in one row.

Any help would be great! Thanks

Why do you implode? Simply itterate through $_POST['checkboxname']and do an insert in each loop. — pmayer
– pmayer, Commented Apr 19, 2013 at 13:07
Firstly, you have a huge SQL injection hole. Secondly, think about the MySQL syntax for inserting multiple rows in a single query - that's what you would need your string to look like. Thirdly, and most importantly because it solves both of the above and more: You should prepare a statement to insert a single row and invoke it multiple times. This is exactly what prepared statements are designed for. — DaveRandom
– DaveRandom, Commented Apr 19, 2013 at 13:07

sybear · Accepted Answer · 2013-04-19 13:15:06Z

2

Try this example:

$tags = $_POST['checkboxname'] ; //Take the array of tags.
$id = 1 ;                        //Set needed id.

$values = array() ;

foreach($tags as $tag){
  $tag = $myConnection->real_escape_string($tag);
  $values[] = " ('{$id}', '{$tag}') " ;
}

$values = implode(" , ", $values) ;
$query = "INSERT INTO blogtags (blogid, tag) VALUES {$values} ; " ;

answered Apr 19, 2013 at 13:15

sybear

7,7921 gold badge25 silver badges38 bronze badges

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

3 Comments

Jocelyn Over a year ago

Saving comma-separated values in a database is often a bad idea. A better option is to save a different record for each tag.

sybear Over a year ago

@Jocelyn If you run this code, you will see, that it makes different records for each tag.

Jocelyn Over a year ago

Ah yes, you are right. I had seen implode and implied you were imploding the tags. Using multi-insert as you do is fine. I should have read the code more carefully.

Collectives™ on Stack Overflow

PHP/MySQL Implode into multiple rows?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related