doudao7113 2014-02-03 17:56
浏览 68
已采纳

将PHP数组作为文本插入MySQL数据库

I am willing to insert an array to a database as normal text.

$subjectcodes[1] = "";
$subjectcodes[2] = "";
$subjectcodes[3] = "";
$subjectcodes[4] = "";
$subjectcodes[5] = "";
$subjectcodes[6] = "";
$subjectcodes[7] = "";

etc...

I give my array an stringname called list_update. So you get this ( I am having "\" so it doesn't see it as PHP )

    $list_update="
    \$subjectcodes\[1\] = \"\";
    \$subjectcodes\[2\] = \"\";
    \$subjectcodes\[3\] = \"\";
    \$subjectcodes\[4\] = \"\";
    \$subjectcodes\[5\] = \"\";
    \$subjectcodes\[6\] = \"\";
    \$subjectcodes\[7\] = \"\";
"

Now when I use my query to input my list into a table it doesn't do anything.

 mysqli_query($connect,"INSERT INTO subjects (list)
        VALUES (" . $list_update . ") WHERE user='". $userid ."'");

Does someone know how I can solve this?

Thank you very much in advance ;)

  • 写回答

2条回答 默认 最新

  • doukuiqian5345 2014-02-03 18:12
    关注

    Do it as below:

    $subjectcodes[1] = "";
    $subjectcodes[2] = "";
    $subjectcodes[3] = "";
    $subjectcodes[4] = "";
    $subjectcodes[5] = "";
    $subjectcodes[6] = "";
    $subjectcodes[7] = "";
    
    json_encode($subjectcodes);
    

    Insert into your DB.

    After you fetch it from DB, then decode it as below:

    $array = json_decode($yourArrayItemFromDB);
    

    ANd you will have your original array like $subjectcodes.

    Using this way, you can not only save arrays, but you can also save objects in DB.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?