2021-09-04 数据库之间传输数据

<?php
$dbcon= mysqli_connect('sqlip','user','password') or die("database cont error，".mysqli_connect_error()."");
$sql="select svr_type,valid,svr_id,lan_ip,lan_port,wan_ip_1,wan_port_1,wan_ip_2,wan_port_2,set_id,idc_no,svr_info from test.pf_list;";
#$sql="select * from test.pf_list;";
$result=mysqli_query($dbcon,$sql);
$row=mysqli_fetch_assoc($result);

if($result = mysqli_query($dbcon, $sql))
{
  while($row = mysqli_fetch_assoc($result))
  {
    $server_info[] = $row;
  }
}


foreach($server_info as $v1)
{
  if($v1 != 0)
  {
   #var_dump($v1);
  $sql="replace into test.yt_list set svr_type='$v1[svr_type]',valid=".$v1['valid'].",svr_id=".$v1['svr_id'].",lan_ip='$v1[lan_ip]',lan_port=".$v1['lan_port'].",wan_ip_1='$v1[wan_ip_1]',wan_port_1='$v1[wan_port_1]',wan_ip_2='$v1[wan_ip_2]',wan_port_2='$v1[wan_port_2]',set_id=".$v1['set_id'].",idc_no=".$v1['idc_no'].",svr_info='$v1[svr_info]';";
  $result=mysqli_query($dbcon,$sql);
  var_dump($sql);
  }
}
mysqli_close($dbcon);