doujuegai8830 2014-02-08 19:07
浏览 14
已采纳

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

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

  • 写回答

2条回答 默认 最新

  • douba05167 2014-02-08 19:15
    关注

    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')
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?