Need help with MySQL array insertion

[vibeit]

Hello, I'm trying to insert an array into mySql database but it keeps inserting the entire array in a single field.

 

 

//the $authors variable is an array taken from an exploded string$authors = [];if(isset($_POST['blogAuthors'])){$authors = explode('\n', $_POST['blogAuthors']);} foreach($authors as $author){            $sql = "INSERT INTO authors (authorName, authorWorkHash) VALUES (:author, :hash)";            $query = $db->prepare($sql);            $query->execute(array(':author'=>$author,':hash'=>$blogHash));        }

 

the database keeps inserting the author names as one record instead of a separate record for each person. Any help would be appreciated. Thanks.

Edited January 16, 2016 by colonel_mortis
Code tags

[as96]

What do you use as primary key?

[vibeit]

What do you use as primary key?

I'm using INT type.

[as96]

I'm using INT type.

Could you post the SQL code of the table?

 

PS: when you post code use the code tags.

[vibeit]

I'm not sure if these are the codes you're looking for but this is from phpmyadmin from the SQL tab:

INSERT INTO `authors`(`authorID`, `authorName`, `authorWorkHash`) VALUES ([value-1],[value-2],[value-3])

SELECT `authorID`, `authorName`, `authorWorkHash` FROM `authors` WHERE 1

UPDATE `authors` SET `authorID`=[value-1],`authorName`=[value-2],`authorWorkHash`=[value-3] WHERE 1

DELETE FROM `authors` WHERE 1

[vibeit]

So as it turns out the explode function isn't really splitting the string. I'll look into it. Thanks for your help.

[Blade of Grass]

So as it turns out the explode function isn't really splitting the string. I'll look into it. Thanks for your help.

Isn't really related to your main question, but you could use a ternary statement to achieve the same thing your first two lines do.

 

$authors = (isset($_POST['blogAuthors'])) ? explode('\n', $_POST['blogAuthors']) : null;

[colonel_mortis]

Unrelated to your original question, but the original purpose of prepared statements was to allow repeated queries to run faster, which you should probably take advantage of. Rather than preparing the statement every time in the loop, just prepare it once, outside, then use the prepared statement inside:

$sql = "INSERT INTO authors (authorName, authorWorkHash) VALUES (:author, :hash)";$query = $db->prepare($sql);foreach($authors as $author){            $query->execute(array(':author'=>$author,':hash'=>$blogHash));}