# php多表更新字段内容

<?php
header('Access-Control-Allow-Origin:*');
$servername = "127.0.0.1";
$username = "root";
$password = "wdqdmm@r";
$dbname = "dbhtmltoo";
  
// 创建链接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检查链接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 

#可以用word导(^P->,), Excel导(拉取id连号,复制到txt, 再word导)
$arr_id1 = array(47279,47269,44636,44530,44526,44490,43963,43961,43706,43695,43506,43359,43193,43006,42222,41873,41752,41741,41439,40545,40510,40473,40458,40414,40412,40055,39040,39018,38807,38792,38784,38429,37365,37024,36402,36351,36143,36129,35942,35921,35692,34605,34557,34525,34488,34273,34266,34226,34220,34169,33994,33989,32870,31825,31602,31537,31521,31517,31359,31173,31130,30994,30904,30899,30388,30015,29611,29214,28207,27828,27827,27440,27432,27431,27427,27408,27210,27185,26899,26870,26707,26688,26424,26412,26408,26396,26381,26278,23457,22497,21749,21630,21239,20824,20061,18769,18204,18167,17928,16910,16893,16651,15628,15627,15547,15523,15522,15500,15474,1292,1208);
$arr_id2 = array(979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089);

for ($i=0; $i<=110; $i++)
{
  $sql = "UPDATE `dbhtmltoo`.`dr_1_blog` SET `id` = $arr_id2[$i], `url` = '/blog-p$arr_id2[$i].html' WHERE `id` = $arr_id1[$i];";
  $sql .= "UPDATE `dbhtmltoo`.`dr_attachment` SET `related` = 'dr_1_blog-$arr_id2[$i]' WHERE `related`  like '%$arr_id1[$i]%';";
  $sql .= "UPDATE `dbhtmltoo`.`dr_attachment_1` SET `related` = 'dr_1_blog-$arr_id2[$i]' WHERE `related`  like '%$arr_id1[$i]%';";
  $sql .= "UPDATE `dbhtmltoo`.`dr_1_blog_index` SET `id` = $arr_id2[$i] WHERE `id` = $arr_id1[$i];";
  $sql .= "UPDATE `dbhtmltoo`.`dr_1_blog_hits` SET `id` = $arr_id2[$i] WHERE `id` = $arr_id1[$i];";
  $sql .= "UPDATE `dbhtmltoo`.`dr_1_blog_data_0` SET `id` = $arr_id2[$i] WHERE `id` = $arr_id1[$i];";
  
  if ($conn->multi_query($sql) === TRUE) {
    echo "Ok:" . $sql . "<br>修改成功";
  } else {
    echo "Error: " . $sql . "<br>" . $conn->error;
  }
  
//如果你使用了一个循环来提交你的数据 并且是多次提交的话 那么你应该需要把结果集滞空，来准备下一个结果集
  do{$conn->next_result();}  while($conn->more_results());
}

$conn->close(); 
 
?>