如何将没有键的数组插入mysql？

Question

I have array

Array
(
    [0] => john
    [1] => melinda
)

And have database table

---

|id|name|

How I can insert the name into my database using php?

I can do using looping on mysql_query, but it not good for my resource.

the code I made now is

foreach( $data as $row ) {
    mysql_query("INSERT INTO badwords (word) VALUES('".$row."')");
    }

it work but I think there is another simple way.

Thank you

Answer 1

You can do a batch insert instead of looping if you'd like.

"INSERT INTO badwords (word) VALUES ('".implode( "'),('", $data)."')";

Not tested, But this should produce something like

"INSERT INTO badwords (word) VALUES ('john'),('melinda')