duanbohan2015 2014-01-21 08:15
浏览 9

将'Array'插入mysql表的各个字段(而不是raws)

my code's

$output.= '<div class="body">'.$message.'</div>';
echo $output;//output the email body

include_once('simple_html_dom.php');
$html = str_get_html("$output"); 
foreach($html->find('tr') as $e) {
    $b = $e->find('td',1)->plaintext;
$EMailArr[] =$b ;
}

$value_string3= implode("','", $EMailArr);
mysql_query("INSERT INTO test (`a`,`b`,`c`,`d`,`e`,`f`,`g`,`h`,`i`) VALUES($value_string3)");
print "INSERT INTO test (`a`,`b`,`c`,`d`,`e`,`f`,`g`,`h`,`i`) VALUES($value_string3)";

outputs.. Array

(
    [0] => MD-MAL_MSAG5200_01 - MD-Malwana - ZTE
    [1] =>   CRITICAL
    [2] => MD-MAL_MSAG5200_01 - MD-Malwana - ZTE Isolated
    [3] => All customers(49) in above MD-MAL_MSAG5200_01 DSLAM/=3D MSAN  
    [4] => PENDING
    [5] => =  FMT-BB(A)
    [6] =>   OPEN
    [7] => PENDING
    [8] => Informed to DGM :idsmanjuka@gmail.com 
)

INSERT INTO test (a,b,c,d,e,f,g,h,i) VALUES(MD-MAL_MSAG5200_01 - MD-Malwana - ZTE',' CRITICAL','MD-MAL_MSAG5200_01 - MD-Malwana - ZTE Isolated','All customers(49) in above MD-MAL_MSAG5200_01 DSLAM/=3D MSAN ','PENDING','= FMT-BB(A)',' OPEN','PENDING','Informed to DGM :idsmanjuka@gmail.com )

  • 写回答

4条回答 默认 最新

  • doulaozhang0238 2014-01-21 08:19
    关注

    Use backticks ` for your column names (as it contains space in it).

    INSERT INTO test (`Network Affected`,`Fault Type`,`Fault Detail Description`,`Systems/Service     
    Affected`,`Expected Clearance`,`Fault Reported By`,`Fault Status`,`Fault Cleared Date`,`Details of 
    Actions Taken by FMT-BB`) VALUES ('MD-MAL_MSAG5200_01 - MD-Malwana - ZTE',' CRITICAL','MD-
    MAL_MSAG5200_01 - MD-Malwana - ZTE Isolated','All customers(49) in above MD-
    MAL_MSAG5200_01 DSLAM/=3D MSAN ','PENDING','= FMT-BB(A)',' OPEN','PENDING','Informed to 
    DGM :kapuru@slt.com.lk' )
    

    Also as mention by @Harry in comment, make sure your string values are surrounded by '

    Warning: It's a very poor practice to have column name with space.

    评论

报告相同问题?

悬赏问题

  • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
  • ¥16 mybatis的代理对象无法通过@Autowired装填
  • ¥15 可见光定位matlab仿真
  • ¥15 arduino 四自由度机械臂
  • ¥15 wordpress 产品图片 GIF 没法显示
  • ¥15 求三国群英传pl国战时间的修改方法
  • ¥15 matlab代码代写,需写出详细代码,代价私
  • ¥15 ROS系统搭建请教(跨境电商用途)
  • ¥15 AIC3204的示例代码有吗,想用AIC3204测量血氧,找不到相关的代码。
  • ¥20 CST怎么把天线放在座椅环境中并仿真