dongzi1209 2016-09-11 21:20
浏览 54

如何将这个数组插入我的表mysql php?

I have a problem to insert the following array into my mysql table. I want to insert the array value (abdominal pain,back pain, pain, abd) into my table, but I have no idea to do that on this complicate array. Appreciate.

<?php
$data = array(
  array("table"=>"abdominal pain"),
  array("table"=>"back pain"),
  array("table"=>"pain"),
  array("table"=>"abd")
);

$add_word = $wpdb->query( $wpdb->prepare( 
    "
        INSERT INTO $word_table
        ( word )
        VALUES ( %s )
    ", 
    $data
) );
?>

</div>
  • 写回答

1条回答 默认 最新

  • duandanai6470 2016-09-11 21:37
    关注

    You can serialize() the value and insert it as a string. Then when you retrieve it, unserialize() it and it will be an array again.

    More on http://php.net/manual/en/function.serialize.php

    评论

报告相同问题?

悬赏问题

  • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集