How to save array values using PDO

Question

I am new to programming and I have a problem when storing the values in an array using PDO.

I get a string from a form input:

  $brands = "Nike, Adidas, Reebok";

I get an array where the string separated by commas:

$pieces = explode(",", $brands);

I need to store each value in the array in different records within a table using PDO, something like this:

$statement = " INSERT INTO userbrands (Name, Email, Brand) VALUES (:name, :email, :brand)";
$sth = $db ->prepare($statement);
$sth -> execute(array(':name'=>$name, ':email'=>$email, ':brand'=>$pieces));

Thanks for answering a rookie question!

Take note that the values will be Nike, [SPACE]Adidas and [SPACE]Reebok. To use explode and ignore whitespace, either loop through and use trim, or use preg_split('/,\s*/', $brands) instead. — h2ooooooo
– h2ooooooo, Commented Mar 14, 2013 at 17:39

Bill Karwin · Accepted Answer · 2013-03-14 17:38:00Z

2

$statement = " INSERT INTO userbrands (Name, Email, Brand) VALUES (:name, :email, :brand)";
$sth = $db ->prepare($statement);
foreach ($pieces as $one_piece) {
  $sth -> execute(array(':name'=>$name, ':email'=>$email, ':brand'=>$one_piece));
}

answered Mar 14, 2013 at 17:38

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

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

Collectives™ on Stack Overflow

How to save array values using PDO

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related